Untitled query #66462

SQL

SELECT rev_timestamp, article.page_title
FROM revision_userindex
JOIN page article ON revision_userindex.rev_page = article.page_id AND article.page_namespace = 0
JOIN page talkpage ON article.page_title = talkpage.page_title AND talkpage.page_namespace = 1
JOIN templatelinks ON talkpage.page_id=templatelinks.tl_from
#WHERE rev_actor = (SELECT actor_id FROM actor WHERE actor_name = "Lugnuts")
WHERE rev_actor = 482
AND rev_parent_id = 0
#AND rev_timestamp BETWEEN (NOW() - INTERVAL 1 YEAR) AND NOW()
AND templatelinks.tl_title IN ('WikiProject_Biography')
ORDER BY rev_timestamp DESC 
#LIMIT 100
SQL

Checking query status...
