SELECT
cod,name_rus, country_id, region_id, rayon_rus, (abs((lon - 167.566)*(lon - 167.566)) + ABS((lat - 54.783)*(lat - 54.783)) ) as distance
FROM city_guru
WHERE cod < 100000000 and
(abs((lon - 167.566)*(lon - 167.566)) + ABS((lat - 54.783)*(lat - 54.783)) )<10 and (abs((lon - 167.566)*(lon - 167.566)) + ABS((lat - 54.783)*(lat - 54.783)) ) >0.000001
ORDER BY `distance` ASC limit 1