dev/2020/2020-009(OK)/2020-009-wj-001.sql

use dcp;
UPDATE base_unit_info
SET industry_dict = '06',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_info
	WHERE
		unit_name IN (
			"Aeration Argentina S.A.",
			"Brametal",
			"W&L Engenharia EIRELI",
			"Fujian Yongfu Power Engineering Co.,Ltd.",
			"State Grid AC Engineering Construction Company",
			"State Grid DC Engineering Construction Company",
			"Hebei Electric Power Design & Research Institute",
			"Hunan Heyday Solar Technology Co., Ltd.",
			"Inner Mongolia Energy Engineering Investment (Group) Co.,Ltd.",
			"Shanghai Urban Planning and Design Research Institute",
			"PowerChina Hubei Electric Engineering Corporation Limited",
			"PowerChina Jilin Electric Engineering Corporation Limited",
			"Shanghai Electric Power Design Institute Co., Ltd.",
			"POWERCHINA SEPCO1 ELECTRIC POWER CONSTRUCTION CO.，LTD.",
			"China Energy Engineering Group Jiangsu Power Design Institute Co.,Ltd.",
			"China Energy Engineering Group Tianjin Electric Power Design Institute Co.,Ltd.",
			"ZhejiangChaoteng Urban-Rural Planning & Design Co., Ltd.",
			"Jiangsu Wenguang Zhufang New Energy Technology Co., Ltd.",
			"Orascom Construction PLC",
			"BK International Inc.",
			"PT.Sariputra Sejahtera Indonesia",
			"Danayarzar Construction Co.Ltd",
			"CMI Group",
			"Constructora Málaga Hnos S.A.",
			"Trans Africa Projects",
			"ABDELRAMAN GUBARAMUSTAEA, SUBAN-GIAD INDUS GROUP"
		)
		) t
	);




	UPDATE base_unit_view
SET industry_dict = '06',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_view
	WHERE
		unit_name IN (
			"Aeration Argentina S.A.",
			"Brametal",
			"W&L Engenharia EIRELI",
			"Fujian Yongfu Power Engineering Co.,Ltd.",
			"State Grid AC Engineering Construction Company",
			"State Grid DC Engineering Construction Company",
			"Hebei Electric Power Design & Research Institute",
			"Hunan Heyday Solar Technology Co., Ltd.",
			"Inner Mongolia Energy Engineering Investment (Group) Co.,Ltd.",
			"Shanghai Urban Planning and Design Research Institute",
			"PowerChina Hubei Electric Engineering Corporation Limited",
			"PowerChina Jilin Electric Engineering Corporation Limited",
			"Shanghai Electric Power Design Institute Co., Ltd.",
			"POWERCHINA SEPCO1 ELECTRIC POWER CONSTRUCTION CO.，LTD.",
			"China Energy Engineering Group Jiangsu Power Design Institute Co.,Ltd.",
			"China Energy Engineering Group Tianjin Electric Power Design Institute Co.,Ltd.",
			"ZhejiangChaoteng Urban-Rural Planning & Design Co., Ltd.",
			"Jiangsu Wenguang Zhufang New Energy Technology Co., Ltd.",
			"Orascom Construction PLC",
			"BK International Inc.",
			"PT.Sariputra Sejahtera Indonesia",
			"Danayarzar Construction Co.Ltd",
			"CMI Group",
			"Constructora Málaga Hnos S.A.",
			"Trans Africa Projects",
			"ABDELRAMAN GUBARAMUSTAEA, SUBAN-GIAD INDUS GROUP"
		)
		) t
	);

	UPDATE base_unit_info
SET industry_dict = '01',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_info
	WHERE
		unit_name IN (
			"Fundacion Bariloche",
			"Cámara Empresaria de Medio Ambiente",
			"Consejo Profesional de Ingenieria Mecanica Y Electricista (COPIME)",
			"Cámara de la Producción, la Industria y el Comercio Argentino China",
			"Fundacion Agreste Delegacion Espana",
			"ADC Forum",
			"Infrastructure Partnership Australia",
			"Concern for Environmental Development And Research (CEDAR)",
			"Friends of the Supergrid",
			"Global Green Energy Industry Council (GGEIC)",
			"World Green Design Organization （WGDO）",
			"WeForest",
			"China Europe Trade Center",
			"Communaute Electrique de Benin (CEB)",
			"Southern Africa Climate Change Coalition",
			"ABEEólica-the Brazilian WindEnergy Association",
			"CIGRÉ-Brasil (Brazilian National Electric Power Generation and Transmission Committee)",
			"Eastern Africa Power Pool (EAPP)",
			"Ethiopian Chamber of Commerce and Sectorial Associations",
			"Hydropower Europe",
			"Association Franco-Chinoise de l’Energie",
			"Chinese Association for Renewable Energy in Germany",
			"Infrawind Eurosia",
			"Europe-Asia-Africa Consulting institute",
			"Abibiman Foundation",
			"Afrochampions Initiative",
			"Sun Based Economic Association",
			"Arab Renewable Energy Comission",
			"Mongolian Renewable Energy Interconnection National Association",
			"Myanmar Renewable Energy Association",
			"Myanmar Belt&Road Development Association",
			"Independent Power Producers' Association Nepal",
			"JVE",
			"African Green Foundation International",
			"World Energy and Meteorology Council",
			"Edison Electric Institute",
			"IEEE",
			"Comité Chileno del CIGRÉ",
			"Coordinador Eléctrico Nacional",
			"H2 Chile",
			"Chinese Society for Electrical Engineering",
			"China Electricity Council",
			"China Federation of Industrial Economics",
			"Chinese Photovoltaic Industry Association",
			"China Enterprise Confederation",
			"Association of Power Utilities of Africa",
			"African Trade Center",
			"Cesko Cinska Obchodni Asociace",
			"Regional Center for Renewable Energy and Energy Efficiency",
			"UDYAMA",
			"India Smart Grid Forum",
			"Infrastructure Consortium for Africa",
			"Environmental Protection and Sustainable Development (ROSCIDET)",
			"International Green Technologies and Investment Center",
			"Association of renewable of Kazakhstan (AREK)",
			"Renewable Energy and Environment Organization, REEO",
			"Asociasión Nexicana de Energia Solar Fotovoltaica, A.C.",
			"Smart Grid Mexico AC.",
			"DESSI International",
			"Organisation pour la Mise en Valeur du Fleuve SENEGAL (OMVS)",
			"Asian Photovoltaic Industry Association (APVIA)",
			"The EKI Foundation",
			"International Hydropower Association",
			"Global Energy Network Institute"
		)
		) t
	);




	UPDATE base_unit_view
