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 '%S. Korea%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%S. Korea%')) a where irecord<>52355 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
S. Korea's foreign reserves falls on strong USD
S. Korea's producer price falls for 4 months through January
S. Korean carmakers' global auto sales fall in September on less business days
S. Korea's business sentiment hits 18-month low
S. Korea's consumer sentiment hits 17-month low