SQL
x
SELECT actor_name, 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 rev_actor = ug_user
WHERE rev_page = 5137507
AND rev_timestamp > (NOW() - INTERVAL 2 day)
# WHERE NOT EXISTS ( SELECT 1 FROM user_groups WHERE ug_user = rev_actor AND ug_group = 'sysop' )
GROUP BY tmp.actor_name
ORDER BY DESC(edits);
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.