c1.spaceid,s.spacekey,s.spacename,sum(cp.longval) as "size (byte)"
from content c1 join content c2 on c1.contentid = c2.pageid
join contentproperties cp on c2.contentid = cp.contentid
join spaces s on c1.spaceid=s.spaceid
where c2.contenttype='ATTACHMENT'
group by c1.spaceid, s.spacekey, s.spacename; SELECT u.username , c.cp_type , c.creationdate , c.lastmoddate
FROM content_perm AS c
JOIN user_mapping AS u
ON c.username = u.user_key
WHERE c.cps_id in (SELECT id FROM content_perm_set WHERE content_id in (SELECT contentid FROM content WHERE title= '<page title here>' ORDER BY version DESC LIMIT 1)); https://ektron0116.neocities.org/software/disconnect.zip
沒有留言:
張貼留言