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 '%Tourism%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Tourism%')) a where irecord<>48999 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
China's tourism sectors report faster growth
Rwanda's tourism generated 438 mln USD last year: report
China's domestic tourism revenue hits 2.45t yuan in H1
Singapore sees tourism industry hitting record highs in 2017
China's tourism revenue posts double digit growth in 2017