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.