Server shutdown in progress<br>select count(*) as total from ***_ecms_hirehouses where classid='12' and (areacity like '%107%' and bedroom like '%2%' and housearea BETWEEN '50' and '80' and floor BETWEEN '10' and '15' and usgroupid like '%2%')