Server shutdown in progress<br>select count(*) as total from ***_ecms_hirehouses where classid='12' and (housetype like '%6%' and areacity like '%107%' and bedroom BETWEEN '5' and '9' and rentprice BETWEEN '40' and '50' and floor like '%6%' and usgroupid like '%2%') and salestate = 0