将您的查询换成另一个查询
SELECt LocationFROM ( SELECt locations.id as Location, 1609.34 * 3956 * 2 * ASIN( SQRT( POWER( SIN( (55.170000 - abs(locations.latitude)) * pi() / 180 / 2), 2) + COS(55.170000 * pi() / 180 ) * COS(abs (locations.latitude) * pi() / 180) * POWER(SIN((-7.400000 - (locations.longitude)) * pi() / 180 / 2), 2) ) ) as result FROM locations order by result asc limit 10) AS L
