MassMessage - Quarry

Replica of https://quarry.wmflabs.org/query/57226 but with actor_revision table to show speed-up (about twice as fast).

SQL

SELECT
CONCAT("# {{target | user =",actor_name,"| site = mediawiki.org }}") AS rev_user_text,
COUNT(actor_id) AS recent_user_editcount
/*user_editcount*/
FROM revision
JOIN actor_revision ON rev_actor=actor_id
JOIN page ON rev_page=page_id
WHERE actor_user IS NOT NULL
  AND page_namespace IN (0)
  AND rev_timestamp BETWEEN 20190101000000 AND 20210630235959
  AND actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 300;

SQL

Checking query status...