Untitled query #75883

SQL

SELECT page_from.page_namespace as "Espace de nommage source", page_from.page_title as "Page source", 
   linktarget.lt_title as "Modèle appelé"
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 page_from.page_namespace, page_from.page_title
SQL

Checking query status...
