Server shutdown in progress<br>select count(*) as total from ***_ecms_hirehouses where classid='12' and (housetype like '%8%' and housearea BETWEEN '160' and '180' and rentprice BETWEEN '1' and '10' and floor BETWEEN '2' and '3' and usgroupid like '%2 and salestate = 0 %') and salestate = 0