Letzte Aktualisierung am Dienstag, 13. August 2024
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* PI() / 180) * SIN(latitude.meta_value * PI() / 180) + COS( * PI() / 180) * ...' at line 6]SELECT DISTINCT
latitude.post_id,
latitude.meta_key,
latitude.meta_value as cityLat,
longitude.meta_value as cityLong,
((ACOS(SIN( * PI() / 180) * SIN(latitude.meta_value * PI() / 180) + COS( * PI() / 180) * COS(latitude.meta_value * PI() / 180) * COS(( - longitude.meta_value) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance,
wp_posts.post_title
FROM
wp_postmeta AS latitude
LEFT JOIN wp_postmeta as longitude ON latitude.post_id = longitude.post_id
INNER JOIN wp_posts ON wp_posts.ID = latitude.post_id
WHERE latitude.meta_key = 'latitude' AND longitude.meta_key = 'longitude'
HAVING distance < 50
ORDER BY distance ASC;
Qualifizierte Spezialisten, mit implantate.com - Gewährleistung und -Preisgarantie in Ihrer Nähe (Deutschland, Österreich, Schweiz).
