~ - Quarry

SQL

use cswiki_p;
select distinct result1.cl_to
from (select distinct cl_to from categorylinks where (cl_from in (select distinct tl_from from templatelinks where tl_title like "Navbox" and tl_from_namespace like 10 and tl_namespace like 10)) or cl_from in (select distinct page_id from page where page_namespace like 14)) as result1
left join (select distinct cl_to from categorylinks where (cl_from not in (select distinct tl_from from templatelinks where tl_title like "Navbox" and tl_from_namespace like 10 and tl_namespace like 10)) or cl_from not in (select distinct page_id from page where page_namespace like 14)) as result2
on result1.cl_to = result2.cl_to
where result2.cl_to is NULL and result1.cl_to not like "Navigační_šablony_%" and result1.cl_to not like "%_navigační_šablony" and result1.cl_to not like "Politické_navigační_šablony_%" and result1.cl_to not like "Fotbalové_navigační_šablony_%" and result1.cl_to not like "Geografické_navigační_šablony_%" and result1.cl_to not like "Tematické_navigační_šablony_%";
SQL

Checking query status...
