SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) *
cos(0.85230186961415) * (sin(RADIANS(haendler.lng)) *
sin(0.14457138152922) + cos(RADIANS(haendler.lng)) *
cos(0.14457138152922)) - sin(RADIANS(haendler.lat)) * sin(0.85230186961415)))) AS `Distance`
FROM `haendler` WHERE `id` IN (521282, 523446, 731930, 1477345, 560566, 522930, 522303, 522374, 522806, 521658, 521134, 1547453, 524379, 523867, 522795, 757893, 521921, 522852, 730793, 730826, 730840, 728118, 1477350, 522489, 525990, 522718, 734029, 715123, 1585923, 525961, 521705, 1477343) ORDER BY `Distance` ASC LIMIT 500
Products from PVAG Polizeiversicherungs-Aktiengesellschaft® in Bischweier - 3 stores
-
locabee.com
-
Bischweier
-
PVAG Polizeiversicherungs-Aktiengesellschaft
3 Stores for PVAG Polizeiversicherungs-Aktiengesellschaft in Bischweier
SIGNAL IDUNA Versicherung Felix Brauchle
Theodor-Bergmann-Str. 20
76571 Gaggenau
more
SIGNAL IDUNA Versicherung Wolfgang Brauchle
Th.-Bergmann-Str. 20
76571 Gaggenau
more
SIGNAL IDUNA Versicherung Stefan Ulrich
Schwarzwaldstr. 18 A
76461 Muggensturm
more
Is something missing here?
Do you have a business in Bischweier? 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 10:55:42
UP
Choose your country and language