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;