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 (0,1182689, 1050880, 1133535, 1107527, 1127458, 1072268, 1091692, 1047135, 1082924, 1078022, 1088088, 1057400, 1132494, 1086757, 1081322, 1112317, 1117480, 1087278, 1105196, 1075839, 1124347, 1067445, 1044271, 1053291, 1132042, 1091060, 1127187, 1077438, 1109995, 1090404, 1118800, 1062149, 1058146, 1112514, 1129745, 1075555, 1047024, 1060177, 1134068, 1068654, 1094533, 1115528, 1090547, 1072439, 1099123, 1103724, 1129079, 1109170) ORDER BY `Distance` ASC LIMIT 500 Products from 3M® in Stanmore - 1 stores