SELECT *,a.Nationcode nationcodeplace,a.Level AS Racelevel FROM A_racejp a LEFT JOIN A_resultjp c ON a.raceid = c.raceid WHERE a.Published=1 AND a.Raceid=3890 ORDER BY c.Cuppoints DESC