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.