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