select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field7 like '%Finland%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Finland%')) a where irecord<>48679 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Finland to increase annual working days, reduce welfare
HK-Finland trade pact in force
China, Finland eye further trade, parliamentary cooperation
Hunan Promotes Its Culture in Finland
Hunan Extends Cooperation with Sweden, Finland, Netherlands