select s.spacename,count(case when contenttype="PAGE" then contenttype else null end) as Page, count(case when contenttype="ATTACHMENT" then contenttype else null end) as Attachment from CONTENT c join SPACES s on c.spaceid=s.spaceid JOIN SPACEPERMISSIONS sp ON s.spaceid=sp.spaceid where sp.PERMALLUSERSSUBJECT is null and sp.PERMGROUPNAME is null and sp.PERMUSERNAME is null and c.CONTENT_STATUS="current" group by s.spacename; |