DotNetNuke(DNN) 中查询所有管理员的SQL语句

今天有人问，写了一个，贴出来也许有人能用上，不过这个语句是查询所有portal下的Administrator

   1: SELECT u.*

   2: FROM {databaseOwner}[{objectQualifier}Users] as u JOIN (

   3:             SELECT u.UserID

   4:             FROM {databaseOwner}[{objectQualifier}Roles] AS r JOIN {databaseOwner}[{objectQualifier}UserRoles] AS u

   5:             ON r.RoleID = u.RoleID

   6:             WHERE r.RoleName = 'Administrators'

   7:                ) AS r

   8: ON u.UserID = r.UserID