Number of articles by editor by week past year

SQL

SELECT actor_name as "Creator",
    COUNT(*) as "Articles",
    FLOOR(-DATEDIFF(20210101, SUBSTRING(rev_timestamp, 1, 8)) / 7) + 1 AS WeeksSince2020
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_len >= 150 #94% of redirects are smaller than this; 95% of articles are created longer.
       OR rev_len < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smaller
GROUP BY Creator, WeeksSince2020
HAVING Articles > 2

AخA
 
SELECT actor_name as "Creator",    COUNT(*) as "Articles",    FLOOR(-DATEDIFF(20210101, SUBSTRING(rev_timestamp, 1, 8)) / 7) + 1 AS WeeksSince2020FROM revisionJOIN actor_revision ON actor_id = rev_actorJOIN page ON page_id = rev_pageWHERE rev_parent_id = 0  AND page_namespace = 0  AND page_is_redirect = 0  AND rev_timestamp >= '20210901'  AND (rev_len >= 150 #94% of redirects are smaller than this; 95% of articles are created longer.       OR rev_len < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smallerGROUP BY Creator, WeeksSince2020HAVING Articles > 2

SQL

Checking query status...