select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_21 Where idCorp=1800000121 and iProject=21 and (field7 like '%LNG%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_21 Where idCorp=1800000121 and iProject=21 and (field2 like '%LNG%')) a where irecord<>104102 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
中国油气储运技术为LNG应用铺路
步钢铁、化工后尘 LNG产业现过剩
巴新第二个LNG项目计划在6年后开始产气并出口
APEC或为汽车业带来"钱景" LNG发动机或临机遇
阿联酋计划扩大LNG进口