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.

Who	First	Last	Count
gold	2007-04	2014-11	5688
pooryorick	2011-01	2014-11	5537
dkf	2007-04	2014-11	5202
LV	2007-05	2012-11	4805
RLE	2010-04	2014-11	3430
AMG	2009-03	2014-11	2957
uniquename	2011-07	2014-07	2615
lars_h	2007-05	2012-12	1306
jdc	2007-04	2014-11	1300
suchenwi	2007-04	2014-10	1270
AK	2007-06	2014-02	1252
escargo	2007-05	2014-10	924
LkpPo	2012-08	2012-10	886
MHo	2007-12	2014-10	852
CMcC	1971-01	2014-04	831
oehhar	2007-11	2014-10	805
Jorge	2008-01	2014-11	723
SEH	2007-05	2014-11	634
EMJ	2007-04	2014-05	626
APN	2007-08	2014-11	619
HJG	2007-05	2014-10	613
arjen	2007-05	2014-09	580
LVwikignome	2009-09	2013-04	534
apw	2007-06	2014-06	531
jbr	2007-05	2014-06	490
MJ	2007-04	2013-09	483
dgp	2007-05	2014-11	482
colin	2007-04	2007-10	479
WJG	2008-05	2014-05	469
lvirden	2007-04	2007-06	444
paul	2007-04	2014-09	441
AKgnome	2009-10	2011-05	435
wdb	2007-04	2014-08	423
andy	2007-07	2012-01	419
Zarutian	2007-05	2011-04	411
PeterLewerin	2010-01	2014-09	403
theover	2007-04	2014-04	390
stevel	2007-04	2013-11	380
nem	2007-08	2013-12	376
FF	2007-05	2014-01	375

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.

---