select count(fyid) as appesfddpc from (select fyid,count(fyid) counts from jy510_esf_zhuzhai WHERE sfsh=1 AND fylx=1 AND ( szqy = '165' OR  szqy = '161' ) AND mj>='200'  AND fyid in (9741662,9672190,9618402,9749142,9614839,9749154,9749160,9673597,9582949,9551116,9748959,9708902,9634407,9634183,9683158,9727581,9710935,9603669,9651693,9611049,9714787,9739611,9710880,9750462,9750467,9710553,9703708,9543203,9739858,9724427)  group by xqid,mj,szlc ) temp