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 '%British%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%British%')) a where irecord<>48681 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
British inflation rate rises to 2.1 pct in July
British car production hits 12th consecutive month drop in May
Strong British GDP growth points to sooner-than-expected rate rise: expert
British economic growth spurred by strong manufacturing figures
British manufacturing sector continues robust growth trend