Error Number: 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 'ORDER BY precio_tour DESC' at line 1

SELECT * , CASE WHEN CONVERT(price_usd, DECIMAL) > 0 THEN CONVERT(price_usd, DECIMAL) ELSE -999999999 END AS precio_tour FROM lodgings WHERE active=1 AND is_experience=0 AND booking>0 AND destination_id= ORDER BY precio_tour DESC

Filename: models/Visitchile_model.php

Line Number: 95