SET industry_dict = '01',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_view
	WHERE
		unit_name IN (
			"Fundacion Bariloche",
			"Cámara Empresaria de Medio Ambiente",
			"Consejo Profesional de Ingenieria Mecanica Y Electricista (COPIME)",
			"Cámara de la Producción, la Industria y el Comercio Argentino China",
			"Fundacion Agreste Delegacion Espana",
			"ADC Forum",
			"Infrastructure Partnership Australia",
			"Concern for Environmental Development And Research (CEDAR)",
			"Friends of the Supergrid",
			"Global Green Energy Industry Council (GGEIC)",
			"World Green Design Organization （WGDO）",
			"WeForest",
			"China Europe Trade Center",
			"Communaute Electrique de Benin (CEB)",
			"Southern Africa Climate Change Coalition",
			"ABEEólica-the Brazilian WindEnergy Association",
			"CIGRÉ-Brasil (Brazilian National Electric Power Generation and Transmission Committee)",
			"Eastern Africa Power Pool (EAPP)",
			"Ethiopian Chamber of Commerce and Sectorial Associations",
			"Hydropower Europe",
			"Association Franco-Chinoise de l’Energie",
			"Chinese Association for Renewable Energy in Germany",
			"Infrawind Eurosia",
			"Europe-Asia-Africa Consulting institute",
			"Abibiman Foundation",
			"Afrochampions Initiative",
			"Sun Based Economic Association",
			"Arab Renewable Energy Comission",
			"Mongolian Renewable Energy Interconnection National Association",
			"Myanmar Renewable Energy Association",
			"Myanmar Belt&Road Development Association",
			"Independent Power Producers' Association Nepal",
			"JVE",
			"African Green Foundation International",
			"World Energy and Meteorology Council",
			"Edison Electric Institute",
			"IEEE",
			"Comité Chileno del CIGRÉ",
			"Coordinador Eléctrico Nacional",
			"H2 Chile",
			"Chinese Society for Electrical Engineering",
			"China Electricity Council",
			"China Federation of Industrial Economics",
			"Chinese Photovoltaic Industry Association",
			"China Enterprise Confederation",
			"Association of Power Utilities of Africa",
			"African Trade Center",
			"Cesko Cinska Obchodni Asociace",
			"Regional Center for Renewable Energy and Energy Efficiency",
			"UDYAMA",
			"India Smart Grid Forum",
			"Infrastructure Consortium for Africa",
			"Environmental Protection and Sustainable Development (ROSCIDET)",
			"International Green Technologies and Investment Center",
			"Association of renewable of Kazakhstan (AREK)",
			"Renewable Energy and Environment Organization, REEO",
			"Asociasión Nexicana de Energia Solar Fotovoltaica, A.C.",
			"Smart Grid Mexico AC.",
			"DESSI International",
			"Organisation pour la Mise en Valeur du Fleuve SENEGAL (OMVS)",
			"Asian Photovoltaic Industry Association (APVIA)",
			"The EKI Foundation",
			"International Hydropower Association",
			"Global Energy Network Institute"
		)
		) t
	);

	UPDATE base_unit_info
