Query Run
SELECT DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day, ... 1 year ago
SELECT DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day, ... 1 year ago