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 '%Express on Imports and Exports by FIEs%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_49 Where idCorp=1800000121 and iProject=49 and (field2 like '%Express on Imports and Exports by FIEs%')) a where irecord<>3938 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Express on Imports and Exports by FIEs from Jan to May 2019
Express on Imports and Exports by FIEs from Jan to Apr 2019
Express on Imports and Exports by FIEs from Jan to Mar 2019
Express on Imports and Exports by FIEs from Jan to Feb 2019
Express on Imports and Exports by FIEs in January 2019