Query Run
select * from revision r where rev_page in (select page_id from page p... 3 years ago
select * from revision r LIMIT 100 where rev_page in (select page_id from... 3 years ago