select * from tbl_FSPro_Members m with (nolock) inner join tbl_LIB_Accounts a with (nolock) on a.FSPro_UserID = m.FSPro_UserID and a.companyid = 132 and moduleid = 42 where ownerid = 21 and email = and domainid = 1 and loginenabled = 1 order by email select ownerid, fsl_tablecode from tbl_FSPro_Members with (nolock) where email = and FSL_TableCode in ('MFR','BRO') and OwnerID > 0 and OwnerID <> 2661 and LoginEnabled = 1 and StaffMember = 1 select ownerid, fsl_tablecode from tbl_FSPro_Members with (nolock) where email = and FSL_TableCode = 'BRO' and OwnerID in (2661) and LoginEnabled = 1 --and StaffMember = 1 select ownerid, fsl_tablecode from tbl_FSPro_Members with (nolock) where OwnerID in () and FSL_TableCode = 'CHO' and email = and LoginEnabled = 1 and staffMember in (0,1)