Umbraco 7 Member export SQL

U7 Member export.sql

/* Core member export: one row per member */
SELECT
    m.nodeId AS MemberId,
    n.uniqueId AS MemberKey,
    n.[text] AS MemberName,
    m.LoginName AS Username,
    m.Email,
    ct.alias AS MemberTypeAlias,
    ct.[description] AS MemberTypeName,
    n.createDate,
    n.path,
    n.level,
    n.sortOrder,
    Groups.GroupNames
FROM cmsMember m
INNER JOIN umbracoNode n
    ON n.id = m.nodeId
LEFT JOIN cmsContent c
    ON c.nodeId = m.nodeId
LEFT JOIN cmsContentType ct
    ON ct.nodeId = c.contentType
OUTER APPLY
(
    SELECT STUFF(
    (
        SELECT ', ' + gn.[text]
        FROM cmsMember2MemberGroup mmg
        INNER JOIN umbracoNode gn
            ON gn.id = mmg.MemberGroup
        WHERE mmg.Member = m.nodeId
        FOR XML PATH(''), TYPE
    ).value('.', 'nvarchar(max)'), 1, 2, '')
    AS GroupNames
) Groups
WHERE n.nodeObjectType = '39EB0F98-B348-42A1-8662-E7EB18487560'
ORDER BY n.[text];