select Server, Map, Points, (select min(Timestamp) from record_race where Map = record_maps.Map and Name = "deen") as FirstFinish, (select count(*) from record_race where Map = record_maps.Map and Name = "deen") as Finishes, (select min(Time) from record_race where Map = record_maps.Map and Name = "deen") as Time, (select count(distinct Name) + 1 from record_race where Map = record_maps.Map and Time < (select min(Time) from record_race where Name = "deen" and Map = record_maps.Map)) as Rank, (select count(distinct ID) + 1 from record_teamrace where Map = record_maps.Map and Time < (select min(Time) from record_teamrace where Map = record_maps.Map and Name = "deen")) as TeamRank from record_maps order by Server, Map;
sixup
field to the statusReleaseTester
roleCScrollRegion
from 0.7?