unreviewed, not biography

SQL

SELECT DISTINCT article.page_title
FROM page article
JOIN revision ON article.page_id = rev_page 
JOIN pagetriage_page ON rev_page = ptrp_page_id 
WHERE rev_parent_id = 0
AND ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0
AND article.page_title NOT IN (
    SELECT DISTINCT talkpage.page_title 
    FROM page article
    JOIN revision ON article.page_id = rev_page 
    JOIN page talkpage ON article.page_title = talkpage.page_title
    JOIN templatelinks ON talkpage.page_id=templatelinks.tl_from
    JOIN pagetriage_page ON rev_page = ptrp_page_id 
    WHERE rev_parent_id = 0
    AND ptrp_reviewed = 0
    AND article.page_namespace = 0
    AND talkpage.page_namespace = 1
    AND templatelinks.tl_title IN ('WikiProject_Songs',
                                    'WikiProject_Albums',
                                    'WikiProject_Trains',
                                    'WikiProject_China',
                                    'WikiProject_Korea',
                                    'WikiProject_Motorsport',
                                    'WikiProject_Biography',
                                    'WikiProject_Film',
                                    'WikiProject_Television',
                                    'WikiProject_Basketball',
                                    'WikiProject_Baseball',
                                    'WikiProject_India',
                                    'WikiProject Professional_wrestling',
                                    'WikiProject_Romania',
                                    'WikiProject_Serbia',
                                    'WikiProject_Schools',
                                    'WikiProject_Women',
                                    'WikiProject_Women_in_Business',
                                    'WikiProject Ohio',
                                   'WikiProject_College_football',
                                   'WikiProject_American_football'
                                   )
)
SQL

Checking query status...
