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 '%Taiwan%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Taiwan%')) a where irecord<>51898 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Mainland important market for Taiwan farm produce: producers
Taiwan's exports slump for six consecutive months
Taiwan's CPI moves up 0.66 pct in April
Taiwan's forex reserves rise for 6 straight months
Taiwan's manufacturing contracts for 5 consecutive months