Number of articles by editor by day past year

SQL

SELECT actor_name as Creator,
    COUNT(*) as Articles,
    SUBSTRING(rev_timestamp, 1, 8) as Date
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND page_namespace = 0
  AND page_is_redirect = 0
  AND rev_timestamp >= '20210901'
  AND (rev_size >= 150 #94% of redirects are smaller than this; 95% of articles are created longer.
       OR rev_size < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smaller
  WHERE Articles > 2
GROUP BY Creator, Date

SQL

Checking query status...