Wikipedia talk:List of Wikipedians by number of edits

How to Generate This List

1. If you have Toolserver access
   • Run this query:

     SET @counter:=0; SELECT @counter:=@counter+1 AS rank, user_name, user_editcount
     FROM user
     WHERE user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
     ORDER BY user_editcount DESC LIMIT 4000;
     

   • Wait 10–20 minutes for it to finish.
2. Otherwise
   1. Download and install Perl. For Windows, try ActivePerl.
   2. Save the following code as wbe.pl:

      while (<>){if(/<(username|ip)>(.*)<.(username|ip)>/){$hash{$2}++;}}
      my @list = sort byedits keys our %hash;
      foreach $item (@list) {print "# $item $hash{$item}\n";}
      sub byedits {our %hash; $hash{$b} <=> $hash{$a};}
      

   3. Download a database dump from download.wikimedia.org/enwiki; you want the latest available file with a name similar to "WIKINAME-DATE-stub-meta-history.xml."
   4. At the command line, run "perl wbe.pl WIKINAME-DATE-stub-meta-history.xml >> results.txt"
   5. Crop the resulting list to approximately 5000 edits.
3. Remove the bots, IP addresses and replace the anonymous editors with Place holder, and format the list, maybe by running it through a regex filter to link/format all of the names. The following regex filter is for C#:

   string regexStr = @"# (?<name>.*[A-Za-z0-9æ²先生!@\(\)\-,\.\:\?]) (?<count>[0-9]*)$";
   string replacement = @"# [[User:${name}|${name}]] ${count}";
   

4. Upload!

Update request

Is it possible to get an update of this list?--Kumioko (talk) 21:56, 24 April 2008 (UTC)

Also, could we update the statement "As of June 2006, the English Wikipedia received more than 120,000 edits a day; more than 67,000 people edited the Wikipedia in that month. As of November 2006, it received 200,000 edits a day." to some new numbers maybe for March of 2008.--Kumioko (talk) 17:38, 1 May 2008 (UTC)

I've also been waiting awhile for an update. See here. Not many people can do it, so we just have to wait until one of them decides to. Enigma ^message 02:36, 2 May 2008 (UTC)

Important note to the next updater: please this time let's avoid drama and respect people wishes, unlike the last updated did. If people are upset by the placeholders, just don't put them. They specifically asked not to be replaced by a placeholder, and it appears to me that the consensus in favor of respecting their wishes. If you think you know better, than you have to change the text on the page as it is now it's... what should I say? "Grossly incorrect" ? As a note for the bot list, I suggest that we shouldn't update it further. As I said when I made if, if anybody ask to be removed even from that list, then I won't updated it again. Since somebody did, I think we should left it as it is (or perhaps deleted it). There's no point if we can't even list bots. Anyway, since then many bots have been unflagged, so you would have, for both lists, to go thru BAG's talk page and gather the list. Snowolf ^{How can I help?} 02:49, 2 May 2008 (UTC)

Not many people can do it? There are no real barriers to doing this other than time and technical expertise; as the list above mentions, pretty much anyone with an Internet connection, hard drive, and a knowledge of scripts can do this. (That does not include me.) -Justin (koavf)❤T☮C☺M☯ 03:32, 2 May 2008 (UTC)

Well, no. Because two sections up Snowolf says "This list must be compiled only with toolserver data", and there aren't very many people with toolserver access. Hesperian 04:19, 2 May 2008 (UTC)

Yep. Enigma ^message 04:21, 2 May 2008 (UTC)

Leaving out names of Wikipedians who actually made edits, and, even worse, leaving out placeholders, presents a fictionalized/falsified version of WP's history, making editors with fewer edits look like they are higher in rank than they actually are. All of these options are ill-advised, as we should not be allowing the whims of a few editors to cause this page to comprise falsified data. Our usernames are already a level of anonymity, as most editors do not use their actual full names as their usernames, so it's best if all editors who participated in our project as editors are included. Badagnani (talk) 04:40, 2 May 2008 (UTC)

I do agree with this. People should not have the right to remove themselves from these lists. The list is intended to be comprehensive, and it's not up to individual people to determine whether they should be on the list. It's sort of similar to the BLP issue, although not exactly. You are "notable" whether you like it or not, if you've made a large number of edits. Allowing "opt outs" destroys the credibility of the list. Personally, I would like a definitive list of the top 500 human editors by edit count updated every two weeks or so. Probably not possible, but that would be ideal. Enigma ^message 04:45, 2 May 2008 (UTC)

