Query Run
SELECT LEFT(rev_timestamp, 10), COUNT(*) FROM... 1 year ago
SELECT LEFT(rev_timestamp, 6), COUNT(*) FROM... 1 year ago