Hewiki unexisting templates

SQL

use hewiki_p;
select page_namespace as 'מרחב', page_title as 'דף', tl_title as 'תבנית'
from page join templatelinks
on page_namespace = 4 #in (0, 4, 6, 8, 10, 12, 14, 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 "הידעת_מדינות_%"))
and not (page_namespace = 8
         and page_title like "%.js")
and not (page_namespace = 4
         and (page_title like "%OTRS%"
              or page_title like "%בקשות_לבדיקה%"
              or page_title like "%דלפק_ייעוץ%"
              or page_title like "%הכה_את_המומחה%"
              or page_title like "%זכויות_יוצרים%"
              or page_title like "%יומן_מחיקות%"
              or page_title like "%סדנה_לגרפיקה%"
              or page_title like "%המלצות_קודמות%"
              or page_title like "%אולם_דיונים%"
              or page_title like "%עבודות_ויקידמיות%"
              or page_title like "%ארכיון%"
              or page_title like "%סקר_ויקיפדיה%"
              or page_title like "%איך_להקים_אסם%"
              or page_title like "%מיזמי_ויקיפדיה/נבחרי_ציבור_פוטנציאליים%"
              or page_title like "%הומור%"
              or page_title like "%בוט_החלפות%"))
SQL

Checking query status...
