Most SPI edits this year

SQL

SELECT actor_name, COUNT(page_id) as `edits`
FROM user_groups
JOIN actor_revision ON ug_user = actor_user
LEFT JOIN revision_userindex ON (
  rev_actor = actor_id
  AND rev_timestamp > "20210000000000"
)
LEFT JOIN page ON (
  rev_page = page_id
  AND page_namespace = 4
  AND page_title LIKE "Sockpuppet_investigations/%"
)
WHERE
    ug_group = "sysop"
    OR actor_name IN ("Tamzin", "Spicy", "Jack Frost", "1997kB", "Praxidicae") # NA-clerks
GROUP BY actor_id
ORDER BY edits DESC

AخA
 
SELECT actor_name, COUNT(page_id) as `edits`FROM user_groupsJOIN actor_revision ON ug_user = actor_userLEFT JOIN revision_userindex ON (  rev_actor = actor_id  AND rev_timestamp > "20210000000000")LEFT JOIN page ON (  rev_page = page_id  AND page_namespace = 4  AND page_title LIKE "Sockpuppet_investigations/%")WHERE    ug_group = "sysop"    OR actor_name IN ("Tamzin", "Spicy", "Jack Frost", "1997kB", "Praxidicae") # NA-clerksGROUP BY actor_idORDER BY edits DESC

SQL

Checking query status...