OAbot tool users and diffs

SQL

USE enwiki_p;
SELECT rev_actor, count(rev_id) AS count, GROUP_CONCAT(rev_id) AS diffs
FROM revision
-- Hardcoded IDs from manual comment table queries in batches of 50M rows
-- select comment_id from comment where comment_id > 100000000 and comment_id < 150000000 and comment_text LIKE "Added free to read link in citations%";
WHERE rev_comment_id IN (1334144, 9033406, 9145070, 9145488, 18306637, 283611845, 308550788)
AND rev_id > 945000000
-- AND rev_id < 800000000
GROUP BY rev_actor
HAVING count < 5
LIMIT 300;
SQL

Checking query status...
