gistfile1.txt

mysql> select YEAR(created) Year, MONTH(created) Month, count(distinct
    -> creator_id) Editors from wiki_revision as r LEFT JOIN wiki_document as d
    -> on r.document_id = d.id GROUP BY MONTH(created), YEAR(created) ORDER BY
    -> Year, Month;
+------+-------+---------+
| Year | Month | Editors |
+------+-------+---------+
| 2005 |     3 |       4 |
| 2005 |     4 |      26 |
| 2005 |     5 |      60 |
| 2005 |     6 |      63 |
| 2005 |     7 |     103 |
| 2005 |     8 |     100 |
| 2005 |     9 |     146 |
| 2005 |    10 |     136 |
| 2005 |    11 |     164 |
| 2005 |    12 |     174 |
| 2006 |     1 |     178 |
| 2006 |     2 |     211 |
| 2006 |     3 |     205 |
| 2006 |     4 |     161 |
| 2006 |     5 |     190 |
| 2006 |     6 |     176 |
| 2006 |     7 |     190 |
| 2006 |     8 |     247 |
| 2006 |     9 |     216 |
| 2006 |    10 |     301 |
| 2006 |    11 |     286 |
| 2006 |    12 |     284 |
| 2007 |     1 |     255 |
| 2007 |     2 |     243 |
| 2007 |     3 |     270 |
| 2007 |     4 |     235 |
| 2007 |     5 |     301 |
| 2007 |     6 |     223 |
| 2007 |     7 |     242 |
| 2007 |     8 |     241 |
| 2007 |     9 |     187 |
| 2007 |    10 |     190 |
| 2007 |    11 |     189 |
| 2007 |    12 |     213 |
| 2008 |     1 |     259 |
| 2008 |     2 |     240 |
| 2008 |     3 |     242 |
| 2008 |     4 |     253 |
| 2008 |     5 |     214 |
| 2008 |     6 |     225 |
| 2008 |     7 |     239 |
| 2008 |     8 |     214 |
| 2008 |     9 |     187 |
| 2008 |    10 |     188 |
| 2008 |    11 |     156 |
| 2008 |    12 |     171 |
| 2009 |     1 |     178 |
| 2009 |     2 |     176 |
| 2009 |     3 |     183 |
| 2009 |     4 |     176 |
| 2009 |     5 |     178 |
| 2009 |     6 |     199 |
| 2009 |     7 |     187 |
| 2009 |     8 |     194 |
| 2009 |     9 |     175 |
| 2009 |    10 |      97 |
| 2009 |    11 |     162 |
| 2009 |    12 |     163 |
| 2010 |     1 |     196 |
| 2010 |     2 |     175 |
| 2010 |     3 |     175 |
| 2010 |     4 |     155 |
| 2010 |     5 |     131 |
| 2010 |     6 |     153 |
| 2010 |     7 |     174 |
| 2010 |     8 |     162 |
| 2010 |     9 |     158 |
| 2010 |    10 |     145 |
| 2010 |    11 |     166 |
| 2010 |    12 |     142 |
| 2011 |     1 |     235 |
| 2011 |     2 |     186 |
| 2011 |     3 |     244 |
| 2011 |     4 |     225 |
| 2011 |     5 |     226 |
| 2011 |     6 |     236 |
| 2011 |     7 |     219 |
| 2011 |     8 |     227 |
| 2011 |     9 |     254 |
| 2011 |    10 |     203 |
| 2011 |    11 |     227 |
| 2011 |    12 |     201 |
| 2012 |     1 |     226 |
| 2012 |     2 |     225 |
| 2012 |     3 |     276 |
| 2012 |     4 |     274 |
| 2012 |     5 |     255 |
| 2012 |     6 |     669 |
| 2012 |     7 |     245 |
| 2012 |     8 |     368 |
| 2012 |     9 |     394 |
| 2012 |    10 |     419 |
| 2012 |    11 |     385 |
| 2012 |    12 |     359 |
| 2013 |     1 |     427 |
| 2013 |     2 |     439 |
| 2013 |     3 |     436 |
| 2013 |     4 |     462 |
| 2013 |     5 |     472 |
| 2013 |     6 |     441 |
| 2013 |     7 |     478 |
| 2013 |     8 |     479 |
| 2013 |     9 |     509 |
| 2013 |    10 |     503 |
| 2013 |    11 |     489 |
| 2013 |    12 |     585 |
| 2014 |     1 |     570 |
| 2014 |     2 |     580 |
| 2014 |     3 |     684 |
| 2014 |     4 |     611 |
| 2014 |     5 |     650 |
| 2014 |     6 |     626 |
| 2014 |     7 |     709 |
| 2014 |     8 |     838 |
| 2014 |     9 |     865 |
| 2014 |    10 |     715 |
| 2014 |    11 |     725 |
| 2014 |    12 |     768 |
| 2015 |     1 |     846 |
| 2015 |     2 |     775 |
| 2015 |     3 |     927 |
| 2015 |     4 |     123 |
+------+-------+---------+
122 rows in set (1.05 sec)