Cite doi/pmid templates for deletion (enwiki)

SQL

use enwiki_p;
/*select concat('Template:',p3.page_title)#count(*)
from categorylinks cl
join page p3 on p3.page_namespace=10 and p3.page_id=cl.cl_from
where cl.cl_to="Cite_pmid_templates"
and not exists (select * from pagelinks pl
						join page p on p.page_title=pl.pl_title and p.page_namespace=10 and pl.pl_namespace=p.page_namespace
						where p.page_id=cl.cl_from and pl.pl_namespace=10)
and not exists (select * from templatelinks tl
						join page p2 on p2.page_title=tl.tl_title and p2.page_namespace=10 and tl.tl_namespace=p2.page_namespace
						where p2.page_id=cl.cl_from and tl.tl_namespace=10)
and exists (select * from revision r
						where r.rev_user=7903804 and r.rev_page=cl.cl_from and r.rev_parent_id=0)
                     */
SELECT
  concat('Template:',tl_title),
  COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10# and tl_from_namespace=0
and exists (select *
          		from categorylinks cl
				join page p3 on p3.page_namespace=10 and p3.page_id=cl.cl_from
				where cl.cl_to="Cite_pmid_templates" and tl_title=p3.page_title
  )
GROUP BY tl_title
ORDER BY COUNT(*) DESC
#LIMIT 1000;
#limit 30;
SQL

Checking query status...
