Unassessed articles

SQL

SELECT *
FROM page AS a
WHERE a.page_namespace = 0
  AND NOT EXISTS (SELECT 1 FROM page AS t WHERE t.page_namespace = 1 AND a.page_title = t.page_title)
  AND a.page_is_redirect = 0
  AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = a.page_id AND (cl_to = 'Candidates_for_speedy_deletion' OR cl_to = 'All_articles_proposed_for_deletion' OR cl_to = 'Temporary_maintenance_holdings' OR cl_to = 'All_disambiguation_pages' OR cl_to = 'All_set_index_articles' OR cl_to = 'Lists_of_lists' OR cl_to = 'Monitored_short_pages' OR cl_to = 'Short_lists_of_lists' OR cl_to = 'Long_lists_of_lists' OR cl_to LIKE 'Redirects_to%'))
LIMIT 100
SQL

Checking query status...
