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;