More fun statistics
Posted: Sat Apr 22, 2017 3:43 pm
Highest sum of length of all ranks on a map:
Highest average time for ranks on a map:
Shortest average time for ranks on a map:
Most finishes on a map by a single player:
Most hours spent on ranks on a map by one player:
Highest times:
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 |
+----------------+--------------------+
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 |
+--------------------+--------------------+
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)
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 |
+-----------------+---------------+----------+
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 |
+--------------------+----------------+--------------------+
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 |
+--------------------+-----------------+--------------------+