6 lines
188 B
SQL
6 lines
188 B
SQL
select speed, ifnull(alias, 'Unregistered Player')
|
|
from Speed, Fastest_players
|
|
left join Id2alias
|
|
on idvalue = cryptokey
|
|
where Speed.mapid = Fastest_players. mapid and Speed.mapid = ?
|