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