Проект:Рутинная работа/Отсутствующие шаблоны

SELECT
  CONCAT('[[:Шаблон:', lt.lt_title, ']]') AS TemplateName,
  GROUP_CONCAT(DISTINCT CONCAT('[[', p2.page_title, ']]') SEPARATOR ', ') AS UsedInPages,
  COUNT(DISTINCT CONCAT(p2.page_namespace, ':', p2.page_title)) AS UsageCount
FROM templatelinks AS t
INNER JOIN linktarget AS lt ON lt.lt_id = t.tl_target_id
LEFT JOIN page AS p ON p.page_namespace = lt.lt_namespace AND p.page_title = lt.lt_title
INNER JOIN page AS p2 ON t.tl_from = p2.page_id
WHERE p.page_title IS NULL
  AND lt.lt_namespace = 10
  AND p2.page_content_model = "wikitext"
  AND p2.page_namespace = 0
GROUP BY lt.lt_title
LIMIT 5000;