use hewiki_p;

select concat('[[:קטגוריה:', replace(cl_to, "_", " "), ']]') as "category",

       concat('[[תבנית:', 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 in ("תבניות_מיפוי_עם_פירוט", "תבניות_מיפוי_ללא_פירוט")

order by cl_to, page_title

​