SQL
x
SELECT
user.user_name,
COUNT(*) AS count
FROM revision
JOIN page ON revision.rev_page = page.page_id
JOIN actor ON revision.rev_actor = actor.actor_id
JOIN user ON actor.actor_user = user.user_id
JOIN user_groups ON user.user_id = user_groups.ug_user AND user_groups.ug_group = 'sysop'
WHERE page.page_namespace = 4
AND page.page_title = 'Requête_aux_administrateurs'
AND rev_timestamp >= '20000101000000'
GROUP BY user.user_name
ORDER BY count DESC
LIMIT 200;
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.