Šablony mimo kategorie šablon

SQL

use cswiki_p;
select concat('Šablona:', replace(page_title, '_', ' ')) from page where page_namespace like 10 and not page_is_redirect and not page_title like 'Vyznamenat/%'
and not page_id in (select cl_from from categorylinks where cl_to rlike '([Šš]ablon|nfobox|álepk|LocMap)' and not cl_to like 'Monitoring:%' and not cl_to like 'Údržba:%' and not cl_to like 'Wikipedie:Šablony_používající_údaje_z_Wikidat' and not cl_to like 'Části taxoboxu'
                    and not cl_to in (select page_title from page join page_props on page_id=pp_page where pp_propname like 'hiddencat'));
SQL

Checking query status...
