Fatal error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* pi()/180 ) * COS(abs(elm_lat) * pi()/180) * POWER(SIN(( - elm_lng) * pi()/18' at line 4
Query: SELECT * FROM ( SELECT *, (3956 * 2 * ASIN(SQRT(POWER(SIN(( - abs(elm_lat)) * pi()/180 / 2),2) + COS( * pi()/180 ) * COS(abs(elm_lat) * pi()/180) * POWER(SIN(( - elm_lng) * pi()/180 / 2), 2))) / 0.62137) as distance, (MATCH(elm_nom, elm_cat, elm_pob, elm_pcl, elm_des, elm_des_bus) AGAINST (:q IN NATURAL LANGUAGE MODE)) AS score FROM tbee_elems2 LEFT JOIN tbee_elems_local ON elm_loc_elm_seq = elm_seq AND elm_loc_idi_seq = :idi_seq LEFT JOIN tbee_pobla ON pob_seq = elm_pob_seq LEFT JOIN tbee_munic ON mun_seq = pob_mun_seq LEFT JOIN tbee_provi ON prv_seq = mun_prv_seq LEFT JOIN tbee_categ ON cat_seq = elm_cat_seq WHERE elm_act = 1 AND MATCH(elm_nom, elm_pob, elm_pcl, elm_cat, e in /var/www/vhosts/filebees.com/m.filebees.com/core/dao.class.php on line 66