MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rev_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rev_id) AS edits
    -> FROM revision
    -> JOIN page ON rev_page = page_id
    -> WHERE page_namespace = 0
    -> GROUP BY MONTH;
+--------+--------+
| MONTH  | edits  |
+--------+--------+
| 200108 |      1 |
| 200109 |      2 |
| 200201 |      2 |
| 200203 |      4 |
| 200204 |      6 |
| 200205 |      5 |
| 200206 |     41 |
| 200207 |     10 |
| 200208 |     17 |
| 200209 |      2 |
| 200210 |      2 |
| 200211 |    190 |
| 200212 |    439 |
| 200301 |    460 |
| 200302 |    456 |
| 200303 |    328 |
| 200304 |    563 |
| 200305 |    481 |
| 200306 |    399 |
| 200307 |    983 |
| 200308 |    901 |
| 200309 |    589 |
| 200310 |    919 |
| 200311 |   1138 |
| 200312 |   5341 |
| 200401 |   4052 |
| 200402 |   5974 |
| 200403 |   6989 |
| 200404 |   7864 |
| 200405 |   9530 |
| 200406 |  13765 |
| 200407 |  25334 |
| 200408 |  16554 |
| 200409 |  21576 |
| 200410 |  27678 |
| 200411 |  41585 |
| 200412 |  33559 |
| 200501 |  26096 |
| 200502 |  27094 |
| 200503 |  35092 |
| 200504 |  52499 |
| 200505 |  62737 |
| 200506 |  63610 |
| 200507 |  73481 |
| 200508 | 125611 |
| 200509 | 137730 |
| 200510 |  85442 |
| 200511 |  99657 |
| 200512 | 124415 |
| 200601 | 142001 |
| 200602 | 150385 |
| 200603 | 186128 |
| 200604 | 229895 |
| 200605 | 218776 |
| 200606 | 219749 |
| 200607 | 242505 |
| 200608 | 271331 |
| 200609 | 238109 |
| 200610 | 225599 |
| 200611 | 244352 |
| 200612 | 265405 |
| 200701 | 399594 |
| 200702 | 331317 |
| 200703 | 359293 |
| 200704 | 322147 |
| 200705 | 383993 |
| 200706 | 345239 |
| 200707 | 354925 |
| 200708 | 351699 |
| 200709 | 399226 |
| 200710 | 465825 |
| 200711 | 481430 |
| 200712 | 371237 |
| 200801 | 433883 |
| 200802 | 453381 |
| 200803 | 464642 |
| 200804 | 438657 |
| 200805 | 492300 |
| 200806 | 464914 |
| 200807 | 441670 |
| 200808 | 455110 |
| 200809 | 519557 |
| 200810 | 469338 |
| 200811 | 416814 |
| 200812 | 419357 |
| 200901 | 516073 |
| 200902 | 439387 |
| 200903 | 443197 |
| 200904 | 464172 |
| 200905 | 539149 |
| 200906 | 488904 |
| 200907 | 494209 |
| 200908 | 459309 |
| 200909 | 492846 |
| 200910 | 465005 |
| 200911 | 457663 |
| 200912 | 454159 |
| 201001 | 562551 |
| 201002 | 499386 |
| 201003 | 468896 |
| 201004 | 515337 |
| 201005 | 547149 |
| 201006 | 531631 |
| 201007 | 517130 |
| 201008 | 490819 |
| 201009 | 557269 |
| 201010 | 546623 |
| 201011 | 476264 |
| 201012 | 526704 |
| 201101 | 642386 |
| 201102 | 480981 |
| 201103 | 536683 |
| 201104 | 534532 |
| 201105 | 512995 |
| 201106 | 497740 |
| 201107 | 531302 |
| 201108 | 575110 |
| 201109 | 523415 |
| 201110 | 460114 |
| 201111 | 637596 |
| 201112 | 525333 |
| 201201 | 656310 |
| 201202 | 573426 |
| 201203 | 616208 |
| 201204 | 582248 |
| 201205 | 571979 |
| 201206 | 521610 |
| 201207 | 609793 |
| 201208 | 555821 |
| 201209 | 527977 |
| 201210 | 561207 |
| 201211 | 538377 |
| 201212 | 573405 |
| 201301 | 601615 |
| 201302 | 843099 |
| 201303 | 923010 |
| 201304 | 422731 |
| 201305 | 463218 |
| 201306 | 477049 |
| 201307 | 529300 |
| 201308 | 627329 |
| 201309 | 381989 |
| 201310 | 376658 |
| 201311 | 428632 |
| 201312 | 410014 |
| 201401 | 425075 |
| 201402 | 452344 |
| 201403 | 467760 |
| 201404 | 465770 |
| 201405 | 408849 |
| 201406 |  17017 |
+--------+--------+
151 rows in set (1 min 53.19 sec)