Untitled query #17039

SQL

USE arwiki_p;
SELECT
  article.page_title FROM revision
INNER JOIN page article ON 
	article.page_id = rev_page AND
    article.page_namespace = 0
INNER JOIN page talk ON 
	talk.page_title = article.page_title AND
    talk.page_namespace = 1
INNER JOIN categorylinks ON 
	cl_from = talk.page_id
WHERE 
	rev_timestamp BETWEEN "2017" AND "2018" AND 
    article.page_title IN (select REPLACE(l.ll_title, '_', ' ')
from langlinks l
join page p on p.page_id=l.ll_from
where p.page_namespace=0 and p.page_title in (select pla.page_title
                from categorylinks cla
                join page pla on cla.cl_from=pla.page_id
                where pla.page_namespace=1 and cla.cl_type="page" and
                                              cla.cl_to="WikiProject_Wiki_Loves_Women_translation")
and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="ar")
and l.ll_lang="ar")
GROUP BY article.page_id
LIMIT 20;
SQL

Checking query status...
