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 '%Finland%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%Finland%')) a where irecord<>0 group by iRecord,ord order by ord asc,iRecord desc
Invest in China
Homepage |
首页 新闻动态 法律服务 数据服务 项目服务 投资环境 投资服务机构 经济开发区
Macro-Economy | Business Economy | Industrial Economy | Regional Economy
Home >News >
Search
Finland exports keep losing markets in January  
Finland to increase annual working days, reduce welfare  
HK-Finland trade pact in force  
China, Finland eye further trade, parliamentary cooperation  
Hunan Promotes Its Culture in Finland  
Hunan Extends Cooperation with Sweden, Finland, Netherlands  
EU invests 187 mln euros in first gas pipeline between Estonia, Finland  
Finland, Estonia reach consensus on liquefied natural gas infrastructure  
Wei Hai city with DELTA—SIGMA CO. (Finland) create a European Shipping Industry  
SIP to Cooperate with HK and Finland in Nanotech  
Finland PKC Group set up a R&D technical supporting Center in Suzhou Industrial  
Finland Enterprise Delegation Investigated Nansha ETDZ  
Finland Elecster (Tianjin) Aseptic Pouch Co., Ltd. Set up in TEDA  
China’s Trade and Investment Promotion Missions Gains Remarkable Achievements i  
China-Finland bilateral trade surges 29.5 pct in first four months of 2011  
Li Guangyun: Great Potential in China-Finland SME Cooperation  
Finland Wartsila Group Established a New Production Base of Diesel Engine in Wu  
Finland-based Mesto Won an Order of Paper-making Machine Worth Some EUR100mn  
18 results   Page 1 of 1  First Previous 1 Next Last
 Site Map | About Us | Services | Links | Statement

Ministry of Commerce of the People's Republic of China Department of Foreign Investment Administration

Operated by Investment Promotion Agency of MOFCOM

Tel:  (86-10) 64404554

Copyright by Invest in China

Fax: (86-10) 64515317

ICP Record No.: Beijing ICP 14022686-4 E-mail: service@fdi.gov.cn