fastest-player-of-map.sql 188 B

123456
  1. select speed, ifnull(alias, 'Unregistered Player')
  2. from Speed, Fastest_players
  3. left join Id2alias
  4. on idvalue = cryptokey
  5. where Speed.mapid = Fastest_players. mapid and Speed.mapid = ?