Articles that have no assigned Wikiproject

SQL

select pageA.page_title
from page pageA
where pageA.page_namespace = 0
# Filter out hard redirects
and pageA.page_is_redirect = 0
and not exists(
  select 1 from categorylinks 
  join page pageB on pageB.page_namespace = 1 
  where pageB.page_id=categorylinks.cl_from 
  and pageB.page_title = pageA.page_title
  and (categorylinks.cl_to like "%articles")
)
and not exists(
  # Main article pages get disambiguation, set index tags and soft redirect indicators
  select 1 from categorylinks
  join templatelinks on tl_from = pageA.page_id
  where pageA.page_id=categorylinks.cl_from 
  and (categorylinks.cl_to like "%Disambiguation" 
       or categorylinks.cl_to like "%disambiguation%"
       or categorylinks.cl_to = "All_set_index_articles"
       # Redirects not of the form "R from ... which will be soft redirects with page_is_redirect=0"
       or tl_title = "Soft redirect" 
       or tl_title = "Double soft redirect"
       or tl_title = "Category redirect" 
       or tl_title = "Portal soft redirect"
       or tl_title = "Wiktionary redirect" 
       or tl_title = "Wikidata redirect" 
       or tl_title = "Wikibooks redirect" 
       or tl_title = "Wikiquote redirect" 
       or tl_title = "Wikisource redirect" 
       or tl_title = "Wikispecies redirect" 
       or tl_title = "Wikivoyage redirect" 
       or tl_title = "Commons redirect"
       # Filter out any other soft redirects (this is usually due to an ongoing RfD)
       or tl_title like "R\_%"))
limit 10
SQL

Checking query status...