SET industry_dict = '04',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
			base_entity_id
		FROM
			base_unit_info
		WHERE
			unit_name IN (
				"CAMMESA",
				"Ausnet Services",
				"Enertolima",
				"CPFL Energia",
				"ISA CTEEP  – Companhia de Transmissão de Energia Elétrica Paulista",
				"Ingema S.A.",
				"Homelex Ltd.",
				"Sungrow Chile SPA",
				"Anhui Province Energy Group Company Limited",
				"North United Power",
				"Beijing Junhui New Energy Technology Co., Ltd.",
				"Beijing Energy Holding Co., Ltd.",
				"Beijing QZTL Sea Wave Energy Technology Research Institute Co., Ltd.",
				"Chengdu Deyuhang Low-Carbon Environmental Protection Technology Co., Ltd.",
				"Chifeng Fulong Thermal Power Co Ltd",
				"Guangdong Power Grid Co.,Ltd.",
				"Guangdong Yudean Group Co.,Ltd.",
				"Guangxi Power Grid Co.,Ltd.",
				"Guizhou Power Grid Co.,Ltd.",
				"State Grid Customer Service Center",
				"Operation Branch of State Grid Corporation of China",
				"State Grid Anhui Electric Power Company",
				"State Grid Beijing Electric Power Company",
				"State Grid Electric Vehicle Co.,Ltd.",
				"State Grid Electronic Commerce Co.,Ltd.",
				"State Grid Fujian Electric Power Co., Ltd.",
				"State Grid Gansu Electric Power Company",
				"State Grid International Development Co.,Ltd.",
				"State Grid Hebei Electric Power Company",
				"State Grid Henan Electric Power Company",
				"State Grid Heilongjiang Electric Power Company Limited",
				"State Grid Hubei Electric Power Company",
				"State Grid Hunan Electric Power Company",
				"State Grid Jilin Electric Power Company",
				"State Grid Jibei Electric Power Company Limited",
				"State Grid Jiangsu Electric Power Company",
				"State Grid Jiangxi Electric Power Company",
				"State Grid Energy Conservation Service Co.,Ltd.",
				"State Grid Liaoning Electric Power Supply Co., Ltd.",
				"East Inner Mongolia Electric Power Company",
				"State Grid Ningxia Electric Power Company",
				"State Grid Qinghai Electric Power Company",
				"State Grid Shandong Electric Power Company",
				"State Grid Shanxi Electric Power Company",
				"State Grid Shaanxi Electric Power Company",
				"State Grid Shanghai Municipal Electric Power Company",
				"State Grid Sichuan Electric Power Company",
				"State Grid Tianjin Electric Power Company",
				"State Grid General Aviation Co.,Ltd.",
				"State Grid Materials Co.,Ltd.",
				"State Grid Tibet Electric Power Company",
				"State Grid Xinjiang Electric Power Company",
				"State Grid Yingda International Holdings Corporation, Ltd.",
				"State Grid Zhejiang Electric Power Company",
				"State Grid Zhongxing Co.,Ltd.",
				"State Grid Chongqing Electric Power Company",
				"Hainan Power Grid Co.,Ltd.",
				"Jointo Energy Investment Co.,LTD.Hebei",
				"Huadian Hubei Power Generation Co.,Ltd.",
				"Hangzhou Chaoteng Energy Technology Co., Ltd.",
				"United Energy (Beijing) Ltd.",
				"Luneng Group Co.,Ltd.",
				"Inner Mongolia Power (Group) Co.,Ltd.",
				"Shaanxi Energy Group Co.,Ltd.",
				"Shanxi Yanchang Petroleum Mining Industry Co., Ltd.",
				"Shanghai Electric Power Co., Ltd.",
				"Yalong River Hydropower Development Co.,Ltd.",
				"Yunnan Power Grid Co.,Ltd.",
				"China Merchants New Energy Group Limited",
				"Zhejiang Energy Group Co.,Ltd.",
				"Zhenfa New Energy Group Co., Ltd.",
				"Sinoma Energy Conservation Ltd",
				"Zhongtan Green Forest Treasure Low-Carbon Technology Co., Ltd.",
				"HMV Ingenieros Ltda",
				"Vega Energy S.A.S",
				"EuroAsia Interconnector Limited",
				"Salco Electric Company，SRL",
				"CENACE",
				"Enara Capital Limited",
				"HK Electric",
				"ADANI Group ",
				"Anglo Euro Developers (s) Private Limited",
				"NE Nomisma Energia",
				"SB Energy corp.",
				"Sumitomo Electric Industries,Ltd",
				"CIOC Energy SARL",
				"Gading Kencana SDN BHD",
				"Golden Green Energy Co.Ltd",
				"Upstream Ayeyawady Confluence Basin Hydropower Co., Ltd (ACHC)",
				"Horizon Energy Group Ltd.",
				"Proton Energy Limited",
				"Eurosibenergo JSC（EN+ Group）",
				"JSC （Eastern energy company）",
				"AL Gihaz Holding",
				"African Development Solution Group",
				"Terrenus Energy PteLTD. ",
				"New Gen Gas Pet.Ltd.",
				"InnoEnergy Sweden",
				"XDY Power Tazania Limited",
				"B.GRIMM POWER PUBLIC COMPANY LIMITED (B.GRIMM)",
				"SunPower by Stellar Solar"
			)
		) t
	);


	UPDATE base_unit_view
