SELECT TOP 100 [.].[obj] as [obj], [.].[objtype] as [objtype], [.].[name] as [name], [.].[emailaddress] as [emailaddress], [.].[active] as [active], [.].[domain] as [domain], [.].[trustees] as [trustees], [.].[memberof] as [memberof] FROM [highstage].[dbo].[ts_role] AS [.] WHERE ([.].[active]=1) AND (([.].[obj] = 'JB')) AND ((CAST([.].[objtype] as VARCHAR) = 'ts_user')) AND ( [.].[obj] = 'everyone' OR [.].[obj] = 'documentation' OR [.].[trustees] like '%;everyone;%' OR [.].[trustees] like '%;documentation;%') ORDER BY [.].[obj]