20241224lh.sql 55 KB
Newer Older
Smile's avatar
Smile committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457
UPDATE jiedao.ecw_region SET title_fr='Europe'	where title_zh like '%欧洲(Europe)%'	and title_en='Europe';
UPDATE jiedao.ecw_region SET title_fr='Asie'	where title_zh like '%亚洲(Asia)%'	and title_en='Asia';
UPDATE jiedao.ecw_region SET title_fr='Afrique'	where title_zh like '%非洲(Africa)%'	and title_en='Africa';
UPDATE jiedao.ecw_region SET title_fr='Amérique du Sud'	where title_zh like '%南美洲%'	and title_en='South America';
UPDATE jiedao.ecw_region SET title_fr='Amérique du Nord'	where title_zh like '%北美洲(North America)%'	and title_en='North America';
UPDATE jiedao.ecw_region SET title_fr='Océanie'	where title_zh like '%大洋洲(Oceania)%'	and title_en='Oceania';
UPDATE jiedao.ecw_region SET title_fr='Antarctique'	where title_zh like '%南极洲(Antarctica)%'	and title_en='Antarctica';
UPDATE jiedao.ecw_region SET title_fr='Chine'	where title_zh like '%中国%'	and title_en='China';
UPDATE jiedao.ecw_region SET title_fr='Pékin'	where title_zh like '%北京%'	and title_en='Beijing';
UPDATE jiedao.ecw_region SET title_fr='Tianjin'	where title_zh like '%天津%'	and title_en='Tianjin';
UPDATE jiedao.ecw_region SET title_fr='Province du Hebei'	where title_zh like '%河北省%'	and title_en='Hebei Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Shanxi'	where title_zh like '%山西省%'	and title_en='Shanxi Province';
UPDATE jiedao.ecw_region SET title_fr='Région autonome de la Mongolie intérieure'	where title_zh like '%内蒙古自治区%'	and title_en='Inner Mongolia Autonomous Region';
UPDATE jiedao.ecw_region SET title_fr='Province du Liaoning'	where title_zh like '%辽宁省%'	and title_en='Liaoning Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Jilin'	where title_zh like '%吉林省%'	and title_en='Jilin Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Heilongjiang'	where title_zh like '%黑龙江省%'	and title_en='Heilongjiang Province';
UPDATE jiedao.ecw_region SET title_fr='Shanghai'	where title_zh like '%上海%'	and title_en='Shanghai';
UPDATE jiedao.ecw_region SET title_fr='Province du Jiangsu'	where title_zh like '%江苏省%'	and title_en='Jiangsu Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Zhejiang'	where title_zh like '%浙江省%'	and title_en='Zhejiang Province';
UPDATE jiedao.ecw_region SET title_fr='Province de l''Anhui'	where title_zh like '%安徽省%'	and title_en='Anhui Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Fujian'	where title_zh like '%福建省%'	and title_en='Fujian Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Jiangxi'	where title_zh like '%江西省%'	and title_en='Jiangxi Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Shandong'	where title_zh like '%山东省%'	and title_en='Shandong Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Henan'	where title_zh like '%河南省%'	and title_en='Henan Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Hubei'	where title_zh like '%湖北省%'	and title_en='Hubei province';
UPDATE jiedao.ecw_region SET title_fr='Province du Hunan'	where title_zh like '%湖南省%'	and title_en='Hunan Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Guangdong'	where title_zh like '%广东省%'	and title_en='Guangdong Province';
UPDATE jiedao.ecw_region SET title_fr='Région autonome Zhuang du Guangxi'	where title_zh like '%广西壮族自治区%'	and title_en='Guangxi Zhuang Autonomous Region';
UPDATE jiedao.ecw_region SET title_fr='Hainan'	where title_zh like '%海南省%'	and title_en='Hainan';
UPDATE jiedao.ecw_region SET title_fr='Chongqing'	where title_zh like '%重庆%'	and title_en='Chongqing';
UPDATE jiedao.ecw_region SET title_fr='Province du Sichuan'	where title_zh like '%四川省%'	and title_en='Sichuan Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Guizhou'	where title_zh like '%贵州省%'	and title_en='Guizhou Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Yunnan'	where title_zh like '%云南省%'	and title_en='Yunnan Province';
UPDATE jiedao.ecw_region SET title_fr='Région autonome du Tibet'	where title_zh like '%西藏自治区%'	and title_en='Tibet Autonomous Region';
UPDATE jiedao.ecw_region SET title_fr='Province du Shaanxi'	where title_zh like '%陕西省%'	and title_en='Shaanxi Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Gansu'	where title_zh like '%甘肃省%'	and title_en='Gansu Province';
UPDATE jiedao.ecw_region SET title_fr='Province du Qinghai'	where title_zh like '%青海省%'	and title_en='Qinghai Province';
UPDATE jiedao.ecw_region SET title_fr='Région autonome Hui du Ningxia'	where title_zh like '%宁夏回族自治区%'	and title_en='Ningxia Hui Autonomous Region';
UPDATE jiedao.ecw_region SET title_fr='Région autonome ouïghoure du Xinjiang'	where title_zh like '%新疆维吾尔自治区%'	and title_en='Xinjiang Uygur Autonomous Region';
UPDATE jiedao.ecw_region SET title_fr='Taïwan'	where title_zh like '%台湾%'	and title_en='Taiwan';
UPDATE jiedao.ecw_region SET title_fr='Région administrative spéciale de Hong Kong'	where title_zh like '%香港特别行政区%'	and title_en='Hong Kong Special Administrative Region';
UPDATE jiedao.ecw_region SET title_fr='Région administrative spéciale de Macao'	where title_zh like '%澳门特别行政区%'	and title_en='Macao Special Administrative Region';
UPDATE jiedao.ecw_region SET title_fr='Outre-mer'	where title_zh like '%海外%'	and title_en='overseas';
UPDATE jiedao.ecw_region SET title_fr='Pékin'	where title_zh like '%北京市%'	and title_en='Beijing';
UPDATE jiedao.ecw_region SET title_fr='Tianjin'	where title_zh like '%天津市%'	and title_en='Tianjin';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shijiazhuang'	where title_zh like '%石家庄市%'	and title_en='Shijiazhuang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tangshan'	where title_zh like '%唐山市%'	and title_en='Tangshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qinhuangdao'	where title_zh like '%秦皇岛市%'	and title_en='Qinhuangdao City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Handan'	where title_zh like '%邯郸市%'	and title_en='Handan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xingtai'	where title_zh like '%邢台市%'	and title_en='Xingtai City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baoding'	where title_zh like '%保定市%'	and title_en='Baoding City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhangjiakou'	where title_zh like '%张家口市%'	and title_en='Zhangjiakou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chengde'	where title_zh like '%承德市%'	and title_en='Chengde City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Cangzhou'	where title_zh like '%沧州市%'	and title_en='Cangzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Langfang'	where title_zh like '%廊坊市%'	and title_en='Langfang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hengshui'	where title_zh like '%衡水市%'	and title_en='Hengshui City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Taiyuan'	where title_zh like '%太原市%'	and title_en='Taiyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Datong'	where title_zh like '%大同市%'	and title_en='Datong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yangquan'	where title_zh like '%阳泉市%'	and title_en='Yangquan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Changzhi'	where title_zh like '%长治市%'	and title_en='Changzhi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jincheng'	where title_zh like '%晋城市%'	and title_en='Jincheng City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shuozhou'	where title_zh like '%朔州市%'	and title_en='Shuozhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jinzhong'	where title_zh like '%晋中市%'	and title_en='Jinzhong';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yuncheng'	where title_zh like '%运城市%'	and title_en='Yuncheng City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xinzhou'	where title_zh like '%忻州市%'	and title_en='xinzhou';
UPDATE jiedao.ecw_region SET title_fr='Ville de Linfen'	where title_zh like '%临汾市%'	and title_en='Linfen City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Luliang'	where title_zh like '%吕梁市%'	and title_en='Luliang City';
UPDATE jiedao.ecw_region SET title_fr='Hohhot'	where title_zh like '%呼和浩特市%'	and title_en='Hohhot';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baotou'	where title_zh like '%包头市%'	and title_en='Baotou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wuhai'	where title_zh like '%乌海市%'	and title_en='Wuhai City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chifeng'	where title_zh like '%赤峰市%'	and title_en='Chifeng City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tongliao'	where title_zh like '%通辽市%'	and title_en='Tongliao City';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Ordos'	where title_zh like '%鄂尔多斯市%'	and title_en='ordos city';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hulun Buir'	where title_zh like '%呼伦贝尔市%'	and title_en='Hulun Buir City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Bayannur'	where title_zh like '%巴彦淖尔市%'	and title_en='Bayannur City';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Ulanqab'	where title_zh like '%乌兰察布市%'	and title_en='Ulanqab City';
UPDATE jiedao.ecw_region SET title_fr='Ligue de Xing''an'	where title_zh like '%兴安盟%'	and title_en='Xing''an League';
UPDATE jiedao.ecw_region SET title_fr='Ligue de Xilingol'	where title_zh like '%锡林郭勒盟%'	and title_en='Xilingol League';
UPDATE jiedao.ecw_region SET title_fr='Ligue d''Alxa'	where title_zh like '%阿拉善盟%'	and title_en='alxa league';
UPDATE jiedao.ecw_region SET title_fr='Shenyang'	where title_zh like '%沈阳市%'	and title_en='Shenyang';
UPDATE jiedao.ecw_region SET title_fr='Dalian'	where title_zh like '%大连市%'	and title_en='Dalian';
UPDATE jiedao.ecw_region SET title_fr='Ville de Anshan'	where title_zh like '%鞍山市%'	and title_en='Anshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Fushun'	where title_zh like '%抚顺市%'	and title_en='Fushun City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Benxi'	where title_zh like '%本溪市%'	and title_en='Benxi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Dandong'	where title_zh like '%丹东市%'	and title_en='Dandong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jinzhou'	where title_zh like '%锦州市%'	and title_en='Jinzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yingkou'	where title_zh like '%营口市%'	and title_en='Yingkou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Fuxin'	where title_zh like '%阜新市%'	and title_en='Fuxin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Liaoyang'	where title_zh like '%辽阳市%'	and title_en='Liaoyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Panjin'	where title_zh like '%盘锦市%'	and title_en='Panjin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tieling'	where title_zh like '%铁岭市%'	and title_en='Tieling City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chaoyang'	where title_zh like '%朝阳市%'	and title_en='Chaoyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huludao'	where title_zh like '%葫芦岛市%'	and title_en='Huludao City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Changchun'	where title_zh like '%长春市%'	and title_en='Changchun City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jilin'	where title_zh like '%吉林市%'	and title_en='Jilin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Siping'	where title_zh like '%四平市%'	and title_en='Siping City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Liaoyuan'	where title_zh like '%辽源市%'	and title_en='Liaoyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tonghua'	where title_zh like '%通化市%'	and title_en='Tonghua City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baishan'	where title_zh like '%白山市%'	and title_en='Baishan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Songyuan'	where title_zh like '%松原市%'	and title_en='Songyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baicheng'	where title_zh like '%白城市%'	and title_en='Baicheng City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome coréenne de Yanbian'	where title_zh like '%延边朝鲜族自治州%'	and title_en='Yanbian Korean Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Harbin'	where title_zh like '%哈尔滨市%'	and title_en='Harbin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qiqihar'	where title_zh like '%齐齐哈尔市%'	and title_en='Qiqihar City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jixi'	where title_zh like '%鸡西市%'	and title_en='Jixi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hegang'	where title_zh like '%鹤岗市%'	and title_en='Hegang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shuangyashan'	where title_zh like '%双鸭山市%'	and title_en='Shuangyashan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Daqing'	where title_zh like '%大庆市%'	and title_en='Daqing City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yichun'	where title_zh like '%伊春市%'	and title_en='Yichun City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiamusi'	where title_zh like '%佳木斯市%'	and title_en='Jiamusi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qitaihe'	where title_zh like '%七台河市%'	and title_en='Qitaihe City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Mudanjiang'	where title_zh like '%牡丹江市%'	and title_en='Mudanjiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Heihe'	where title_zh like '%黑河市%'	and title_en='Heihe City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Suihua'	where title_zh like '%绥化市%'	and title_en='Suihua City';
UPDATE jiedao.ecw_region SET title_fr='Monts du Grand Khingan'	where title_zh like '%大兴安岭地区%'	and title_en='Greater Khingan Mountains';
UPDATE jiedao.ecw_region SET title_fr='Shanghai'	where title_zh like '%上海市%'	and title_en='Shanghai';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nanjing'	where title_zh like '%南京市%'	and title_en='Nanjing City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wuxi'	where title_zh like '%无锡市%'	and title_en='Wuxi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xuzhou'	where title_zh like '%徐州市%'	and title_en='Xuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Changzhou'	where title_zh like '%常州市%'	and title_en='Changzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Suzhou'	where title_zh like '%苏州市%'	and title_en='Suzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nantong'	where title_zh like '%南通市%'	and title_en='Nantong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lianyungang'	where title_zh like '%连云港市%'	and title_en='Lianyungang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huai''an'	where title_zh like '%淮安市%'	and title_en='Huai''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yancheng'	where title_zh like '%盐城市%'	and title_en='yancheng';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yangzhou'	where title_zh like '%扬州市%'	and title_en='Yangzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhenjiang'	where title_zh like '%镇江市%'	and title_en='Zhenjiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Taizhou'	where title_zh like '%泰州市%'	and title_en='Taizhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Suqian'	where title_zh like '%宿迁市%'	and title_en='Suqian City';
UPDATE jiedao.ecw_region SET title_fr='Hangzhou'	where title_zh like '%杭州市%'	and title_en='Hangzhou';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ningbo'	where title_zh like '%宁波市%'	and title_en='Ningbo City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wenzhou'	where title_zh like '%温州市%'	and title_en='Wenzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiaxing'	where title_zh like '%嘉兴市%'	and title_en='Jiaxing City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huzhou'	where title_zh like '%湖州市%'	and title_en='Huzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shaoxing'	where title_zh like '%绍兴市%'	and title_en='Shaoxing City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jinhua'	where title_zh like '%金华市%'	and title_en='Jinhua City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Quzhou'	where title_zh like '%衢州市%'	and title_en='Quzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhoushan'	where title_zh like '%舟山市%'	and title_en='Zhoushan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Taizhou'	where title_zh like '%台州市%'	and title_en='Taizhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lishui'	where title_zh like '%丽水市%'	and title_en='Lishui City';
UPDATE jiedao.ecw_region SET title_fr='Hefei'	where title_zh like '%合肥市%'	and title_en='Hefei';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wuhu'	where title_zh like '%芜湖市%'	and title_en='Wuhu City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Bengbu'	where title_zh like '%蚌埠市%'	and title_en='Bengbu City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huainan'	where title_zh like '%淮南市%'	and title_en='Huainan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ma''anshan'	where title_zh like '%马鞍山市%'	and title_en='Ma''anshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huaibei'	where title_zh like '%淮北市%'	and title_en='Huaibei City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tongling'	where title_zh like '%铜陵市%'	and title_en='tongling';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Anqing'	where title_zh like '%安庆市%'	and title_en='Anqing City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huangshan'	where title_zh like '%黄山市%'	and title_en='Huangshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chuzhou'	where title_zh like '%滁州市%'	and title_en='Chuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Fuyang'	where title_zh like '%阜阳市%'	and title_en='Fuyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Suzhou'	where title_zh like '%宿州市%'	and title_en='Suzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lu''an'	where title_zh like '%六安市%'	and title_en='Lu''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Bozhou'	where title_zh like '%亳州市%'	and title_en='Bozhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chizhou'	where title_zh like '%池州市%'	and title_en='chizhou';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xuancheng'	where title_zh like '%宣城市%'	and title_en='Xuancheng City';
UPDATE jiedao.ecw_region SET title_fr='Fuzhou'	where title_zh like '%福州市%'	and title_en='Fuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Xiamen'	where title_zh like '%厦门市%'	and title_en='Xiamen';
UPDATE jiedao.ecw_region SET title_fr='Ville de Putian'	where title_zh like '%莆田市%'	and title_en='Putian City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Sanming'	where title_zh like '%三明市%'	and title_en='Sanming City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Quanzhou'	where title_zh like '%泉州市%'	and title_en='Quanzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhangzhou'	where title_zh like '%漳州市%'	and title_en='Zhangzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nanping'	where title_zh like '%南平市%'	and title_en='Nanping City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Longyan'	where title_zh like '%龙岩市%'	and title_en='Longyan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ningde'	where title_zh like '%宁德市%'	and title_en='Ningde City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nanchang'	where title_zh like '%南昌市%'	and title_en='Nanchang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jingdezhen'	where title_zh like '%景德镇市%'	and title_en='Jingdezhen City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Pingxiang'	where title_zh like '%萍乡市%'	and title_en='Pingxiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiujiang'	where title_zh like '%九江市%'	and title_en='Jiujiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xinyu'	where title_zh like '%新余市%'	and title_en='Xinyu City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yingtan'	where title_zh like '%鹰潭市%'	and title_en='Yingtan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ganzhou'	where title_zh like '%赣州市%'	and title_en='Ganzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ji''an'	where title_zh like '%吉安市%'	and title_en='Ji''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yichun'	where title_zh like '%宜春市%'	and title_en='Yichun City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Fuzhou'	where title_zh like '%抚州市%'	and title_en='Fuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shangrao'	where title_zh like '%上饶市%'	and title_en='Shangrao City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jinan'	where title_zh like '%济南市%'	and title_en='Jinan City';
UPDATE jiedao.ecw_region SET title_fr='Qingdao'	where title_zh like '%青岛市%'	and title_en='Qingdao';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zibo'	where title_zh like '%淄博市%'	and title_en='Zibo City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zaozhuang'	where title_zh like '%枣庄市%'	and title_en='Zaozhuang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Dongying'	where title_zh like '%东营市%'	and title_en='Dongying City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yantai'	where title_zh like '%烟台市%'	and title_en='Yantai City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Weifang'	where title_zh like '%潍坊市%'	and title_en='Weifang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jining'	where title_zh like '%济宁市%'	and title_en='Jining City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tai''an'	where title_zh like '%泰安市%'	and title_en='Tai''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Weihai'	where title_zh like '%威海市%'	and title_en='Weihai City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Rizhao'	where title_zh like '%日照市%'	and title_en='Rizhao City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Laiwu'	where title_zh like '%莱芜市%'	and title_en='Laiwu';
UPDATE jiedao.ecw_region SET title_fr='Ville de Linyi'	where title_zh like '%临沂市%'	and title_en='Linyi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Dezhou'	where title_zh like '%德州市%'	and title_en='Dezhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Liaocheng'	where title_zh like '%聊城市%'	and title_en='LiaoCheng';
UPDATE jiedao.ecw_region SET title_fr='Ville de Binzhou'	where title_zh like '%滨州市%'	and title_en='Binzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Heze'	where title_zh like '%菏泽市%'	and title_en='HeZe';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhengzhou'	where title_zh like '%郑州市%'	and title_en='Zhengzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Kaifeng'	where title_zh like '%开封市%'	and title_en='Kaifeng City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Luoyang'	where title_zh like '%洛阳市%'	and title_en='Luoyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Pingdingshan'	where title_zh like '%平顶山市%'	and title_en='Pingdingshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Anyang'	where title_zh like '%安阳市%'	and title_en='Anyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hebi'	where title_zh like '%鹤壁市%'	and title_en='Hebi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xinxiang'	where title_zh like '%新乡市%'	and title_en='Xinxiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiaozuo'	where title_zh like '%焦作市%'	and title_en='Jiaozuo City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Puyang'	where title_zh like '%濮阳市%'	and title_en='Puyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xuchang'	where title_zh like '%许昌市%'	and title_en='Xuchang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Luohe'	where title_zh like '%漯河市%'	and title_en='Luohe City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Sanmenxia'	where title_zh like '%三门峡市%'	and title_en='Sanmenxia City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nanyang'	where title_zh like '%南阳市%'	and title_en='Nanyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shangqiu'	where title_zh like '%商丘市%'	and title_en='Shangqiu City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xinyang'	where title_zh like '%信阳市%'	and title_en='Xinyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhoukou'	where title_zh like '%周口市%'	and title_en='Zhoukou';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhumadian'	where title_zh like '%驻马店市%'	and title_en='Zhumadian City';
UPDATE jiedao.ecw_region SET title_fr='Wuhan'	where title_zh like '%武汉市%'	and title_en='Wuhan';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huangshi'	where title_zh like '%黄石市%'	and title_en='Huangshi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shiyan'	where title_zh like '%十堰市%'	and title_en='Shiyan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yichang'	where title_zh like '%宜昌市%'	and title_en='Yichang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xiangyang'	where title_zh like '%襄阳市%'	and title_en='Xiangyang';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Ezhou'	where title_zh like '%鄂州市%'	and title_en='Ezhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jingmen'	where title_zh like '%荆门市%'	and title_en='Jingmen City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xiaogan'	where title_zh like '%孝感市%'	and title_en='Xiaogan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jingzhou'	where title_zh like '%荆州市%'	and title_en='jingzhou';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huanggang'	where title_zh like '%黄冈市%'	and title_en='Huanggang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xianning'	where title_zh like '%咸宁市%'	and title_en='Xianning';
UPDATE jiedao.ecw_region SET title_fr='Ville de Suizhou'	where title_zh like '%随州市%'	and title_en='suizhou';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Tujia et Miao d''Enshi'	where title_zh like '%恩施土家族苗族自治州%'	and title_en='Enshi Tujia and Miao Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Changsha'	where title_zh like '%长沙市%'	and title_en='Changsha City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhuzhou'	where title_zh like '%株洲市%'	and title_en='Zhuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xiangtan'	where title_zh like '%湘潭市%'	and title_en='Xiangtan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hengyang'	where title_zh like '%衡阳市%'	and title_en='Hengyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shaoyang'	where title_zh like '%邵阳市%'	and title_en='Shaoyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yueyang'	where title_zh like '%岳阳市%'	and title_en='Yueyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Changde'	where title_zh like '%常德市%'	and title_en='Changde City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhangjiajie'	where title_zh like '%张家界市%'	and title_en='Zhangjiajie City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yiyang'	where title_zh like '%益阳市%'	and title_en='Yiyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chenzhou'	where title_zh like '%郴州市%'	and title_en='Chenzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yongzhou'	where title_zh like '%永州市%'	and title_en='Yongzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huaihua'	where title_zh like '%怀化市%'	and title_en='huaihua';
UPDATE jiedao.ecw_region SET title_fr='Ville de Loudi'	where title_zh like '%娄底市%'	and title_en='Loudi City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Tujia et Miao de Xiangxi'	where title_zh like '%湘西土家族苗族自治州%'	and title_en='Xiangxi Tujia and Miao Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guangzhou'	where title_zh like '%广州市%'	and title_en='Guangzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shaoguan'	where title_zh like '%韶关市%'	and title_en='Shaoguan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shenzhen'	where title_zh like '%深圳市%'	and title_en='Shenzhen City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhuhai'	where title_zh like '%珠海市%'	and title_en='Zhuhai City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shantou'	where title_zh like '%汕头市%'	and title_en='Shantou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Foshan'	where title_zh like '%佛山市%'	and title_en='Foshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiangmen'	where title_zh like '%江门市%'	and title_en='Jiangmen City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhanjiang'	where title_zh like '%湛江市%'	and title_en='Zhanjiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Maoming'	where title_zh like '%茂名市%'	and title_en='Maoming City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhaoqing'	where title_zh like '%肇庆市%'	and title_en='Zhaoqing City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Huizhou'	where title_zh like '%惠州市%'	and title_en='Huizhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Meizhou'	where title_zh like '%梅州市%'	and title_en='Meizhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shanwei'	where title_zh like '%汕尾市%'	and title_en='Shanwei City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Heyuan'	where title_zh like '%河源市%'	and title_en='Heyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yangjiang'	where title_zh like '%阳江市%'	and title_en='Yangjiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qingyuan'	where title_zh like '%清远市%'	and title_en='Qingyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Dongguan'	where title_zh like '%东莞市%'	and title_en='Dongguan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhongshan'	where title_zh like '%中山市%'	and title_en='zhongshan';
UPDATE jiedao.ecw_region SET title_fr='Îles Dongsha'	where title_zh like '%东沙群岛%'	and title_en='the Dongsha Islands';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chaozhou'	where title_zh like '%潮州市%'	and title_en='Chaozhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jieyang'	where title_zh like '%揭阳市%'	and title_en='Jieyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yunfu'	where title_zh like '%云浮市%'	and title_en='Yunfu City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nanning'	where title_zh like '%南宁市%'	and title_en='Nanning City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Liuzhou'	where title_zh like '%柳州市%'	and title_en='Liuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guilin'	where title_zh like '%桂林市%'	and title_en='Guilin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wuzhou'	where title_zh like '%梧州市%'	and title_en='Wuzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Beihai'	where title_zh like '%北海市%'	and title_en='Beihai City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Fangchenggang'	where title_zh like '%防城港市%'	and title_en='Fangchenggang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qinzhou'	where title_zh like '%钦州市%'	and title_en='Qinzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guigang'	where title_zh like '%贵港市%'	and title_en='Guigang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yulin'	where title_zh like '%玉林市%'	and title_en='Yulin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baise'	where title_zh like '%百色市%'	and title_en='Baise City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hezhou'	where title_zh like '%贺州市%'	and title_en='Hezhou';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hechi'	where title_zh like '%河池市%'	and title_en='Hechi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Laibin'	where title_zh like '%来宾市%'	and title_en='Laibin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chongzuo'	where title_zh like '%崇左市%'	and title_en='Chongzuo City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Haikou'	where title_zh like '%海口市%'	and title_en='Haikou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Sanya'	where title_zh like '%三亚市%'	and title_en='The city of Sanya';
UPDATE jiedao.ecw_region SET title_fr='Sansha'	where title_zh like '%三沙市%'	and title_en='Sansha';
UPDATE jiedao.ecw_region SET title_fr='Ville de Chongqing'	where title_zh like '%重庆市%'	and title_en='Chongqing City';
UPDATE jiedao.ecw_region SET title_fr='Chengdu'	where title_zh like '%成都市%'	and title_en='Chengdu';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zigong'	where title_zh like '%自贡市%'	and title_en='Zigong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Panzhihua'	where title_zh like '%攀枝花市%'	and title_en='Panzhihua City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Luzhou'	where title_zh like '%泸州市%'	and title_en='Luzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Deyang'	where title_zh like '%德阳市%'	and title_en='deyang';
UPDATE jiedao.ecw_region SET title_fr='Ville de Mianyang'	where title_zh like '%绵阳市%'	and title_en='Mianyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guangyuan'	where title_zh like '%广元市%'	and title_en='Guangyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Suining'	where title_zh like '%遂宁市%'	and title_en='Suining City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Neijiang'	where title_zh like '%内江市%'	and title_en='Neijiang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Leshan'	where title_zh like '%乐山市%'	and title_en='Leshan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Nanchong'	where title_zh like '%南充市%'	and title_en='Nanchong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Meishan'	where title_zh like '%眉山市%'	and title_en='Meishan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yibin'	where title_zh like '%宜宾市%'	and title_en='Yibin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guang''an'	where title_zh like '%广安市%'	and title_en='Guang''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Dazhou'	where title_zh like '%达州市%'	and title_en='Dazhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ya''an'	where title_zh like '%雅安市%'	and title_en='Ya''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Bazhong'	where title_zh like '%巴中市%'	and title_en='Bazhong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Ziyang'	where title_zh like '%资阳市%'	and title_en='Ziyang City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine et qiang de Aba'	where title_zh like '%阿坝藏族羌族自治州%'	and title_en='Aba Tibetan and Qiang Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Ganzi'	where title_zh like '%甘孜藏族自治州%'	and title_en='Ganzi Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Yi de Liangshan'	where title_zh like '%凉山彝族自治州%'	and title_en='Liangshan Yi Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guiyang'	where title_zh like '%贵阳市%'	and title_en='Guiyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Liupanshui'	where title_zh like '%六盘水市%'	and title_en='liupanshui city';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zunyi'	where title_zh like '%遵义市%'	and title_en='Zunyi City';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Anshun'	where title_zh like '%安顺市%'	and title_en='Anshun City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tongren'	where title_zh like '%铜仁市%'	and title_en='Tongren';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Buyei et Miao de Qianxinan'	where title_zh like '%黔西南布依族苗族自治州%'	and title_en='Qianxinan Buyei and Miao Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Bijie'	where title_zh like '%毕节市%'	and title_en='Bijie City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Miao et Dong de Qiandongnan'	where title_zh like '%黔东南苗族侗族自治州%'	and title_en='Qiandongnan Miao and Dong Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Buyei et Miao de Qiannan'	where title_zh like '%黔南布依族苗族自治州%'	and title_en='Qiannan Buyei and Miao Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Kunming'	where title_zh like '%昆明市%'	and title_en='Kunming';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qujing'	where title_zh like '%曲靖市%'	and title_en='Qujing';
UPDATE jiedao.ecw_region SET title_fr='Ville de YuXi'	where title_zh like '%玉溪市%'	and title_en='YuXi';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baoshan'	where title_zh like '%保山市%'	and title_en='baoshan';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhaotong'	where title_zh like '%昭通市%'	and title_en='zhaotong';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lijiang'	where title_zh like '%丽江市%'	and title_en='lijiang';
UPDATE jiedao.ecw_region SET title_fr='Ville de Pu''er'	where title_zh like '%普洱市%'	and title_en='Pu''er City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lincang'	where title_zh like '%临沧市%'	and title_en='Lincang City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Yi de Chuxiong'	where title_zh like '%楚雄彝族自治州%'	and title_en='Chuxiong Yi Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Hani et Yi de Honghe'	where title_zh like '%红河哈尼族彝族自治州%'	and title_en='Honghe Hani and Yi Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Zhuang et Miao de Wenshan'	where title_zh like '%文山壮族苗族自治州%'	and title_en='Wenshan Zhuang and Miao Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Dai de Xishuangbanna'	where title_zh like '%西双版纳傣族自治州%'	and title_en='Xishuangbanna Dai Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Bai de Dali'	where title_zh like '%大理白族自治州%'	and title_en='Dali Bai Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Dai et Jingpo de Dehong'	where title_zh like '%德宏傣族景颇族自治州%'	and title_en='Dehong Dai and Jingpo Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Lisu de Nujiang'	where title_zh like '%怒江傈僳族自治州%'	and title_en='Nujiang Lisu Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Diqing'	where title_zh like '%迪庆藏族自治州%'	and title_en='Diqing Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lhasa'	where title_zh like '%拉萨市%'	and title_en='Lhasa City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Changdu'	where title_zh like '%昌都市%'	and title_en='Changdu';
UPDATE jiedao.ecw_region SET title_fr='Région de Shannan'	where title_zh like '%山南地区%'	and title_en='Shannan region';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shigatse'	where title_zh like '%日喀则市%'	and title_en='Shigatse City';
UPDATE jiedao.ecw_region SET title_fr='Région de Naqu'	where title_zh like '%那曲地区%'	and title_en='Naqu region';
UPDATE jiedao.ecw_region SET title_fr='Région d''Ali'	where title_zh like '%阿里地区%'	and title_en='Ali region';
UPDATE jiedao.ecw_region SET title_fr='Ville de Linzhi'	where title_zh like '%林芝市%'	and title_en='Linzhi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xi''an'	where title_zh like '%西安市%'	and title_en='Xi''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tongchuan'	where title_zh like '%铜川市%'	and title_en='Tongchuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baoji'	where title_zh like '%宝鸡市%'	and title_en='Baoji City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xianyang'	where title_zh like '%咸阳市%'	and title_en='Xianyang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Weinan'	where title_zh like '%渭南市%'	and title_en='Weinan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yan''an'	where title_zh like '%延安市%'	and title_en='Yan''an City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hanzhong'	where title_zh like '%汉中市%'	and title_en='Hanzhong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yulin'	where title_zh like '%榆林市%'	and title_en='Yulin City';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Ankang'	where title_zh like '%安康市%'	and title_en='Ankang City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shangluo'	where title_zh like '%商洛市%'	and title_en='shangluo';
UPDATE jiedao.ecw_region SET title_fr='Ville de Lanzhou'	where title_zh like '%兰州市%'	and title_en='Lanzhou City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiayuguan'	where title_zh like '%嘉峪关市%'	and title_en='Jiayuguan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jinchang'	where title_zh like '%金昌市%'	and title_en='Jinchang';
UPDATE jiedao.ecw_region SET title_fr='Ville de Baiyin'	where title_zh like '%白银市%'	and title_en='Baiyin City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tianshui'	where title_zh like '%天水市%'	and title_en='Tianshui City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wuwei'	where title_zh like '%武威市%'	and title_en='Wuwei City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhangye'	where title_zh like '%张掖市%'	and title_en='Zhangye City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Pingliang'	where title_zh like '%平凉市%'	and title_en='Pingliang';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiuquan'	where title_zh like '%酒泉市%'	and title_en='jiuquan';
UPDATE jiedao.ecw_region SET title_fr='Ville de Qingyang'	where title_zh like '%庆阳市%'	and title_en='qingyang';
UPDATE jiedao.ecw_region SET title_fr='Ville de Dingxi'	where title_zh like '%定西市%'	and title_en='dingxi';
UPDATE jiedao.ecw_region SET title_fr='Ville de Longnan'	where title_zh like '%陇南市%'	and title_en='Longnan City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Hui de Linxia'	where title_zh like '%临夏回族自治州%'	and title_en='Linxia Hui Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Gannan'	where title_zh like '%甘南藏族自治州%'	and title_en='Gannan Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xining'	where title_zh like '%西宁市%'	and title_en='Xining City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Haidong'	where title_zh like '%海东市%'	and title_en='Haidong City';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Haibei'	where title_zh like '%海北藏族自治州%'	and title_en='Haibei Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Huangnan'	where title_zh like '%黄南藏族自治州%'	and title_en='Huangnan Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Hainan'	where title_zh like '%海南藏族自治州%'	and title_en='Hainan Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Golog'	where title_zh like '%果洛藏族自治州%'	and title_en='Golog Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome tibétaine de Yushu'	where title_zh like '%玉树藏族自治州%'	and title_en='Yushu Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Mongole et tibétaine de Haixi'	where title_zh like '%海西蒙古族藏族自治州%'	and title_en='Haixi Mongol and Tibetan Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Ville de Yinchuan'	where title_zh like '%银川市%'	and title_en='Yinchuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Shizuishan'	where title_zh like '%石嘴山市%'	and title_en='Shizuishan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Wuzhong'	where title_zh like '%吴忠市%'	and title_en='Wuzhong City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Guyuan'	where title_zh like '%固原市%'	and title_en='Guyuan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Zhongwei'	where title_zh like '%中卫市%'	and title_en='Zhongwei City';
UPDATE jiedao.ecw_region SET title_fr='Ville d''Urumqi'	where title_zh like '%乌鲁木齐市%'	and title_en='Urumqi';
UPDATE jiedao.ecw_region SET title_fr='Ville de Karamay'	where title_zh like '%克拉玛依市%'	and title_en='Karamay City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Turpan'	where title_zh like '%吐鲁番市%'	and title_en='Turpan City';
UPDATE jiedao.ecw_region SET title_fr='Région de Hami'	where title_zh like '%哈密地区%'	and title_en='Hami region';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome Hui de Changji'	where title_zh like '%昌吉回族自治州%'	and title_en='Changji Hui Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome mongole de Bortala'	where title_zh like '%博尔塔拉蒙古自治州%'	and title_en='Bortala Mongol Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome mongole de Bayingolin'	where title_zh like '%巴音郭楞蒙古自治州%'	and title_en='Bayingolin Mongolian Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Région d''Aksu'	where title_zh like '%阿克苏地区%'	and title_en='Aksu region';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome kirghize de Kizilsu'	where title_zh like '%克孜勒苏柯尔克孜自治州%'	and title_en='Kizilsu Kyrgyz Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='Région de Kashgar'	where title_zh like '%喀什地区%'	and title_en='Kashgar region';
UPDATE jiedao.ecw_region SET title_fr='Région de Hotan'	where title_zh like '%和田地区%'	and title_en='Hotan Region';
UPDATE jiedao.ecw_region SET title_fr='Préfecture autonome kazakhe d''Ili'	where title_zh like '%伊犁哈萨克自治州%'	and title_en='Ili Kazak Autonomous Prefecture';
UPDATE jiedao.ecw_region SET title_fr='District de Tacheng'	where title_zh like '%塔城地区%'	and title_en='Tacheng District';
UPDATE jiedao.ecw_region SET title_fr='Région d''Altay'	where title_zh like '%阿勒泰地区%'	and title_en='Altay region';
UPDATE jiedao.ecw_region SET title_fr='Ville de Taipei'	where title_zh like '%台北市%'	and title_en='Taipei City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Kaohsiung'	where title_zh like '%高雄市%'	and title_en='Kaohsiung City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Tainan'	where title_zh like '%台南市%'	and title_en='Tainan City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Taichung'	where title_zh like '%台中市%'	and title_en='Taichung City';
UPDATE jiedao.ecw_region SET title_fr='Comté de Jinmen'	where title_zh like '%金门县%'	and title_en='Jinmen County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Nantou'	where title_zh like '%南投县%'	and title_en='Nantou County';
UPDATE jiedao.ecw_region SET title_fr='Ville de Keelung'	where title_zh like '%基隆市%'	and title_en='Keelung City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Hsinchu'	where title_zh like '%新竹市%'	and title_en='Hsinchu City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Jiayi'	where title_zh like '%嘉义市%'	and title_en='Jiayi City';
UPDATE jiedao.ecw_region SET title_fr='Ville de Xinbei'	where title_zh like '%新北市%'	and title_en='Xinbei City';
UPDATE jiedao.ecw_region SET title_fr='Comté de Yilan'	where title_zh like '%宜兰县%'	and title_en='Yilan County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Xinzhu'	where title_zh like '%新竹县%'	and title_en='Xinzhu County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Taoyuan'	where title_zh like '%桃园县%'	and title_en='Taoyuan County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Miaoli'	where title_zh like '%苗栗县%'	and title_en='Miaoli County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Changhua'	where title_zh like '%彰化县%'	and title_en='Changhua County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Jiayi'	where title_zh like '%嘉义县%'	and title_en='Jiayi County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Yunlin'	where title_zh like '%云林县%'	and title_en='Yunlin County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Pingdong'	where title_zh like '%屏东县%'	and title_en='Pingdong County';
UPDATE jiedao.ecw_region SET title_fr='Taitung'	where title_zh like '%台东县%'	and title_en='Taitung';
UPDATE jiedao.ecw_region SET title_fr='Comté de Hualien'	where title_zh like '%花莲县%'	and title_en='Hualien County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Penghu'	where title_zh like '%澎湖县%'	and title_en='Penghu County';
UPDATE jiedao.ecw_region SET title_fr='Comté de Lianjiang'	where title_zh like '%连江县%'	and title_en='Lianjiang County';
UPDATE jiedao.ecw_region SET title_fr='Île de Hong Kong'	where title_zh like '%香港岛%'	and title_en='Hong Kong Island';
UPDATE jiedao.ecw_region SET title_fr='Kowloon'	where title_zh like '%九龙%'	and title_en='Kowloon';
UPDATE jiedao.ecw_region SET title_fr='Nouveaux Territoires'	where title_zh like '%新界%'	and title_en='New Territories';
UPDATE jiedao.ecw_region SET title_fr='Péninsule de Macao'	where title_zh like '%澳门半岛%'	and title_en='Macau Peninsula';
UPDATE jiedao.ecw_region SET title_fr='Îles périphériques'	where title_zh like '%离岛%'	and title_en='Outlying islands';
UPDATE jiedao.ecw_region SET title_fr='Outre-mer'	where title_zh like '%海外%'	and title_en='overseas';
UPDATE jiedao.ecw_region SET title_fr='Yiwu'	where title_zh like '%义乌市%'	and title_en='yiwu';
UPDATE jiedao.ecw_region SET title_fr='Nigeria'	where title_zh like '%尼日利亚(Nigeria)%'	and title_en='Nigeria';
UPDATE jiedao.ecw_region SET title_fr='Ghana'	where title_zh like '%加纳(Ghana)%'	and title_en='Ghana';
UPDATE jiedao.ecw_region SET title_fr='Mozambique (Maputo)'	where title_zh like '%莫桑比克(Maputo)%'	and title_en='Mozambique (Maputo)';
UPDATE jiedao.ecw_region SET title_fr='Kenya'	where title_zh like '%肯尼亚(Kenya)%'	and title_en='Kenya';
UPDATE jiedao.ecw_region SET title_fr='Émirats Arabes Unis (CGU)'	where title_zh like '%阿联酋(CGU)%'	and title_en='United Arab Emirates (CGU)';
UPDATE jiedao.ecw_region SET title_fr='Lagos'	where title_zh like '%拉各斯 (Lagso)%'	and title_en='Lagso';
UPDATE jiedao.ecw_region SET title_fr='Onitsha'	where title_zh like '%奥尼查 (Onitsha)%'	and title_en='Onitsha';
UPDATE jiedao.ecw_region SET title_fr='Lagos (Nigeria)'	where title_zh like '%拉各斯 (Lagos)%'	and title_en='Lagos (Nigeria)';
UPDATE jiedao.ecw_region SET title_fr='Onitsha, Nigeria'	where title_zh like '%奥尼查 (Onitsha)%'	and title_en='Onitsha, Nigeria';
UPDATE jiedao.ecw_region SET title_fr='Capitale (Accra)'	where title_zh like '%首都(Acrra )%'	and title_en='Capital (Acrra)';
UPDATE jiedao.ecw_region SET title_fr='Accra'	where title_zh like '%阿克拉(加纳)(Accra)%'	and title_en='Accra';
UPDATE jiedao.ecw_region SET title_fr='Maputo'	where title_zh like '%马普托(Maputo)%'	and title_en='Maputo';
UPDATE jiedao.ecw_region SET title_fr='Maputo'	where title_zh like '%马普托(莫桑比克)(Maputo)%'	and title_en='Maputo';
UPDATE jiedao.ecw_region SET title_fr='Nairobi'	where title_zh like '%内罗毕(Nairobi)%'	and title_en='Nairobi';
UPDATE jiedao.ecw_region SET title_fr='Nairobi'	where title_zh like '%内罗毕(肯尼亚)(Nairobi)%'	and title_en='Nairobi';
UPDATE jiedao.ecw_region SET title_fr='Dubaï'	where title_zh like '%迪拜(阿联酋)(Dubai)%'	and title_en='Dubai';
UPDATE jiedao.ecw_region SET title_fr='Dubaï'	where title_zh like '%迪拜(Dubai)%'	and title_en='Dubai';
UPDATE jiedao.ecw_region SET title_fr='Côte d''Ivoire'	where title_zh like '%科特迪瓦(Cote D’lvoire)%'	and title_en='Cote D’lvoire';
UPDATE jiedao.ecw_region SET title_fr='Abidjan'	where title_zh like '%阿比让(Abidjan)%'	and title_en='Abidjan';
UPDATE jiedao.ecw_region SET title_fr='Abidjan'	where title_zh like '%阿比让(Abidjan)%'	and title_en='Abidjan';
UPDATE jiedao.ecw_region SET title_fr='Beira'	where title_zh like '%贝拉(Beira)%'	and title_en='Beira';
UPDATE jiedao.ecw_region SET title_fr='Beira'	where title_zh like '%贝拉(Beira)%'	and title_en='Beira';
UPDATE jiedao.ecw_region SET title_fr='Chimoio'	where title_zh like '%希莫尤(Chimoio)%'	and title_en='Chimoio';
UPDATE jiedao.ecw_region SET title_fr='Chimoio'	where title_zh like '%希莫尤(Chimoio)%'	and title_en='Chimoio';
UPDATE jiedao.ecw_region SET title_fr='Quelimane'	where title_zh like '%克利马纳%'	and title_en='Quelimane';
UPDATE jiedao.ecw_region SET title_fr='Quelimane'	where title_zh like '%克利马纳(Quelimane)%'	and title_en='Quelimane';
UPDATE jiedao.ecw_region SET title_fr='Nampula'	where title_zh like '%楠普拉%'	and title_en='Nampula';
UPDATE jiedao.ecw_region SET title_fr='Nampula'	where title_zh like '%楠普拉(Nampula)%'	and title_en='Nampula';
UPDATE jiedao.ecw_region SET title_fr='Kumasi'	where title_zh like '%库马西(Kumasi)%'	and title_en='Kumasi';
UPDATE jiedao.ecw_region SET title_fr='Kumasi'	where title_zh like '%库马西(Kumasi)%'	and title_en='kumasi';
UPDATE jiedao.ecw_region SET title_fr='Kano'	where title_zh like '%卡诺(Kano)%'	and title_en='Kano';
UPDATE jiedao.ecw_region SET title_fr='Kano (Nigeria)'	where title_zh like '%卡诺(Kano)%'	and title_en='Kano (Nigeria)';
UPDATE jiedao.ecw_region SET title_fr='Tanzanie'	where title_zh like '%坦桑尼亚(Tansania)%'	and title_en='Tansania';
UPDATE jiedao.ecw_region SET title_fr='Dar es Salaam'	where title_zh like '%达累斯萨拉姆(Dar es Salaam)%'	and title_en='Dar es Salaam';
UPDATE jiedao.ecw_region SET title_fr='Dar es Salaam'	where title_zh like '%达累斯萨拉姆(Dar es Salaam)%'	and title_en='Dar es Salaam';
UPDATE jiedao.ecw_region SET title_fr='Nakuru'	where title_zh like '%纳库鲁%'	and title_en='Nakuru';
UPDATE jiedao.ecw_region SET title_fr='Mombasa'	where title_zh like '%蒙巴萨%'	and title_en='Mombasa';
UPDATE jiedao.ecw_region SET title_fr='Nakuru'	where title_zh like '%纳库鲁(Nakuru)%'	and title_en='Nakuru';
UPDATE jiedao.ecw_region SET title_fr='Mombasa'	where title_zh like '%蒙巴萨(Mombasa)%'	and title_en='Mombasa';



update ecw_warehouse set title_fr='Mombasa'	where title_zh='Mombasa'	and title_en='Mombasa';
update ecw_warehouse set title_fr='Nakuru'	where title_zh='Nakuru'	and title_en='Nakuru';