Untitled query #15086

SQL

use enwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
where pl.pl_from_namespace=0 and pl.pl_namespace=0
and exists (select pla.page_title
		from categorylinks cla
		join page pla on cla.cl_from=pla.page_id
		where pl.pl_from=pla.page_id and pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="All WikiProject_Medicine_articles")# in ("Top-importance_medicine_articles","High-importance_medicine_articles"))
		and NOT EXISTS (Select sp1.page_title from page sp1 where pl.pl_title=sp1.page_title and sp1.page_namespace=0)
and NOT EXISTS (select spl2.pl_title
					from pagelinks spl2
					left join page sp3 on spl2.pl_from=sp3.page_id
					where pl.pl_title=spl2.pl_title and sp3.page_namespace=10
                			and EXISTS (select tl2.tl_from
										from templatelinks tl2
										where spl2.pl_from=tl2.tl_from and tl2.tl_from_namespace=10)
							and spl2.pl_namespace=0)
group by pl.pl_title
#having COUNT(pl.pl_title)>10
order by COUNT(pl.pl_title) DESC
limit 1000;
SQL

Checking query status...
