Pdd existantes de modèles inexistants

SQL

USE frwiki_p;

SELECT
  CONCAT("\[\[Modèle:", REPLACE(page_pdd.page_title, '_', ' '), "\]\]") AS modele,
  CONCAT("{{a-redir-simple|Discussion modèle:", REPLACE(page_pdd.page_title, '_', ' '), "}}") AS pdd
  FROM 
       (SELECT page_title FROM page WHERE page_namespace = 10) AS page_modele
  RIGHT JOIN
       (SELECT page_title FROM page WHERE page_namespace = 11 AND page_is_redirect = 0 
        AND page_title NOT LIKE '%/Suppression%' AND page_title NOT LIKE N'%[Aa]rchive%'
        AND page_title NOT LIKE '%/À faire%' AND page_title NOT LIKE '%/Neutralité%') AS page_pdd
  ON page_modele.page_title = page_pdd.page_title
  WHERE page_modele.page_title IS NULL
ORDER BY page_pdd.page_title
SQL

Checking query status...
