Untitled query #59430

SQL

SELECT  page.page_title, categorylinks.cl_to
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 IN ('Artists from California', 'American_artists', 'Belgian architects')
AND categorylinks.cl_to NOT IN ('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_pages_needing_cleanup', 
  #                              'All_stub_articles',
                               )
SQL

Checking query status...
