ddnet: Oldest Top Ranks Still Standing

Custom SQL query returning 50 rows (hide) 

SELECT r1s.map, name, timestamp, time FROM race AS ranks INNER JOIN (SELECT map, MIN(time) AS mintime FROM race GROUP BY map) AS r1s ON ranks.map = r1s.map AND ranks.time = r1s.mintime ORDER BY timestamp LIMIT 50;

Edit SQL

This data as json, copyable, seaborn, CSV

mapNameTimestampTime
Gedan EryX 2016-02-02 13:11:32 65.92
Impossible 2 Shocker 2016-02-04 04:07:29 121.9
Careless =Pipou= 2016-06-10 02:24:25 30.34
Teleport Soapy Sandwich 2016-09-23 22:58:34 76.44
Skillz 6 Soapy Sandwich 2016-09-24 15:34:35 88.3
xyz_ddrace2 Soapy Sandwich 2016-09-24 16:53:59 148.88
GlassBox 9 Soapy Sandwich 2016-09-24 23:20:15 91.98
bBzZ!! Colo-Colo 2016-10-01 15:14:05 354.36
Deria Soapy Sandwich 2016-10-15 19:04:05 63.52
Vizur 2_Ta6LeTki_LSD 2016-12-05 15:16:59 119.56
Cuboid stompie 2016-12-25 21:08:28 98.76
DawnOfDust Cireme 2017-01-14 18:26:28 664.22
DawnOfDust Fluday 2017-01-14 18:26:28 664.22
Elumite MilTee 2017-04-29 19:32:36 639.6
Elumite Yota. 2017-04-29 19:32:36 639.6
run_skizz_loop1200 nether 2017-07-24 01:18:25 73.24
run_inset_into_the_light nether 2017-07-27 11:52:19 63.64
SkyLand2 Graves 2017-07-29 17:37:58 486.26
SkyLand2 NISO 2017-07-29 17:37:58 486.26
run_the_rock nether 2017-08-01 12:50:38 90.86
run_dragon nether 2017-08-06 19:57:00 58.26
run_ffs nether 2017-08-07 21:04:33 34.42
run_inset_into_the_heavy_jungle nether 2017-08-11 15:58:49 165.36
run_heaven_and_hell nether 2017-08-16 16:10:52 87.48
run_WARmoepopo nether 2017-08-17 18:44:06 30.52
run_WARmoepopo Fudgyking 2017-08-21 05:41:28 30.52
Sky Movement *~Rôny~* 2017-08-22 16:58:38 154.88
run_forrest nether 2017-08-22 19:28:42 36.98
run_crystal Fudgyking 2017-08-26 21:39:48 40.94
run_miniatur Fudgyking 2017-08-27 07:02:52 36.02
run_pencil Fudgyking 2017-08-27 23:28:34 29.58
run_4tzoy Fudgyking 2017-08-29 03:10:24 36.62
run_pokemon Fudgyking 2017-08-31 05:37:14 140.46
run_black_white Fudgyking 2017-09-01 03:46:29 64.42
run_stoned Fudgyking 2017-09-02 02:10:24 110.42
run_pinky Fudgyking 2017-09-04 04:45:18 120.0
run_toxic_green Fudgyking 2017-09-09 08:10:14 40.14
run_long_for_popo Fudgyking 2017-09-10 01:55:10 53.44
run_experience_of_incredibleness Fudgyking 2017-09-10 03:55:51 51.96
Lucid Dream Mıss Fʋггצ 2017-09-16 19:47:52 39.3
Anoteex *~Rôny~* 2017-09-23 08:03:41 275.52
run_4xerhul Fudgyking 2017-10-04 03:07:00 64.5
Aufnahmetest_AE Fudgyking 2017-10-04 04:28:41 57.76
run_redbull Fudgyking 2017-10-09 01:40:13 47.06
run_unschaffbar Fudgyking 2017-10-09 05:39:56 57.28
Guhimbarwa Cireme 2017-10-17 23:05:25 517.16
Guhimbarwa Lexin 2017-10-17 23:05:25 517.16
Tough Cireme 2017-10-19 21:55:41 640.86
Tough Fluday 2017-10-19 21:55:41 640.86
Lamb *~Rôny~* 2017-10-24 14:23:05 221.74