select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_39 Where idCorp=1800000121 and iProject=39 and (field12 like '%Decision of the Standing Committee of the National People鈥檚 Congress on Amending Four Laws Including the Law of the People鈥檚 Republic of China on Foreign-funded Enterprises%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_39 Where idCorp=1800000121 and iProject=39 and (field2 like '%Decision of the Standing Committee of the National People鈥檚 Congress on Amending Four Laws Including the Law of the People鈥檚 Republic of China on Foreign-funded Enterprises%')) a where irecord<>4849 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网