Query Run
use fawiki_p; select left(rev_timestamp, 8), count(*) from revision group by... 6 years ago