Untagged Zagreb WG articles

SQL

use enwiki_p;

select * 
from page pa
inner join categorylinks cl on cl.cl_from = pa.page_id
where pa.page_namespace = 0 and cl.cl_to in (
# Categories below "Zagreb"
select pa.page_title 
from page pa
inner join categorylinks cl on cl.cl_from = pa.page_id
where pa.page_namespace = 14 and cl.cl_to = "Zagreb" and pa.page_title <> "People_from_Zagreb"
) and pa.page_title not in (
select pa.page_title
from page pa
inner join categorylinks cl on cl.cl_from = pa.page_id
where cl.cl_to = "Zagreb_articles"
) 
limit 100
SQL

Checking query status...
