Query Run
SELECT * FROM revision LEFT JOIN (select t2.page_id, min(t1.rev_id) ts from... 7 years ago
SELECT * FROM revision LEFT JOIN (select t2.page_id, min(t1.rev_id) ts from... 7 years ago