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 '%Macao%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Macao%')) a where irecord<>52389 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Macao retail sale value edges down by 0.5 pct in Q3
Macao's Gross Value Added increases in 2018
Macao's composite consumer price index up 2.73 pct in September
Macao's restaurants revenue, gross surplus increase in 2018
Macao's current account registers 19.6 bln USD surplus in 2018