select top 20 this_.oid as oid27_0_, this_.loginName as loginName27_0_, this_.loginPwd as loginPwd27_0_, this_.userType as userType27_0_, 
this_.description as descript5_27_0_, this_.lastLoginTime as lastLogi6_27_0_, this_.accountOid as accountOid27_0_, this_.employeeOid as employee8_27_0_, 
this_.regionOid as regionOid27_0_, this_.createdBy as createdBy27_0_, this_.createdTime as created11_27_0_, this_.lastModifiedBy as lastMod12_27_0_, 
this_.lastModifiedTime as lastMod13_27_0_ 
from FS_User this_ 
where 'CEO' in (select role.name from FS_Role role, FS_USER_To_Role userToRole where role.oid=userToRole.roleOid and userToRole.userOid= this_.oid)