Query Run
SELECT * FROM revision LEFT JOIN (select min(t1.rev_timestamp) ts from... 7 years ago
SELECT * FROM revision WHERE rev_timestamp IN (select min(t1.rev_timestamp)... 7 years ago