TEST - Quarry

SQL

USE arwiki_p;
SELECT user_name, first_edit, last_edit, user_editcount, articles_created
	FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision_userindex WHERE rev_user > 0 GROUP BY rev_user) AS latest
	JOIN user
		ON user_id = latest.rev_user
	LEFT JOIN (SELECT *, COUNT(*) AS articles_created FROM revision_userindex JOIN page ON page_id = rev_page
               WHERE rev_parent_id = 0 AND page_namespace = 0 GROUP BY rev_user) AS created
		ON created.rev_user = latest.rev_user
	JOIN (SELECT *, MIN(rev_timestamp) AS first_edit FROM revision_userindex WHERE rev_user > 0 GROUP BY rev_user) AS oldest
		ON oldest.rev_user = latest.rev_user
WHERE last_edit < DATE_ADD(NOW(), INTERVAL -1 YEAR)
AND (articles_created > 100 OR (user_editcount > 2000 AND last_edit - first_edit > 20000000000))
AND user_name NOT LIKE '%bot'
AND user_name NOT LIKE '%Bot'
AND user_name NOT LIKE '%BOT%'
#AND user_name NOT LIKE '%Bot[A-Z]%'
ORDER BY last_edit - first_edit DESC
LIMIT 200;
SQL

Checking query status...
