Query Run
select * from revision inner join page on rev_page = page_id order by... 1 year ago
select * from revision inner join page on rev_id = page_id order by... 1 year ago