More fun statistics

More serious discussions, information about official DDNet servers, important announcements.
User avatar
deen
Retired Administrator
Posts: 3292
Joined: Mon May 05, 2014 2:30 pm
Player profile: deen

More fun statistics

Post by deen » Sat Apr 22, 2017 3:43 pm

Highest sum of length of all ranks on a map:

Code: Select all

MariaDB [teeworlds]> select Map, sum(Time)/3600 as Hours from record_race group by Map order by sum(Time) desc limit 20;
+----------------+--------------------+
| Map            | Hours              |
+----------------+--------------------+
| Kobra          | 24911.475450795493 |
| Multimap       |  19087.74150695801 |
| Kobra 2        |   18952.7200831604 |
| Kobra 4        | 13736.423268008763 |
| Epix           | 11384.284661424424 |
| Absurd 4       |  9039.078671866522 |
| Purple Panic   |  8215.322137832642 |
| Kobra 3        |  7497.704812808566 |
| Just2Easy      |  7394.134056150649 |
| Light Grey     |  5436.445849804349 |
| Absurd 2       |  4698.182123294407 |
| Icebreaker     |  4557.120310228136 |
| Sunny Land     | 4029.6279740397135 |
| Baby Aim 1.0   | 3905.3651927863225 |
| Houll          | 3605.3742739274767 |
| Pados 2        | 3380.0798666551377 |
| Race_Sanktoras |  3357.248273993598 |
| ZeroX          | 3344.2213060675726 |
| Monster        | 3342.4934799109565 |
| Baby Aim 2.0   |  3337.364182840983 |
+----------------+--------------------+
Highest average time for ranks on a map:

Code: Select all

MariaDB [teeworlds]> select Map, avg(Time)/60 as Minutes from record_race group by Map order by avg(Time) desc limit 20;
+--------------------+--------------------+
| Map                | Minutes            |
+--------------------+--------------------+
| run_antibuguse     |   831.814501953125 |
| Heartcore          | 414.89801432291665 |
| Generic World      |   398.092106537126 |
| run_world_war_zero |  366.2774843158144 |
| Dark Descent       | 266.11870341684624 |
| Shockwave          |  251.8925811767578 |
| Striped Clouds     |  249.3676708984375 |
| Gloomy Den         |  222.3353016843078 |
| nameless_run       |  192.7470002673921 |
| WoFs               |  190.0490533093968 |
| Delirious          | 187.31617509145588 |
| The Rapture        | 187.31499884189705 |
| Agony              | 174.71160152787013 |
| At Sundown         | 173.78526225842927 |
| Generic Hell 2     |  170.4762058423913 |
| Neverwhere         | 169.17141643804135 |
| Anoix              | 167.34059342447918 |
| Rockstar           | 167.06903016493055 |
| QuintessenZ        | 160.40385468800864 |
| Adrenaline 5       | 159.82074788411458 |
+--------------------+--------------------+
Shortest average time for ranks on a map:

Code: Select all

MariaDB [teeworlds]> select Map, avg(Time)/60 as Minutes from record_race group by Map order by avg(Time) limit 20;
+------------------+---------------------+
| Map              | Minutes             |
+------------------+---------------------+
| NUT_short_race6  |  0.1252669569617031 |
| run_g6           | 0.15508761779628819 |
| run_blue         | 0.23624196976564166 |
| run_ankii        |  0.2481843837498339 |
| run_orange       | 0.24848620589242099 |
| NUT_short_race7  |  0.2709765301499496 |
| NUT_short_race2  | 0.27759396576456685 |
| BlackBear7       | 0.34349999993133074 |
| BlackBear6       |  0.3867314644605878 |
| NUT_short_race3  |  0.4160955813456202 |
| Short Sky        |  0.4714964284783318 |
| Gorou            |  0.5265076642335619 |
| BlackBear3       |  0.5726293337504068 |
| Nyan Cat         |   0.591376086643764 |
| Verification 3.5 |  0.5956998989301145 |
| BlackBear2       |   0.629992400253375 |
| Speedster        |  0.6788388601217664 |
| BlackBear5       |  0.6889407741136787 |
| BlackBear4       |  0.7864212451138339 |
| Lonely Swim 4    |  0.8081987291507465 |
+------------------+---------------------+
20 rows in set (15.64 sec)
Most finishes on a map by a single player:

