Edit count Armenia and Azerbaijan articles

SQL

WITH ar_articles AS (SELECT cl_from
	FROM categorylinks
	WHERE cl_to = "WikiProject_Armenia_articles"),
    
az_articles AS (SELECT cl_from
	FROM categorylinks
    WHERE cl_to = "WikiProject_Azerbaijan_articles"),
    
intersection AS (SELECT *
	FROM ar_articles
	WHERE cl_from IN (SELECT *
                  FROM az_articles)),
                  
title AS (SELECT page_title
	FROM intersection
    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...
