Article creations by editor and size

SQL

WITH excluded_pages AS (SELECT cl_from
	FROM categorylinks
	WHERE cl_to IN 
		("All_article_disambiguation_pages", 
         "Temporary_maintenance_holdings", 
         "Redirects_to_Wiktionary",
         "Surnames", 
         "Given_names")
    LIMIT 100
),

all_revisions AS (SELECT *#page_id, page_title, actor_name
	FROM revision
	JOIN page on page_id = rev_page
	LEFT JOIN excluded_pages ON page_id = cl_from
	JOIN actor_revision ON actor_id = rev_actor
	WHERE cl_from IS NULL
    	AND page_namespace = 0
		AND rev_timestamp >= '2018'
    	AND rev_timestamp < '2019'
        AND rev_parent_id = 0
        AND (revision.rev_len >= 150 #94% of redirects are smaller than this; 95% of articles are created longer.
        OR revision.rev_len < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smaller
	LIMIT 100
                 ),

editor_contributions AS (SELECT actor_revision.actor_name as Editor, all_revisions.actor_name as Creator, page_title as Article, sum(all_revisions.rev_len) AS Contributions
	FROM all_revisions
    JOIN revision on page_id = rev_page
	JOIN actor_revision ON actor_id = rev_actor
    LIMIT 1000
   # GROUP BY rev_page, rev_actor
)

SELECT *
FROM all_revisions
SQL

Checking query status...
