list - Quarry

SQL

USE bnwiki_p;

SELECT
  CONCAT("# {{target | user =", actor_name, "| site = bn.wikipedia.org }}") AS rev_user_text,
  COUNT(actor_id) AS recent_user_editcount
FROM revision
JOIN actor ON rev_actor = actor_id
JOIN page ON rev_page = page_id
LEFT JOIN ipblocks ON actor_user = ipb_user
LEFT JOIN global_user_groups ON actor_user = gug_user
WHERE actor_user IS NOT NULL
  AND page_namespace IN ('0','1','2','3','4','5')
  AND rev_timestamp BETWEEN 20200000000000 AND 20231231235959
  AND ipb_user IS NULL  -- Exclude blocked users
  AND (gug_group IS NULL OR gug_group != 'global-lock')  -- Exclude globally locked users
  AND actor_user NOT IN (
    SELECT ug_user
    FROM user_groups
    WHERE ug_group = 'bot'
  )  -- Exclude bot accounts
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 1000;
SQL

Checking query status...
