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 = page.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 10 YEAR) AND NOW()
AND templatelinks.tl_title IN ('WikiProject_Biography'
                              )
ORDER BY rev_timestamp DESC 
LIMIT 100
SQL

Checking query status...
