Top ro.wikipedia users by number of created articles

SQL

USE rowiki_p;
SELECT user_name, user_editcount, articles_created
	FROM revision
	JOIN user
		ON user_id = rev_user
	LEFT JOIN (SELECT *, COUNT(*) AS articles_created FROM revision 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 = revision.rev_user
WHERE (articles_created > 100 OR (user_editcount > 2000))
/*
AND user_name NOT LIKE '%Bot'
AND user_name NOT LIKE '%Bot[A-Z]%'
AND user_name NOT LIKE '%BOT%'
AND user_name NOT LIKE '%bot'*/
ORDER BY articles_created DESC
limit 400;

SQL

Checking query status...