Stránky mimo hlavní kategorie

SQL

use cswiki_p;
select concat(replace(replace(replace(page_namespace, '100', 'Portál'), '12', 'Nápověda'), '4', 'Wikipedie'), ':', replace(page_title, '_', ' ')) from page where (((page_namespace like 4 or page_namespace like 100) and not page_title like '%/%') or page_namespace like 12) and not page_is_redirect
and not page_id in (select cl_from from categorylinks where (cl_to like 'Wikipedie:%' or cl_to like 'Nápověda:%')
                    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...
