Users by editcount

SQL

USE commonswiki_p;
SELECT user_name,
	user_editcount,
	LEFT(user_registration,4) AS reg,
	(SELECT rev_timestamp from revision_userindex where rev_user = user_id ORDER BY rev_timestamp DESC LIMIT 1) AS last_edit,
	GROUP_CONCAT(DISTINCT ug_group SEPARATOR ' ') AS grps,
	CONCAT(ipb_expiry, ' &mdash; ', ipb_reason) AS block
FROM user u
LEFT JOIN user_groups ON u.user_id=ug_user
LEFT JOIN ipblocks ON ipb_user=u.user_id
LEFT JOIN revision_userindex ON rev_user=u.user_id
WHERE user_editcount>=10000
GROUP BY user_name
LIMIT 10;
SQL

Checking query status...
