SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) *
cos(0.8257850822886) * (sin(RADIANS(haendler.lng)) *
sin(0.1440268388026) + cos(RADIANS(haendler.lng)) *
cos(0.1440268388026)) - sin(RADIANS(haendler.lat)) * sin(0.8257850822886)))) AS `Distance`
FROM `haendler` WHERE `id` IN (629683, 1402032, 1410827, 1450948, 723496, 1410821, 700337, 1406359, 1473590, 1593646, 1454845, 642097) ORDER BY `Distance` ASC LIMIT 500
Is something missing here?
Do you have a business in Sarmenstorf? Enter it for free in a few steps.
Register now!
© 2024, Wogibtswas / Locabee. All brand names and trademarks are the property of their respective owners. All information without guarantee. Status 04.10.2024 11:02:40