To be honest we're talking a handful of users out of thousands. As someone who does read the list more for fun than anything else (I don't think this list will be a topic of interest to eminent historians) I have no problem with them being omitted if they don't wish to be there. Orderinchaos 19:30, 8 May 2008 (UTC)

As long as it's not a huge drain on bandwidth to do it so frequently. Badagnani (talk) 04:59, 2 May 2008 (UTC)

Compiling and anonymity Well, up above it says there's a method without toolserver access. I don't know if it works, but if it doesn't, that method should be deleted. I completely agree about the anonymity; it's sheer nonsense, but that's the compromise. If you want to change it, you'll have to propose that and go through an outrageous discussion/edit war with users who disagree. -Justin (koavf)❤T☮C☺M☯ 07:51, 2 May 2008 (UTC)

The most recent update used the non-toolserver method. It turns out that method omits deleted edits, so that many users' edit counts actually fell. Some people expressed the sentiment that this list is pointless if it is calculated inconsistently from update to update. The non-toolserver method should therefore probably be deprecated. Hesperian 11:42, 2 May 2008 (UTC)

The query is a bit long, so yes, it shouldn't be run to often. As for the placeholder, consensus can change. If so, I think that an RfC is in order, as I think it was the method used last time. (or was an MfD?)Snowolf ^{How can I help?} 15:21, 2 May 2008 (UTC)

Just to be clear. Personally, I think that there shouldn't be placeholder at all. Al this business of getting removed from this list is just nonsense. But you know, people like drama so much around here. When I first run this list, I tried to gasp what consensus on the issue was, and from what I understood (I say again, I may be wrong of course) the consensus led me to believe that I should remove the people from the anonymous page. So I did. I just think that after a MfD and a RfC, if you want to change the method, you can't do it just by updating the page how you like. Snowolf ^{How can I help?} 15:27, 2 May 2008 (UTC)

Anyway, for the updates, just catch somebody with ts access and ask them to update the list. I should have the queries somewhere and I can pass it along (however this time it requires to get the list of deflagged bots, so there is that additional work to do) and I have a executable which performed the old regex (not the table) that I can pass along. Snowolf ^{How can I help?} 15:31, 2 May 2008 (UTC)

I think that someone should make a bot the runs this automatically or semiautomatically. I think that would help to make the pulls more consistant and it would remove some of the human time it takes to do this.--Kumioko (talk) 15:39, 2 May 2008 (UTC)

Its probably about time for another update, please. Simply south (talk) 13:29, 19 May 2008 (UTC)

who is builder of this list?

I am a social research who are really interested in this list and also have some questions about how this list have been established. May i ask the builder or one of builders can contact with me? regards!Wikizeyi (talk) 02:00, 11 May 2008 (UTC)

The list have been automatically generated by different users in the past. I updated it twice, I believe, if I may be of any assistance, feel free to give me a ping ;-) Snowolf ^{How can I help?} 08:14, 14 May 2008 (UTC)

Updated

see User:Betacommand/Edit count β^_command 22:32, 20 May 2008 (UTC)

Deleted. It was blatant disregard of the request of people who don't wish their names seen in this list. `'Míkka>t 23:21, 21 May 2008 (UTC)

Thanks What is the date of this information? -Justin (koavf)❤T☮C☺M☯ 02:27, 21 May 2008 (UTC)

My edit count on it is the same that it was for most of today so I think it is today's or yesterday's information. Captain panda 02:34, 21 May 2008 (UTC)

Thank you for the update. It would be great to have it done on the actual page rather than on the talk page. Badagnani (talk) 02:38, 21 May 2008 (UTC)

Thank you for updating it. Enigma ^message 06:27, 21 May 2008 (UTC)

Please restore blanked updated edit count. Blanking was highly disruptive. Badagnani (talk) 23:26, 21 May 2008 (UTC)

It was not an agreed-upon updated edit count. For your personal fun please set up personal webpage and count whatever you want. Wikipedia is a project to build encyclopedia, not to caress wikipedians' egoes. `'Míkka>t 23:48, 21 May 2008 (UTC)

Why are so many people so worked up about this? − Twas Now ( talk • contribs • e-mail ) 23:29, 21 May 2008 (UTC)

Because for great many people wikipedia is virtual reality, MUD, MMRPG, WTF, etc. `'Míkka>t 23:46, 21 May 2008 (UTC)

(ec) Because a lot of us don't want to be on this list and we thought we'd seen the end of conversations like this. This list is absolutely meaningless, especially now anyone can rack up 3000 edits in a day with HUGGLE. — iridescent 23:49, 21 May 2008 (UTC)

Please restore blanked updated edit count. Blanking was highly disruptive. Badagnani (talk) 23:51, 21 May 2008 (UTC)

Irony: People such as mikkalai who are so anti this stuff are probably one of the only reasons i care at all about edit count. Go figure :) Wizardman 23:52, 21 May 2008 (UTC)

Not me: I have severe editcountitis. ;) But I agree with Mikka's deletion of that page. · AndonicO ^Engage. 00:19, 22 May 2008 (UTC)

Tough one. What goes into the Wikipedia namespace must reflect community consensus, but what goes into user subspace only needs to conform with policy. There's no policy that governs this, except possibly NOTCENSORED. Hesperian 03:01, 22 May 2008 (UTC)

Well, he shouldn't have done it in his userspace in the first place... · AndonicO ^Engage. 03:07, 22 May 2008 (UTC)

Why not? Hesperian 04:49, 22 May 2008 (UTC)

The update belongs on this actual page, not the discussion page or in someone's user page. Badagnani (talk) 04:59, 22 May 2008 (UTC)

What Andon was getting at was that it shouldn't have been done at all because a few editors don't want their edit counts displayed. His argument was that it shouldn't have been done in userspace, or here either. Enigma ^message 05:05, 22 May 2008 (UTC)

Which rather begs the point of my previous comment. Hesperian 06:27, 22 May 2008 (UTC)

It does not matter that a few editors don't want their edit counts displayed. Most editors do not use their real names as their username and these few editors do not get to mandate that our history, in terms of total edits, is presented in a falsified manner. Badagnani (talk) 06:29, 22 May 2008 (UTC)

I already know you hold that opinion, Badagnani. I was wondering why AndonicO thinks BetaCommand should not have created this list, not even in his user space. Hesperian 06:57, 22 May 2008 (UTC)

Well, I guess it could be considered more or less a "bending" of WP:UP#OWN: he was putting up statistics against the wishes of the community (I don't just mean the minority who didn't want to be on the list, but also everyone else, because we've decided the list goes here). · AndonicO ^Engage. 10:32, 22 May 2008 (UTC)

Several people have been whining for an update, and here it is. If you want to put it onto the Wikipedia-space page, go ahead and do that, but don't criticize Beta for obtaining the information and making it available for you. − Twas Now ( talk • contribs • e-mail ) 14:27, 22 May 2008 (UTC)

I know this is likly to rub some people the wrong way but IMHO this whole conversation is absolutely ridiculous. Wikipedia is open to the public so anyone can edit and anyone can SEE what edits anyone has made. You can request the data from the database for research and everything is open source. If you don't want people to know YOU edited or what you edited then don't edit its that simple. I hate to sound like a jerk but to me thats the bottom line. If someone is that sensitive about their privacy then they shouldn't be participating in this type of forum. I for one have chronic editcountitis and like to know where I stand amongst my peers. --Kumioko (talk) 11:59, 22 May 2008 (UTC)

Since I haven't seen it here yet, the deletion is at DRV currently. Cheers all. --lifebaka (Talk - Contribs) 01:38, 23 May 2008 (UTC)

DYK

...that in the discussed EdiCo list, the 5147-th ranked user:Duggy 1138 made 5147 edits and there is no users with this property in the official EdiCo lists?-) Mukadderat (talk) 02:51, 22 May 2008 (UTC)

Haha, very nice. :) · AndonicO ^Engage. 02:58, 22 May 2008 (UTC)

Interesting. No other users could have done that, because anyone with fewer edits would be ranked higher, and anyone with more edits would be ranked lower. − Twas Now ( talk • contribs • e-mail ) 03:08, 22 May 2008 (UTC)

Freaky. Makes me want to not make anymore edits to keep it so. Duggy 1138 (talk) 04:22, 22 May 2008 (UTC)

Damn. Duggy 1138 (talk) 04:22, 22 May 2008 (UTC)

How do I figure out how many edits I've made?

I'd like to be able to keep track of my number of edits without having to count them by hand. Is there any way to accomplish this? --Luigifan (talk) 23:41, 21 May 2008 (UTC)

If you click "My preferences" link (http://en.wikipedia.org/wiki/Special:Preferences) , you will see your current edit count. `'Míkka>t 23:43, 21 May 2008 (UTC)

Special:Preferences Wizardman 23:44, 21 May 2008 (UTC)

Also if you want to see your editing patterns/statistics, there's the wannabe kate tool (may take a while to load, depending on how many edits you have). · AndonicO ^Engage. 00:16, 22 May 2008 (UTC)

It will only count up to 45k edits though, unfortunately. --John (talk) 05:10, 22 May 2008 (UTC)