Untitled query #5160

SQL

USE commonswiki_p;
SELECT user_name, count(rc_id), user_editcount, GROUP_CONCAT(DISTINCT ug_group)
	FROM (SELECT * FROM categorylinks WHERE cl_to = 'User_ro-N') AS userpages
	JOIN (SELECT * FROM page WHERE page_namespace = 2) AS users ON page_id = cl_from
	JOIN user ON user_name = REPLACE(page_title,"_"," ")
	JOIN (SELECT * FROM recentchanges WHERE rc_namespace > -1) AS recent ON user_id = rc_user
	LEFT JOIN user_groups ON ug_user = user_id
GROUP BY user_name
ORDER BY count(rc_id) DESC, user_editcount DESC, user_name LIMIT 100;
SQL

Checking query status...
