Edit count Kurds articles summary

SQL

WITH ids AS (SELECT cl_from
	FROM categorylinks
	WHERE cl_to = "WikiProject_Kurdistan"),
                  
title AS (SELECT page_title
	FROM ids
    JOIN page ON page_id = cl_from),
    
article AS (SELECT page_id
	FROM page
	WHERE page_namespace = 0
	AND page_title IN (SELECT *
                       FROM title)),

counts AS (SELECT edits, reverted_edits, user_editcount AS total_edits
FROM user
RIGHT JOIN (SELECT actor_user, actor_name, COUNT(*) AS edits, COUNT(ct_tag_id) AS reverted_edits
	FROM article
	JOIN revision ON page_id = rev_page
	JOIN actor ON actor_id = rev_actor
    LEFT JOIN change_tag ON ct_rev_id = rev_id AND (ct_tag_id = 582 OR ct_tag_id = 590)
	WHERE rev_timestamp > 20220000000000
    GROUP BY actor_id) editors ON actor_user = user_id),
            
sums AS (SELECT 
	SUM(edits) as "AllEdits",
	SUM(reverted_edits) as "AllReverts",
	SUM(CASE WHEN total_edits > 499 THEN edits ELSE 0 END) as "EXCEdits",
	SUM(CASE WHEN total_edits > 499 THEN reverted_edits ELSE 0 END) as "EXCReverts",
	SUM(CASE WHEN total_edits < 500 THEN edits ELSE 0 END) as "nonEXCEdits",
	SUM(CASE WHEN total_edits < 500 THEN reverted_edits ELSE 0 END) as "nonEXCReverts",
	SUM(CASE WHEN total_edits > 9 THEN edits ELSE 0 END) as "AutoEdits",
	SUM(CASE WHEN total_edits > 9 THEN reverted_edits ELSE 0 END) as "AutoReverts",
	SUM(CASE WHEN total_edits < 10 THEN edits ELSE 0 END) as "nonAutoEdits",
	SUM(CASE WHEN total_edits < 10 THEN reverted_edits ELSE 0 END) as "nonAutoReverts",
	SUM(CASE WHEN total_edits > 9 AND total_edits < 500 THEN edits ELSE 0 END) as "AutoAndNonEXCEdits",
	SUM(CASE WHEN total_edits > 9 AND total_edits < 500 THEN reverted_edits ELSE 0 END) as "AutoAndNonEXCReverts"
FROM counts)

SELECT 
	AllEdits,
	AllReverts,
    EXCEdits / AllEdits AS "% reverts all",
	EXCEdits,
	EXCReverts,
    EXCReverts / EXCEdits AS "% reverts EXC",
	nonEXCEdits,
	nonEXCReverts,
    nonEXCReverts / nonEXCEdits AS "% reverts non-EXC",
	AutoEdits,
	AutoReverts,
    AutoReverts / AutoEdits AS "% reverts auto",
	nonAutoEdits,
	nonAutoReverts,
    nonAutoReverts / nonAutoEdits AS "% reverts non-auto",
	AutoAndNonEXCEdits,
	AutoAndNonEXCReverts,
    AutoAndNonEXCReverts / AutoAndNonEXCEdits AS "% reverts auto, non-EXC",
    EXCEdits / AllEdits AS "% EXC edits",
    AutoEdits / AllEdits AS "% Auto edits"
FROM sums
SQL

Checking query status...
