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<>45832 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Taiwan export orders fall 6 pct in January
Taiwan manufacturing revenue up in Q1
Taiwan export orders up 9.1 pct in May
Taiwan unemployment rate falls to 3.95 pct in October
Number of visitors to Taiwan down 3.4 percent in August