Untitled query #23962

SQL

use arwiki_p;
select p.page_title, p.page_id
FROM revision
INNER JOIN page p ON p.page_namespace=0 and p.page_title in (select pla.page_title
		from categorylinks cla
		INNER join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
		where p.page_title=pla.page_title and pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="مقالات_مشروع_ويكي_طب")
        and rev_timestamp BETWEEN "2017" AND "2018"
#and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
order by p.page_id desc
limit 100;
SQL

Checking query status...
