Top ro.wikipedia users by number of created articles

SQL

USE rowiki_p;
SELECT user_name, first_edit, last_edit, user_editcount, articles_created
	FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision 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 JOIN page ON page_id = rev_page
               WHERE rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 0 GROUP BY rev_user) AS created
		ON created.rev_user = latest.rev_user
	JOIN (SELECT *, MIN(rev_timestamp) AS first_edit FROM revision WHERE rev_user > 0 GROUP BY rev_user) AS oldest
		ON oldest.rev_user = latest.rev_user
WHERE (articles_created > 300 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...
