Levels of revision deletion

SQL

#SELECT @min := MIN(rev_id), @max := MAX(rev_id) FROM revision;

SELECT rev_deleted, count(*) FROM revision
JOIN page ON page.page_id = revision.rev_page
#JOIN (SELECT FLOOR(@min + (@max - @min + 1) * RAND(1)) AS rev_id FROM revision LIMIT 1000000) AS random USING (rev_id)
#WHERE rev_timestamp >= 20090130081928 AND rev_timestamp < 20090600000000 # Run 393342, 393366, 393612 took 1305.14 secs
#WHERE rev_timestamp >= 20090600000000 AND rev_timestamp < 20100000000000 # Run 393345, 393365, 393628 took 1387.69 secs
WHERE rev_timestamp >= 20100000000000 AND rev_timestamp < 20110000000000 # Run 393353, 393364,  took 1512 secs
#WHERE rev_timestamp >= 20150000000000 AND rev_timestamp < 20170000000000 # Run 393358, 393363 took 1260.77 secs
#WHERE rev_timestamp >= 20170000000000 # Run 393359, 393361 took 1197.87 secs
#AND rev_deleted > 0
AND page_namespace in (0, 1, 2, 3)
GROUP BY rev_deleted;
SQL

Checking query status...
