xdfcgi/queries/mleaderboard-ojoin.sql

6 lines
214 B
MySQL
Raw Permalink Normal View History

2017-03-13 11:50:57 +05:30
select trank, ifnull(alias, "Unregistered Player"), tvalue
from Cts_times, Cts_ranks
left join Id2alias
on idvalue = cryptokey
where trank = idrank and Cts_times.mapid = Cts_ranks.mapid and Cts_times.mapid = ?