Untitled query #66462

SQL

SELECT rev_timestamp, rev_actor, rev_page, article.page_title
FROM revision_userindex
JOIN page article ON revision_userindex.rev_page = article.page_id
JOIN page talkpage ON article.page_title = talkpage.page_title
JOIN templatelinks ON talkpage.page_id=templatelinks.tl_from
WHERE rev_actor = (SELECT actor_id FROM actor WHERE actor_name = "Lugnuts")
AND rev_parent_id = 0
AND article.page_namespace = 0
AND article.page_is_redirect = 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...
