SELECT TOP 25 [.].[item] as [item], [.].[alias] as [alias], [.].[itemtype] as [itemtype], [.].[minorversion] as [minorversion], [.].[filename] as [file], [.].[folderrelativepath] as [folderrelativepath], [.].[filename] as [filename], [.].[pdf] as [pdf], [.].[status] as [status], [.].[name] as [name], [.].[latest] as [latest], [.].[latestapproved] as [latestapproved], [.].[obsolete] as [obsolete], [.].[predecessor] as [predecessor], [.].[rejected] as [rejected], [.].[description] as [description], [.].[workspace] as [workspace], [.].[eventtime] as [eventtime], [subtype].[class] as [subtype.class], [.].[copyto] as [copyto], [.].[sharewith] as [sharewith], [.].[objtype] as [objtype], [.].[editby] as [author], [.].[date1] as [date1], [.].[date2] as [date2], [.].[reviewby] as [reviewby], [.].[date3] as [date3], [.].[approveby] as [approveby], [.].[date4] as [date4], [.].[date5] as [date5], [subtype].[typetype] as [subtype.typetype], [subtype].[objtype] as [subtype.objtype], [subtype].[itemtype] as [subtype.itemtype] FROM [highstage].[dbo].[item] AS [.] LEFT OUTER JOIN [highstage].[dbo].[itemtype] AS [subtype] ON (LTRIM([.].[itemtype]) COLLATE database_default)=LTRIM([subtype].[itemtype]) 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 [.].[eventtime] desc,[.].[item]