query failed:
  • errorno = 1064
  • 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 '),2 ) + POW( (longitude - ),2 ) ) as distance, i.file_name, ...' at line 5
  • query = SELECT o.id, o.latitude, o.longitude, ot.name, SQRT( POW( (latitude - ),2 ) + POW( (longitude - ),2 ) ) as distance, i.file_name, c.name as city FROM offers o, offers_texts ot, offers_images i, cities c WHERE o.id = ot.offer_id AND c.city_id = o.city_id AND c.language = 1 AND i.id = o.main_image_id AND ot.language = 1 AND o.status IN (1,4,5,6,7,8,9,11) AND o.latitude IS NOT NULL AND o.longitude IS NOT NULL AND o.id != 9757 AND o.property_type IN (1,9) ORDER BY distance LIMIT 9