



















ef6282d Replace remaining int64_t by int64 for the sake of consistency - Kaffeine
a9bc619 CGameControllerDDRace: Add Score() getter - Kaffeine
a6bdda6 GameController: Add OnPlayerConnect() like in the upstream - Kaffeine
b0c0fb3 Get rid of gamemode.h with confusing definitions - Kaffeine
688f11e Move DDRace-specific player initialization code to the Controller - Kaffeine
dfc7580 CGameContext::SendVoteStatus: Hide the trick for 64 clients - Kaffeine
2790270 Adopt upstream refactoring: Mark several functions as 'const' - Kaffeine
6b49bf1 Make spectators stay specs on map changed - Kaffeine
908646e Merge #3605 - bors[bot]



(void)Uninitialized; // We need a reference for the next line. why is this needed?













select distinct r.Name, r.ID, r.Time, r.Timestamp, n.Server from (select distinct ID from record_teamrace where Map = 'Multeasymap' ORDER BY Time limit 20) as l left join (select * from record_teamrace where Map = 'Multeasymap') as r on l.ID = r.ID inner join ((select distinct Map, Name, Time, SUBSTRING(Server, 1, 3) as Server from record_race) as n) on r.Map = n.Map and r.Name = n.Name and r.Time = n.Time order by r.Time, r.ID, r.Name;| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-----------------+------+------------------------------------+--------------+---------+---------------------------------------------------------------+--------+-----------------------------------------------------------+
| 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 20 | Using temporary; Using filesort |
| 1 | PRIMARY | record_teamrace | ref | PRIMARY,Name,Map,ID,MapID | ID | 532 | l.ID,const | 1 | Using where; Using index |
| 1 | PRIMARY | <derived4> | ref | key0 | key0 | 70 | teeworlds.record_teamrace.Name,teeworlds.record_teamrace.Time | 10 | Using where |
| 4 | DERIVED | record_race | ref | Map,Map_2,MapTimestamp,MapNameTime | MapTimestamp | 514 | const | 161796 | Using where; Using index; Using temporary |
| 2 | DERIVED | record_teamrace | ref | PRIMARY,Map,MapID | PRIMARY | 514 | const | 20044 | Using where; Using index; Using temporary; Using filesort |select distinct r.Name, r.ID, r.Time, r.Timestamp, SUBSTRING(n.Server, 1, 3) from (select distinct ID from record_teamrace where Map = 'Multeasymap' ORDER BY Time limit 20) as l left join record_teamrace as r on l.ID = r.ID inner join record_race as n on r.Map = n.Map and r.Name = n.Name and r.Time = n.Time order by r.Time, r.ID, r.Name;
2
1