use elwiki_p;

SELECT

  Concat('[[Πρότυπο:',tl_title,']]'),

  COUNT(*)

FROM templatelinks

WHERE tl_namespace = 10# and tl_from_namespace=0# tl_from_namespace=0

and tl_title like "Πληροφορίες%"

GROUP BY tl_title

ORDER BY COUNT(*) DESC

LIMIT 4000;