unreviewed sports articles

SQL

SELECT DISTINCT article.page_title AS Title, templatelinks.tl_title AS Project

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 templatelinks.tl_title IN ('WikiProject_Football'
                              )
AND templatelinks.tl_title = 'WikiProject_Biography'
SQL

Checking query status...
