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 '%Exports%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Exports%')) a where irecord<>50452 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Fruit exports boost New Zealand wholesale trade sales
Cambodia's garment exports up 11 pct in Q1
S. Korea's auto exports decline in March
Vietnam seeks to boost motorbike exports amid flat domestic consumption
Vietnam's top farm exports in 2014