Edit count BLP articles summary

SQL

WITH ids AS (SELECT cl_from
	FROM categorylinks
	WHERE cl_to = "Living_people"),
                  
article AS (SELECT page_id
	FROM ids
    JOIN page ON page_id = cl_from
    WHERE page_namespace = 0),

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)
            
SELECT 
	SUM(edits) as "All Edits",
	SUM(reverted_edits) as "All Reverts",
	SUM(CASE WHEN total_edits > 499 THEN edits ELSE 0 END) as "EXC Edits",
	SUM(CASE WHEN total_edits > 499 THEN reverted_edits ELSE 0 END) as "EXC Reverts",
	SUM(CASE WHEN total_edits > 9 THEN edits ELSE 0 END) as "Auto Edits",
	SUM(CASE WHEN total_edits > 9 THEN reverted_edits ELSE 0 END) as "Auto Reverts",
	SUM(CASE WHEN total_edits < 10 THEN edits ELSE 0 END) as "Non-Auto Edits",
	SUM(CASE WHEN total_edits < 10 THEN reverted_edits ELSE 0 END) as "Non-Auto Reverts",
	SUM(CASE WHEN total_edits > 9 AND total_edits < 500 THEN edits ELSE 0 END) as "Auto, non-EXC Edits",
	SUM(CASE WHEN total_edits > 9 AND total_edits < 500 THEN reverted_edits ELSE 0 END) as "Auto, non-EXC Reverts"
FROM counts
SQL

Checking query status...
