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's newly registered company capital surges by 647 pct in H1
Macao's unemployment rate remains steady
Macao's retail sales decrease year-on-year in Q1
Visitors spending up 3.1 pct in Q1 in Macao
Macao's composite CPI up by 2.79 pct in February