SELECT [.].[description] as [description], [.].[note16] as [note16], [.].[filename] as [file], [.].[folderrelativepath] as [folderrelativepath], [.].[filename] as [filename], [.].[pdf] as [pdf], [.].[copyto] as [copyto], [.].[sharewith] as [sharewith], [.].[item] as [item], [.].[alias] as [alias], [.].[itemtype] as [itemtype], [.].[minorversion] as [minorversion], [.].[name] as [name], [.].[objtype] as [objtype], [.].[workspace] as [workspace], [.].[status] as [status], [.].[latest] as [latest], [.].[latestapproved] as [latestapproved], [.].[obsolete] as [obsolete], [.].[predecessor] as [predecessor], [.].[rejected] as [rejected], [.].[editby] as [author], [.].[date1] as [date1], [.].[date2] as [date2], [.].[reviewby] as [reviewby], [.].[date3] as [date3], [.].[approveby] as [approveby], [.].[date4] as [date4], [.].[date5] as [date5] FROM [highstage].[dbo].[item] AS [.] WHERE ([.].[latestapproved]=1 AND [.].[obsolete]=0) AND (([.].[itemtype] = 'DOCU')) AND ((CAST([.].[objtype] as VARCHAR) = 'doc')) AND ( [.].[copyto] like '%;everyone;%' OR [.].[copyto] like '%;documentation;%' OR [.].[workspace] IN (SELECT Obj FROM [highstage].[dbo].[entity] WHERE trustees LIKE '%;everyone;%' OR trustees LIKE '%;documentation;%') OR [.].[editby] LIKE '%;DOCUMENTATION;%' OR [.].[editby] LIKE '%;DOCUMENTATION;%' OR [.].[reviewby] LIKE '%;DOCUMENTATION;%' OR [.].[approveby] LIKE '%;DOCUMENTATION;%') ORDER BY [.].[description],[.].[item]