MariaDB [teeworlds]> SELECT r1s.map, name, timestamp, time FROM record_race AS ranks INNER JOIN (SELECT mapROM record_race GROUP BY map) AS r1s ON ranks.map = r1s.map AND ranks.time = r1s.mintime ORDER BY timestamp +---------------------+-----------------+---------------------+---------+ | map | name | timestamp | time | +---------------------+-----------------+---------------------+---------+ | Difficult 1.3 | !_Vergeboy_! | 2013-10-08 17:55:04 | 738.3 | | Difficult 1.3 | aaa | 2013-10-08 17:55:04 | 738.3 | | The Cursed Night | (1)Ninja_Valik | 2014-04-09 20:55:25 | 2376.06 | | The Cursed Night | Ninja_Valik | 2014-04-09 20:55:25 | 2376.06 | | Orange 1 | artkis | 2014-07-21 04:24:12 | 109.06 | | leopold | Gridwyn | 2014-12-13 13:17:14 | 128.18 | | NUT Hardcore UNITED | FarinDoc | 2015-04-20 01:41:32 | 1935.6 | | NUT Hardcore UNITED | Obst | 2015-04-20 01:41:32 | 1935.6 | | NUT Hardcore UNITED | cris | 2015-04-20 01:41:32 | 1935.6 | | NUT Hardcore UNITED | walter | 2015-04-20 01:41:32 | 1935.6 | | Killstreak 1 | levi | 2015-06-23 00:44:42 | 50.5 | | Fall & Rise | LanuX | 2015-07-29 14:02:00 | 495.3 | | Fall & Rise | LanuX | 2015-07-29 20:02:00 | 495.3 | | Fall & Rise | LanuX | 2015-07-29 22:02:00 | 495.3 | | Adrenaline 3 | Cireme | 2015-07-30 06:05:44 | 2289.46 | | Adrenaline 3 | aaa | 2015-07-30 06:05:44 | 2289.46 | | Eternal | Habibi57 | 2015-09-04 00:08:40 | 592.8 | | Eternal | Novo c: | 2015-09-04 00:08:40 | 592.8 | | Xabier | | 2015-09-06 00:40:05 | 398.62 | | Xabier | hi_leute_gll | 2015-09-06 00:40:05 | 398.62 | | The Way to the Hell | Lexin | 2015-12-05 03:14:25 | 774.38 | | The Way to the Hell | Ysu | 2015-12-05 03:14:25 | 774.38 | | Amor 2 | Amor | 2015-12-20 01:22:55 | 608.78 | | Explosive | Aoe | 2016-01-23 06:54:18 | 468.22 | | Explosive | Ironik | 2016-01-23 06:54:18 | 468.22 | | Gedan | EryX | 2016-02-02 14:11:32 | 65.92 | | Impossible 2 | Shocker | 2016-02-04 05:07:29 | 121.9 | | Noo! | Hindu | 2016-02-15 04:11:07 | 459.86 | | Noo! | Xan | 2016-02-15 04:11:07 | 459.86 | | Reality | Shocker | 2016-02-24 05:38:42 | 270.54 | | Reality | Pwner | 2016-02-24 05:38:47 | 270.54 | | NUT_short_race2 | SquareDeltaFox | 2016-03-24 21:41:02 | 7.68 | | NUT_short_race2 | snailx3 | 2016-04-17 17:08:39 | 7.68 | | Yoko 2.1 | --------- | 2016-04-29 04:25:11 | 62.04 | | Madness 2 | Ironik | 2016-05-04 04:28:29 | 47.5 | | Climax | Hindu | 2016-05-12 22:32:02 | 616.58 | | Climax | Xan | 2016-05-12 22:32:02 | 616.58 | | Noovice! | no | 2016-05-15 21:58:18 | 605.88 | | Noovice! | yes | 2016-05-15 21:58:18 | 605.88 | | Aftermath | Hindu | 2016-06-09 14:59:29 | 301.64 | | Aftermath | Xan | 2016-06-09 14:59:29 | 301.64 | | Careless | --------- | 2016-06-10 04:24:25 | 30.34 | | Dead Darkness | Ironik | 2016-06-13 02:39:23 | 132.24 | | NUT_short_race4 | Soapy Sandwich | 2016-08-04 21:35:40 | 13.34 | | NUT_hardcore_race5 | Soapy Sandwich | 2016-08-09 19:08:58 | 77.22 | | Veni Vidi Vici | Beard | 2016-08-26 02:59:42 | 698.04 | | Veni Vidi Vici | Hindu | 2016-08-26 02:59:42 | 698.04 | | NUT_race4 | Soapy Sandwich | 2016-09-04 06:24:59 | 25.72 | | HDP_run_gay25 | snailx3 | 2016-09-13 13:08:11 | 364.42 | | Teleport | Soapy Sandwich | 2016-09-24 00:58:34 | 76.44 | | Skillz 6 | Soapy Sandwich | 2016-09-24 17:34:35 | 88.3 | | xyz_ddrace2 | Soapy Sandwich | 2016-09-24 18:53:59 | 148.88 | | Core | sloppydog | 2016-09-24 23:01:42 | 69.18 | | GlassBox 9 | Soapy Sandwich | 2016-09-25 01:20:15 | 91.98 | | ClassicMonkez | Xan | 2016-09-25 02:46:02 | 842.2 | | ClassicMonkez | Yota. | 2016-09-25 02:46:02 | 842.2 | | Pale 2 | ^b[Bro] flummi | 2016-09-28 00:53:01 | 253.26 | | Pale 2 | meter'. | 2016-09-28 00:53:01 | 253.26 | | Pale | ^b[Bro] flummi | 2016-09-28 03:02:15 | 235.66 | | Pale | meter'. | 2016-09-28 03:02:15 | 235.66 | | bBzZ!! | Colo-Colo | 2016-10-01 17:14:05 | 354.36 | | FWYS 4 | snailx3 | 2016-10-02 23:21:17 | 1732.02 | | FWYS 4 | zyr.f | 2016-10-02 23:21:17 | 1732.02 | | Increase Your Speed | snailx3 | 2016-10-05 12:09:26 | 52.1 | | Deria | Soapy Sandwich | 2016-10-15 21:04:05 | 63.52 | | MojoJump | snailx3 | 2016-11-02 13:56:26 | 69.74 | | Castle Mario | StorмPʜöɴix | 2016-11-14 17:20:23 | 443.78 | | Castle Mario | ☆.Sυsнι♪ | 2016-11-14 17:20:23 | 443.78 | | Anaphore | snailx3 | 2016-11-24 03:31:02 | 73.78 | | Inspire | | 2016-11-24 18:06:45 | 1290.74 | | Inspire | HaHAxD* | 2016-11-24 18:06:45 | 1290.74 | | Inspire | RosenVerkäufer | 2016-11-24 18:06:45 | 1290.74 | | Vizur | 2_Ta6LeTki_LSD | 2016-12-05 16:16:59 | 119.56 | | Caventure IV | TNT | 2016-12-07 21:12:08 | 202.56 | | Journey Man | Genex | 2016-12-14 19:27:51 | 2131.56 | | Journey Man | kill the tee | 2016-12-14 19:27:51 | 2131.56 | | Cuboid | stompie | 2016-12-25 22:08:28 | 98.76 | | Clarity | I See You | 2017-01-06 05:45:49 | 70.18 | | DawnOfDust | Cireme | 2017-01-14 19:26:28 | 664.22 | | DawnOfDust | Fluday | 2017-01-14 19:26:28 | 664.22 | | Flow | Ninja_Valik | 2017-02-01 22:21:04 | 1203.06 | | Flow | milk | 2017-02-01 22:21:04 | 1203.06 | | Love 0.6 | Didinette | 2017-03-18 01:07:09 | 64.04 | | Tricktee | Tar :v | 2017-03-31 20:43:11 | 272.84 | | Tricktee | iParano | 2017-03-31 20:43:11 | 272.84 | | DarkCore 1 | Soapy Sandwich | 2017-04-02 07:41:55 | 106.78 | | Emerald | Qywinc | 2017-04-07 15:27:44 | 704.64 | | Emerald | Xan | 2017-04-07 15:27:44 | 704.64 | | Dusty Road | NANAMAR | 2017-04-08 16:41:31 | 377.02 | | Dusty Road | Xan | 2017-04-08 16:41:31 | 377.02 | | Valley 2 | Cireme | 2017-04-29 13:19:16 | 1097.26 | | Valley 2 | iParano | 2017-04-29 13:19:16 | 1097.26 | | Elumite | MilTee | 2017-04-29 21:32:36 | 639.6 | | Elumite | Yota. | 2017-04-29 21:32:36 | 639.6 | | BackToBasics2 | Blurry | 2017-06-20 16:58:34 | 239.14 | | BackToBasics2 | Fluday | 2017-06-20 16:58:34 | 239.14 | | FWYS Key 1 | Hydra | 2017-06-25 03:16:00 | 699.58 | | FWYS Key 1 | ^b[Bro] flummi | 2017-06-25 03:16:00 | 699.58 | | Fender | Fluday | 2017-06-27 00:43:29 | 593.46 | | Fender | snailx3 | 2017-06-27 00:43:29 | 593.46 | +---------------------+-----------------+---------------------+---------+ 100 rows in set (10.898 sec)