SQL
x
SELECT actor_id, actor_user, actor_name, rev_actor, ug_group, COUNT(actor_name) AS edits
FROM revision JOIN actor ON rev_actor = actor_id
JOIN page ON rev_page = page_id
JOIN user_groups ON actor_user = ug_user
WHERE rev_page = 5137507
AND rev_timestamp > (NOW() - INTERVAL 1 week)
AND ug_user NOT IN (SELECT DISTINCT user_groups.ug_user FROM user_groups WHERE ug_group = 'sysop')
GROUP BY actor_name
ORDER BY edits DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.