Server shutdown in progress<br>select count(*) as total from ***_ecms_hirehouses where classid='13' and (housetype like '%6%' and areacity like '%107%' and housearea BETWEEN '120' and '144' and rentprice BETWEEN '900' and '1200' and floor BETWEEN '10' and '15' and usgroupid like '%1%')