Article creations by editor and size

SQL

WITH all_creations AS (SELECT page_id, page_title, rev_actor, page_len, rev_id
	FROM page
    JOIN revision ON page_id = rev_page
    WHERE page_namespace = 0
    	AND rev_parent_id = 0
		AND rev_timestamp >= '2018'
    	AND rev_timestamp < '2019'
),

not_redirect AS (SELECT page_id, page_title, rev_actor, page_len
    FROM all_creations
    LEFT JOIN change_tag ON rev_id = ct_rev_id AND ct_tag_id = 11
    AND ct_tag_id IS NULL,
)

creations AS (SELECT page_id, page_title, rev_actor, page_len
	FROM all_creations
	LEFT JOIN categorylinks ON cl_from = page_id AND (
		cl_to IN ("All_article_disambiguation_pages", 
         "Temporary_maintenance_holdings", 
         "Redirects_to_Wiktionary",
         "Surnames", 
         "Given_names")
		OR cl_to LIKE 'List%')
	WHERE cl_to IS NULL
),

deltas AS (SELECT (CAST(child_rev.rev_len as SIGNED) - CAST((CASE WHEN parent_rev.rev_len IS NOT NULL THEN parent_rev.rev_len ELSE 0 END) as SIGNED)) as deltas, page_id, page_title, creations.rev_actor as creator_id, child_rev.rev_actor as editor_id, page_len
	FROM creations
    JOIN revision AS child_rev ON creations.page_id = child_rev.rev_page
    LEFT JOIN revision AS parent_rev ON child_rev.rev_parent_id = parent_rev.rev_id
)

#SELECT creator.actor_name as Creator, editor.actor_name as Editor, page_title as Article, page_len as "Current length", SUM(deltas) as Contributions
#FROM deltas
#JOIN actor AS creator on creator_id = creator.actor_id
#JOIN actor AS editor on editor_id = editor.actor_id
#GROUP BY page_title, editor.actor_id

SELECT *
FROM not_redirect
SQL

Checking query status...
