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 ('20th-century sculptors',
                            '21st-century sculptors',
                            '21st-century_American_artists',
                            '21st-century_Canadian_artists',
                            '21st-century_Dutch_artists',
                            '21st-century_German_artists',
                            '21st-century_English_artists',
                            '21st-century_French_artists',
                            '21st-century_Italian_artists',
                            '21st-century_Spanish_artists',
                            '21st-century_American_painters',
                            '20th-century American painters',
                            '21st-century French painters',
                            '21st-century German painters',
                           '21st-century Dutch painters',
                           '21st-century Spanish painters',
                            '21st-century Italian painters',
                           '21st-century German painters',
                           '21st-century Canadian painters',
                          '21st-century Canadian artists',
                           '21st-century_English_painters',
                           '20th-century_English_painters',
                           '19th-century_English_painters'
                           '18th-century_English_painters'
                           '17th-century_English_painters'
                           '16th-century_English_painters',
                            'American installation artists',
                            'Alumni of Goldsmiths, University of London',
                            'Hunter College alumni', 
                            'Tufts University faculty', 
                            'School of Visual Arts alumni',
                            'Public art in London'
                           )
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...
