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 >= '2013'
    	AND rev_timestamp < '2014'
),

not_redirect AS (SELECT DISTINCT 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
    WHERE ct_tag_id IS NULL
),

creations AS (SELECT page_id, page_title, rev_actor, page_len
	FROM not_redirect
	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
ORDER BY page_len
SQL

Checking query status...
