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 = ?