SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.89946415666154) * (sin(RADIANS(haendler.lng)) * sin(-0.0060407765273701) + cos(RADIANS(haendler.lng)) * cos(-0.0060407765273701)) - sin(RADIANS(haendler.lat)) * sin(0.89946415666154)))) AS `Distance` FROM `haendler` WHERE `id` IN (1096070, 1090226, 1117219, 1115528, 1058146, 1075839, 1129745, 1057742, 1094533, 1087278, 1103724, 1091692, 1047024, 1133535, 1057400, 1129079, 1090404, 1117480, 1134068, 1082924, 1109170, 1132494, 1062149, 1124347, 1088088, 1099123, 1067445, 1075555, 1047135, 1112317, 1105196, 1127458, 1118800, 1107527, 1072268, 1081322, 1068654, 1086757, 1077438, 1060177, 1044271, 1132042, 1109995, 1078022, 1072439, 1127187, 1112514) ORDER BY `Distance` ASC LIMIT 500 Ideal Greenford 1 Výrobky z ® v - obchody