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