SET industry_dict = '04',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
			base_entity_id
		FROM
			base_unit_view
		WHERE
			unit_name IN (
				"CAMMESA",
				"Ausnet Services",
				"Enertolima",
				"CPFL Energia",
				"ISA CTEEP  – Companhia de Transmissão de Energia Elétrica Paulista",
				"Ingema S.A.",
				"Homelex Ltd.",
				"Sungrow Chile SPA",
				"Anhui Province Energy Group Company Limited",
				"North United Power",
				"Beijing Junhui New Energy Technology Co., Ltd.",
				"Beijing Energy Holding Co., Ltd.",
				"Beijing QZTL Sea Wave Energy Technology Research Institute Co., Ltd.",
				"Chengdu Deyuhang Low-Carbon Environmental Protection Technology Co., Ltd.",
				"Chifeng Fulong Thermal Power Co Ltd",
				"Guangdong Power Grid Co.,Ltd.",
				"Guangdong Yudean Group Co.,Ltd.",
				"Guangxi Power Grid Co.,Ltd.",
				"Guizhou Power Grid Co.,Ltd.",
				"State Grid Customer Service Center",
				"Operation Branch of State Grid Corporation of China",
				"State Grid Anhui Electric Power Company",
				"State Grid Beijing Electric Power Company",
				"State Grid Electric Vehicle Co.,Ltd.",
				"State Grid Electronic Commerce Co.,Ltd.",
				"State Grid Fujian Electric Power Co., Ltd.",
				"State Grid Gansu Electric Power Company",
				"State Grid International Development Co.,Ltd.",
				"State Grid Hebei Electric Power Company",
				"State Grid Henan Electric Power Company",
				"State Grid Heilongjiang Electric Power Company Limited",
				"State Grid Hubei Electric Power Company",
				"State Grid Hunan Electric Power Company",
				"State Grid Jilin Electric Power Company",
				"State Grid Jibei Electric Power Company Limited",
				"State Grid Jiangsu Electric Power Company",
				"State Grid Jiangxi Electric Power Company",
				"State Grid Energy Conservation Service Co.,Ltd.",
				"State Grid Liaoning Electric Power Supply Co., Ltd.",
				"East Inner Mongolia Electric Power Company",
				"State Grid Ningxia Electric Power Company",
				"State Grid Qinghai Electric Power Company",
				"State Grid Shandong Electric Power Company",
				"State Grid Shanxi Electric Power Company",
				"State Grid Shaanxi Electric Power Company",
				"State Grid Shanghai Municipal Electric Power Company",
				"State Grid Sichuan Electric Power Company",
				"State Grid Tianjin Electric Power Company",
				"State Grid General Aviation Co.,Ltd.",
				"State Grid Materials Co.,Ltd.",
				"State Grid Tibet Electric Power Company",
				"State Grid Xinjiang Electric Power Company",
				"State Grid Yingda International Holdings Corporation, Ltd.",
				"State Grid Zhejiang Electric Power Company",
				"State Grid Zhongxing Co.,Ltd.",
				"State Grid Chongqing Electric Power Company",
				"Hainan Power Grid Co.,Ltd.",
				"Jointo Energy Investment Co.,LTD.Hebei",
				"Huadian Hubei Power Generation Co.,Ltd.",
				"Hangzhou Chaoteng Energy Technology Co., Ltd.",
				"United Energy (Beijing) Ltd.",
				"Luneng Group Co.,Ltd.",
				"Inner Mongolia Power (Group) Co.,Ltd.",
				"Shaanxi Energy Group Co.,Ltd.",
				"Shanxi Yanchang Petroleum Mining Industry Co., Ltd.",
				"Shanghai Electric Power Co., Ltd.",
				"Yalong River Hydropower Development Co.,Ltd.",
				"Yunnan Power Grid Co.,Ltd.",
				"China Merchants New Energy Group Limited",
				"Zhejiang Energy Group Co.,Ltd.",
				"Zhenfa New Energy Group Co., Ltd.",
				"Sinoma Energy Conservation Ltd",
				"Zhongtan Green Forest Treasure Low-Carbon Technology Co., Ltd.",
				"HMV Ingenieros Ltda",
				"Vega Energy S.A.S",
				"EuroAsia Interconnector Limited",
				"Salco Electric Company，SRL",
				"CENACE",
				"Enara Capital Limited",
				"HK Electric",
				"ADANI Group ",
				"Anglo Euro Developers (s) Private Limited",
				"NE Nomisma Energia",
				"SB Energy corp.",
				"Sumitomo Electric Industries,Ltd",
				"CIOC Energy SARL",
				"Gading Kencana SDN BHD",
				"Golden Green Energy Co.Ltd",
				"Upstream Ayeyawady Confluence Basin Hydropower Co., Ltd (ACHC)",
				"Horizon Energy Group Ltd.",
				"Proton Energy Limited",
				"Eurosibenergo JSC（EN+ Group）",
				"JSC （Eastern energy company）",
				"AL Gihaz Holding",
				"African Development Solution Group",
				"Terrenus Energy PteLTD. ",
				"New Gen Gas Pet.Ltd.",
				"InnoEnergy Sweden",
				"XDY Power Tazania Limited",
				"B.GRIMM POWER PUBLIC COMPANY LIMITED (B.GRIMM)",
				"SunPower by Stellar Solar"
			)
		) t
	);

	UPDATE base_unit_info
SET industry_dict = '11',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT base_entity_id
	FROM base_unit_info WHERE unit_name IN ( "Laopan Group", "Sinotrans Limited", "China Merchants Group Djibouti Industrial Park Co., Ltd", "Everfast Cargo Services Pte Ltd", "ISTMOIL" )
		) t
	);


	UPDATE base_unit_view
SET industry_dict = '11',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT base_entity_id
	FROM base_unit_view WHERE unit_name IN ( "Laopan Group", "Sinotrans Limited", "China Merchants Group Djibouti Industrial Park Co., Ltd", "Everfast Cargo Services Pte Ltd", "ISTMOIL" )
		) t
	);

	UPDATE base_unit_info
SET industry_dict = '09',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_info
	WHERE
		unit_name IN (
			"Beijing Di Di Infinite Technology Development Co.,Ltd.",
			"CIRI（Beijing） Information Technology Co., Ltd.",
			"Neusoft Group Co.,LTD",
			"EleFirst Science & Tech Co.,Ltd.",
			"State Grid Information & Telecommunication Group Co.,Ltd.",
			"Hengtong Group",
			"Integrated Electronic Systems Lab Co.,Ltd.",
			"Lenovo Group",
			"Qingdao Gaoke Communication Co.,Ltd.",
			"Shanghai Leadsoft Co., Ltd.",
			"Shanghai Lin-e tech.&info. Limited Company",
			"Shanghai Sihua Technologies Co., Ltd.",
			"Shanghai Yo-I Information Technology Ltd.",
			"Shenzhen Tencent Computer Systems Co.,Ltd.",
			"Zhong Neng Ding Li",
			"Wei Sheng Information Technology Co.,LTD",
			"Tibet Hongjing  Information Technology Co., Ltd.",
			"YGSOFT Inc.",
			"China Mobile Communications Group Co., Ltd. Government and Enterprise Service Company",
			"ZTE Corporation",
			"Shanghai Bayantu Information Technology Co., Ltd.",
			"Shanghai Cosun Network Technology Co., Ltd.",
			"ADARIS",
			"Big Data Engineering and IT Solutions",
			"Digit All 4.0, S.A",
			"Vision Technologies Company",
			"CCS Comservice (Thailand) Limited"
		)
		) t
	);





	UPDATE base_unit_view
