Untitled query #69214

SQL

SELECT actor_name as "Creator",
    COUNT(*) as "Articles",
    SUBSTRING(rev_timestamp, 1, 4) AS Year
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 >= '2002'
  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, Year
SQL

Checking query status...
