Query Run
select * from revision join page on rev_page=page_id where rev_timestamp >... 1 year ago
select * from revision where rev_parent_id = 0 and rev_timestamp >... 1 year ago