SELECT COUNT(DISTINCT rc_id), actor_name, GROUP_CONCAT(DISTINCT ug_group)

FROM recentchanges -- last 30 days

JOIN actor_recentchanges ON actor_id = rc_actor

LEFT JOIN user_groups ON ug_user = actor_user

WHERE rc_type IN (0, 1) -- create new page, edit existing page

  AND actor_user IS NOT NULL

GROUP BY rc_actor

HAVING COUNT(DISTINCT rc_id) > 1000 AND GROUP_CONCAT(DISTINCT ug_group) NOT RLIKE '\\b(bot|sysop)\\b'

ORDER BY COUNT(DISTINCT rc_id) DESC;