Most regular admin editors on frwiki Admin requests (07.2022-07.2023)

SQL

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 >= '20220719000000' 
  AND rev_timestamp <= '20230719235959'
GROUP BY user.user_name
ORDER BY count DESC
LIMIT 200;

SQL

Checking query status...