Query Run
SELECT LEFT(rev_timestamp, 8) as `date`, COUNT(*) FROM revision JOIN... 1 month ago
SELECT LEFT(rev_timestamp, 6) as `month`, COUNT(*) FROM revision JOIN... 1 month ago