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 LIMIT 21' at line 12
SELECT dealerID, stock, type, vin, vif, miles, photourl, exteriorcolor, exteriorcolorcode, interiorcolor, enginedisplacement, enginecylinders, transmission, drivetrain, depsellingprice, sellingprice, msrp, year, make, model, trim, servicenumber, name, imgURL, certified, body, mpgcity, mpghighway, client.zip AS zip FROM (`inventory`) JOIN `dealer` ON dealer.id=inventory.dealerID JOIN `client` ON client.id=dealer.clientID WHERE `type` = '60712' AND `make` = 'used' AND `year` BETWEEN 0 AND 2009 AND (CASE WHEN depsellingprice=0 THEN sellingprice ELSE depsellingprice END) BETWEEN 0 and 2009 AND inventory.active = 1 AND dealer.active = 1 AND client.active = 1 ORDER BY IF(sellingprice < 1, 1, 0), sellingprice 0-5000000 LIMIT 21