~ - Quarry

SQL

use cswiki_p;
select page_namespace, page_title from page where page_namespace like 0 and not page_is_redirect and not page_title like 'Hlavní_strana%' and page_id not in (select cl_from from categorylinks where (cl_to not like 'Údržba:%' and cl_to not like 'Monitoring:%' and cl_to not in (select page_title from page join page_props on page_id = pp_page where pp_propname = 'hiddencat')));
select page_namespace, page_title from page where page_namespace like 0 and not page_is_redirect and not page_title like 'Hlavní_strana%' and not page_id in (select cl_from from categorylinks where not cl_to like 'Údržba:%' and not cl_to like 'Monitoring:%' and not cl_to in (select page_title from page join page_props on page_id=pp_page where page_namespace like 14 and pp_propname='hiddencat'));
SQL

Checking query status...
