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 '%Anhui%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Anhui%')) a where irecord<>46164 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Anhui Ranks 7th in GDP Growth in Q1
Anhui's Foreign Trade Volume up 27.2% in Q1
South Anhui's Tourism Revenue Hits 353.24 Billion Yuan in 2017
Private Firms' Value-Added Output up 9.3% in 2017
77,000 Family Farms Registered in Anhui