Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 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((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/1' at line 1

SQL Query: SELECT `Ville`.`nom`, `Ville`.`slug`, (((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance FROM `c2_1001ecolesprivees_db`.`villes` AS `Ville` LEFT JOIN `c2_1001ecolesprivees_db`.`etablissements` AS `Etablissement` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Ville`.`slug` != "breze" AND agregat_id = 1 GROUP BY `Ville`.`id` HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1 ORDER BY `distance` ASC LIMIT 7

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace