select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_49 Where idCorp=1800000121 and iProject=49 and (field10 like '%News Release of National Assimilation of FDI%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_49 Where idCorp=1800000121 and iProject=49 and (field2 like '%News Release of National Assimilation of FDI%')) a where irecord<>4690 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
News Release of National Assimilation of FDI From January to July 2019
News Release of National Assimilation of FDI From January to May 2019
News Release of National Assimilation of FDI From January to April 2019
News Release of National Assimilation of FDI From January to March 2019
News Release of National Assimilation of FDI From January to February 2019