SELECT [.].[description] as [description], [.].[name] as [name], [.].[folderrelativepath] as [folderrelativepath], [.].[copyto] as [copyto], [.].[sharewith] as [sharewith], [.].[item] as [item], [.].[alias] as [alias], [.].[itemtype] as [itemtype], [.].[minorversion] as [minorversion], [.].[objtype] as [objtype], [.].[workspace] as [workspace], [.].[status] as [status], [.].[editby] as [author], [.].[reviewby] as [reviewby], [.].[approveby] as [approveby], [.].[latest] as [latest], [.].[latestapproved] as [latestapproved], [.].[obsolete] as [obsolete], [.].[predecessor] as [predecessor], [.].[rejected] as [rejected], [.].[date1] as [date1], [.].[date2] as [date2], [.].[date3] as [date3], [.].[date4] as [date4], [.].[date5] as [date5] FROM [highstage].[dbo].[item] AS [.] WHERE ([.].[latest]=1 AND [.].[obsolete]=0) AND ((workspace='PUBLICDOCS' AND status='5')) AND (([.].[productfamily] LIKE '%2D%' AND [.].[productfamily] LIKE '%profilers%')) AND (([.].[itemtype] = 'GA')) AND ((CAST([.].[objtype] as VARCHAR(16)) = 'doc')) AND ( [.].[copyto] like '%;everyone;%' OR [.].[copyto] like '%;public;%' OR [.].[copyto] like '%;publicgroup;%' OR [.].[sharewith] like '%;everyone;%' OR [.].[sharewith] like '%;public;%' OR [.].[sharewith] like '%;publicgroup;%' OR [.].[workspace] IN (SELECT Obj FROM [highstage].[dbo].[entity] WHERE trustees LIKE '%;everyone;%' OR trustees LIKE '%;public;%' OR trustees LIKE '%;publicgroup;%' OR trustees='') OR [.].[editby] LIKE '%;PUBLIC;%' OR [.].[editby] LIKE '%;PUBLIC;%' OR [.].[reviewby] LIKE '%;PUBLIC;%' OR [.].[approveby] LIKE '%;PUBLIC;%') ORDER BY [.].[description],[.].[item]