unreviewed Visual arts articles

SQL

SELECT DISTINCT (article.page_title) AS PT, CONCAT("http://en.wikipedia/org/wiki/"PT)

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', 
                               'WikiProject_Women_artists', 
                               'Wikiproject_Craft'
                              )
SQL

Checking query status...
