Pages that call a non-existent template

SQL

/* Créée en 2022.
Mise à jour le 16 août 2023 suite à une modification de schéma de templatelinks */
SELECT concat("[[Modèle:", linktarget.lt_title, "]]") as "Modèle",
   page_from.page_namespace as "Espace de nommage source", page_from.page_title as "Page source"
FROM page page_from, linktarget, templatelinks
WHERE linktarget.lt_id = templatelinks.tl_target_id
  AND linktarget.lt_namespace = 10
  AND linktarget.lt_title not like "%/documentation" 
  AND page_from.page_id = templatelinks.tl_from
  AND page_from.page_namespace in (0, 4, 10, 12, 14, 102, 104, 106)
  AND NOT EXISTS
   (SELECT 'x' FROM page
    WHERE page.page_namespace = linktarget.lt_namespace
    AND page.page_title = linktarget.lt_title)
ORDER BY 1, 2, 3
SQL

Checking query status...
