Most linked non-existing pages v2 (orwiki)

SQL

select now();

use orwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
#left join page p on pl.pl_from=p.page_id
where pl.pl_from_namespace=10 and pl.pl_namespace=10
		and not exists (Select * from page where page_namespace=10 and page_title=pl.pl_title)
        and not exists (select * from pagelinks pl2 where pl2.pl_from=184158 and pl2.pl_title=pl.pl_title)
        and not exists (
        		select *
				from pagelinks pl3
				left join page p on pl3.pl_from=p.page_id
				where pl3.pl_title=pl.pl_title
						and p.page_namespace=10# and pl3.pl_from IN (select tl_from
												#					from templatelinks
												#					where
												#					#(tl_title="Navbox" or tl_title="Sidebar") and
												#					tl_from_namespace=10)
						and pl_namespace=0
						)
                        
group by pl.pl_title
having COUNT(pl.pl_title)>10
order by COUNT(pl.pl_title) DESC, pl_title
#limit 850;
SQL

Checking query status...
