SELECT

  t.page_title AS "Šablon",

  MIN(p.page_title) AS "Podstranica",

  CONCAT(t.page_title, '/dok') AS "Očekivano",

  COUNT(*) AS "BrojTranskluzija"

FROM page AS t

JOIN templatelinks AS tl ON tl.tl_target_id = t.page_id

JOIN page AS p ON p.page_id = tl.tl_from

WHERE t.page_namespace = 10

GROUP BY t.page_title

HAVING COUNT(*) = 1

  AND LOWER(TRIM(MIN(p.page_title))) = LOWER(TRIM(CONCAT(t.page_title, '/dok')));