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 'desc and AND inventory.active = 1 AND dealer.active = 1 AND client.active = 1 A' at line 7
SELECT count(*) as total FROM (`inventory`) JOIN `dealer` ON dealer.id=inventory.dealerID JOIN `client` ON client.id=dealer.clientID WHERE `model` = '0-2009' AND `year` BETWEEN 0 AND 5000000 AND (CASE WHEN depsellingprice=0 THEN sellingprice ELSE depsellingprice END) BETWEEN desc and AND inventory.active = 1 AND dealer.active = 1 AND client.active = 1 AND client.zip IN ('')