Code: Select all

MariaDB [teeworlds]> select Map, Name, count(*) from record_race group by Map, Name order by count(*) desc limit 20;
+-----------------+---------------+----------+
| Map             | Name          | count(*) |
+-----------------+---------------+----------+
| run_blue        | Matrose l_I   |     1186 |
| NUT_short_race6 | fikmesån      |     1001 |
| NUT_short_race6 | snailx3       |      958 |
| Just2Easy       | brainless tee |      824 |
| run_ankii       | FeaRZ         |      762 |
| run_g6          | Ƥɑłɱɑɣ        |      530 |
| run_g6          | FeaRZ         |      501 |
| run_g6          | ihood         |      431 |
| StepByStep      | brainless tee |      351 |
| run_orange      | Gulino        |      342 |
| run_g6          | kill_prinz    |      326 |
| run_ankii       | miami         |      321 |
| run_g6          | Sя.ÐǾĠ€       |      297 |
| run_blue        | Hindu         |      285 |
| run_ankii       | RafaelosKy    |      280 |
| run_g6          | sen pa'       |      279 |
| run_blue        | Neo           |      279 |
| run_ankii       | nameless tee  |      279 |
| run_orange      | Putin         |      277 |
| NUT_short_race6 | coradax       |      272 |
+-----------------+---------------+----------+
Most hours spent on ranks on a map by one player:

Code: Select all

MariaDB [teeworlds]> select Map, Name, sum(Time)/3600 as Hours from record_race group by Map, Name order by sum(Time) desc limit 20;
+--------------------+----------------+--------------------+
| Map                | Name           | Hours              |
+--------------------+----------------+--------------------+
| Kobra              | nameless tee   | 156.88226623535155 |
| Epix               | brainless tee  | 155.29066638522679 |
| Just2Easy          | brainless tee  |  125.8680111863878 |
| Multimap           | toM            | 124.79832260131836 |
| Kobra              | Mrs Depression |  123.2420388454861 |
| Kobra 2            | nameless tee   | 115.62320551554362 |
| Purple Panic       | brainless tee  |   115.360994398329 |
| Multimap           | danylr         | 113.09064951578776 |
| Kobra 4            | nameless tee   | 104.72881659613715 |
| Multimap           | brainless tee  | 101.27330596923828 |
| Multimap           | Policeo        |   97.0203611585829 |
| Multimap           | igN            |  94.86378885904948 |
| Kobra              | om             |  90.63036068386502 |
| Absurd 4           | brainless tee  |  89.64076109144423 |
| Kobra              | brainless tee  |  86.88915564643013 |
| Multimap           | Churra         |  85.53274982028537 |
| Kobra              | Qu!ck          |  84.40019434611003 |
| Multimap           | Grk0ne         |  84.15566116333008 |
| Kobra              | OLEG           |  83.58511715359158 |
+--------------------+----------------+--------------------+
Highest times:

Code: Select all

MariaDB [teeworlds]> select Map, Name, Time/60 as Minutes from record_race order by Time desc limit 20;
+--------------------+-----------------+--------------------+
| Map                | Name            | Minutes            |
+--------------------+-----------------+--------------------+
| Epix               | nameless tee    | 1660.1766927083333 |
| Epix               | brainless tee   | 1660.1376302083333 |
| run_world_war_zero | RedPig          | 1593.5559895833333 |
| Naufrage 3         | M Emile         |      1465.03671875 |
| Care for your Time | Savander-Long   | 1440.2200520833333 |
| Weird Cave         | =phacrum=       | 1337.2166666666667 |
| MonkeyDream        | Narcizj         |     1248.749609375 |
| MonkeyDream        | Hermezj         |       1248.6140625 |
| run_antibuguse     | Netherman       |           1177.625 |
| Kobra              | Chele           |    1042.4216796875 |
| Care for your Time | (2)             | 1015.0083333333333 |
| Care for your Time | 1000            |  999.9949869791667 |
| Multimap           | Silverstreak    |  921.3483072916666 |
| Fly out of hell    | ChillerDragon   |     869.5216796875 |
| run_guy_25         | red!            |  845.6303385416667 |
+--------------------+-----------------+--------------------+

