Error in sql statement:
SELECT p.smart_price as lowestPrice, DATEDIFF(p.date,curdate()) FROM `price_list` p LEFT JOIN destinations d ON d.did = p.destination WHERE destination= and smart_price > 0 AND DATE > '2017-11-20' and status=1 and pstatus='1' and (DATEDIFF(p.date,curdate())>84)ORDER BY smart_price
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 'and smart_price > 0 AND DATE > '2017-11-20' and status=1 and pstatus='1' and (' at line 4