use cswiki_p;

select concat('# [[:Kategorie:', replace(page_title, '_', ' '), ']]') from page where page_namespace like 14

and page_id in (select tl_from from templatelinks where tl_title like "Metakategorie")

and page_title in (select cl_to from categorylinks where not cl_from in (select page_id from page where page_namespace like 14)) order by convert(page_title using utf8) collate utf8_czech_ci;