Most regular editors on frwiki Admin requests (2022-2023)

Fork of Most regular editors on frwiki Admin requests (2022-2023) by LD

This query is marked as a draft This query has been published by Lepticed7.

SQL

SELECT
  user.user_name,
  COUNT(*) AS count,
  user_groups.ug_user
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
LEFT 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 >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), '%Y%m%d%H%i%s')
  AND user_groups.ug_user IS NULL
  AND ABS(revision.rev_len) > 100
GROUP BY user.user_name
ORDER BY count DESC
LIMIT 200;

SQL

Checking query status...