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