Content deleted Content added
Dragons flight (talk | contribs) note |
update |
||
Line 1: | Line 1: | ||
<pre>mysql> SELECT afh_user_text, COUNT(*) FROM abuse_filter_history GROUP BY afh_user_text ORDER BY COUNT(*) DESC; |
<pre>mysql> SELECT afh_user_text, COUNT(*) FROM abuse_filter_history GROUP BY afh_user_text ORDER BY COUNT(*) DESC; |
||
+---------------------------+----------+ |
+---------------------------+----------+ |
||
| afh_user_text | COUNT(*) | |
| afh_user_text | COUNT(*) | |
||
+---------------------------+----------+ |
+---------------------------+----------+ |
||
| |
| Prodego | 474 | |
||
| |
| NawlinWiki | 449 | |
||
| |
| Dragons flight | 397 | |
||
| King of Hearts | |
| King of Hearts | 297 | |
||
| |
| Wknight94 | 241 | |
||
| |
| Beetstra | 232 | |
||
| |
| Ruslik0 | 197 | |
||
| Zzuuzz | |
| Zzuuzz | 151 | |
||
| Hersfold | 130 | |
| Hersfold | 130 | |
||
| Cenarium | |
| Cenarium | 115 | |
||
| MacGyverMagic | 82 | |
| MacGyverMagic | 82 | |
||
| Mr.Z-man | |
| Mr.Z-man | 69 | |
||
| |
| Evil saltine | 63 | |
||
| |
| Nixeagle | 58 | |
||
| Conti | 52 | |
| Conti | 52 | |
||
| |
| OverlordQ | 52 | |
||
| |
| Od Mishehu | 47 | |
||
| |
| Gogo Dodo | 45 | |
||
| |
| Werdna | 45 | |
||
| |
| Bjweeks | 40 | |
||
| |
| Triplestop | 36 | |
||
| |
| Nihiltres | 33 | |
||
| |
| Someguy1221 | 30 | |
||
| |
| X! | 29 | |
||
| |
| Xeno | 27 | |
||
| |
| J.delanoy | 27 | |
||
| |
| Admiral Norton | 25 | |
||
| |
| Raul654 | 23 | |
||
| |
| Avraham | 22 | |
||
| |
| Lucasbfr | 21 | |
||
| Cobi | |
| Cobi | 19 | |
||
| |
| East718 | 19 | |
||
| |
| ABCD | 17 | |
||
| |
| Tiptoety | 17 | |
||
| |
| Rich Farmbrough | 16 | |
||
| |
| Amalthea | 16 | |
||
| |
| MuZemike | 16 | |
||
| |
| Chris G | 13 | |
||
| |
| NuclearWarfare | 11 | |
||
| |
| Stifle | 9 | |
||
| |
| EncMstr | 9 | |
||
| |
| Will Beback | 9 | |
||
| |
| Reedy | 9 | |
||
| |
| Ckatz | 8 | |
||
| |
| Zzyzx11 | 8 | |
||
| |
| Slakr | 8 | |
||
| |
| Rjd0060 | 7 | |
||
| |
| Nakon | 7 | |
||
| |
| Drilnoth | 7 | |
||
| |
| Maxim | 6 | |
||
| |
| It Is Me Here | 6 | |
||
| |
| Nihonjoe | 5 | |
||
| ThaddeusB | |
| ThaddeusB | 5 | |
||
| |
| Jarry1250 | 5 | |
||
| |
| Future Perfect at Sunrise | 5 | |
||
| |
| SoWhy | 5 | |
||
| |
| Soap | 5 | |
||
| |
| Luk | 5 | |
||
| |
| Jac16888 | 5 | |
||
| |
| MSGJ | 4 | |
||
| |
| RockMFR | 4 | |
||
| |
| Jéské Couriano | 4 | |
||
| |
| Happy-melon | 4 | |
||
| |
| Docu | 4 | |
||
| |
| Nishkid64 | 3 | |
||
| |
| Tim Starling | 3 | |
||
| |
| Coffee | 3 | |
||
| |
| Shimgray | 3 | |
||
| |
| KnightLago | 3 | |
||
| |
| Remember the dot | 3 | |
||
| |
| Xaosflux | 2 | |
||
| MZMcBride | 2 | |
| MZMcBride | 2 | |
||
| |
| Juliancolton | 2 | |
||
| |
| Rootology | 2 | |
||
| |
| Meno25 | 2 | |
||
| |
| Kanonkas | 2 | |
||
| |
| Mindmatrix | 2 | |
||
| |
| Graham87 | 2 | |
||
| |
| Andre Engels | 2 | |
||
| |
| Keegan | 2 | |
||
| Voice of All | 2 | |
|||
| Backslash Forwardslash | 2 | |
|||
| Eloquence | 1 | |
|||
| Jake Wartenberg | 1 | |
|||
| Adambro | 1 | |
|||
| Alison | 1 | |
|||
| Versageek | 1 | |
|||
| Coren | 1 | |
|||
| Pascal.Tesson | 1 | |
|||
+---------------------------+----------+ |
+---------------------------+----------+ |
||
89 rows in set (0.12 sec)</pre> |
|||
88% of edits are made by 12% of the editors. Top 5% accounts for 70%. Top 6 editors account for 50% of the edits. Dragonsflight has more edits than the bottom 175 editors combined (out of 199) Only 80 editors have actions. [[User:Prodego|<font color="darkgreen">''Prodego''</font>]] <sup>[[User talk:Prodego|<font color="darkgreen">talk</font>]]</sup> 21:28, 10 September 2009 (UTC) |
88% of edits are made by 12% of the editors. Top 5% accounts for 70%. Top 6 editors account for 50% of the edits. Dragonsflight has more edits than the bottom 175 editors combined (out of 199) Only 80 editors have actions. [[User:Prodego|<font color="darkgreen">''Prodego''</font>]] <sup>[[User talk:Prodego|<font color="darkgreen">talk</font>]]</sup> 21:28, 10 September 2009 (UTC) |
Revision as of 21:07, 3 December 2009
mysql> SELECT afh_user_text, COUNT(*) FROM abuse_filter_history GROUP BY afh_user_text ORDER BY COUNT(*) DESC; +---------------------------+----------+ | afh_user_text | COUNT(*) | +---------------------------+----------+ | Prodego | 474 | | NawlinWiki | 449 | | Dragons flight | 397 | | King of Hearts | 297 | | Wknight94 | 241 | | Beetstra | 232 | | Ruslik0 | 197 | | Zzuuzz | 151 | | Hersfold | 130 | | Cenarium | 115 | | MacGyverMagic | 82 | | Mr.Z-man | 69 | | Evil saltine | 63 | | Nixeagle | 58 | | Conti | 52 | | OverlordQ | 52 | | Od Mishehu | 47 | | Gogo Dodo | 45 | | Werdna | 45 | | Bjweeks | 40 | | Triplestop | 36 | | Nihiltres | 33 | | Someguy1221 | 30 | | X! | 29 | | Xeno | 27 | | J.delanoy | 27 | | Admiral Norton | 25 | | Raul654 | 23 | | Avraham | 22 | | Lucasbfr | 21 | | Cobi | 19 | | East718 | 19 | | ABCD | 17 | | Tiptoety | 17 | | Rich Farmbrough | 16 | | Amalthea | 16 | | MuZemike | 16 | | Chris G | 13 | | NuclearWarfare | 11 | | Stifle | 9 | | EncMstr | 9 | | Will Beback | 9 | | Reedy | 9 | | Ckatz | 8 | | Zzyzx11 | 8 | | Slakr | 8 | | Rjd0060 | 7 | | Nakon | 7 | | Drilnoth | 7 | | Maxim | 6 | | It Is Me Here | 6 | | Nihonjoe | 5 | | ThaddeusB | 5 | | Jarry1250 | 5 | | Future Perfect at Sunrise | 5 | | SoWhy | 5 | | Soap | 5 | | Luk | 5 | | Jac16888 | 5 | | MSGJ | 4 | | RockMFR | 4 | | Jéské Couriano | 4 | | Happy-melon | 4 | | Docu | 4 | | Nishkid64 | 3 | | Tim Starling | 3 | | Coffee | 3 | | Shimgray | 3 | | KnightLago | 3 | | Remember the dot | 3 | | Xaosflux | 2 | | MZMcBride | 2 | | Juliancolton | 2 | | Rootology | 2 | | Meno25 | 2 | | Kanonkas | 2 | | Mindmatrix | 2 | | Graham87 | 2 | | Andre Engels | 2 | | Keegan | 2 | | Voice of All | 2 | | Backslash Forwardslash | 2 | | Eloquence | 1 | | Jake Wartenberg | 1 | | Adambro | 1 | | Alison | 1 | | Versageek | 1 | | Coren | 1 | | Pascal.Tesson | 1 | +---------------------------+----------+ 89 rows in set (0.12 sec)
88% of edits are made by 12% of the editors. Top 5% accounts for 70%. Top 6 editors account for 50% of the edits. Dragonsflight has more edits than the bottom 175 editors combined (out of 199) Only 80 editors have actions. Prodego talk 21:28, 10 September 2009 (UTC) test &
- And the real kicker is that I have hardly touched it at all in months. Dragons flight (talk) 20:51, 3 December 2009 (UTC)