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 where d.locale='en-US' GROUP BY MONTH(created),
    -> YEAR(created) ORDER BY Year, Month;
+------+-------+---------+
| Year | Month | Editors |
+------+-------+---------+
| 2005 |     3 |       4 |
| 2005 |     4 |      26 |
| 2005 |     5 |      59 |
| 2005 |     6 |      58 |
| 2005 |     7 |      92 |
| 2005 |     8 |      86 |
| 2005 |     9 |     127 |
| 2005 |    10 |     116 |
| 2005 |    11 |     132 |
| 2005 |    12 |     151 |
| 2006 |     1 |     146 |
| 2006 |     2 |     174 |
| 2006 |     3 |     174 |
| 2006 |     4 |     135 |
| 2006 |     5 |     141 |
| 2006 |     6 |     144 |
| 2006 |     7 |     142 |
| 2006 |     8 |     180 |
| 2006 |     9 |     159 |
| 2006 |    10 |     224 |
| 2006 |    11 |     212 |
| 2006 |    12 |     211 |
| 2007 |     1 |     187 |
| 2007 |     2 |     186 |
| 2007 |     3 |     213 |
| 2007 |     4 |     193 |
| 2007 |     5 |     243 |
| 2007 |     6 |     150 |
| 2007 |     7 |     172 |
| 2007 |     8 |     166 |
| 2007 |     9 |     142 |
| 2007 |    10 |     148 |
| 2007 |    11 |     132 |
| 2007 |    12 |     153 |
| 2008 |     1 |     189 |
| 2008 |     2 |     199 |
| 2008 |     3 |     182 |
| 2008 |     4 |     198 |
| 2008 |     5 |     170 |
| 2008 |     6 |     175 |
| 2008 |     7 |     177 |
| 2008 |     8 |     174 |
| 2008 |     9 |     159 |
| 2008 |    10 |     159 |
| 2008 |    11 |     129 |
| 2008 |    12 |     144 |
| 2009 |     1 |     152 |
| 2009 |     2 |     162 |
| 2009 |     3 |     160 |
| 2009 |     4 |     149 |
| 2009 |     5 |     149 |
| 2009 |     6 |     176 |
| 2009 |     7 |     161 |
| 2009 |     8 |     179 |
| 2009 |     9 |     162 |
| 2009 |    10 |      87 |
| 2009 |    11 |     143 |
| 2009 |    12 |     143 |
| 2010 |     1 |     174 |
| 2010 |     2 |     162 |
| 2010 |     3 |     156 |
| 2010 |     4 |     138 |
| 2010 |     5 |     119 |
| 2010 |     6 |     137 |
| 2010 |     7 |     150 |
| 2010 |     8 |     142 |
| 2010 |     9 |     138 |
| 2010 |    10 |     132 |
| 2010 |    11 |     150 |
| 2010 |    12 |     129 |
| 2011 |     1 |     219 |
| 2011 |     2 |     176 |
| 2011 |     3 |     226 |
| 2011 |     4 |     215 |
| 2011 |     5 |     204 |
| 2011 |     6 |     218 |
| 2011 |     7 |     207 |
| 2011 |     8 |     203 |
| 2011 |     9 |     230 |
| 2011 |    10 |     188 |
| 2011 |    11 |     207 |
| 2011 |    12 |     188 |
| 2012 |     1 |     212 |
| 2012 |     2 |     205 |
| 2012 |     3 |     243 |
| 2012 |     4 |     259 |
| 2012 |     5 |     229 |
| 2012 |     6 |     340 |
| 2012 |     7 |     191 |
| 2012 |     8 |     296 |
| 2012 |     9 |     292 |
| 2012 |    10 |     312 |
| 2012 |    11 |     285 |
| 2012 |    12 |     261 |
| 2013 |     1 |     304 |
| 2013 |     2 |     318 |
| 2013 |     3 |     309 |
| 2013 |     4 |     327 |
| 2013 |     5 |     340 |
| 2013 |     6 |     328 |
| 2013 |     7 |     365 |
| 2013 |     8 |     367 |
| 2013 |     9 |     387 |
| 2013 |    10 |     378 |
| 2013 |    11 |     362 |
| 2013 |    12 |     416 |
| 2014 |     1 |     404 |
| 2014 |     2 |     408 |
| 2014 |     3 |     465 |
| 2014 |     4 |     425 |
| 2014 |     5 |     415 |
| 2014 |     6 |     396 |
| 2014 |     7 |     429 |
| 2014 |     8 |     512 |
| 2014 |     9 |     513 |
| 2014 |    10 |     440 |
| 2014 |    11 |     407 |
| 2014 |    12 |     482 |
| 2015 |     1 |     535 |
| 2015 |     2 |     424 |
| 2015 |     3 |     524 |
| 2015 |     4 |      67 |
+------+-------+---------+
122 rows in set (0.94 sec)