SELECT p.page_id, p.page_title, p.page_touched, actor.actor_name AS creator_username

FROM page AS p

LEFT JOIN flaggedpages AS fp ON p.page_id = fp.fp_page_id

INNER JOIN (

    SELECT rev_page, MIN(rev_id) AS first_rev_id

    FROM revision

    GROUP BY rev_page

) AS first_rev ON p.page_id = first_rev.rev_page

INNER JOIN revision AS r ON first_rev.rev_page = r.rev_page AND first_rev.first_rev_id = r.rev_id

INNER JOIN actor ON r.rev_actor = actor.actor_id

INNER JOIN user_groups AS ug ON actor.actor_user = ug.ug_user AND ug.ug_group = 'editor'

WHERE 

    p.page_namespace = 0

    AND fp.fp_page_id IS NULL

    AND p.page_is_redirect = 0

ORDER BY creator_username DESC;