Query Run
SELECT old_text, r.* FROM revision r inner join text on rev_text_id =... 1 year ago