An Error Was Encountered
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 '0-5000000 , depsellingprice 0-5000000 LIMIT desc, 20' at line 86
SELECT i.homenetID , i.vin , i.dealeraddress , i.stock , i.type , i.year , i.make , i.model , i.trim , i.body , i.doors , i.miles , i.certified , i.description , i.options , i.dateinstock , i.sellingprice , i.msrp , i.vif , i.photopath , i.exteriorcolor , i.exteriorcolorgeneric , i.exteriorcolorcode , i.interiorcolor , i.interiorcolorgeneric , i.interiorcolorcode , i.interiorupholstery , i.enginecylinders , i.enginedisplacement , i.engineblocktype , i.transmission , i.transmissionspeed , i.drivetrain , i.fueltype , i.mpgcity , i.mpghighway , i.passengercapacity , i.marketclass , i.standardequipment , i.exteriorequipment , i.interiorequipment , i.mechanicalequipment , i.safetyequipment , i.optionalequipment , i.optionalequipmentshort , i.standardbody , i.isspecial , i.specialprice , i.specialsdisclaimer , i.comment1 , i.comment2 , i.comment3 , i.comment4 , i.specialfield1 , i.specialfield2 , i.specialfield3 , i.specialfield4 , i.iolvideolink , i.videoembed , i.videourl , i.oneowner , i.depsellingprice , i.depspecial , i.depspecialtext , i.depcomments , i.dateoutofstock , i.active , i.jato_id , asr.discount , asr.special_text FROM inventory i LEFT JOIN auto_specials ats ON ats.vin = i.vin LEFT JOIN auto_special_rules asr ON asr.id = ats.rule_id WHERE i.active = "1" AND i.type = "48357" AND i.make = "used" AND (CASE WHEN (depsellingprice IS NULL OR depsellingprice = 0) THEN sellingprice ELSE depsellingprice END) BETWEEN 0 AND 0 ORDER BY IF(sellingprice < 1, 1, 0), sellingprice 0-5000000 , depsellingprice 0-5000000 LIMIT desc, 20