Hewiki unexisting templates

SQL

use hewiki_p;
select page_namespace as 'מרחב', page_title as 'ערך', tl_title as 'תבנית'
from page join templatelinks
on (page_namespace = 0 or page_namespace = 6 or page_namespace = 10 or page_namespace = 12 or page_namespace = 14 or page_namespace = 100)
and page_id = tl_from
and tl_namespace != 8
and not exists
(select * from page as p1
 where p1.page_namespace = tl_namespace
 and p1.page_title = tl_title)
and not
(page_namespace = 100
 and (tl_namespace <> 10
      or tl_title like "הידעת_מדינות_%"))
SQL

Checking query status...
