Untitled query #63421

SQL

WITH selection 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
   db1.page_title AS Article,
   db1.rev_id AS rev_id,
   db1.rev_timestamp AS Date,
   db1.comment_text AS "Edit summary",
   db1.actor_name AS Editor,
   db1.rev_deleted AS "Edit deleted",
   db1.rev_minor_edit AS "Minor edit",
   db1.rev_len AS "Article length after edit"
FROM selection db1
WHERE page_title ="Siddington,_Gloucestershire"
ORDER BY Date ASC
SQL

Checking query status...
