MariaDB [teeworlds]> select record_race.Map, Name, count(*) as Finishes from record_race inner join record_maps on record_race.Map = record_maps.Map and record_maps.Server != "Race" and record_race.Name != "nameless tee" and record_race.Name != "brainless tee" and record_maps.Map not like "%short%" group by Map, Name order by Finishes desc limit 20;
+---------------+-----------------+----------+
| Map | Name | Finishes |
+---------------+-----------------+----------+
| Multeasymap | vento123 | 1208 |
| Multeasymap | JaaJ | 805 |
| Multeasymap | EzeJe | 687 |
| Multeasymap | Spike_666 | 657 |
| Sunny Side Up | Catalin | 603 |
| Sunny Side Up | clownpiece | 578 |
| Multeasymap | MARS FACE | 484 |
| Buckle Up | deen | 480 |
| Multeasymap | fla_flou | 456 |
| Multeasymap | Steroid Stewie | 396 |
| Multeasymap | Mitsch | 393 |
| Multeasymap | Angelofsicness | 391 |
| Multeasymap | (1)nameless tee | 378 |
| DontMove | 嘻嘻 | 378 |
| Just2Easy | (1) | 369 |
| Multeasymap | TickTack | 363 |
| Multeasymap | Kittiii | 360 |
| Multeasymap | Careloco117 | 353 |
| Multeasymap | Gabe McKraken | 345 |
| Jajpack | (inacceptable) | 344 |
+---------------+-----------------+----------+
20 rows in set (5 min 9.320 sec)