SET industry_dict = '09',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_view
	WHERE
		unit_name IN (
			"Beijing Di Di Infinite Technology Development Co.,Ltd.",
			"CIRI（Beijing） Information Technology Co., Ltd.",
			"Neusoft Group Co.,LTD",
			"EleFirst Science & Tech Co.,Ltd.",
			"State Grid Information & Telecommunication Group Co.,Ltd.",
			"Hengtong Group",
			"Integrated Electronic Systems Lab Co.,Ltd.",
			"Lenovo Group",
			"Qingdao Gaoke Communication Co.,Ltd.",
			"Shanghai Leadsoft Co., Ltd.",
			"Shanghai Lin-e tech.&info. Limited Company",
			"Shanghai Sihua Technologies Co., Ltd.",
			"Shanghai Yo-I Information Technology Ltd.",
			"Shenzhen Tencent Computer Systems Co.,Ltd.",
			"Zhong Neng Ding Li",
			"Wei Sheng Information Technology Co.,LTD",
			"Tibet Hongjing  Information Technology Co., Ltd.",
			"YGSOFT Inc.",
			"China Mobile Communications Group Co., Ltd. Government and Enterprise Service Company",
			"ZTE Corporation",
			"Shanghai Bayantu Information Technology Co., Ltd.",
			"Shanghai Cosun Network Technology Co., Ltd.",
			"ADARIS",
			"Big Data Engineering and IT Solutions",
			"Digit All 4.0, S.A",
			"Vision Technologies Company",
			"CCS Comservice (Thailand) Limited"
		)
		) t
	);

	UPDATE base_unit_info
SET industry_dict = '05',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
	SELECT
		base_entity_id
	FROM
		base_unit_info
	WHERE
		unit_name IN (
			"Project Production Solaire SASL",
			"TMR Sales and Services Ltd.",
			"General Cable Brazil Ltda",
			"SAE Towers Brasil Torres De Transmissaō LTDA",
			"Energivo",
			"TecMundo",
			"I-see R&D International Co., Ltd.",
			"Anhui Meion Electric Co., Ltd.",
			"Beijing Hi-tech Xin-Neng New Energy Automotive Technology  Co., Ltd.",
			"Coherence Prudence Development Co.",
			"Beijing Shendian Technology Co., Ltd.",
			"Beijing Wind Source Automatic Control Equipment Co., Ltd.",
			"Synergy Blockchain Technology Co., Ltd.",
			"Beijing UC Energy Technology Co., Ltd.",
			"Yangtze Optical Fibre and Cable Joint Stock Co.,Ltd.",
			"CYG SUNRI Co., Ltd.",
			"Changshu Switchgear MFG Co.,Ltd.",
			"Ubiquitous Power Internet of Things Technology Co., Ltd.",
			"Fujian Nanping Sun Cable Co.,Ltd.",
			"Guangzhou Baiyun Electric Equipment Co., Ltd",
			"Guangzhou Hengku Electromechanical Equipment Engineering Co., Ltd.",
			"State Grid Information and Telecommunication Branch",
			"Guo Neng Guo Xin New Energy Technology Co. Ltd",
			"Hangzhou Cable Co.,Ltd.",
			"Hefei Coffey Electric Technology Co., Ltd.",
			"Henan Leshan Cable Co., Ltd.",
			"Henan Senyuan Electric Co.,Ltd.",
			"Hunan Geosun High-Technology Co., Ltd.",
			"Holley Technology Ltd.",
			"Huayi Electric Co.,Ltd.",
			"Jilin Shenfei Environmental Protection Energy Co., Ltd.",
			"Jilin Dingxin Automatic Control Engineering Co., Ltd.",
			"Jilin Grand Analysis Technology Co., Ltd.",
			"Jinan FLITON Electrical Equipment Co., Ltd.",
			"Jiangxi Guangjing Electric Equipment Co., Ltd.",
			"Jiangyin City Trasen Automation Meter Co., Ltd.",
			"Lifan Group",
			"DJ Teamwork（Liaoning） Electric Power Engineering Co., Ltd.",
			"China Molybdenum Co. Ltd",
			"Wenergy Co., Ltd.",
			"Nanjing Nengrui Automation Equipment Corporation",
			"Nanjing Chiebot Technology Co., Ltd.",
			"Nanjing Xinlian Electronics Co.,Ltd.",
			"Inner Mongolia Sinceresky Co. Ltd",
			"Ningbo Sanxing Medical & Electric Co.,Ltd.",
			"Presence Energy Technologies (Beijing) Co., Ltd.",
			"Chery automobile co.,LTD",
			"Qingdao Topscomm Communication Co.,Ltd.",
			"Qingdao TGOOD Electric Co.,Ltd.",
			"Shandong Nate Electrical Equipment Co., Ltd.",
			"Shandong Nanyang Electric Equipment Co. Ltd.",
			"Shandong Strictly Electrical Technology Co., Ltd.",
			"Shaanxi Taijie Bio-technology Co., Ltd.",
			"Shaanxi Nonerrous Metals Holding Group Co.,Ltd.",
			"Shanghai Proinvent Information Technology Co., Ltd.",
			"Shanghai Guanghuayongsheng Fire Intelligent System Co.,Ltd.",
			"Shanghai Rox Electric Co.,Ltd.",
			"Fujikura Shanghai Cable Co.,Ltd.",
			"Shanghai Tianling Switchgear Co.,Ltd.",
			"Shanghai First Electrical Group Co., Ltd.",
			"Shanghai Zhezhong Electrical Co.,Ltd.",
			"Shenzhen DXDA Tech-nology Co., Ltd.",
			"Shenzhen Hopewind Electric Co.,Ltd.",
			"Shenzhen Clou Eletronics Co.,Ltd.",
			"Shenzhen Sino Hoau Co., Ltd.",
			"Shenyang Huayan Electric Technology Co., Ltd.",
			"Shenyang Jia Yue Electric Power Technology Co.,Ltd.",
			"Shenyang Motic Energy Technology Co., Ltd.",
			"Shenyang Ruijing Technology Development Co., Ltd.",
			"Shougang Group",
			"Tellhow Sci-Tech Co.,Ltd.",
			"Taikai Group Co.,Ltd.",
			"Tianjin Cadbury's Pure Electric Co.,LTD",
			"Wanxiang Group Co.",
			"Xiamen SMTS Intelligent Electric Co., Ltd.",
			"ENN Group Co.,Ltd.",
			"ENN Digital Energy Technology CO.LTD",
			"Asia Silicon Co., Ltd.",
			"Yixing Dongfeng Electric Technology Co.,Ltd.",
			"Yihe Electric Group Co.,Ltd.",
			"Zhejiang Hengye Electronics Co.,Ltd.",
			"China FAW Group Corporation",
			"Zhongyan New Materials Co., Ltd.",
			"Zhengzhou Diamond Precision Manufacturing Co., Ltd.",
			"Hangzhou Telehems Electronics Technology Co., Ltd.",
			"Hubei Wangan Science and Technology Co., Ltd.",
			"Huangshan Teras Intelligent Technology Co., Ltd.",
			"Jiangsu Borui Electric Co., Ltd",
			"CSG Smart Electric Technology Co., Ltd.",
			"Nanjing Hezhi Electric Technology Co., Ltd.",
			"Nanjing Rongkong Electric Technology Co., Ltd",
			"Rongzhong Electrical Co., Ltd.",
			"AAC Microtech（Changzhou） Co., Ltd.",
			"GV12 Proyectos SAS",
			"UKA",
			"Elsewedy Electric",
			"Finland UTU Company",
			"Volkswagen Aktiengesellschaft",
			"Gunung Rinjani",
			"PT. Wahana Duta Cemerlang",
			"NGK Insulators，Ltd.",
			"Kenya Pipeline Co., Ltd",
			"EasternWorld (M) Sdn.Bhd",
			"Forever Technology Development CO., Ltd",
			"Durapower Technology(Singapore)PTE LTD",
			"Tecnosolar S.A. Del Salvador",
			"Rungjaroen Environnemental Services",
			"Hengkee Enterprise (Thailand) Co. Ltd",
			"Techen Technology （Thailand）Co.Ltd",
			"NP Electrical System Co., Ltd.",
			"NESCO Lighting & Pole Co., Ltd."

		)
		) t
	);



	UPDATE base_unit_view
