new visual arts articles

SQL

# new visual arts articles
SELECT talk.page_title, article.page_title #, revtalk.rev_timestamp , revtalk.rev_user_text, revarticle.rev_user_text
FROM page as talk
JOIN page as article 
INNER JOIN templatelinks ON tl_from = talk.page_id
JOIN revision_userindex as revtalk ON revtalk.rev_page = talk.page_id
#INNER JOIN revision_userindex as revarticle ON revarticle.rev_page = article.page_id
#WHERE revtalk.rev_timestamp > (NOW() - INTERVAL 30 DAY)
#AND revarticle.rev_timestamp > (NOW() - INTERVAL 30 DAY)
WHERE tl_title = "WikiProject_Visual_arts"
AND talk.page_namespace = 1
#AND article.page_namespace = 0
AND tl_namespace = 10
#AND talk.page_title = "Saar_de_Swart"
AND revtalk.rev_parent_id = 0
#AND article.page_title = talk.page_title
#AND revarticle.rev_parent_id = 0
#ORDER BY revtalk.rev_timestamp DESC
LIMIT 20;
SQL

Checking query status...
