Település infobox

SQL

select row_number() over (order by (select count('X') from templatelinks where tl_target_id = 
(select lt_id from linktarget where lt_namespace=10 and lt_title=page_title)) desc, page_title) s, concat('[[Sablon:', replace(page_title, '_', ' '), ']]') tpl, 
(select count('X') from templatelinks where tl_target_id = 
(select lt_id from linktarget where lt_namespace=10 and lt_title=page_title)) darab from page as t
where page_namespace=10
and page_title like '%település_infobox'
order by 3 desc, 2
SQL

Checking query status...
