~ - 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)) 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)) 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";
SQL

Checking query status...
