Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Anarchyte
.
Toggle Highlighting
SQL
WITH original 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 JOIN comment_logging ON rev_comment_id = comment_id JOIN actor_logging ON rev_actor = actor_id ) SELECT db1.page_title AS Article, 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 original 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...