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, user_editcount AS total_edits
FROM (SELECT actor_user, actor_name, COUNT(*) AS edits
	FROM article
	JOIN revision ON page_id = rev_page
	JOIN actor ON actor_id = rev_actor
	WHERE rev_timestamp > 20220000000000
      GROUP BY actor_id)
JOIN user ON actor_user = user_id
SQL

Checking query status...
