USE wikidatawiki_p;

SELECT user_name, count(rc_id), user_editcount, GROUP_CONCAT( DISTINCT ug_group )

    FROM (SELECT * FROM categorylinks WHERE cl_to = 'User_lv-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;