unreviewed, not biography

SQL

#SELECT  page.page_title, categorylinks.cl_to
SELECT DISTINCT page.page_title
FROM page JOIN categorylinks ON page.page_id=categorylinks.cl_from
WHERE page.page_id IN (
SELECT page.page_id
FROM revision 
JOIN pagetriage_page ON rev_page = ptrp_page_id 
JOIN page ON page_id = rev_page 
WHERE rev_parent_id = 0
AND ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0
) 
AND page.page_namespace=0
#AND categorylinks.cl_to NOT LIKE '%deaths' OR '%births'
AND categorylinks.cl_to NOT REGEXP 'people|women|deaths|births|songs|films|albums|series|sports|muscians'
AND categorylinks.cl_to NOT IN (
  'Living people',
  'All_disambiguation_pages',
  'All_articles_lacking_sources',
  'All_articles_with_empty_sections',
  'All_articles_with_topics_of_unclear_notability',
  'All_articles_lacking_in-text_citations',
  'All_articles_needing_additional_references',
  'All_articles_lacking_reliable_references',
  'All_articles_with_failed_verification',
  'All_pages_needing_cleanup', 
  'All_stub_articles',
  'All_articles_to_be_merged',
  'All_articles_with_unsourced_statements',
  'All_BLP_articles_lacking_sources',
  'All_articles_proposed_for_deletion'
)
SQL

Checking query status...
