WITH items as (

    SELECT  rev_id, page_title, comment_text, actor_name, rev_timestamp, rev_minor_edit, rev_deleted, rev_len

    FROM revision

    JOIN page ON rev_page = page_id 

    LEFT JOIN comment_logging ON rev_comment_id = comment_id

    LEFT JOIN actor_logging ON rev_actor = actor_id

)

SELECT

   t1.page_title AS Article,

   t1.rev_timestamp AS Date,

   t1.comment_text AS "Edit summary",

   t1.actor_name AS Editor,

   t1.rev_deleted AS "Edit deleted",

   t1.rev_minor_edit AS Minor,

   t1.rev_len AS Length

FROM items t1

WHERE rev_page =16317734