Most linked non-existing pages v2 (lvwiki)

SQL

select now();

use lvwiki_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=0 and pl.pl_namespace=0
		and not exists (Select * from page where page_namespace=0 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 pl.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...
