new visual arts articles

SQL

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

Checking query status...
