Query Run
select substring(rev_timestamp, 1, 6) date_, count(*) c from revision left... 1 week ago
select substring(rev_timestamp, 1, 6) date_, count(*) c from revision left... 1 week ago