race
table).
SELECT maps.Map, maps.Stars, COUNT(race.Map), FLOOR(MIN(IFNULL(race.Time,0))) FROM maps JOIN race ON race.Map = maps.Map AND maps.Server='HRD' AND maps.Timestamp <= NOW() GROUP BY race.Map ORDER BY maps.Timestamp DESC LIMIT 5
race
table).
SELECT maps.Map, maps.Stars, COUNT(race.Map), FLOOR(MIN(IFNULL(race.Time,0))) FROM maps JOIN race ON race.Map = maps.Map AND maps.Server='HRD' AND maps.Timestamp <= NOW() GROUP BY race.Map ORDER BY maps.Timestamp DESC LIMIT 5