첨부파일이 5개 이상인 페이지의 스페이스 정보, 사용자 정보, 페이지 정보 등을 표시합니다.
SELECT *
FROM (
select r.pageid, r.spaceid, s.spacename, r.username, r.pageTitle, count(r.title) as attachment_count
from (
SELECT DISTINCT c.pageid, c.spaceid, u.username, c.title, co.title AS pageTitle
FROM CONTENT c
INNER JOIN user_mapping u
ON u.user_key = c.creator
INNER JOIN CONTENT co
ON c.pageid = co.contentid
INNER JOIN CONTENTPROPERTIES cn
ON cn.contentid = c.contentid
WHERE c.contenttype = 'ATTACHMENT'
AND c.title is not null
AND c.content_status != 'deleted'
AND c.prevver is null
ORDER BY c.pageid DESC
) r
INNER JOIN SPACES s
ON r.spaceid = s.spaceid
WHERE r.pageTitle is not null
GROUP BY r.pageid, r.spaceid, s.spacename, r.username, r.pageTitle
ORDER BY r.pageid DESC
) f
WHERE f.attachment_count > 5;
