Server shutdown in progress<br>select count(*) as total from ***_ecms_hirehouses where classid='12' and (housetype like '%1%' and areacity like '%107%' and bedroom BETWEEN '5' and '9' and housearea BETWEEN '180' and '200' and rentprice BETWEEN '20' and '30' and floor BETWEEN '15' and '20' and usgroupid like '%3 and salestate = 0 %') and salestate = 0