User avatar
Shishigami
User
Posts: 188
Joined: Sat Nov 26, 2016 6:01 pm
Location: Germany
Player profile: Shishigami
Mapper profile: Shishigami
Clan: TOP
Website: http://www.shishigami.eu

Re: More fun statistics

Post by Shishigami » Sat Apr 22, 2017 6:18 pm

1660 minutes is the record? I can beat that ( ͡° ͜ʖ ͡°)
Image

User avatar
Konsti
User
Posts: 1173
Joined: Mon Sep 28, 2015 9:01 pm
Location: Germany
Player profile: Konsti
Mapper profile: Konsti
Clan: flawLess
Website: Konsti

Re: More fun statistics

Post by Konsti » Sun Apr 23, 2017 2:10 am

Care for your time shouldnt get counted, just hold a at tele 9 and go afk some time xD
Image
Image

Chairn
User
Posts: 386
Joined: Sat Apr 11, 2015 5:05 pm
Player profile: Chairn
Clan: QuintessenZ

Re: More fun statistics

Post by Chairn » Sun Apr 23, 2017 2:48 am

And there was a time with 10k minutes by snail if i recall correctly.
For Kobra map, it's like it has been played continuously since its release but by only one player, which is not that much ^^.

User avatar
Lumpy ◐ω◑
User
Posts: 233
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: Lumpy ◐ω◑

Re: More fun statistics

Post by Lumpy ◐ω◑ » Mon Apr 24, 2017 12:22 pm

nice statistics :D I can explain 123 hours that Mrs Depression spent on Kobra, she just helping newbies a lot :D

Index
User
Posts: 1070
Joined: Mon May 05, 2014 7:30 pm
Player profile: ٭ıƞdex'<3
Mapper profile: ٭ıƞdex'<3
Clan: Eagle

Re: More fun statistics

Post by Index » Tue Apr 25, 2017 9:37 pm

What about a statsitic with the most amount of team finishes together, like first team finished 300 maps together (with the same partner) and so on.
I think there even was such a list, but I can't find it anymore .__.
So, if you take requests: That would be awesome to have something like this :3

However, thanks for your work and the funny information, deen :)
Totally useless but really interesting.

User avatar
Konsti
User
Posts: 1173
Joined: Mon Sep 28, 2015 9:01 pm
Location: Germany
Player profile: Konsti
Mapper profile: Konsti
Clan: flawLess
Website: Konsti

Re: More fun statistics

Post by Konsti » Wed Apr 26, 2017 1:57 am

Lol, im close to 300 ranks with My dummy x)
Forever Alone <3 ~Index
Image
Image

Oblique.
User
Posts: 200
Joined: Sun Apr 26, 2015 10:38 pm

Re: More fun statistics

Post by Oblique. » Wed Apr 26, 2017 3:01 am

In highest times, didn't even notice the first time. :'D

Code: Select all

+--------------------+-----------------+--------------------+
| Map                | Name            | Minutes            |
+--------------------+-----------------+--------------------+
| ...
| Care for your Time | 1000            |  999.9949869791667 |
| ...
+--------------------+-----------------+--------------------+
A is for Apple.

User avatar
Konsti
User
Posts: 1173
Joined: Mon Sep 28, 2015 9:01 pm
Location: Germany
Player profile: Konsti
Mapper profile: Konsti
Clan: flawLess
Website: Konsti

Re: More fun statistics

Post by Konsti » Wed Apr 26, 2017 6:46 am

Care for your time doesnt count
Image
Image

Welf
User
Posts: 1839
Joined: Fri Jun 06, 2014 12:20 am
Player profile: Welf
Mapper profile: Welf

Re: More fun statistics

Post by Welf » Wed Apr 26, 2017 9:48 am

A list about most frequently banned players

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests