User talk:ST47/Stats

From Wikipedia, the free encyclopedia

Contents

[edit] Stat generation

Wow. This is impressive. How did you generate these stats? Is there a way I could see, for instance, deletions of images vs. deletions of articles? – Quadell (talk) (random) 04:03, 1 August 2007 (UTC)

Any such requests can probably be done tonight once everything is back together and I'm back home - Can I have a list of what you ave in mind? --ST47Talk·Desk 11:09, 1 August 2007 (UTC)

Well, mostly I'd like to see admins by images deleted. I'm just curious. :) – Quadell (talk) (random) 11:23, 1 August 2007 (UTC)

OK, once the toolserver is back up, I'll run it. For my reference, the query is:
  • set @counter:=0; select @counter:=@counter+1 as rank, user_ids.user_name as username, count(logging.log_timestamp) as number from logging, user_ids where logging.log_type='delete' and logging.log_action='delete' and logging.log_user = user_ids.user_id and log_namespace = 6 group by logging.log_user order by number desc;
Here are the top 50:
+------+----------------------------------+--------+
| rank | username                         | number |
+------+----------------------------------+--------+
|    1 | Misza13                          |  86195 | 
|    2 | Quadell                          |  48414 | 
|    3 | Nv8200p                          |  44255 | 
|    4 | Sherool                          |  33682 | 
|    5 | JesseW                           |  26839 | 
|    6 | Angr                             |  25496 | 
|    7 | Awyong Jeffrey Mordecai Salleh   |  23641 | 
|    8 | TheCoffee                        |  21915 | 
|    9 | ^demon                           |  18068 | 
|   10 | Shyam                            |  15190 | 
|   11 | Mushroom                         |  15050 | 
|   12 | Howcheng                         |  14913 | 
|   13 | Mailer diablo                    |  14805 | 
|   14 | Fang Aili                        |  13230 | 
|   15 | Naconkantari                     |  13168 | 
|   16 | CLW                              |  13090 | 
|   17 | Dmcdevit                         |  11865 | 
|   18 | TheParanoidOne                   |  10034 | 
|   19 | NawlinWiki                       |   9835 | 
|   20 | RedWolf                          |   9541 | 
|   21 | Conscious                        |   8579 | 
|   22 | Meegs                            |   8215 | 
|   23 | Rettetast                        |   7280 | 
|   24 | Zscout370                        |   7050 | 
|   25 | Geni                             |   6575 | 
|   26 | B                                |   6575 | 
|   27 | Garion96                         |   6420 | 
|   28 | RHaworth                         |   6367 | 
|   29 | Jaranda                          |   6154 | 
|   30 | Enochlau                         |   5865 | 
|   31 | Riana                            |   5796 | 
|   32 | Cohesion                         |   5778 | 
|   33 | Tone                             |   5630 | 
|   34 | After Midnight                   |   5385 | 
|   35 | Jeffrey O. Gustafson             |   5320 | 
|   36 | Blnguyen                         |   5149 | 
|   37 | Dbenbenn                         |   5109 | 
|   38 | ESkog                            |   5105 | 
|   39 | DVD R W                          |   4608 | 
|   40 | Betacommand                      |   4245 | 
|   41 | Redvers                          |   4225 | 
|   42 | Wizardman                        |   4077 | 
|   43 | The wub                          |   3859 | 
|   44 | SCEhardt                         |   3793 | 
|   45 | Ryulong                          |   3783 | 
|   46 | Cryptic                          |   3640 | 
|   47 | PDH                              |   3530 | 
|   48 | Shell Kinney                     |   3490 | 
|   49 | Zzyzx11                          |   3478 | 
|   50 | Jkelly                           |   3399 | 
+------+----------------------------------+--------+

This information is lagged 1d 22h 37m 12s (167832s) at time of reporting, that is, there is no information more recent than 1:51:39 PM 07/30/07 UTC. I hope full information will be available soon, but as you can see, your second place rank is reasonably secure :) --ST47Talk·Desk 12:32, 1 August 2007 (UTC)

[edit] Dates

Very impressive. Could you give a date range for this data? I'm assuming it goes from as far back as possible up to the date it was posted? If possible, as you update, could you post (and update) the date it goes up to, to save people looking it up in the page history? Thanks. Carcharoth 01:04, 2 August 2007 (UTC)

Sure. --ST47Talk·Desk 11:24, 2 August 2007 (UTC)

[edit] New field

Could you add a "rank" field to the "admins by number of actions" table? Thank you for your consideration, — xaosflux Talk 05:59, 25 December 2007 (UTC)

I would like to see this added also. --Kukini hablame aqui 21:40, 10 January 2008 (UTC)

[edit] Stats

Note I try to add my stats from this account, to my old one until I could get the edits combined, I hope you don't mind. I like deleting contests :P. Secret account 19:41, 10 January 2008 (UTC)

[edit] Promotions

Excellent statistics, but I do have a question: would it be possible to separate the admins who have granted rollback from the bureaucrats by number of promotions to something like "admins by number of rollback promotions"? Currently, it looks as though I'm bureaucrat, and have promoted over 150 people. Can this be done? Thanks. Acalamari 17:51, 29 January 2008 (UTC)

Bureaucrat promotion stats are updated manually at User:NoSeptember/crat stats, but the section header on ST47/Stats is now obviously wrong as it includes admins plus bureaucrats. NoSeptember 18:08, 29 January 2008 (UTC)
https://jira.ts.wikimedia.org/browse/ST-36 - I've submitted it as a bug on JIRA. ~Kylu (u|t) 08:05, 7 March 2008 (UTC)