as

 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));