Get Umbraco Members with last login date

umbracoMembersWithLoginDate.sql

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

FYI This will only include accounts where the user has logged in at least once