Query Run
select count(*) from page join revision r1 on rev_id = page_latest and... 1 year ago
select count(*) from page join revision r1 on rev_id = page_latest and... 1 year ago