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

   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