Ανύπαρκτα πρότυπα

SQL

SELECT P.page_namespace, P.page_title, tl_namespace, tl_title
      FROM templatelinks 
      JOIN page AS P ON P.page_id = tl_from
      LEFT JOIN page AS L on L.page_namespace = tl_namespace AND L.page_title = tl_title
      WHERE L.page_namespace IS NULL
      
-- use elwiki_p;
-- select tl_title as 'protypo', page_title as 'lemma', case tl_namespace when 10 then "" else tl_namespace end as 'temp'
-- from page join templatelinks
-- on page_namespace = 0
-- 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)
-- order by protypo
SQL

Checking query status...
