select count(fyid) as appesfddpc from (select fyid,count(fyid) counts from jy510_esf_zhuzhai WHERE sfsh=1 AND  schoolpid like '238%' AND  schoolmid like '229%' AND xqid in (42,43,47,48,51,52,53,54,56,60,70,72,131,151,152,153,164,177,178,184,192,198,200,201,206,235,286,294,298,329,387,389,391,450,451,452,458,606,607,608,609,637,645,651,652,661,674,675,684,685,688,2487,4092,6608,7074,8481,8833,8872) AND fylx=1 AND  szqy = '174'  group by xqid,mj,szlc ) temp