DRAFTNOCAT - Quarry

SQL

-- select count(cat_title) from category where cat_title like '%|%';
select page_namespace, page_title, cl_to from page
join categorylinks on cl_from = page_id
where page_namespace in (2, 118)
and cl_to not in (
  select page_title from templatelinks join page on tl_from = page_id and page_namespace = 14 where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('Possibly_empty_category', 'Maintenance_category', 'Polluted_category') and lt_namespace = 10
  )
)
and cl_to not like 'Drafts\_about\_%'
and cl_to not like '%\_drafts'
and cl_to not like 'CS1\_maint%'
limit 100
SQL

Checking query status...
