Version 0 of Who edits the Wiki

Lots of people edit the wiki, some more than others. From the most recent downloadable snapshot of the wiki (12th November, 2014), here are the top 40, together with the first and last dates (yyyy-mm) of their edits and, of course, how many edits.

This does not include pre-2007 edits when only the IP adress is available (there are 113,470 such edits), some people use more than one name, and some people edit the same page multiple times on the same day, never mind in the same month.

If anyone cares,

select substr(who,1,instr(who,'@')-1)
,      min(strftime('%Y-%m',date,'unixepoch'))
,      max(strftime('%Y-%m',date,'unixepoch'))
,      count(*)
from   changes
group by substr(who,1,instr(who,'@')-1)
order by count(*);