Query Run
select distinct(r.rev_page) from revision r join page p on r.rev_page =... 1 year ago