Edit count Kurdistan articles

Fork of Edit count Armenia and Azerbaijan articles by BilledMammal

This query is marked as a draft This query has been published by BilledMammal.

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))

SELECT actor_name, 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

SQL

Checking query status...