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 '%gas%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%gas%')) a where irecord<>52470 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
China's natural gas output sees steady growth
China's natural gas output posts faster growth
Weekly storage of natural gas in U.S. up 2.2 pct: EIA
China's imports of natural gas up 29.3 pct in January
China's largest shale gas field output exceeds 6 bln cubic meters in 2018