Miscategorized DAB/SIA

SQL

/*
with recursive subcats (cat_title) as (
  select distinct cl_to from categorylinks where cl_to in ('Disambiguation_pages')
  union all
  select page_title from subcats, categorylinks, page
  where cl_type = 'subcat' and cl_from = page_id and cl_to = cat_title and page_title != 'All_disambiguation_pages'
)

select distinct page_namespace, page_title from subcats
join categorylinks on cl_to = cat_title and cl_type != 'subcat'
join page on cl_from = page_id
and page_id not in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type != 'subcat')
order by page_namespace;
*/

with recursive subcats (cat_title) as (
  select distinct cl_to from categorylinks where cl_to in ('Set_index_articles')
  union all
  select page_title from subcats, categorylinks, page
  where cl_type = 'subcat' and cl_from = page_id and cl_to = cat_title and page_title != 'All_set_index_articles'
)

select distinct page_namespace, page_title from subcats
join categorylinks on cl_to = cat_title and cl_type != 'subcat'
join page on cl_from = page_id
and page_id not in (select cl_from from categorylinks where cl_to = 'All_set_index_articles' and cl_type != 'subcat')
order by page_namespace;
SQL

Checking query status...
