select count(*) as totalNum from products where isOnSale=1 and actType <=1 and attrId=0 and naviId in() and proType = 6
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 proType = 6' at line 1