Fork of Oldest revision in draft space by JPxG
This query is marked as a draft This query has been published by JPxG.

SQL

AخA
 
# Adapted from "replicating Xtools stuff in a normal query", 29 Dec 2021.
SELECT rev_timestamp, page_title
#SELECT COUNT(*) AS revisions, COUNT(case rev_minor_edit when 1 then 1 else null end) AS minor_edits,
#COUNT(DISTINCT rev_actor) AS editors, MIN(rev_timestamp) AS first_timestamp,
#MIN(rev_id) AS first_rev, MAX(rev_timestamp) AS last_timestamp,
#MAX(rev_id) AS last_rev, actor_name AS page_author
FROM revision
INNER JOIN page
ON revision.rev_page = page.page_id
WHERE page_namespace = "119"
ORDER BY rev_timestamp ASC
LIMIT 1000;
# 0/1       main   2/3   user       4/5     wp      6/7     file  8/9     mediawiki 10/11  template
# 12/13     help   14/15 cat        100/101 portal  118/119 draft 710/711 timedtext 828/829 module
# 2300/2301 gadget 2302/2303 g. def -1      special -2 media
# Runs in like 13 seconds -- what da?
#SELECT COUNT(*) AS revisions, COUNT(DISTINCT rev_actor) AS editors, MIN(rev_timestamp) AS first_timestamp, rev_actor, rev_id
#FROM revision
#WHERE rev_page = 16601866;
# Runs in like 0.09 seconds.
#SELECT page_id FROM page WHERE page_title = "Skon" AND page_namespace = "0";
#SELECT COUNT(*) FROM revision WHERE rev_page = 16601866;
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...