Query Run
SELECT revision.rev_id, page.page_title, revision.rev_timestamp,... 1 year ago
SELECT revision.rev_id, page.page_title, revision.rev_timestamp,... 1 year ago
SELECT * FROM revision WHERE rev_page IN ( SELECT page.page_id FROM... 1 year ago