SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) * cos(0.91384217903947) * (sin(RADIANS(haendler.lng)) * sin(0.23743633677056) + cos(RADIANS(haendler.lng)) * cos(0.23743633677056)) - sin(RADIANS(haendler.lat)) * sin(0.91384217903947)))) AS `Distance` FROM `haendler` WHERE `id` IN (12402, 3667, 12405, 12409, 3535, 12411, 12415, 8019, 12407, 12406, 12410, 12417, 12413, 13843, 12421, 12414, 12412, 3450, 8024, 10826, 3453, 12427, 10820, 12448, 10817, 12423, 12426, 3451, 22106, 18009, 10819, 10824, 12422, 7571, 10816, 12439, 12425, 12432, 12431, 4064, 4452, 4603, 10821, 12416, 3448) ORDER BY `Distance` ASC LIMIT 500 Gær frisk Schulzendorf 0 køb i " butikker