Untitled query #89323

SQL

SELECT
  ROW_NUMBER() OVER (ORDER BY COUNT(actor_id) DESC) AS row_number,
  CONCAT("[[Special:Contributions/", actor_name, "]]") AS rev_user_text,
  COUNT(actor_id) AS recent_user_editcount,
  SUM(CASE WHEN page_namespace = '0' THEN 1 ELSE 0 END) AS namespace_0_editcount
/*user_editcount*/
FROM revision
JOIN actor ON rev_actor = actor_id
JOIN page ON rev_page = page_id
WHERE actor_user IS NOT NULL
  AND page_namespace IN ('0', '10', '100', '2', '828', '14')
  AND NOT (actor_name LIKE '%AWB%' OR actor_name LIKE '%Bot%' OR actor_name LIKE '%bot%' OR actor_name = 'CommonsDelinker')
  AND rev_timestamp BETWEEN 20240101000000 AND 20241231000000
  AND actor_name IN ('username1', 'username2', 'username3')
GROUP BY actor_id, actor_name
ORDER BY recent_user_editcount DESC;
;
SQL

Checking query status...
