SELECT TOP 25 [ts_ref].[ref] as [ts_ref.ref], [.].[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], [.].[editby] as [author], [.].[reviewby] as [reviewby], [.].[approveby] as [approveby], [.].[eventtime] as [eventtime], [subtype].[class] as [subtype.class], [ts_ref].[lock] as [ts_ref.lock], [ts_ref].[comment] as [ts_ref.comment], [.].[copyto] as [copyto], [.].[sharewith] as [sharewith], [.].[objtype] as [objtype], [.].[date1] as [date1], [.].[date2] as [date2], [.].[date3] as [date3], [.].[date4] as [date4], [.].[date5] as [date5], [subtype].[typetype] as [subtype.typetype], [subtype].[objtype] as [subtype.objtype], [subtype].[itemtype] as [subtype.itemtype], [ts_ref].[objref] as [ts_ref.objref] FROM [highstage].[dbo].[item] AS [.] LEFT OUTER JOIN [highstage].[dbo].[itemtype] AS [subtype] ON (LTRIM([.].[itemtype]) COLLATE database_default)=LTRIM([subtype].[itemtype]), [highstage].[dbo].[objref] AS [ts_ref] WHERE ([.].[latestapproved]=1 AND [.].[obsolete]=0) AND ('doc'=[ts_ref].[childtype]) AND (CAST([.].[item] as VARCHAR(250)) COLLATE database_default=[ts_ref].[child]) AND ((CAST([ts_ref].[parenttype] as VARCHAR) = 'doc')) AND (([ts_ref].[parent] = 'DOCU12342-8')) 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]