SET industry_dict = '05',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
	SELECT
		base_entity_id
	FROM
		base_unit_view
	WHERE
		unit_name IN (
			"Project Production Solaire SASL",
			"TMR Sales and Services Ltd.",
			"General Cable Brazil Ltda",
			"SAE Towers Brasil Torres De Transmissaō LTDA",
			"Energivo",
			"TecMundo",
			"I-see R&D International Co., Ltd.",
			"Anhui Meion Electric Co., Ltd.",
			"Beijing Hi-tech Xin-Neng New Energy Automotive Technology  Co., Ltd.",
			"Coherence Prudence Development Co.",
			"Beijing Shendian Technology Co., Ltd.",
			"Beijing Wind Source Automatic Control Equipment Co., Ltd.",
			"Synergy Blockchain Technology Co., Ltd.",
			"Beijing UC Energy Technology Co., Ltd.",
			"Yangtze Optical Fibre and Cable Joint Stock Co.,Ltd.",
			"CYG SUNRI Co., Ltd.",
			"Changshu Switchgear MFG Co.,Ltd.",
			"Ubiquitous Power Internet of Things Technology Co., Ltd.",
			"Fujian Nanping Sun Cable Co.,Ltd.",
			"Guangzhou Baiyun Electric Equipment Co., Ltd",
			"Guangzhou Hengku Electromechanical Equipment Engineering Co., Ltd.",
			"State Grid Information and Telecommunication Branch",
			"Guo Neng Guo Xin New Energy Technology Co. Ltd",
			"Hangzhou Cable Co.,Ltd.",
			"Hefei Coffey Electric Technology Co., Ltd.",
			"Henan Leshan Cable Co., Ltd.",
			"Henan Senyuan Electric Co.,Ltd.",
			"Hunan Geosun High-Technology Co., Ltd.",
			"Holley Technology Ltd.",
			"Huayi Electric Co.,Ltd.",
			"Jilin Shenfei Environmental Protection Energy Co., Ltd.",
			"Jilin Dingxin Automatic Control Engineering Co., Ltd.",
			"Jilin Grand Analysis Technology Co., Ltd.",
			"Jinan FLITON Electrical Equipment Co., Ltd.",
			"Jiangxi Guangjing Electric Equipment Co., Ltd.",
			"Jiangyin City Trasen Automation Meter Co., Ltd.",
			"Lifan Group",
			"DJ Teamwork（Liaoning） Electric Power Engineering Co., Ltd.",
			"China Molybdenum Co. Ltd",
			"Wenergy Co., Ltd.",
			"Nanjing Nengrui Automation Equipment Corporation",
			"Nanjing Chiebot Technology Co., Ltd.",
			"Nanjing Xinlian Electronics Co.,Ltd.",
			"Inner Mongolia Sinceresky Co. Ltd",
			"Ningbo Sanxing Medical & Electric Co.,Ltd.",
			"Presence Energy Technologies (Beijing) Co., Ltd.",
			"Chery automobile co.,LTD",
			"Qingdao Topscomm Communication Co.,Ltd.",
			"Qingdao TGOOD Electric Co.,Ltd.",
			"Shandong Nate Electrical Equipment Co., Ltd.",
			"Shandong Nanyang Electric Equipment Co. Ltd.",
			"Shandong Strictly Electrical Technology Co., Ltd.",
			"Shaanxi Taijie Bio-technology Co., Ltd.",
			"Shaanxi Nonerrous Metals Holding Group Co.,Ltd.",
			"Shanghai Proinvent Information Technology Co., Ltd.",
			"Shanghai Guanghuayongsheng Fire Intelligent System Co.,Ltd.",
			"Shanghai Rox Electric Co.,Ltd.",
			"Fujikura Shanghai Cable Co.,Ltd.",
			"Shanghai Tianling Switchgear Co.,Ltd.",
			"Shanghai First Electrical Group Co., Ltd.",
			"Shanghai Zhezhong Electrical Co.,Ltd.",
			"Shenzhen DXDA Tech-nology Co., Ltd.",
			"Shenzhen Hopewind Electric Co.,Ltd.",
			"Shenzhen Clou Eletronics Co.,Ltd.",
			"Shenzhen Sino Hoau Co., Ltd.",
			"Shenyang Huayan Electric Technology Co., Ltd.",
			"Shenyang Jia Yue Electric Power Technology Co.,Ltd.",
			"Shenyang Motic Energy Technology Co., Ltd.",
			"Shenyang Ruijing Technology Development Co., Ltd.",
			"Shougang Group",
			"Tellhow Sci-Tech Co.,Ltd.",
			"Taikai Group Co.,Ltd.",
			"Tianjin Cadbury's Pure Electric Co.,LTD",
			"Wanxiang Group Co.",
			"Xiamen SMTS Intelligent Electric Co., Ltd.",
			"ENN Group Co.,Ltd.",
			"ENN Digital Energy Technology CO.LTD",
			"Asia Silicon Co., Ltd.",
			"Yixing Dongfeng Electric Technology Co.,Ltd.",
			"Yihe Electric Group Co.,Ltd.",
			"Zhejiang Hengye Electronics Co.,Ltd.",
			"China FAW Group Corporation",
			"Zhongyan New Materials Co., Ltd.",
			"Zhengzhou Diamond Precision Manufacturing Co., Ltd.",
			"Hangzhou Telehems Electronics Technology Co., Ltd.",
			"Hubei Wangan Science and Technology Co., Ltd.",
			"Huangshan Teras Intelligent Technology Co., Ltd.",
			"Jiangsu Borui Electric Co., Ltd",
			"CSG Smart Electric Technology Co., Ltd.",
			"Nanjing Hezhi Electric Technology Co., Ltd.",
			"Nanjing Rongkong Electric Technology Co., Ltd",
			"Rongzhong Electrical Co., Ltd.",
			"AAC Microtech（Changzhou） Co., Ltd.",
			"GV12 Proyectos SAS",
			"UKA",
			"Elsewedy Electric",
			"Finland UTU Company",
			"Volkswagen Aktiengesellschaft",
			"Gunung Rinjani",
			"PT. Wahana Duta Cemerlang",
			"NGK Insulators，Ltd.",
			"Kenya Pipeline Co., Ltd",
			"EasternWorld (M) Sdn.Bhd",
			"Forever Technology Development CO., Ltd",
			"Durapower Technology(Singapore)PTE LTD",
			"Tecnosolar S.A. Del Salvador",
			"Rungjaroen Environnemental Services",
			"Hengkee Enterprise (Thailand) Co. Ltd",
			"Techen Technology （Thailand）Co.Ltd",
			"NP Electrical System Co., Ltd.",
			"NESCO Lighting & Pole Co., Ltd."

		)
		) t
	);
	UPDATE base_unit_info
