This query is marked as a draft This query has been published by Anarchyte.

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...