use hewiki_p;

SET @rowno = 0;

select @rowno:=@rowno+1 as `rn`, 

(SELECT distinct(cl_to)  #replace(cl_to, "_", " ") as "category"#, replace(page_title, "_", " ") as "template"

from page join categorylinks

on page_id = cl_from

where page_namespace = 10

and page_title like "מפת_מיקום/%"

#and not cl_to = "תבניות_מיפוי_ללא_פירוט"

order by cl_to, page_title)

​