Pages that call a non-existent template

Fork of Most used templates on frwikisource by VIGNERON en résidence

This query is marked as a draft This query has been published by Seudo.

SQL

/* Créée en 2022.
Mise à jour le 16 août 2023 suite à une modification de schéma de templatelinks */
SELECT concat("[[Spécial:Pages liées/Modèle:", linktarget.lt_title, "]]")
  FROM templatelinks, linktarget
LEFT JOIN page page_cible
  ON page_cible.page_namespace = linktarget.lt_namespace 
    AND page_cible.page_title = linktarget.lt_title 
INNER JOIN page page_origine
  ON templatelinksdddd.tl_from  = page_origine.page_id

WHERE page_cible.page_title IS NULL
  AND linktarget.lt_id = templatelinks.tl_target_id
  AND linktarget.lt_namespace = 10 
  AND linktarget.lt_title not like "%/documentation" 
  AND page_origine.page_namespace in (0, 4, 10, 12, 14, 102, 104, 106)  	
GROUP BY 1

SQL

Checking query status...