select count(fyid) as appesfddpc from (select fyid,count(fyid) counts from jy510_esf_zhuzhai WHERE sfsh=1 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 = '169' AND fyid in (9741662,9672190,9618402,9749142,9614839,9749154,9749160,9673597,9582949,9551116,9748959,9740428,9708902,9634407,9634183,9683158,9727581,9710935,9603669,9651693,9611049,9714787,9739611,9710880,9750462,9750467,9710553,9703708,9543203,9739858,9724427) AND jg > 0  group by xqid,mj,szlc ) temp