Find A Store

WordPress database error: [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(wp_zip_codes.lat * PI() / 180) + COS( * PI() / 180) * COS(wp' at line 1]
SELECT DISTINCT wp_zip_codes.zip_id,wp_stores.name, wp_stores.address, wp_stores.town, wp_stores.state, wp_stores.postal, wp_stores.phone,wp_zip_codes.lat, wp_zip_codes.lon, ((ACOS(SIN( * PI() / 180) * SIN(wp_zip_codes.lat * PI() / 180) + COS( * PI() / 180) * COS(wp_zip_codes.lat * PI() / 180) * COS(( - wp_zip_codes.lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM wp_stores JOIN wp_zip_codes ON wp_stores.postal = wp_zip_codes.zip WHERE (wp_stores.specialties LIKE '%Ayr Allergy & Sinus%') AND (((ACOS(SIN( * PI() / 180) * SIN(wp_zip_codes.lat * PI() / 180) + COS( * PI() / 180) * COS(wp_zip_codes.lat * PI() / 180) * COS(( - wp_zip_codes.lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) <= 5) ORDER BY distance

WordPress database error: [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(wp_zip_codes.lat * PI() / 180) + COS( * PI() / 180) * COS(wp' at line 1]
SELECT DISTINCT wp_zip_codes.zip_id,wp_stores.name, wp_stores.address, wp_stores.town, wp_stores.state, wp_stores.postal, wp_stores.phone,wp_zip_codes.lat, wp_zip_codes.lon, ((ACOS(SIN( * PI() / 180) * SIN(wp_zip_codes.lat * PI() / 180) + COS( * PI() / 180) * COS(wp_zip_codes.lat * PI() / 180) * COS(( - wp_zip_codes.lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM wp_stores JOIN wp_zip_codes ON wp_stores.postal = wp_zip_codes.zip WHERE (wp_stores.specialties LIKE '%Ayr Allergy & Sinus%') AND (((ACOS(SIN( * PI() / 180) * SIN(wp_zip_codes.lat * PI() / 180) + COS( * PI() / 180) * COS(wp_zip_codes.lat * PI() / 180) * COS(( - wp_zip_codes.lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) <= 5) ORDER BY distance limit 0, 5