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 count(*)
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;
#SELECT * from actor where actor.actor_name = "ClueBot NG"; # actor_id = 589, actor_user = 13286072
SQL

Checking query status...
