Query Run
SELECT DATE_FORMAT(LEFT(rev_timestamp, 8), '%Y-%m-%d') AS date,... 3 years ago