unreviewed, not biography

SQL

SELECT DISTINCT article.page_title, rev_timestamp
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 (
      # Entertainment
      'WikiProject_Albums',
      'WikiProject_Comics',
      'WikiProject_Songs',
      'WikiProject_Eurovision',
      'WikiProject_Film',
      'WikiProject_Television',
      'WikiProject_Video_games',
      'WikiProject_Professional_wrestling',
      'WikiProject_Anime_and_manga',
      'WikiProject_Amusement_Parks' 
      # Sports
      'WikiProject_College_football',
      'WikiProject_American_football',
      'WikiProject_College_Basketball',
      'WikiProject_Basketball',
      'WikiProject_National_Basketball_Association',
      'WikiProject_Baseball',
      'WikiProject_Boxing',
      'WikiProject_Football',
      'WikiProject_Motorsport',
      'WikiProject_Rugby_union',
      "WikiProject Women's sport",
      # Countries
      'WikiProject_Germany',
      'WikiProject_Austria',
      'WikiProject_France',
      'WikiProject_Italy',
      'WikiProject_Spain',
      'WikiProject_Korea',
      'WikiProject_Palestine',
      'WikiProject_Iran',
      'WikiProject_China',
      'WikiProject_India',
      'WikiProject_Sri_Lanka',
      'WikiProject_Romania',
      'WikiProject_Serbia',
      'WikiProject_Thailand',
      'WikiProject_Turkey',
      # Religion
      'WikiProject_Religion',
      'WikiProject_Hinduism',
      'WikiProject_Buddhism',
      # other
      'WikiProject_Schools',
      'WikiProject_Politics',
      'WikiProject_Women',
      'WikiProject_Women_in_Business'
      'WikiProject_Companies',
      'WikiProject_Business',
      'WikiProject_Record_labels',
      'WikiProject_Cryptocurrency',
      'WikiProject_Firearms',
      'WikiProject_Military_history',
      'WikiProject_Trains',
      'WikiProject_Articles for creation',
      'WikiProject_Lists',
      'WikiProject_Biography'
    )
)
SQL

Checking query status...
