SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.89718301132918) * (sin(RADIANS(haendler.lng)) * sin(0.0027839921431487) + cos(RADIANS(haendler.lng)) * cos(0.0027839921431487)) - sin(RADIANS(haendler.lat)) * sin(0.89718301132918)))) AS `Distance` FROM `haendler` WHERE `id` IN (1363155, 1113792, 1103210, 1109773, 1097386, 1128472, 1054106, 1090404, 1134068, 1053291, 1088088, 1099123, 1047135, 1050880, 1127458, 1118800, 1081322, 1086757, 1077438, 1069735, 1115844) ORDER BY `Distance` ASC LIMIT 500 Epson Swanley 0 Produkter fra ® i - butikker