Hewiki red links from articles to articles

SQL

use hewiki_p;
select pl_count as 'מספר הקישורים', pl_title as 'שם הערך' from
(select count(*) as pl_count, pl_title from pagelinks as pl1
 where pl1.pl_from_namespace = 0
 and pl1.pl_namespace = 0
and not exists
(select * from page
 where pl1.pl_title = page_title
 and page_namespace = 0)
and not exists
(select * from templatelinks
 where pl1.pl_from = tl_from
 and tl_from_namespace = 0
 and tl_namespace = 10
 and exists
(select * from page
 where tl_title = page_title
 and page_namespace = 10
 and exists
(select * from pagelinks as pl2
 where page_id = pl2.pl_from
 and pl2.pl_from_namespace = 10
 and pl2.pl_namespace = 0
 and pl2.pl_title = pl1.pl_title)))
group by pl1.pl_title) as t
order by 'מספר הקישורים' desc
SQL

Checking query status...
