Query Run
select distinct(rev_page) from revision join page on rev_page=page_id where... 1 year ago
select distinct(rev_page) from revision where rev_parent_id = 0 and... 1 year ago