SELECT s.SPACENAME AS "Space Name",  a.PAGEID, a.TITLE AS "File Name", a.ATTVERSION AS "Version", a.PAGEID, um.username AS "Modified BY", a.lastmoddate AS "Modified Date" FROM attachments a JOIN content c ON a.PAGEID = c.CONTENTID  JOIN spaces s ON c.SPACEID = s.SPACEID  JOIN user_mapping um ON a.lastmodifier  = um.user_key ORDER BY a.ATTVERSION DESC;