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