Levels of revision deletion

SQL

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

SELECT rev_deleted, count(*) FROM revision
#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 < 20110000000000 # Run 393342, took 1390 secs
#WHERE rev_timestamp >= 20110000000000 AND rev_timestamp < 20130000000000 # Run 393345, took 1387.69 secs
WHERE rev_timestamp >= 20130000000000 AND rev_timestamp < 20150000000000 # Run , took  secs
#WHERE rev_timestamp >= 20110000000000 AND rev_timestamp < 20130000000000 # Run , took  secs
#WHERE rev_timestamp >= 20110000000000 AND rev_timestamp < 20130000000000 # Run , took  secs
AND rev_deleted > 0
GROUP BY rev_deleted;
SQL

Checking query status...
