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