select s.spacename as 空间,count(case when contenttype='PAGE' then contenttype else null end) as 页面, count(case when contenttype='ATTACHMENT' and prevver is null then contenttype else null end) as 附件, count(case when contenttype='BLOGPOST' then contenttype else null end) as 博客 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 CONTENT_STATUS='current' group by s.spacename; |