Untitled query #63421

SQL

WITH items as (
    SELECT  rev_id, page_title, comment_text, actor_name, rev_timestamp, rev_minor_edit, rev_deleted, rev_len
    FROM revision
    LEFT 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 page_title ="Siddington, Gloucestershire"
SQL

Checking query status...
