-- Pronalaženje šablona koji se koriste samo na svojoj stranici

SELECT

  t.page_title AS template_title,

  COUNT(l.tl_from) AS usage_count

FROM page AS t

JOIN templatelinks AS l

  ON l.tl_namespace = t.page_namespace

  AND l.tl_target = t.page_title

WHERE t.page_namespace = 10

GROUP BY t.page_title, t.page_id

HAVING COUNT(l.tl_from) = 1

   AND MIN(l.tl_from) = t.page_id

ORDER BY t.page_title;

​