Active high-volume enwiki editors

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/Special:Contributions/', u.user_name) AS 'User', COUNT(rc.rc_id) AS 'Edits in past 30 days', u.user_editcount AS 'Total edit count', TIMESTAMP(u.user_registration) AS 'Registered'
FROM user u
INNER JOIN actor a ON a.actor_user = u.user_id
INNER JOIN recentchanges_userindex rc ON rc.rc_actor = a.actor_id AND rc.rc_timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY)
WHERE u.user_registration <= DATE_SUB(NOW(), INTERVAL 1 YEAR)
AND u.user_editcount >= 500
AND u.user_id NOT IN (
	SELECT ug.ug_user
	FROM user_groups ug
	WHERE ug_group = 'bot'
)
GROUP BY u.user_id
HAVING COUNT(rc.rc_id) >= 30
ORDER BY u.user_name
SQL

Checking query status...
