unreviewed Visual arts articles

SQL

SELECT templatelinks.tl_title, article.page_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 templatelinks.tl_title IN ('WikiProject_Arts', 'WikiProject_Visual_Art', 'WikiProject_Visual_arts', 'WikiProject_Visual_Arts')
SQL

Checking query status...
