Version 8 of Who edits the Wiki

EMJ: 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
where  instr(who,'@') > 0
group by substr(who,1,instr(who,'@')-1)
order by count(*) desc
limit 40;

AMG: Cool stuff, though I would suggest adding DESC to the ordering term.

I am such a person who used more than one name. I used to sign my edits with "andy" but, once the name in the edit history became a page link, I changed to AMG to match my signature.

• AK = AKgnome
• AMG = andy
• CMcC = colin
• LV = LVwikignome = lvirden

Others?

Also, CMcC has been at this wiki business for quite a long time now. :^)

EMJ Fixed the order and the query, I was just being lazy before.