Untitled query #17297

SQL

USE arwiki_p;

SELECT rev_user_text, COUNT(rev_id) FROM revision

JOIN page on page_id = rev_page 
WHERE rev_user_text IN
(SELECT REPLACE(pl_title, '_', ' ') FROM pagelinks WHERE pl_from = 3271075 AND pl_namespace = 2 )
AND page_id IN 
(SELECT REPLACE(pl_title, '_', ' ') FROM pagelinks WHERE pl_namespace = 4 AND 
 pl_from IN 
 (SELECT page_id FROM page WHERE page_namespace = 4 AND page_title LIKE 'مشروع ويكي المرأة/%')
)
AND rev_parent_id = 0
AND page_namespace = 6
AND page_is_redirect = 0
AND rev_timestamp > 20160901000000 
AND rev_timestamp < 20161130235959
GROUP BY rev_user_text

;
SQL

Checking query status...
