Untitled query #68172

SQL

SELECT actor_name, page_title, sum(rev_len) AS contributions, rev_parent_id
FROM revision
JOIN page on page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
WHERE page_namespace = 0
	AND rev_timestamp >= '2018'
    AND rev_timestamp < '2019'
    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 rev_page, rev_actor
LIMIT 10000
SQL

Checking query status...