SET industry_dict = '02',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_info
	WHERE
		unit_name IN (
			"Centre de Developpment des Energies Renouvelables",
			"International Institute for Applied Systems Analysis",
			"Power And Energy Research Centre-Bangladesh",
			"Center for Participatory Research and Development-CPRD",
			"European Institute for Asian Studies",
			"Institute of Economic Research（IIE)-UMSA",
			"PSR - Energy Consulting and Analytics (Power System Rearch)",
			"CEPEL-Electrical Energy Research Center",
			"Institute of Technology for Development - Institutes Lactec",
			"Empresa de Pesquisa Energética",
			"FDTE - Fundação de Desenvolvimento Tecnológico da Engenharia",
			"FGV Energia-Centre for energy studies",
			"GESEL - Grupo de Estudos do Setor Elétrico",
			"Royal Academy of Cambodia",
			"Waterloo Institute for Sustainable Energy-WISE",
			"Global Environmental Policy Research Center of Beijing Normal University",
			"Guangdong Research Institute of Rare Metal",
			"Advanced Training Center of State Grid Corporation of China",
			"Management Institute of State Grid Corporation of China",
			"China National Renewable Energy Centre",
			"State Power Economic Research Institute",
			"State Grid Energy Research Institute",
			"Global Energy Interconnection Research Institute",
			"Shanxi Jingyuan Low-Carbon Research Centre",
			"Shanghai New Energy Center for Technology Transfer and Industry Promotion",
			"China Champions for Climate Action",
			"Tianjin Research Institute of Electric Science Co.,Ltd.",
			"TianJin Recyclable Resources Institute",
			"Yangtze Delta Region Institute of Tsinghua University, Zhejiang",
			"Harbin Power System Engineering & Research Institute Co., Ltd. of CNEEC",
			"China Electric Power Research Institute",
			"The Dalian Institute of Chemical Physics, Chinese Academy of Sciences",
			"Institute of Metal Research, Chinese Academy of Sciences",
			"Shenyang Institute of Automation, Chinese Academy of Sciences",
			"Changchun Institute of Optics, Fine Mechanics and Physics, Chinese Academy of Sciences",
			"China Automotive Technology and Research Center Co.,Ltd.",
			"Institute for Urban and Environmental Studies Chinese Academy of Social Sciences",
			"Tropical Agriculture Research and Higher Education Center(CATIE)",
			"Center for Energy Informatics, University of Southern Denmark",
			"Pentacronos Corporation",
			"Kamal Shan International Vocational Training Chinese Center",
			"Ethiopian Development Research Institute (EDRI)",
			"Horn Economic and Social Policy Institute",
			"Addis Ababa Institute of Technology, Addis Ababa University",
			"SuperGrid Institute",
			"Integrated Research and Action for Development (IRADE)",
			"Terre Policy Center",
			"Indonesian Research & Development International (IRDI)",
			"UCD energy institute",
			"Green Technology Center",
			"Mongolia Renewable Energy Knowledge Centre",
			"Mongolian Energy Economics Institute",
			"Institute for International Relations -Nepal",
			"Research and Development Centre,Nepal(RDC Nepal)",
			"African Climate Change Research Centre （ACCREC)",
			"The National Power Training Institute of Nigeria",
			"Centre for Climate Change and Environmental Studies",
			"Sustainable Development Policy Institute (SDPI)",
			"Center for Research Innovation and Policy",
			"Centro investigação em energia REN",
			"The  Energy Research Institute of the Rusian Academy of Sciences(ERI RAS)",
			"Melentiev Energy Systems Institute of Siberian Branch of the Russian Academy of Science",
			"JSC High Voltage Direct Current Power Transmission Research Institute",
			"Russian Institute of Humanities",
			"Survey and Design Institute for Energy Systems and Electrical Grid",
			"Nanyang Technological University Energy Research Institute @NTU",
			"Energy Studies Institute , National University of Singapore",
			"SANEDI",
			"Greater Mekong Subregion Academic Research Network",
			"SACREEE",
			"Mediterranean Renewable Energy Center (MEDREC)",
			"Coal Energy Technology Institute of the NAS of Ukraine",
			"IEA Clean Coal Centre",
			"International Solar Energy Institute (ISEI)"
		)
		) t
	);




	UPDATE base_unit_view
