unreviewed, not biography

SQL

SELECT DISTINCT talkpage.page_title, templatelinks.tl_title
FROM page article
JOIN page talkpage ON article.page_title = talkpage.page_title
JOIN templatelinks ON talkpage.page_id=templatelinks.tl_from
WHERE article.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 article.page_namespace=0
AND talkpage.page_namespace= 1
AND NOT templatelinks.tl_title = 'WikiProject_Automobiles'
AND NOT templatelinks.tl_title = 'WikiProject_Albums'
AND NOT templatelinks.tl_title = 'WikiProject_Songs'
AND NOT templatelinks.tl_title = 'WikiProject_Trains'
AND NOT templatelinks.tl_title = 'WikiProject_China'
AND NOT templatelinks.tl_title = 'WikiProject_Korea'
AND NOT templatelinks.tl_title = 'WikiProject_Motorsport'
AND NOT templatelinks.tl_title = 'WikiProject_Biography'
AND NOT templatelinks.tl_title = 'WikiProject_Film'
AND NOT templatelinks.tl_title = 'WikiProject_Television'
AND NOT templatelinks.tl_title = 'WikiProject_Basketball'
AND NOT templatelinks.tl_title = 'WikiProject_Baseball'
AND NOT templatelinks.tl_title = 'WikiProject_Romania'
AND NOT templatelinks.tl_title = 'WikiProject_Schools'
AND NOT templatelinks.tl_title = 'WikiProject_Women'
AND NOT templatelinks.tl_title = 'WikiProject_Women_in_Business'
SQL

Checking query status...
