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 '%Britain%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Britain%')) a where irecord<>50897 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Britain reports first budget surplus in 15 years
Inflation in Britain highest since 2014, says ONS
Number of small businesses in Britain reaches six million
Report urges investment in "key areas" of Britain's shipbuilding industry
Unemployment in Britain at lowest level for 10 years