SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.9006108379801) * (sin(RADIANS(haendler.lng)) * sin(-0.0051711138676864) + cos(RADIANS(haendler.lng)) * cos(-0.0051711138676864)) - sin(RADIANS(haendler.lat)) * sin(0.9006108379801)))) AS `Distance` FROM `haendler` WHERE `id` IN (1115528, 1058146, 1075839, 1129745, 1094533, 1087278, 1103724, 1091692, 1047024, 1133535, 1057400, 1129079, 1090404, 1117480, 1134068, 1053291, 1082924, 1109170, 1132494, 1062149, 1124347, 1088088, 1099123, 1067445, 1075555, 1047135, 1112317, 1105196, 1127458, 1118800, 1107527, 1072268, 1081322, 1068654, 1086757, 1077438, 1060177, 1044271, 1132042, 1109995, 1091060, 1078022, 1072439, 1127187, 1112514, 1090547) ORDER BY `Distance` ASC LIMIT 500 Products from Europa® in Stanmore - 1 stores