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