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