MariaDB [teeworlds]> select Name, count(*) from record_race group by Name order by count(*) desc limit 20;
+----------------+----------+
| Name | count(*) |
+----------------+----------+
| brainless tee | 21073 |
| nameless tee | 15778 |
| Matrose l_I | 6638 |
| (1) | 6349 |
| NovaShock | 5675 |
| Soapy Sandwich | 5462 |
| fikmesån | 5260 |
| Deathman | 5141 |
| Esckiller | 5072 |
| Kicker | 4602 |
| coradax | 4361 |
| <BµmM> | 4257 |
| Noctua | 4192 |
| Starkiller | 4141 |
| N9mkOik | 4134 |
| Tropo | 3914 |
| Yota. | 3908 |
| Grk0ne | 3706 |
| FeaRZ | 3457 |
| Cor | 3396 |
+----------------+----------+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 | 2833 |
| run_g6 | Matrose l_I | 2105 |
| Just2Easy | brainless tee | 1963 |
| NUT_short_race6 | fikmesån | 1342 |
| NUT_short_race6 | Tropo | 1316 |
| run_g6 | Hawkeye88 | 1274 |
| run_g6 | mrs.Smith | 1045 |
| NUT_short_race6 | snailx3 | 960 |
| run_g6 | Nyanto | 949 |
| NUT_short_race6 | Tropo[D] | 869 |
| run_ankii | FeaRZ | 804 |
| run_g6 | Cagih | 777 |
| NUT_short_race6 | coradax | 731 |
| run_g6 | The Great ❶ | 716 |
| StepByStep | brainless tee | 696 |
| run_g6 | Syltoox | 677 |
| run_g6 | Ƥɑłɱɑɣ | 530 |
| run_g6 | ihood | 518 |
| run_g6 | FeaRZ | 512 |
| run_ankii | Matrose l_I | 485 |
+-----------------+---------------+----------+
MariaDB [teeworlds]> select record_race.Map, Name, count(*) from record_race join record_maps on record_race.Map = record_maps.Map and record_maps.Server = "Insane" group by Map, Name order by count(*) desc limit 20;
+-----------+-----------------+----------+
| Map | Name | count(*) |
+-----------+-----------------+----------+
| Ravillion | Lwai | 37 |
| Ravillion | 人形 | 29 |
| Justice 2 | =645654= | 22 |
| Ravillion | MilTee | 17 |
| Justice 2 | =phacrum= | 15 |
| Binary | Vendetta | 14 |
| Justice | =645654= | 13 |
| Ravillion | N9mkOik | 13 |
| Ravillion | Vendetta | 13 |
| Ravillion | Yota. | 11 |
| Heartcore | Vendetta | 11 |
| Ravillion | xeno | 10 |
| Justice 2 | Freezestyler | 9 |
| Ravillion | N9mkOik [CHEAT] | 9 |
| Heartcore | Yota. | 8 |
| Binary | N9mkOik | 8 |
| Ravillion | Linkx3 | 8 |
| Justice | =phacrum= | 7 |
| Justice 2 | Tropo | 7 |
| Ravillion | zєℓ∂α♥ | 7 |
+-----------+-----------------+----------+MariaDB [teeworlds]> select Name, count(*) from record_race join record_maps on record_race.Map = record_maps.Map and record_maps.Server = "Insane" group by Name order by count(*) desc limit 20;
+-----------------+----------+
| Name | count(*) |
+-----------------+----------+
| Vendetta | 79 |
| N9mkOik | 60 |
| Lwai | 50 |
| Kicker | 49 |
| Freezestyler | 48 |
| Colo-Colo | 41 |
| Grk0ne | 39 |
| Cor | 38 |
| =645654= | 37 |
| Starkiller | 36 |
| 人形 | 33 |
| Tropo | 31 |
| Cyclic~ | 31 |
| Yota. | 31 |
| <BµmM> | 29 |
| Shawn. | 28 |
| HaHAxD* | 28 |
| N9mkOik [CHEAT] | 26 |
| MilTee | 26 |
| .:Danytto:. | 23 |
+-----------------+----------+
MariaDB [teeworlds]> select Name, count(*) from record_race join record_maps on record_race.Map = record_maps.Map and record_maps.Server = "Insane" and record_race.Map != "Ravillion" group by Name order by count(*) desc limit 20;
+--------------+----------+
| Name | count(*) |
+--------------+----------+
| Vendetta | 66 |
| N9mkOik | 47 |
| Freezestyler | 46 |
| Kicker | 45 |
| Colo-Colo | 40 |
| Grk0ne | 38 |
| =645654= | 37 |
| Cor | 37 |
| Starkiller | 35 |
| Tropo | 31 |
| <BµmM> | 29 |
| Cyclic~ | 27 |
| HaHAxD* | 27 |
| Shawn. | 26 |
| =phacrum= | 23 |
| .:Danytto:. | 22 |
| Lexin | 21 |
| Forris | 20 |
| Yota. | 20 |
| TyшkaNчuk | 19 |
+--------------+----------+
4
MariaDB [teeworlds]> select Name, count(*) from record_race join record_maps on record_race.Map = record_maps.Map and record_maps.Server <> "Race" group by Name order by count(*) desc limit 20;
+----------------+----------+
| Name | count(*) |
+----------------+----------+
| brainless tee | 20910 |
| nameless tee | 14140 |
| (1) | 5844 |
| NovaShock | 5320 |
| fikmesån | 5021 |
| Deathman | 5015 |
| Soapy Sandwich | 4887 |
| Esckiller | 4797 |
| Kicker | 4105 |
| <BµmM> | 4003 |
| Noctua | 3926 |
| Starkiller | 3765 |
| Tropo | 3762 |
| coradax | 3651 |
| Yota. | 3551 |
| Grk0ne | 3528 |
| N9mkOik | 3358 |
| Cor | 3180 |
| ad | 2982 |
| Colo-Colo | 2976 |
+----------------+----------+
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
3
2
♂️
5
