~ - Quarry

SQL

use cswiki_p;
select concat('Kategorie:', replace(page_title, '_', ' ')) from page where page_namespace like 14 and page_title rlike '(ablon|nfobox)' and ((page_title like '%–%' and page_id not in (select cl_from from categorylinks where (cl_to like 'Šablony:Podle_zemí') or (cl_to like 'Šablony:Podle_zaniklých_zemí'))) or (page_title like '%-%' and page_id not in (select cl_from from categorylinks where (cl_to like 'Infoboxy_podle_zemí' or cl_to like 'Navigační_šablony_podle_zemí'))));
SQL

Checking query status...
