Query Run
SET @one_week = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 WEEK),... 1 year ago
SELECT actor_name FROM revision_userindex JOIN page ON rev_page = page_id... 1 year ago