MySQL Query:SELECT COUNT(houseid) AS number FROM h_house WHERE infocat=4 and name = 'Áú½»¨Ô°' and propertytype=4 and (price<=70 or (unit=3 and price*buildarea <=70*10000)) and buildarea>10 and buildarea<50lou1= and decorate=5
MySQL Error: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 decorate=5' at line 1
MySQL Errno:1064
Message:MySQL Query Error