ProNotion

SELECT        m.LoginName, m.Email, cmsPropertyData.dataDate AS LastLoginDate
FROM            cmsPropertyType INNER JOIN
                         cmsPropertyData ON 
                         cmsPropertyType.id = cmsPropertyData.propertytypeid RIGHT OUTER JOIN
                         cmsMember AS m ON cmsPropertyData.contentNodeId = m.nodeId
WHERE        (cmsPropertyType.Alias = N'umbracoMemberLastLogin') AND (cmsPropertyData.dataDate IS NOT NULL)
ORDER BY LastLoginDate DESC

ProNotion

internal static string GetModelPropertyTypeAlias<TModel>(Expression<Func<TModel, object>> selector)
        where TModel : PublishedElementModel
    {
        Expression body = selector.Body;

        // Unwrap conversions, if any
        if (body is UnaryExpression unaryExpression && unaryExpression.NodeType == ExpressionType.Convert)
            body = unaryExpression.Operand;

        if (!(body is MemberExpression memberExpression))

ProNotion

public class MyServiceComposer : IComposer
{
    public void Compose(IUmbracoBuilder builder)
    {
        builder.AddNotificationHandler<UmbracoApplicationStartedNotification, UmbracoStartedNotificationHandler>();
    }
}

ProNotion

<div ng-controller="RadioButtonListWithDefault.DropdownController as vm">
    <select ng-model="vm.model.value">
        <option ng-repeat="item in vm.items" value="{{item.value}}">
            {{item.value}}
        </option>
    </select>
</div>

ProNotion

-- Retrieves content items that have a newer, unpublished version than the currently published version.

SELECT 
    c.nodeId AS ContentId,
    un.text AS NodeName,
    CONCAT('https://example.com/umbraco#/content/content/edit/', c.nodeId) AS Link
FROM cmsContent c
JOIN cmsContentVersion cv ON c.nodeId = cv.ContentId
JOIN cmsDocument d ON c.nodeId = d.nodeId
JOIN umbracoNode un ON c.nodeId = un.id