most active visual arts editors last week

SQL

# most active editors in visual arts
SELECT user_name, COUNT(rev_id), user_editcount
FROM page AS article
INNER JOIN page AS talk on article.page_title = talk.page_title 
INNER JOIN templatelinks 
ON tl_from = talk.page_id
INNER JOIN revision_userindex ON rev_page = article.page_id
JOIN user ON rev_user = user_id
WHERE rev_timestamp > (NOW() - INTERVAL 30 DAY)
AND tl_title = "WikiProject_Visual_arts"
AND article.page_namespace = 0
AND talk.page_namespace = 1
AND tl_namespace = 10
GROUP BY user_name
ORDER BY COUNT(rev_id) DESC
LIMIT 100;

SQL

Checking query status...