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_id, 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
SQL

Checking query status...