SET industry_dict = '02',
showable = '2'
WHERE
	base_entity_id IN (
	SELECT
		t.base_entity_id
	FROM
		(
		SELECT
		base_entity_id
	FROM
		base_unit_view
	WHERE
		unit_name IN (
			"Centre de Developpment des Energies Renouvelables",
			"International Institute for Applied Systems Analysis",
			"Power And Energy Research Centre-Bangladesh",
			"Center for Participatory Research and Development-CPRD",
			"European Institute for Asian Studies",
			"Institute of Economic Research（IIE)-UMSA",
			"PSR - Energy Consulting and Analytics (Power System Rearch)",
			"CEPEL-Electrical Energy Research Center",
			"Institute of Technology for Development - Institutes Lactec",
			"Empresa de Pesquisa Energética",
			"FDTE - Fundação de Desenvolvimento Tecnológico da Engenharia",
			"FGV Energia-Centre for energy studies",
			"GESEL - Grupo de Estudos do Setor Elétrico",
			"Royal Academy of Cambodia",
			"Waterloo Institute for Sustainable Energy-WISE",
			"Global Environmental Policy Research Center of Beijing Normal University",
			"Guangdong Research Institute of Rare Metal",
			"Advanced Training Center of State Grid Corporation of China",
			"Management Institute of State Grid Corporation of China",
			"China National Renewable Energy Centre",
			"State Power Economic Research Institute",
			"State Grid Energy Research Institute",
			"Global Energy Interconnection Research Institute",
			"Shanxi Jingyuan Low-Carbon Research Centre",
			"Shanghai New Energy Center for Technology Transfer and Industry Promotion",
			"China Champions for Climate Action",
			"Tianjin Research Institute of Electric Science Co.,Ltd.",
			"TianJin Recyclable Resources Institute",
			"Yangtze Delta Region Institute of Tsinghua University, Zhejiang",
			"Harbin Power System Engineering & Research Institute Co., Ltd. of CNEEC",
			"China Electric Power Research Institute",
			"The Dalian Institute of Chemical Physics, Chinese Academy of Sciences",
			"Institute of Metal Research, Chinese Academy of Sciences",
			"Shenyang Institute of Automation, Chinese Academy of Sciences",
			"Changchun Institute of Optics, Fine Mechanics and Physics, Chinese Academy of Sciences",
			"China Automotive Technology and Research Center Co.,Ltd.",
			"Institute for Urban and Environmental Studies Chinese Academy of Social Sciences",
			"Tropical Agriculture Research and Higher Education Center(CATIE)",
			"Center for Energy Informatics, University of Southern Denmark",
			"Pentacronos Corporation",
			"Kamal Shan International Vocational Training Chinese Center",
			"Ethiopian Development Research Institute (EDRI)",
			"Horn Economic and Social Policy Institute",
			"Addis Ababa Institute of Technology, Addis Ababa University",
			"SuperGrid Institute",
			"Integrated Research and Action for Development (IRADE)",
			"Terre Policy Center",
			"Indonesian Research & Development International (IRDI)",
			"UCD energy institute",
			"Green Technology Center",
			"Mongolia Renewable Energy Knowledge Centre",
			"Mongolian Energy Economics Institute",
			"Institute for International Relations -Nepal",
			"Research and Development Centre,Nepal(RDC Nepal)",
			"African Climate Change Research Centre （ACCREC)",
			"The National Power Training Institute of Nigeria",
			"Centre for Climate Change and Environmental Studies",
			"Sustainable Development Policy Institute (SDPI)",
			"Center for Research Innovation and Policy",
			"Centro investigação em energia REN",
			"The  Energy Research Institute of the Rusian Academy of Sciences(ERI RAS)",
			"Melentiev Energy Systems Institute of Siberian Branch of the Russian Academy of Science",
			"JSC High Voltage Direct Current Power Transmission Research Institute",
			"Russian Institute of Humanities",
			"Survey and Design Institute for Energy Systems and Electrical Grid",
			"Nanyang Technological University Energy Research Institute @NTU",
			"Energy Studies Institute , National University of Singapore",
			"SANEDI",
			"Greater Mekong Subregion Academic Research Network",
			"SACREEE",
			"Mediterranean Renewable Energy Center (MEDREC)",
			"Coal Energy Technology Institute of the NAS of Ukraine",
			"IEA Clean Coal Centre",
			"International Solar Energy Institute (ISEI)"
		)
		) t
	);