Sample revisions reverted by ClueBotNG

SQL

/*
SELECT revision_userindex.rev_id, revision_userindex.rev_comment_id, revision_userindex.rev_deleted, 
	revision_userindex.rev_timestamp, revision_userindex.rev_minor_edit, revision_userindex.rev_parent_id,
    revision_userindex.rev_len, comment.comment_text, page.*, actor.* 
FROM revision_userindex
JOIN actor ON rev_actor = actor_id
JOIN page ON rev_page = page_id
JOIN comment ON rev_comment_id = comment_id
WHERE actor_name = "ClueBot NG"
AND page_namespace IN (0, 1, 2, 3)
AND rev_id >= 393382306
LIMIT 10;
*/
SELECT rev_id
FROM revision_userindex
JOIN page ON rev_page = page_id
WHERE rev_actor = 589
AND page_namespace IN (0, 1, 2, 3)
#AND rev_id < 400000000; # 93007 in 526 seconds
#AND rev_id >= 400000000 AND rev_id < 430000000; #  took 1756 seconds
AND rev_id >= 430000000 AND rev_id < 460000000; #  took 1573 seconds
#AND rev_id >= 460000000 AND rev_id < 500000000; #  took 2255 seconds
#AND rev_id >= 500000000 AND rev_id < 550000000; #  took 2469 seconds
#AND rev_id >= 550000000 AND rev_id < 600000000; #  took 2001 seconds
#AND rev_id >= 600000000 AND rev_id < 650000000; #  took 2099 seconds
#AND rev_id >= 650000000 AND rev_id < 700000000; #  took 1976 seconds
#AND rev_id >= 700000000 AND rev_id < 750000000; #  took 1948 seconds
#AND rev_id >= 750000000 AND rev_id < 800000000; #  took 1672 seconds
#AND rev_id >= 800000000 AND rev_id < 850000000; #  took 1786 seconds
#AND rev_id >= 850000000; #  took 1236 seconds



#SELECT * from actor where actor.actor_name = "ClueBot NG"; # actor_id = 589, actor_user = 13286072
SQL

Checking query status...
