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
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
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 1000;
SQL

Checking query status...
