REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug) VALUES 
('CN', 'China', 'china');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(743561, 'cn', 'Anhui', 1, 'anhui');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(37550, 743561, 'cn', 'Anqing Diqu', 1, 'anqing-diqu'),
(37551, 743561, 'cn', 'Anqing Shi', 1, 'anqing-shi'),
(37552, 743561, 'cn', 'Bengbu Shi', 1, 'bengbu-shi'),
(37553, 743561, 'cn', 'Bozhou Shi', 1, 'bozhou-shi'),
(37554, 743561, 'cn', 'Changfeng Xian', 1, 'changfeng-xian'),
(37555, 743561, 'cn', 'Chaohu Diqu', 1, 'chaohu-diqu'),
(37556, 743561, 'cn', 'Chaohu Shi', 1, 'chaohu-shi'),
(37557, 743561, 'cn', 'Chuxian Diqu', 1, 'chuxian-diqu'),
(37558, 743561, 'cn', 'Chuzhou Shi', 1, 'chuzhou-shi'),
(37559, 743561, 'cn', 'Dangshan Xian', 1, 'dangshan-xian'),
(37560, 743561, 'cn', 'Dangtu Xian', 1, 'dangtu-xian'),
(37561, 743561, 'cn', 'Dingyuan Xian', 1, 'dingyuan-xian'),
(37562, 743561, 'cn', 'Dongzhi Xian', 1, 'dongzhi-xian'),
(37563, 743561, 'cn', 'Fanchang Xian', 1, 'fanchang-xian'),
(37564, 743561, 'cn', 'Feidong Xian', 1, 'feidong-xian'),
(37565, 743561, 'cn', 'Feixi Xian', 1, 'feixi-xian'),
(37566, 743561, 'cn', 'Fengtai Xian', 1, 'fengtai-xian'),
(37567, 743561, 'cn', 'Fengyang Xian', 1, 'fengyang-xian'),
(37568, 743561, 'cn', 'Funan Xian', 1, 'funan-xian'),
(37569, 743561, 'cn', 'Fuyang Diqu', 1, 'fuyang-diqu'),
(37570, 743561, 'cn', 'Fuyang Shi', 1, 'fuyang-shi'),
(37571, 743561, 'cn', 'Fuyang Xian', 1, 'fuyang-xian'),
(37572, 743561, 'cn', 'Guangde Xian', 1, 'guangde-xian'),
(37573, 743561, 'cn', 'Guichi Xian', 1, 'guichi-xian'),
(37574, 743561, 'cn', 'Guoyang Xian', 1, 'guoyang-xian'),
(37575, 743561, 'cn', 'Guzhen Xian', 1, 'guzhen-xian'),
(37576, 743561, 'cn', 'Hanshan Xian', 1, 'hanshan-xian'),
(37577, 743561, 'cn', 'He Xian', 1, 'he-xian'),
(37578, 743561, 'cn', 'Hefei Shi', 1, 'hefei-shi'),
(37579, 743561, 'cn', 'Huaibei Shi', 1, 'huaibei-shi'),
(37580, 743561, 'cn', 'Huainan Shi', 1, 'huainan-shi'),
(37581, 743561, 'cn', 'Huaining Xian', 1, 'huaining-xian'),
(37582, 743561, 'cn', 'Huaiyuan Xian', 1, 'huaiyuan-xian'),
(37583, 743561, 'cn', 'Huangshan Shi', 1, 'huangshan-shi'),
(37584, 743561, 'cn', 'Huizhou Diqu', 1, 'huizhou-diqu'),
(37585, 743561, 'cn', 'Huoqiu Xian', 1, 'huoqiu-xian'),
(37586, 743561, 'cn', 'Huoshan Xian', 1, 'huoshan-xian'),
(37587, 743561, 'cn', 'Jiashan Xian', 1, 'jiashan-xian'),
(37588, 743561, 'cn', 'Jieshou Xian', 1, 'jieshou-xian'),
(37589, 743561, 'cn', 'Jing Xian', 1, 'jing-xian'),
(37590, 743561, 'cn', 'Jingde Xian', 1, 'jingde-xian'),
(37591, 743561, 'cn', 'Jinzhai Xian', 1, 'jinzhai-xian'),
(37592, 743561, 'cn', 'Jixi Xian', 1, 'jixi-xian'),
(37593, 743561, 'cn', 'Lai´an Xian', 1, 'laian-xian'),
(37594, 743561, 'cn', 'Langxi Xian', 1, 'langxi-xian'),
(37595, 743561, 'cn', 'Lingbi Xian', 1, 'lingbi-xian'),
(37596, 743561, 'cn', 'Linquan Xian', 1, 'linquan-xian'),
(37597, 743561, 'cn', 'Lixin Xian', 1, 'lixin-xian'),
(37598, 743561, 'cn', 'Lujiang Xian', 1, 'lujiang-xian'),
(37599, 743561, 'cn', 'Lu´an Diqu', 1, 'luan-diqu'),
(37600, 743561, 'cn', 'Lu´an Shi', 1, 'luan-shi'),
(37601, 743561, 'cn', 'Lu´an Xian', 1, 'luan-xian'),
(37602, 743561, 'cn', 'Ma´anshan Shi', 1, 'maanshan-shi'),
(37603, 743561, 'cn', 'Mengcheng Xian', 1, 'mengcheng-xian'),
(37604, 743561, 'cn', 'Nanling Xian', 1, 'nanling-xian'),
(37605, 743561, 'cn', 'Ningguo Xian', 1, 'ningguo-xian'),
(37606, 743561, 'cn', 'Qianshan Xian', 1, 'qianshan-xian'),
(37607, 743561, 'cn', 'Qimen Xian', 1, 'qimen-xian'),
(37608, 743561, 'cn', 'Qingyang Xian', 1, 'qingyang-xian'),
(37609, 743561, 'cn', 'Quanjiao Xian', 1, 'quanjiao-xian'),
(37610, 743561, 'cn', 'She Xian', 1, 'she-xian'),
(37611, 743561, 'cn', 'Shitai Xian', 1, 'shitai-xian'),
(37612, 743561, 'cn', 'Shou Xian', 1, 'shou-xian'),
(37613, 743561, 'cn', 'Shucheng Xian', 1, 'shucheng-xian'),
(37614, 743561, 'cn', 'Si Xian', 1, 'si-xian'),
(37615, 743561, 'cn', 'Su Xian', 1, 'su-xian'),
(37616, 743561, 'cn', 'Suixi Xian', 1, 'suixi-xian'),
(37617, 743561, 'cn', 'Susong Xian', 1, 'susong-xian'),
(37618, 743561, 'cn', 'Suxian Diqu', 1, 'suxian-diqu'),
(37619, 743561, 'cn', 'Suzhou Shi', 1, 'suzhou-shi'),
(37620, 743561, 'cn', 'Taihe Xian', 1, 'taihe-xian'),
(37621, 743561, 'cn', 'Taihu Xian', 1, 'taihu-xian'),
(37622, 743561, 'cn', 'Tianchang Shi', 1, 'tianchang-shi'),
(37623, 743561, 'cn', 'Tongcheng Xian', 1, 'tongcheng-xian'),
(37624, 743561, 'cn', 'Tongling Shi', 1, 'tongling-shi'),
(37625, 743561, 'cn', 'Tongling Xian', 1, 'tongling-xian'),
(37626, 743561, 'cn', 'Tunxi Shi', 1, 'tunxi-shi'),
(37627, 743561, 'cn', 'Wangjiang Xian', 1, 'wangjiang-xian'),
(37628, 743561, 'cn', 'Wuhe Xian', 1, 'wuhe-xian'),
(37629, 743561, 'cn', 'Wuhu Shi', 1, 'wuhu-shi'),
(37630, 743561, 'cn', 'Wuhu Xian', 1, 'wuhu-xian'),
(37631, 743561, 'cn', 'Wuwei Xian', 1, 'wuwei-xian'),
(37632, 743561, 'cn', 'Xiao Xian', 1, 'xiao-xian'),
(37633, 743561, 'cn', 'Xiuning Xian', 1, 'xiuning-xian'),
(37634, 743561, 'cn', 'Xuancheng Diqu', 1, 'xuancheng-diqu'),
(37635, 743561, 'cn', 'Xuancheng Xian', 1, 'xuancheng-xian'),
(37636, 743561, 'cn', 'Yi Xian', 1, 'yi-xian'),
(37637, 743561, 'cn', 'Yingshang Xian', 1, 'yingshang-xian'),
(37638, 743561, 'cn', 'Yuexi Xian', 1, 'yuexi-xian'),
(37639, 743561, 'cn', 'Zongyang Xian', 1, 'zongyang-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(743652, 'cn', 'Fújiàn', 1, 'fujian');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(37640, 743652, 'cn', 'Anxi Xian', 1, 'anxi-xian'),
(37641, 743652, 'cn', 'Changle Shi', 1, 'changle-shi'),
(37642, 743652, 'cn', 'Changtai Xian', 1, 'changtai-xian'),
(37643, 743652, 'cn', 'Changting Xian', 1, 'changting-xian'),
(37644, 743652, 'cn', 'Chong´an Xian', 1, 'chongan-xian'),
(37645, 743652, 'cn', 'Datian Xian', 1, 'datian-xian'),
(37646, 743652, 'cn', 'Dehua Xian', 1, 'dehua-xian'),
(37647, 743652, 'cn', 'Dongshan Xian', 1, 'dongshan-xian'),
(37648, 743652, 'cn', 'Fuding Shi', 1, 'fuding-shi'),
(37649, 743652, 'cn', 'Fuqing Shi', 1, 'fuqing-shi'),
(37650, 743652, 'cn', 'Fuzhou', 1, 'fuzhou'),
(37651, 743652, 'cn', 'Fuzhou Shi', 1, 'fuzhou-shi'),
(37652, 743652, 'cn', 'Fu´an Shi', 1, 'fuan-shi'),
(37653, 743652, 'cn', 'Guangze Xian', 1, 'guangze-xian'),
(37654, 743652, 'cn', 'Gutian Xian', 1, 'gutian-xian'),
(37655, 743652, 'cn', 'Hua´an Xian', 1, 'huaan-xian'),
(37656, 743652, 'cn', 'Hui´an Xian', 1, 'huian-xian'),
(37657, 743652, 'cn', 'Jiangle Xian', 1, 'jiangle-xian'),
(37658, 743652, 'cn', 'Jianning Xian', 1, 'jianning-xian'),
(37659, 743652, 'cn', 'Jianyang Shi', 1, 'jianyang-shi'),
(37660, 743652, 'cn', 'Jian´ou Shi', 1, 'jianou-shi'),
(37661, 743652, 'cn', 'Jinjiang Shi', 1, 'jinjiang-shi'),
(37662, 743652, 'cn', 'Liancheng Xian', 1, 'liancheng-xian'),
(37663, 743652, 'cn', 'Lianjiang Xian', 1, 'lianjiang-xian'),
(37664, 743652, 'cn', 'Longhai Shi', 1, 'longhai-shi'),
(37665, 743652, 'cn', 'Longwen Qu', 1, 'longwen-qu'),
(37666, 743652, 'cn', 'Longyan Shi', 1, 'longyan-shi'),
(37667, 743652, 'cn', 'Luoyuan Xian', 1, 'luoyuan-xian'),
(37668, 743652, 'cn', 'Mingxi Xian', 1, 'mingxi-xian'),
(37669, 743652, 'cn', 'Minhou Xian', 1, 'minhou-xian'),
(37670, 743652, 'cn', 'Minqing Xian', 1, 'minqing-xian'),
(37671, 743652, 'cn', 'Nanjing Xian', 1, 'nanjing-xian'),
(37672, 743652, 'cn', 'Nanping Shi', 1, 'nanping-shi'),
(37673, 743652, 'cn', 'Nan´an Shi', 1, 'nanan-shi'),
(37674, 743652, 'cn', 'Ningde Shi', 1, 'ningde-shi'),
(37675, 743652, 'cn', 'Ninghua Xian', 1, 'ninghua-xian'),
(37676, 743652, 'cn', 'Pinghe Xian', 1, 'pinghe-xian'),
(37677, 743652, 'cn', 'Pingnan Xian', 1, 'pingnan-xian'),
(37678, 743652, 'cn', 'Pingtan Xian', 1, 'pingtan-xian'),
(37679, 743652, 'cn', 'Pucheng Xian', 1, 'pucheng-xian'),
(37680, 743652, 'cn', 'Putian Shi', 1, 'putian-shi'),
(37681, 743652, 'cn', 'Putian Xian', 1, 'putian-xian'),
(37682, 743652, 'cn', 'Qingliu Xian', 1, 'qingliu-xian'),
(37683, 743652, 'cn', 'Quanzhou Shi', 1, 'quanzhou-shi'),
(37684, 743652, 'cn', 'Sanming Shi', 1, 'sanming-shi'),
(37685, 743652, 'cn', 'Sha Xian', 1, 'sha-xian'),
(37686, 743652, 'cn', 'Shanghang Xian', 1, 'shanghang-xian'),
(37687, 743652, 'cn', 'Shaowu Shi', 1, 'shaowu-shi'),
(37688, 743652, 'cn', 'Shishi Shi', 1, 'shishi-shi'),
(37689, 743652, 'cn', 'Shouning Xian', 1, 'shouning-xian'),
(37690, 743652, 'cn', 'Shunchang Xian', 1, 'shunchang-xian'),
(37691, 743652, 'cn', 'Songxi Xian', 1, 'songxi-xian'),
(37692, 743652, 'cn', 'Taining Xian', 1, 'taining-xian'),
(37693, 743652, 'cn', 'Tong´an Qu', 1, 'tongan-qu'),
(37694, 743652, 'cn', 'Wuping Xian', 1, 'wuping-xian'),
(37695, 743652, 'cn', 'WuyishanShi', 1, 'wuyishanshi'),
(37696, 743652, 'cn', 'Xiamen Shi', 1, 'xiamen-shi'),
(37697, 743652, 'cn', 'Xianyou Xian', 1, 'xianyou-xian'),
(37698, 743652, 'cn', 'Xiapu Xian', 1, 'xiapu-xian'),
(37699, 743652, 'cn', 'Yongchun Xian', 1, 'yongchun-xian'),
(37700, 743652, 'cn', 'Yongding Xian', 1, 'yongding-xian'),
(37701, 743652, 'cn', 'Yongtai Xian', 1, 'yongtai-xian'),
(37702, 743652, 'cn', 'Yong´an Shi', 1, 'yongan-shi'),
(37703, 743652, 'cn', 'Youxi Xian', 1, 'youxi-xian'),
(37704, 743652, 'cn', 'Yunxiao Xian', 1, 'yunxiao-xian'),
(37705, 743652, 'cn', 'Zhangping Shi', 1, 'zhangping-shi'),
(37706, 743652, 'cn', 'Zhangpu Xian', 1, 'zhangpu-xian'),
(37707, 743652, 'cn', 'Zhangzhou Shi', 1, 'zhangzhou-shi'),
(37708, 743652, 'cn', 'Zhao´an Xian', 1, 'zhaoan-xian'),
(37709, 743652, 'cn', 'Zhenghe Xian', 1, 'zhenghe-xian'),
(37710, 743652, 'cn', 'Zherong Xian', 1, 'zherong-xian'),
(37711, 743652, 'cn', 'Zhouning Xian', 1, 'zhouning-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(743725, 'cn', 'Gansù', 1, 'gansu');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(37712, 743725, 'cn', 'Aksay Kazakzu Zizhixian', 1, 'aksay-kazakzu-zizhixian'),
(37713, 743725, 'cn', 'Anxi Xian', 1, 'anxi-xian'),
(37714, 743725, 'cn', 'Baiyin Shi', 1, 'baiyin-shi'),
(37715, 743725, 'cn', 'Cheng Xian', 1, 'cheng-xian'),
(37716, 743725, 'cn', 'Chongxin Xian', 1, 'chongxin-xian'),
(37717, 743725, 'cn', 'Dangchang Xian', 1, 'dangchang-xian'),
(37718, 743725, 'cn', 'Dingxi Diqu', 1, 'dingxi-diqu'),
(37719, 743725, 'cn', 'Dingxi Xian', 1, 'dingxi-xian'),
(37720, 743725, 'cn', 'Dongxiangzu Zizhixian', 1, 'dongxiangzu-zizhixian'),
(37721, 743725, 'cn', 'Dunhuang Xian', 1, 'dunhuang-xian'),
(37722, 743725, 'cn', 'Gangu Xian', 1, 'gangu-xian'),
(37723, 743725, 'cn', 'Gannan Zangzu Zizhizhou', 1, 'gannan-zangzu-zizhizhou'),
(37724, 743725, 'cn', 'Gaolan Xian', 1, 'gaolan-xian'),
(37725, 743725, 'cn', 'Gaotai Xian', 1, 'gaotai-xian'),
(37726, 743725, 'cn', 'Guanghe Xian', 1, 'guanghe-xian'),
(37727, 743725, 'cn', 'Gulang Xian', 1, 'gulang-xian'),
(37728, 743725, 'cn', 'Heshui Xian', 1, 'heshui-xian'),
(37729, 743725, 'cn', 'Hezheng Xian', 1, 'hezheng-xian'),
(37730, 743725, 'cn', 'Huachi Xian', 1, 'huachi-xian'),
(37731, 743725, 'cn', 'Huan Xian', 1, 'huan-xian'),
(37732, 743725, 'cn', 'Huating Xian', 1, 'huating-xian'),
(37733, 743725, 'cn', 'Hui Xian', 1, 'hui-xian'),
(37734, 743725, 'cn', 'Huining Xian', 1, 'huining-xian'),
(37735, 743725, 'cn', 'Jiayuguan Shi', 1, 'jiayuguan-shi'),
(37736, 743725, 'cn', 'Jinchang Shi', 1, 'jinchang-shi'),
(37737, 743725, 'cn', 'Jingchuan Xian', 1, 'jingchuan-xian'),
(37738, 743725, 'cn', 'Jingning Xian', 1, 'jingning-xian'),
(37739, 743725, 'cn', 'Jingtai Xian', 1, 'jingtai-xian'),
(37740, 743725, 'cn', 'Jingyuan Xian', 1, 'jingyuan-xian'),
(37741, 743725, 'cn', 'Jinta Xian', 1, 'jinta-xian'),
(37742, 743725, 'cn', 'Jishishan Bonanzu Dongxiangzu Salarzu Zizhixian', 1, 'jishishan-bonanzu-dongxiangzu-salarzu-zizhixian'),
(37743, 743725, 'cn', 'Jiuquan Diqu', 1, 'jiuquan-diqu'),
(37744, 743725, 'cn', 'Jiuquan Shi', 1, 'jiuquan-shi'),
(37745, 743725, 'cn', 'Jonê Xian', 1, 'jone-xian'),
(37746, 743725, 'cn', 'Kang Xian', 1, 'kang-xian'),
(37747, 743725, 'cn', 'Kangle Xian', 1, 'kangle-xian'),
(37748, 743725, 'cn', 'Lanzhou', 1, 'lanzhou'),
(37749, 743725, 'cn', 'Lanzhou Shi', 1, 'lanzhou-shi'),
(37750, 743725, 'cn', 'Li Xian', 1, 'li-xian'),
(37751, 743725, 'cn', 'Liangdang Xian', 1, 'liangdang-xian'),
(37752, 743725, 'cn', 'Lingtai Xian', 1, 'lingtai-xian'),
(37753, 743725, 'cn', 'Lintan Xian', 1, 'lintan-xian'),
(37754, 743725, 'cn', 'Lintao Xian', 1, 'lintao-xian'),
(37755, 743725, 'cn', 'Linxia Huizu Zizhizhou', 1, 'linxia-huizu-zizhizhou'),
(37756, 743725, 'cn', 'Linxia Shi', 1, 'linxia-shi'),
(37757, 743725, 'cn', 'Linxia Xian', 1, 'linxia-xian'),
(37758, 743725, 'cn', 'Linze Xian', 1, 'linze-xian'),
(37759, 743725, 'cn', 'Longnan Diqu', 1, 'longnan-diqu'),
(37760, 743725, 'cn', 'Longxi Xian', 1, 'longxi-xian'),
(37761, 743725, 'cn', 'Luqu Xian', 1, 'luqu-xian'),
(37762, 743725, 'cn', 'Maqu Xian', 1, 'maqu-xian'),
(37763, 743725, 'cn', 'Min Xian', 1, 'min-xian'),
(37764, 743725, 'cn', 'Minle Xian', 1, 'minle-xian'),
(37765, 743725, 'cn', 'Minqin Xian', 1, 'minqin-xian'),
(37766, 743725, 'cn', 'Ning Xian', 1, 'ning-xian'),
(37767, 743725, 'cn', 'Pingliang Diqu', 1, 'pingliang-diqu'),
(37768, 743725, 'cn', 'Pingliang Shi', 1, 'pingliang-shi'),
(37769, 743725, 'cn', 'Qingshui Xian', 1, 'qingshui-xian'),
(37770, 743725, 'cn', 'Qingyang Diqu', 1, 'qingyang-diqu'),
(37771, 743725, 'cn', 'Qingyang Xian', 1, 'qingyang-xian'),
(37772, 743725, 'cn', 'Qin´an Xian', 1, 'qinan-xian'),
(37773, 743725, 'cn', 'Shandan Xian', 1, 'shandan-xian'),
(37774, 743725, 'cn', 'Subei Mongolzu Zizhixian', 1, 'subei-mongolzu-zizhixian'),
(37775, 743725, 'cn', 'Sunan Yugurzu Zizhixian', 1, 'sunan-yugurzu-zizhixian'),
(37776, 743725, 'cn', 'Têwo Xian', 1, 'tewo-xian'),
(37777, 743725, 'cn', 'Tianshui Shi', 1, 'tianshui-shi'),
(37778, 743725, 'cn', 'Tianzhu Zangzu Zizhixian', 1, 'tianzhu-zangzu-zizhixian'),
(37779, 743725, 'cn', 'Tongwei Xian', 1, 'tongwei-xian'),
(37780, 743725, 'cn', 'Weiyuan Xian', 1, 'weiyuan-xian'),
(37781, 743725, 'cn', 'Wen Xian', 1, 'wen-xian'),
(37782, 743725, 'cn', 'Wudu Xian', 1, 'wudu-xian'),
(37783, 743725, 'cn', 'Wushan Xian', 1, 'wushan-xian'),
(37784, 743725, 'cn', 'Wuwei Diqu', 1, 'wuwei-diqu'),
(37785, 743725, 'cn', 'Wuwei Xian', 1, 'wuwei-xian'),
(37786, 743725, 'cn', 'Xiahe Xian', 1, 'xiahe-xian'),
(37787, 743725, 'cn', 'Xifeng Shi', 1, 'xifeng-shi'),
(37788, 743725, 'cn', 'Xihe Xian', 1, 'xihe-xian'),
(37789, 743725, 'cn', 'Yongchang Xian', 1, 'yongchang-xian'),
(37790, 743725, 'cn', 'Yongdeng Xian', 1, 'yongdeng-xian'),
(37791, 743725, 'cn', 'Yongjing Xian', 1, 'yongjing-xian'),
(37792, 743725, 'cn', 'Yumen Shi', 1, 'yumen-shi'),
(37793, 743725, 'cn', 'Yuzhong Xian', 1, 'yuzhong-xian'),
(37794, 743725, 'cn', 'Zhang Xian', 1, 'zhang-xian'),
(37795, 743725, 'cn', 'Zhangjiachuan Huizu Zizhixian', 1, 'zhangjiachuan-huizu-zizhixian'),
(37796, 743725, 'cn', 'Zhangye Diqu', 1, 'zhangye-diqu'),
(37797, 743725, 'cn', 'Zhangye Shi', 1, 'zhangye-shi'),
(37798, 743725, 'cn', 'Zhengning Xian', 1, 'zhengning-xian'),
(37799, 743725, 'cn', 'Zhenyuan Xian', 1, 'zhenyuan-xian'),
(37800, 743725, 'cn', 'Zhuanglang Xian', 1, 'zhuanglang-xian'),
(37801, 743725, 'cn', 'Zhugqu Xian', 1, 'zhugqu-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(743816, 'cn', 'Guangdong', 1, 'guangdong');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(37802, 743816, 'cn', 'Bao´an Xian', 1, 'baoan-xian'),
(37803, 743816, 'cn', 'Boluo Xian', 1, 'boluo-xian'),
(37804, 743816, 'cn', 'Chaoyang Xian', 1, 'chaoyang-xian'),
(37805, 743816, 'cn', 'Chaozhou Shi', 1, 'chaozhou-shi'),
(37806, 743816, 'cn', 'Chao´an Xian', 1, 'chaoan-xian'),
(37807, 743816, 'cn', 'Chenghai Shi', 1, 'chenghai-shi'),
(37808, 743816, 'cn', 'Conghua Shi', 1, 'conghua-shi'),
(37809, 743816, 'cn', 'Dabu Xian', 1, 'dabu-xian'),
(37810, 743816, 'cn', 'Dapu Xian', 1, 'dapu-xian'),
(37811, 743816, 'cn', 'Deqing Xian', 1, 'deqing-xian'),
(37812, 743816, 'cn', 'Dianbai Xian', 1, 'dianbai-xian'),
(37813, 743816, 'cn', 'Dongguan Shi', 1, 'dongguan-shi'),
(37814, 743816, 'cn', 'Dongyuan Xian', 1, 'dongyuan-xian'),
(37815, 743816, 'cn', 'Doumen Xian', 1, 'doumen-xian'),
(37816, 743816, 'cn', 'Enping Shi', 1, 'enping-shi'),
(37817, 743816, 'cn', 'Fengkai Xian', 1, 'fengkai-xian'),
(37818, 743816, 'cn', 'Fengshun Xian', 1, 'fengshun-xian'),
(37819, 743816, 'cn', 'Fogang Xian', 1, 'fogang-xian'),
(37820, 743816, 'cn', 'Foshan Shi', 1, 'foshan-shi'),
(37821, 743816, 'cn', 'Gaoming Shi', 1, 'gaoming-shi'),
(37822, 743816, 'cn', 'Gaoyao Shi', 1, 'gaoyao-shi'),
(37823, 743816, 'cn', 'Gaozhou Xian', 1, 'gaozhou-xian'),
(37824, 743816, 'cn', 'Guangning Xian', 1, 'guangning-xian'),
(37825, 743816, 'cn', 'Guangzhou', 1, 'guangzhou'),
(37826, 743816, 'cn', 'Guangzhou Shi', 1, 'guangzhou-shi'),
(37827, 743816, 'cn', 'Haifeng Xian', 1, 'haifeng-xian'),
(37828, 743816, 'cn', 'Haikang Xian', 1, 'haikang-xian'),
(37829, 743816, 'cn', 'Heping Xian', 1, 'heping-xian'),
(37830, 743816, 'cn', 'Heshan Shi', 1, 'heshan-shi'),
(37831, 743816, 'cn', 'Heyuan Xian', 1, 'heyuan-xian'),
(37832, 743816, 'cn', 'Huadu Shi', 1, 'huadu-shi'),
(37833, 743816, 'cn', 'Huaiji Xian', 1, 'huaiji-xian'),
(37834, 743816, 'cn', 'Huazhou Xian', 1, 'huazhou-xian'),
(37835, 743816, 'cn', 'Huidong Xian', 1, 'huidong-xian'),
(37836, 743816, 'cn', 'Huilai Xian', 1, 'huilai-xian'),
(37837, 743816, 'cn', 'Huiyang Diqu', 1, 'huiyang-diqu'),
(37838, 743816, 'cn', 'Huiyang Xian', 1, 'huiyang-xian'),
(37839, 743816, 'cn', 'Huizhou Shi', 1, 'huizhou-shi'),
(37840, 743816, 'cn', 'Jiangmen Shi', 1, 'jiangmen-shi'),
(37841, 743816, 'cn', 'Jiaoling Xian', 1, 'jiaoling-xian'),
(37842, 743816, 'cn', 'Jiedong Xian', 1, 'jiedong-xian'),
(37843, 743816, 'cn', 'Jiexi Xian', 1, 'jiexi-xian'),
(37844, 743816, 'cn', 'Jieyang Shi', 1, 'jieyang-shi'),
(37845, 743816, 'cn', 'Kaiping Shi', 1, 'kaiping-shi'),
(37846, 743816, 'cn', 'Lechang Xian', 1, 'lechang-xian'),
(37847, 743816, 'cn', 'Lianjiang Xian', 1, 'lianjiang-xian'),
(37848, 743816, 'cn', 'Liannan Yaozu Zizhixian', 1, 'liannan-yaozu-zizhixian'),
(37849, 743816, 'cn', 'Lianping Xian', 1, 'lianping-xian'),
(37850, 743816, 'cn', 'Lianshan Zhuangzu Yaozu Zizhixian', 1, 'lianshan-zhuangzu-yaozu-zizhixian'),
(37851, 743816, 'cn', 'Lianzhou Shi', 1, 'lianzhou-shi'),
(37852, 743816, 'cn', 'Longchuan Xian', 1, 'longchuan-xian'),
(37853, 743816, 'cn', 'Longmen Xian', 1, 'longmen-xian'),
(37854, 743816, 'cn', 'Lufeng Xian', 1, 'lufeng-xian'),
(37855, 743816, 'cn', 'Luoding Shi', 1, 'luoding-shi'),
(37856, 743816, 'cn', 'Maoming Shi', 1, 'maoming-shi'),
(37857, 743816, 'cn', 'Mei Xian', 1, 'mei-xian'),
(37858, 743816, 'cn', 'Meizhou Shi', 1, 'meizhou-shi'),
(37859, 743816, 'cn', 'Nanhai Shi', 1, 'nanhai-shi'),
(37860, 743816, 'cn', 'Nanxiong Xian', 1, 'nanxiong-xian'),
(37861, 743816, 'cn', 'Nan´ao Xian', 1, 'nanao-xian'),
(37862, 743816, 'cn', 'Panyu Xian', 1, 'panyu-xian'),
(37863, 743816, 'cn', 'Pingyuan Xian', 1, 'pingyuan-xian'),
(37864, 743816, 'cn', 'Puning Shi', 1, 'puning-shi'),
(37865, 743816, 'cn', 'Qingyuan Shi', 1, 'qingyuan-shi'),
(37866, 743816, 'cn', 'Qujiang Xian', 1, 'qujiang-xian'),
(37867, 743816, 'cn', 'Raoping Xian', 1, 'raoping-xian'),
(37868, 743816, 'cn', 'Renhua Xian', 1, 'renhua-xian'),
(37869, 743816, 'cn', 'Ruyuan Yaozu Zizhixian', 1, 'ruyuan-yaozu-zizhixian'),
(37870, 743816, 'cn', 'Sanshui Shi', 1, 'sanshui-shi'),
(37871, 743816, 'cn', 'Shantou Shi', 1, 'shantou-shi'),
(37872, 743816, 'cn', 'Shaoguan Shi', 1, 'shaoguan-shi'),
(37873, 743816, 'cn', 'Shenzhen Shi', 1, 'shenzhen-shi'),
(37874, 743816, 'cn', 'Shixing Xian', 1, 'shixing-xian'),
(37875, 743816, 'cn', 'Shunde Xian', 1, 'shunde-xian'),
(37876, 743816, 'cn', 'Sihui Shi', 1, 'sihui-shi'),
(37877, 743816, 'cn', 'Suixi Xian', 1, 'suixi-xian'),
(37878, 743816, 'cn', 'Taishan Shi', 1, 'taishan-shi'),
(37879, 743816, 'cn', 'Wengyuan Xian', 1, 'wengyuan-xian'),
(37880, 743816, 'cn', 'Wuchuan Xian', 1, 'wuchuan-xian'),
(37881, 743816, 'cn', 'Wuhua Xian', 1, 'wuhua-xian'),
(37882, 743816, 'cn', 'Xinfeng Xian', 1, 'xinfeng-xian'),
(37883, 743816, 'cn', 'Xingning Xian', 1, 'xingning-xian'),
(37884, 743816, 'cn', 'Xinhui Xian', 1, 'xinhui-xian'),
(37885, 743816, 'cn', 'Xinxing Xian', 1, 'xinxing-xian'),
(37886, 743816, 'cn', 'Xinyi Xian', 1, 'xinyi-xian'),
(37887, 743816, 'cn', 'Xuwen Xian', 1, 'xuwen-xian'),
(37888, 743816, 'cn', 'Yangchun Shi', 1, 'yangchun-shi'),
(37889, 743816, 'cn', 'Yangdong Xian', 1, 'yangdong-xian'),
(37890, 743816, 'cn', 'Yangjiang Shi', 1, 'yangjiang-shi'),
(37891, 743816, 'cn', 'Yangshan Xian', 1, 'yangshan-xian'),
(37892, 743816, 'cn', 'Yangxi Xian', 1, 'yangxi-xian'),
(37893, 743816, 'cn', 'Yingde Xian', 1, 'yingde-xian'),
(37894, 743816, 'cn', 'Yunan Xian', 1, 'yunan-xian'),
(37895, 743816, 'cn', 'Yunfu Shi', 1, 'yunfu-shi'),
(37896, 743816, 'cn', 'Yun´an Xian', 1, 'yunan-xian'),
(37897, 743816, 'cn', 'Zengcheng Shi', 1, 'zengcheng-shi'),
(37898, 743816, 'cn', 'Zhanjiang Shi', 1, 'zhanjiang-shi'),
(37899, 743816, 'cn', 'Zhaoqing Shi', 1, 'zhaoqing-shi'),
(37900, 743816, 'cn', 'Zhongshan Shi', 1, 'zhongshan-shi');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(743916, 'cn', 'Uìzzhouho Guì', 1, 'uizzhouho-gui');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(37901, 743916, 'cn', 'Anlong Xian', 1, 'anlong-xian'),
(37902, 743916, 'cn', 'Anshun Diqu', 1, 'anshun-diqu'),
(37903, 743916, 'cn', 'Anshun Shi', 1, 'anshun-shi'),
(37904, 743916, 'cn', 'Anshun Xian', 1, 'anshun-xian'),
(37905, 743916, 'cn', 'Bijie Diqu', 1, 'bijie-diqu'),
(37906, 743916, 'cn', 'Bijie Shi', 1, 'bijie-shi'),
(37907, 743916, 'cn', 'Ceheng Xian', 1, 'ceheng-xian'),
(37908, 743916, 'cn', 'Cengong Xian', 1, 'cengong-xian'),
(37909, 743916, 'cn', 'Changshun Xian', 1, 'changshun-xian'),
(37910, 743916, 'cn', 'Chishui Shi', 1, 'chishui-shi'),
(37911, 743916, 'cn', 'Congjiang Xian', 1, 'congjiang-xian'),
(37912, 743916, 'cn', 'Dafang Xian', 1, 'dafang-xian'),
(37913, 743916, 'cn', 'Danzhai Xian', 1, 'danzhai-xian'),
(37914, 743916, 'cn', 'Daozhen Gelaozu Miaozu Zizhixian', 1, 'daozhen-gelaozu-miaozu-zizhixian'),
(37915, 743916, 'cn', 'Dejiang Xian', 1, 'dejiang-xian'),
(37916, 743916, 'cn', 'Dushan Xian', 1, 'dushan-xian'),
(37917, 743916, 'cn', 'Duyun Shi', 1, 'duyun-shi'),
(37918, 743916, 'cn', 'Fenggang Xian', 1, 'fenggang-xian'),
(37919, 743916, 'cn', 'Fuquan Xian', 1, 'fuquan-xian'),
(37920, 743916, 'cn', 'Guanling Bouyeizu Miaozu Zizhixian', 1, 'guanling-bouyeizu-miaozu-zizhixian'),
(37921, 743916, 'cn', 'Guiding Xian', 1, 'guiding-xian'),
(37922, 743916, 'cn', 'Guiyang', 1, 'guiyang'),
(37923, 743916, 'cn', 'Hezhang Xian', 1, 'hezhang-xian'),
(37924, 743916, 'cn', 'Huangping Xian', 1, 'huangping-xian'),
(37925, 743916, 'cn', 'Huishui Xian', 1, 'huishui-xian'),
(37926, 743916, 'cn', 'Jiangkou Xian', 1, 'jiangkou-xian'),
(37927, 743916, 'cn', 'Jianhe Xian', 1, 'jianhe-xian'),
(37928, 743916, 'cn', 'Jinping Xian', 1, 'jinping-xian'),
(37929, 743916, 'cn', 'Jinsha Xian', 1, 'jinsha-xian'),
(37930, 743916, 'cn', 'Kaili Shi', 1, 'kaili-shi'),
(37931, 743916, 'cn', 'Kaiyang Xian', 1, 'kaiyang-xian'),
(37932, 743916, 'cn', 'Leishan Xian', 1, 'leishan-xian'),
(37933, 743916, 'cn', 'Libo Xian', 1, 'libo-xian'),
(37934, 743916, 'cn', 'Liping Xian', 1, 'liping-xian'),
(37935, 743916, 'cn', 'Longli Xian', 1, 'longli-xian'),
(37936, 743916, 'cn', 'Luodian Xian', 1, 'luodian-xian'),
(37937, 743916, 'cn', 'Lupanshui Shi', 1, 'lupanshui-shi'),
(37938, 743916, 'cn', 'Luzhi Tequ', 1, 'luzhi-tequ'),
(37939, 743916, 'cn', 'Majiang Xian', 1, 'majiang-xian'),
(37940, 743916, 'cn', 'Meitan Xian', 1, 'meitan-xian'),
(37941, 743916, 'cn', 'Nayong Xian', 1, 'nayong-xian'),
(37942, 743916, 'cn', 'Panxian Tequ', 1, 'panxian-tequ'),
(37943, 743916, 'cn', 'Pingba Xian', 1, 'pingba-xian'),
(37944, 743916, 'cn', 'Pingtang Xian', 1, 'pingtang-xian'),
(37945, 743916, 'cn', 'Puding Xian', 1, 'puding-xian'),
(37946, 743916, 'cn', 'Pu´an Xian', 1, 'puan-xian'),
(37947, 743916, 'cn', 'Qiandongnan Miaozu Dongzu Zizhizhou', 1, 'qiandongnan-miaozu-dongzu-zizhizhou'),
(37948, 743916, 'cn', 'Qiannan Bouyeizu Miaozu Zizhizhou', 1, 'qiannan-bouyeizu-miaozu-zizhizhou'),
(37949, 743916, 'cn', 'Qianxi Xian', 1, 'qianxi-xian'),
(37950, 743916, 'cn', 'Qianxinan Bouyeizu Miaozu Zizhizhou', 1, 'qianxinan-bouyeizu-miaozu-zizhizhou'),
(37951, 743916, 'cn', 'Qinglong Xian', 1, 'qinglong-xian'),
(37952, 743916, 'cn', 'Qingzhen Xian', 1, 'qingzhen-xian'),
(37953, 743916, 'cn', 'Renhuai Xian', 1, 'renhuai-xian'),
(37954, 743916, 'cn', 'Rongjiang Xian', 1, 'rongjiang-xian'),
(37955, 743916, 'cn', 'Sandu Suizu Zizhixian', 1, 'sandu-suizu-zizhixian'),
(37956, 743916, 'cn', 'Sansui Xian', 1, 'sansui-xian'),
(37957, 743916, 'cn', 'Shibing Xian', 1, 'shibing-xian'),
(37958, 743916, 'cn', 'Shiqian Xian', 1, 'shiqian-xian'),
(37959, 743916, 'cn', 'Shuicheng Tequ', 1, 'shuicheng-tequ'),
(37960, 743916, 'cn', 'Sinan Xian', 1, 'sinan-xian'),
(37961, 743916, 'cn', 'Songtao Miaozu Zizhixian', 1, 'songtao-miaozu-zizhixian'),
(37962, 743916, 'cn', 'Suiyang Xian', 1, 'suiyang-xian'),
(37963, 743916, 'cn', 'Taijiang Xian', 1, 'taijiang-xian'),
(37964, 743916, 'cn', 'Tianzhu Xian', 1, 'tianzhu-xian'),
(37965, 743916, 'cn', 'Tongren Diqu', 1, 'tongren-diqu'),
(37966, 743916, 'cn', 'Tongren Xian', 1, 'tongren-xian'),
(37967, 743916, 'cn', 'Tongzi Xian', 1, 'tongzi-xian'),
(37968, 743916, 'cn', 'Wangmo Xian', 1, 'wangmo-xian'),
(37969, 743916, 'cn', 'Wanshan Tequ', 1, 'wanshan-tequ'),
(37970, 743916, 'cn', 'Weining Yizu Huizu Miaozu Zizhixian', 1, 'weining-yizu-huizu-miaozu-zizhixian'),
(37971, 743916, 'cn', 'Weng´an Xian', 1, 'wengan-xian'),
(37972, 743916, 'cn', 'Wuchuan Gelaozu Miaozu Zizhixian', 1, 'wuchuan-gelaozu-miaozu-zizhixian'),
(37973, 743916, 'cn', 'Xifeng Xian', 1, 'xifeng-xian'),
(37974, 743916, 'cn', 'Xingren Xian', 1, 'xingren-xian'),
(37975, 743916, 'cn', 'Xingyi Shi', 1, 'xingyi-shi'),
(37976, 743916, 'cn', 'Xishui Xian', 1, 'xishui-xian'),
(37977, 743916, 'cn', 'Xiuwen Xian', 1, 'xiuwen-xian'),
(37978, 743916, 'cn', 'Yanhe Tujiazu Zizhixian', 1, 'yanhe-tujiazu-zizhixian'),
(37979, 743916, 'cn', 'Yinjiang Tujiazu Miaozu Zizhixian', 1, 'yinjiang-tujiazu-miaozu-zizhixian'),
(37980, 743916, 'cn', 'Yuping Dongzu Zizhixian', 1, 'yuping-dongzu-zizhixian'),
(37981, 743916, 'cn', 'Yuqing Xian', 1, 'yuqing-xian'),
(37982, 743916, 'cn', 'Zhenfeng Xian', 1, 'zhenfeng-xian'),
(37983, 743916, 'cn', 'Zheng´an Xian', 1, 'zhengan-xian'),
(37984, 743916, 'cn', 'Zhenning Bouyeizu Miaozu Zizhixian', 1, 'zhenning-bouyeizu-miaozu-zizhixian'),
(37985, 743916, 'cn', 'Zhenyuan Xian', 1, 'zhenyuan-xian'),
(37986, 743916, 'cn', 'Zhijin Xian', 1, 'zhijin-xian'),
(37987, 743916, 'cn', 'Ziyun Miaozu Bouyeizu Zizhixian', 1, 'ziyun-miaozu-bouyeizu-zizhixian'),
(37988, 743916, 'cn', 'Zunyi Diqu', 1, 'zunyi-diqu'),
(37989, 743916, 'cn', 'Zunyi Shi', 1, 'zunyi-shi'),
(37990, 743916, 'cn', 'Zunyi Xian', 1, 'zunyi-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744007, 'cn', 'Hainán', 1, 'hainan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(37991, 744007, 'cn', 'Baisha Lizu Zizhixian', 1, 'baisha-lizu-zizhixian'),
(37992, 744007, 'cn', 'Baoting Lizu Miaozu Zizhixian', 1, 'baoting-lizu-miaozu-zizhixian'),
(37993, 744007, 'cn', 'Changjiang Lizu Zizhixian', 1, 'changjiang-lizu-zizhixian'),
(37994, 744007, 'cn', 'Chengmai Xian', 1, 'chengmai-xian'),
(37995, 744007, 'cn', 'Danzhou Shi', 1, 'danzhou-shi'),
(37996, 744007, 'cn', 'Ding´an Xian', 1, 'dingan-xian'),
(37997, 744007, 'cn', 'Dongfang Shi', 1, 'dongfang-shi'),
(37998, 744007, 'cn', 'Haikou', 1, 'haikou'),
(37999, 744007, 'cn', 'Haikou Shi', 1, 'haikou-shi'),
(38000, 744007, 'cn', 'Ledong Lizu Zizhixian', 1, 'ledong-lizu-zizhixian'),
(38001, 744007, 'cn', 'Lingao Xian', 1, 'lingao-xian'),
(38002, 744007, 'cn', 'Lingshui Lizu Zizhixian', 1, 'lingshui-lizu-zizhixian'),
(38003, 744007, 'cn', 'Longhua Qu', 1, 'longhua-qu'),
(38004, 744007, 'cn', 'Meilan Qu', 1, 'meilan-qu'),
(38005, 744007, 'cn', 'Qionghai Shi', 1, 'qionghai-shi'),
(38006, 744007, 'cn', 'Qiongshan Qu', 1, 'qiongshan-qu'),
(38007, 744007, 'cn', 'Qiongzhong Lizu Miaozu Zizhixian', 1, 'qiongzhong-lizu-miaozu-zizhixian'),
(38008, 744007, 'cn', 'Sanya Shi', 1, 'sanya-shi'),
(38009, 744007, 'cn', 'Tunchang Xian', 1, 'tunchang-xian'),
(38010, 744007, 'cn', 'Wanning Shi', 1, 'wanning-shi'),
(38011, 744007, 'cn', 'Wenchang Shi', 1, 'wenchang-shi'),
(38012, 744007, 'cn', 'Wuzhishan Shi', 1, 'wuzhishan-shi'),
(38013, 744007, 'cn', 'Xiuying Qu', 1, 'xiuying-qu');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744031, 'cn', 'Hébei', 1, 'hebei');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38014, 744031, 'cn', 'Anguo Xian', 1, 'anguo-xian'),
(38015, 744031, 'cn', 'Anping Xian', 1, 'anping-xian'),
(38016, 744031, 'cn', 'Anxin Xian', 1, 'anxin-xian'),
(38017, 744031, 'cn', 'Ba Xian', 1, 'ba-xian'),
(38018, 744031, 'cn', 'Baixiang Xian', 1, 'baixiang-xian'),
(38019, 744031, 'cn', 'Baoding Diqu', 1, 'baoding-diqu'),
(38020, 744031, 'cn', 'Baoding Shi', 1, 'baoding-shi'),
(38021, 744031, 'cn', 'Botou Shi', 1, 'botou-shi'),
(38022, 744031, 'cn', 'Boye Xian', 1, 'boye-xian'),
(38023, 744031, 'cn', 'Cang Xian', 1, 'cang-xian'),
(38024, 744031, 'cn', 'Cangzhou Diqu', 1, 'cangzhou-diqu'),
(38025, 744031, 'cn', 'Cangzhou Shi', 1, 'cangzhou-shi'),
(38026, 744031, 'cn', 'Changli Xian', 1, 'changli-xian'),
(38027, 744031, 'cn', 'Chengde Diqu', 1, 'chengde-diqu'),
(38028, 744031, 'cn', 'Chengde Shi', 1, 'chengde-shi'),
(38029, 744031, 'cn', 'Chengde Xian', 1, 'chengde-xian'),
(38030, 744031, 'cn', 'Cheng´an Xian', 1, 'chengan-xian'),
(38031, 744031, 'cn', 'Chicheng Xian', 1, 'chicheng-xian'),
(38032, 744031, 'cn', 'Chongli Xian', 1, 'chongli-xian'),
(38033, 744031, 'cn', 'Ci Xian', 1, 'ci-xian'),
(38034, 744031, 'cn', 'Dachang Huizu Zizhixian', 1, 'dachang-huizu-zizhixian'),
(38035, 744031, 'cn', 'Daicheng Xian', 1, 'daicheng-xian'),
(38036, 744031, 'cn', 'Daming Xian', 1, 'daming-xian'),
(38037, 744031, 'cn', 'Dingxing Xian', 1, 'dingxing-xian'),
(38038, 744031, 'cn', 'Dingzhou Shi', 1, 'dingzhou-shi'),
(38039, 744031, 'cn', 'Dongguang Xian', 1, 'dongguang-xian'),
(38040, 744031, 'cn', 'Feixiang Xian', 1, 'feixiang-xian'),
(38041, 744031, 'cn', 'Fengnan Xian', 1, 'fengnan-xian'),
(38042, 744031, 'cn', 'Fengning Xian', 1, 'fengning-xian'),
(38043, 744031, 'cn', 'Fengrun Xian', 1, 'fengrun-xian'),
(38044, 744031, 'cn', 'Fucheng Xian', 1, 'fucheng-xian'),
(38045, 744031, 'cn', 'Funing Xian', 1, 'funing-xian'),
(38046, 744031, 'cn', 'Fuping Xian', 1, 'fuping-xian'),
(38047, 744031, 'cn', 'Gaocheng Shi', 1, 'gaocheng-shi'),
(38048, 744031, 'cn', 'Gaoyang Xian', 1, 'gaoyang-xian'),
(38049, 744031, 'cn', 'Gaoyi Xian', 1, 'gaoyi-xian'),
(38050, 744031, 'cn', 'Guangping Xian', 1, 'guangping-xian'),
(38051, 744031, 'cn', 'Guangzong Xian', 1, 'guangzong-xian'),
(38052, 744031, 'cn', 'Guantao Xian', 1, 'guantao-xian'),
(38053, 744031, 'cn', 'Gucheng Xian', 1, 'gucheng-xian'),
(38054, 744031, 'cn', 'Guyuan Xian', 1, 'guyuan-xian'),
(38055, 744031, 'cn', 'Gu´an Xian', 1, 'guan-xian'),
(38056, 744031, 'cn', 'Haixing Xian', 1, 'haixing-xian'),
(38057, 744031, 'cn', 'Handan Diqu', 1, 'handan-diqu'),
(38058, 744031, 'cn', 'Handan Shi', 1, 'handan-shi'),
(38059, 744031, 'cn', 'Handan Xian', 1, 'handan-xian'),
(38060, 744031, 'cn', 'Hebei Sheng', 1, 'hebei-sheng'),
(38061, 744031, 'cn', 'Hejian Xian', 1, 'hejian-xian'),
(38062, 744031, 'cn', 'Hengshui Shi', 1, 'hengshui-shi'),
(38063, 744031, 'cn', 'Huailai Xian', 1, 'huailai-xian'),
(38064, 744031, 'cn', 'Huai´an Xian', 1, 'huaian-xian'),
(38065, 744031, 'cn', 'Huanghua Xian', 1, 'huanghua-xian'),
(38066, 744031, 'cn', 'Jin Xian', 1, 'jin-xian'),
(38067, 744031, 'cn', 'Jing Xian', 1, 'jing-xian'),
(38068, 744031, 'cn', 'Jingxing Xian', 1, 'jingxing-xian'),
(38069, 744031, 'cn', 'Jize Xian', 1, 'jize-xian'),
(38070, 744031, 'cn', 'Jizhou Shi', 1, 'jizhou-shi'),
(38071, 744031, 'cn', 'Julu Xian', 1, 'julu-xian'),
(38072, 744031, 'cn', 'Kangbao Xian', 1, 'kangbao-xian'),
(38073, 744031, 'cn', 'Kuancheng Xian', 1, 'kuancheng-xian'),
(38074, 744031, 'cn', 'Laishui Xian', 1, 'laishui-xian'),
(38075, 744031, 'cn', 'Laiyuan Xian', 1, 'laiyuan-xian'),
(38076, 744031, 'cn', 'Langfang Shi', 1, 'langfang-shi'),
(38077, 744031, 'cn', 'Leting Xian', 1, 'leting-xian'),
(38078, 744031, 'cn', 'Li Xian', 1, 'li-xian'),
(38079, 744031, 'cn', 'Lincheng Xian', 1, 'lincheng-xian'),
(38080, 744031, 'cn', 'Lingshou Xian', 1, 'lingshou-xian'),
(38081, 744031, 'cn', 'Linxi Xian', 1, 'linxi-xian'),
(38082, 744031, 'cn', 'Linzhang Xian', 1, 'linzhang-xian'),
(38083, 744031, 'cn', 'Longhua Xian', 1, 'longhua-xian'),
(38084, 744031, 'cn', 'Longyao Xian', 1, 'longyao-xian'),
(38085, 744031, 'cn', 'Luan Xian', 1, 'luan-xian'),
(38086, 744031, 'cn', 'Luancheng Xian', 1, 'luancheng-xian'),
(38087, 744031, 'cn', 'Luannan Xian', 1, 'luannan-xian'),
(38088, 744031, 'cn', 'Luanping Xian', 1, 'luanping-xian'),
(38089, 744031, 'cn', 'Lulong Xian', 1, 'lulong-xian'),
(38090, 744031, 'cn', 'Luquan Shi', 1, 'luquan-shi'),
(38091, 744031, 'cn', 'Mancheng Xian', 1, 'mancheng-xian'),
(38092, 744031, 'cn', 'Mengcun Huizu Zizhixian', 1, 'mengcun-huizu-zizhixian'),
(38093, 744031, 'cn', 'Nangong Shi', 1, 'nangong-shi'),
(38094, 744031, 'cn', 'Nanhe Xian', 1, 'nanhe-xian'),
(38095, 744031, 'cn', 'Nanpi Xian', 1, 'nanpi-xian'),
(38096, 744031, 'cn', 'Neiqiu Xian', 1, 'neiqiu-xian'),
(38097, 744031, 'cn', 'Ningjin Xian', 1, 'ningjin-xian'),
(38098, 744031, 'cn', 'Pingquan Xian', 1, 'pingquan-xian'),
(38099, 744031, 'cn', 'Pingshan Xian', 1, 'pingshan-xian'),
(38100, 744031, 'cn', 'Pingxiang Xian', 1, 'pingxiang-xian'),
(38101, 744031, 'cn', 'Qianxi Xian', 1, 'qianxi-xian'),
(38102, 744031, 'cn', 'Qian´an Shi', 1, 'qianan-shi'),
(38103, 744031, 'cn', 'Qing Xian', 1, 'qing-xian'),
(38104, 744031, 'cn', 'Qinghe Xian', 1, 'qinghe-xian'),
(38105, 744031, 'cn', 'Qinglong Manzu Zizhixian', 1, 'qinglong-manzu-zizhixian'),
(38106, 744031, 'cn', 'Qingyuan Xian', 1, 'qingyuan-xian'),
(38107, 744031, 'cn', 'Qinhuangdao Shi', 1, 'qinhuangdao-shi'),
(38108, 744031, 'cn', 'Qiu Xian', 1, 'qiu-xian'),
(38109, 744031, 'cn', 'Quyang Xian', 1, 'quyang-xian'),
(38110, 744031, 'cn', 'Quzhou Xian', 1, 'quzhou-xian'),
(38111, 744031, 'cn', 'Raoyang Xian', 1, 'raoyang-xian'),
(38112, 744031, 'cn', 'Qinhuangdao', 1, 'qinhuangdao'),
(38113, 744031, 'cn', 'Shijiazhuang', 1, 'shijiazhuang'),
(38114, 744031, 'cn', 'Tangshan', 1, 'tangshan'),
(38115, 744031, 'cn', 'Xingtai', 1, 'xingtai'),
(38116, 744031, 'cn', 'Zhangjiakou', 1, 'zhangjiakou');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744135, 'cn', 'Heilóngjang', 1, 'heilongjang');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38117, 744135, 'cn', 'Anda Shi', 1, 'anda-shi'),
(38118, 744135, 'cn', 'Baiquan Xian', 1, 'baiquan-xian'),
(38119, 744135, 'cn', 'Baoqing Xian', 1, 'baoqing-xian'),
(38120, 744135, 'cn', 'Bayan Xian', 1, 'bayan-xian'),
(38121, 744135, 'cn', 'Bei´an Shi', 1, 'beian-shi'),
(38122, 744135, 'cn', 'Bin Xian', 1, 'bin-xian'),
(38123, 744135, 'cn', 'Boli Xian', 1, 'boli-xian'),
(38124, 744135, 'cn', 'Da Hinggan Ling Diqu', 1, 'da-hinggan-ling-diqu'),
(38125, 744135, 'cn', 'Daqing Shi', 1, 'daqing-shi'),
(38126, 744135, 'cn', 'Dedu Xian', 1, 'dedu-xian'),
(38127, 744135, 'cn', 'Dongning Xian', 1, 'dongning-xian'),
(38128, 744135, 'cn', 'Dorbod Mongolzu Zizhixian', 1, 'dorbod-mongolzu-zizhixian'),
(38129, 744135, 'cn', 'Fangzheng Xian', 1, 'fangzheng-xian'),
(38130, 744135, 'cn', 'Fujin Xian', 1, 'fujin-xian'),
(38131, 744135, 'cn', 'Fuyu Xian', 1, 'fuyu-xian'),
(38132, 744135, 'cn', 'Fuyuan Xian', 1, 'fuyuan-xian'),
(38133, 744135, 'cn', 'Gannan Xian', 1, 'gannan-xian'),
(38134, 744135, 'cn', 'Hailin Xian', 1, 'hailin-xian'),
(38135, 744135, 'cn', 'Hailun Xian', 1, 'hailun-xian'),
(38136, 744135, 'cn', 'Harbin', 1, 'harbin'),
(38137, 744135, 'cn', 'Harbin Shi', 1, 'harbin-shi'),
(38138, 744135, 'cn', 'Hegang Shi', 1, 'hegang-shi'),
(38139, 744135, 'cn', 'Heihe Diqu', 1, 'heihe-diqu'),
(38140, 744135, 'cn', 'Heihe Shi', 1, 'heihe-shi'),
(38141, 744135, 'cn', 'Heilongjiang Sheng', 1, 'heilongjiang-sheng'),
(38142, 744135, 'cn', 'Huachuan Xian', 1, 'huachuan-xian'),
(38143, 744135, 'cn', 'Huanan Xian', 1, 'huanan-xian'),
(38144, 744135, 'cn', 'Hulan Xian', 1, 'hulan-xian'),
(38145, 744135, 'cn', 'Hulin Xian', 1, 'hulin-xian'),
(38146, 744135, 'cn', 'Huma Xian', 1, 'huma-xian'),
(38147, 744135, 'cn', 'Jiamusi Shi', 1, 'jiamusi-shi'),
(38148, 744135, 'cn', 'Jiayin Xian', 1, 'jiayin-xian'),
(38149, 744135, 'cn', 'Jidong Xian', 1, 'jidong-xian'),
(38150, 744135, 'cn', 'Jingpohu Shi', 1, 'jingpohu-shi'),
(38151, 744135, 'cn', 'Jixi Shi', 1, 'jixi-shi'),
(38152, 744135, 'cn', 'Jixian Xian', 1, 'jixian-xian'),
(38153, 744135, 'cn', 'Kedong Xian', 1, 'kedong-xian'),
(38154, 744135, 'cn', 'Keshan Xian', 1, 'keshan-xian'),
(38155, 744135, 'cn', 'Lanxi Xian', 1, 'lanxi-xian'),
(38156, 744135, 'cn', 'Lindian Xian', 1, 'lindian-xian'),
(38157, 744135, 'cn', 'Linkou Xian', 1, 'linkou-xian'),
(38158, 744135, 'cn', 'Longjiang Xian', 1, 'longjiang-xian'),
(38159, 744135, 'cn', 'Luobei Xian', 1, 'luobei-xian'),
(38160, 744135, 'cn', 'Mingshui Xian', 1, 'mingshui-xian'),
(38161, 744135, 'cn', 'Mishan Xian', 1, 'mishan-xian'),
(38162, 744135, 'cn', 'Mohe Xian', 1, 'mohe-xian'),
(38163, 744135, 'cn', 'M0udanjiang Shi', 1, 'm0udanjiang-shi'),
(38164, 744135, 'cn', 'Mulan Xian', 1, 'mulan-xian'),
(38165, 744135, 'cn', 'Muling Xian', 1, 'muling-xian'),
(38166, 744135, 'cn', 'Nehe Xian', 1, 'nehe-xian'),
(38167, 744135, 'cn', 'Nenjiang Xian', 1, 'nenjiang-xian'),
(38168, 744135, 'cn', 'Ning´an Xian', 1, 'ningan-xian'),
(38169, 744135, 'cn', 'Qinggang Xian', 1, 'qinggang-xian'),
(38170, 744135, 'cn', 'Qing´an Xian', 1, 'qingan-xian'),
(38171, 744135, 'cn', 'Qiqihar Shi', 1, 'qiqihar-shi'),
(38172, 744135, 'cn', 'Qitaihe Shi', 1, 'qitaihe-shi'),
(38173, 744135, 'cn', 'Raohe Xian', 1, 'raohe-xian'),
(38174, 744135, 'cn', 'Shangzhi Xian', 1, 'shangzhi-xian'),
(38175, 744135, 'cn', 'Shuangcheng Xian', 1, 'shuangcheng-xian'),
(38176, 744135, 'cn', 'Shuangyashan Shi', 1, 'shuangyashan-shi'),
(38177, 744135, 'cn', 'Songhuajiang Diqu', 1, 'songhuajiang-diqu'),
(38178, 744135, 'cn', 'Suibin Xian', 1, 'suibin-xian'),
(38179, 744135, 'cn', 'Suifenhe Shi', 1, 'suifenhe-shi'),
(38180, 744135, 'cn', 'Suihua Diqu', 1, 'suihua-diqu'),
(38181, 744135, 'cn', 'Suihua Shi', 1, 'suihua-shi'),
(38182, 744135, 'cn', 'Suileng Xian', 1, 'suileng-xian'),
(38183, 744135, 'cn', 'Sunwu Xian', 1, 'sunwu-xian'),
(38184, 744135, 'cn', 'Tahe Xian', 1, 'tahe-xian'),
(38185, 744135, 'cn', 'Tailai Xian', 1, 'tailai-xian'),
(38186, 744135, 'cn', 'Tangyuan Xian', 1, 'tangyuan-xian'),
(38187, 744135, 'cn', 'Tieli Xian', 1, 'tieli-xian'),
(38188, 744135, 'cn', 'Tonghe Xian', 1, 'tonghe-xian'),
(38189, 744135, 'cn', 'Tongjiang Xian', 1, 'tongjiang-xian'),
(38190, 744135, 'cn', 'Wangkui Xian', 1, 'wangkui-xian'),
(38191, 744135, 'cn', 'Wuchang Xian', 1, 'wuchang-xian'),
(38192, 744135, 'cn', 'Wudalianchi Shi', 1, 'wudalianchi-shi'),
(38193, 744135, 'cn', 'Xunke Xian', 1, 'xunke-xian'),
(38194, 744135, 'cn', 'Yanshou Xian', 1, 'yanshou-xian'),
(38195, 744135, 'cn', 'Yichun Shi', 1, 'yichun-shi'),
(38196, 744135, 'cn', 'Yilan Xian', 1, 'yilan-xian'),
(38197, 744135, 'cn', 'Yi´an Xian', 1, 'yian-xian'),
(38198, 744135, 'cn', 'Youyi Xian', 1, 'youyi-xian'),
(38199, 744135, 'cn', 'Zhaodong Shi', 1, 'zhaodong-shi'),
(38200, 744135, 'cn', 'Zhaoyuan Xian', 1, 'zhaoyuan-xian'),
(38201, 744135, 'cn', 'Zhaozhou Xian', 1, 'zhaozhou-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744222, 'cn', 'Hénán', 1, 'henan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38202, 744222, 'cn', 'Anyang Shi', 1, 'anyang-shi'),
(38203, 744222, 'cn', 'Anyang Xian', 1, 'anyang-xian'),
(38204, 744222, 'cn', 'Baofeng Xian', 1, 'baofeng-xian'),
(38205, 744222, 'cn', 'Biyang Xian', 1, 'biyang-xian'),
(38206, 744222, 'cn', 'Bo´ai Xian', 1, 'boai-xian'),
(38207, 744222, 'cn', 'Changge Shi', 1, 'changge-shi'),
(38208, 744222, 'cn', 'Changyuan Xian', 1, 'changyuan-xian'),
(38209, 744222, 'cn', 'Dancheng Xian', 1, 'dancheng-xian'),
(38210, 744222, 'cn', 'Dengfeng Shi', 1, 'dengfeng-shi'),
(38211, 744222, 'cn', 'Dengzhou Shi', 1, 'dengzhou-shi'),
(38212, 744222, 'cn', 'Fan Xian', 1, 'fan-xian'),
(38213, 744222, 'cn', 'Fangcheng Xian', 1, 'fangcheng-xian'),
(38214, 744222, 'cn', 'Fengqiu Xian', 1, 'fengqiu-xian'),
(38215, 744222, 'cn', 'Fugou Xian', 1, 'fugou-xian'),
(38216, 744222, 'cn', 'Gongyi Shi', 1, 'gongyi-shi'),
(38217, 744222, 'cn', 'Guangshan Xian', 1, 'guangshan-xian'),
(38218, 744222, 'cn', 'Gushi Xian', 1, 'gushi-xian'),
(38219, 744222, 'cn', 'Hebi Shi', 1, 'hebi-shi'),
(38220, 744222, 'cn', 'Hua Xian', 1, 'hua-xian'),
(38221, 744222, 'cn', 'Huaibin Xian', 1, 'huaibin-xian'),
(38222, 744222, 'cn', 'Huaiyang Xian', 1, 'huaiyang-xian'),
(38223, 744222, 'cn', 'Huangchuan Xian', 1, 'huangchuan-xian'),
(38224, 744222, 'cn', 'Huixian Shi', 1, 'huixian-shi'),
(38225, 744222, 'cn', 'Huojia Xian', 1, 'huojia-xian'),
(38226, 744222, 'cn', 'Jia Xian', 1, 'jia-xian'),
(38227, 744222, 'cn', 'Jiaozuo Shi', 1, 'jiaozuo-shi'),
(38228, 744222, 'cn', 'Jiyuan Shi', 1, 'jiyuan-shi'),
(38229, 744222, 'cn', 'Kaifeng Shi', 1, 'kaifeng-shi'),
(38230, 744222, 'cn', 'Kaifeng Xian', 1, 'kaifeng-xian'),
(38231, 744222, 'cn', 'Lankao Xian', 1, 'lankao-xian'),
(38232, 744222, 'cn', 'Lingbao Shi', 1, 'lingbao-shi'),
(38233, 744222, 'cn', 'Linying Xian', 1, 'linying-xian'),
(38234, 744222, 'cn', 'Linzhou Shi', 1, 'linzhou-shi'),
(38235, 744222, 'cn', 'Luanchuan Xian', 1, 'luanchuan-xian'),
(38236, 744222, 'cn', 'Luohe Shi', 1, 'luohe-shi'),
(38237, 744222, 'cn', 'Luoning Xian', 1, 'luoning-xian'),
(38238, 744222, 'cn', 'Luoshan Xian', 1, 'luoshan-xian'),
(38239, 744222, 'cn', 'Luoyang Shi', 1, 'luoyang-shi'),
(38240, 744222, 'cn', 'Lushan Xian', 1, 'lushan-xian'),
(38241, 744222, 'cn', 'Lushi Xian', 1, 'lushi-xian'),
(38242, 744222, 'cn', 'Luyi Xian', 1, 'luyi-xian'),
(38243, 744222, 'cn', 'Mengjin Xian', 1, 'mengjin-xian'),
(38244, 744222, 'cn', 'Mengzhou Shi', 1, 'mengzhou-shi'),
(38245, 744222, 'cn', 'Mianchi Xian', 1, 'mianchi-xian'),
(38246, 744222, 'cn', 'Minquan Xian', 1, 'minquan-xian'),
(38247, 744222, 'cn', 'Nanle Xian', 1, 'nanle-xian'),
(38248, 744222, 'cn', 'Nanyang Shi', 1, 'nanyang-shi'),
(38249, 744222, 'cn', 'Nanzhao Xian', 1, 'nanzhao-xian'),
(38250, 744222, 'cn', 'Neihuang Xian', 1, 'neihuang-xian'),
(38251, 744222, 'cn', 'Neixiang Xian', 1, 'neixiang-xian'),
(38252, 744222, 'cn', 'Ningling Xian', 1, 'ningling-xian'),
(38253, 744222, 'cn', 'Pingdingshan Shi', 1, 'pingdingshan-shi'),
(38254, 744222, 'cn', 'Pingyu Xian', 1, 'pingyu-xian'),
(38255, 744222, 'cn', 'Puyang Shi', 1, 'puyang-shi'),
(38256, 744222, 'cn', 'Puyang Xian', 1, 'puyang-xian'),
(38257, 744222, 'cn', 'Qi Xian', 1, 'qi-xian'),
(38258, 744222, 'cn', 'Qingfeng Xian', 1, 'qingfeng-xian'),
(38259, 744222, 'cn', 'Qinyang Shi', 1, 'qinyang-shi'),
(38260, 744222, 'cn', 'Queshan Xian', 1, 'queshan-xian'),
(38261, 744222, 'cn', 'Runan Xian', 1, 'runan-xian'),
(38262, 744222, 'cn', 'Ruyang Xian', 1, 'ruyang-xian'),
(38263, 744222, 'cn', 'Ruzhou Shi', 1, 'ruzhou-shi'),
(38264, 744222, 'cn', 'Sanmenxia Shi', 1, 'sanmenxia-shi'),
(38265, 744222, 'cn', 'Shan Xian', 1, 'shan-xian'),
(38266, 744222, 'cn', 'Shangcai Xian', 1, 'shangcai-xian'),
(38267, 744222, 'cn', 'Shangcheng Xian', 1, 'shangcheng-xian'),
(38268, 744222, 'cn', 'Shangqiu Shi', 1, 'shangqiu-shi'),
(38269, 744222, 'cn', 'Shangshui Xian', 1, 'shangshui-xian'),
(38270, 744222, 'cn', 'Shenqiu Xian', 1, 'shenqiu-xian'),
(38271, 744222, 'cn', 'Sheqi Xian', 1, 'sheqi-xian'),
(38272, 744222, 'cn', 'Song Xian', 1, 'song-xian'),
(38273, 744222, 'cn', 'Sui Xian', 1, 'sui-xian'),
(38274, 744222, 'cn', 'Suiping Xian', 1, 'suiping-xian'),
(38275, 744222, 'cn', 'Taikang Xian', 1, 'taikang-xian'),
(38276, 744222, 'cn', 'Taiqian Xian', 1, 'taiqian-xian'),
(38277, 744222, 'cn', 'Tanghe Xian', 1, 'tanghe-xian'),
(38278, 744222, 'cn', 'Tangyin Xian', 1, 'tangyin-xian'),
(38279, 744222, 'cn', 'Tongbai Xian', 1, 'tongbai-xian'),
(38280, 744222, 'cn', 'Tongxu Xian', 1, 'tongxu-xian'),
(38281, 744222, 'cn', 'Weihui Xian', 1, 'weihui-xian'),
(38282, 744222, 'cn', 'Weishi Xian', 1, 'weishi-xian'),
(38283, 744222, 'cn', 'Wen Xian', 1, 'wen-xian'),
(38284, 744222, 'cn', 'Wugang Shi', 1, 'wugang-shi'),
(38285, 744222, 'cn', 'Wuyang Xian', 1, 'wuyang-xian'),
(38286, 744222, 'cn', 'Wuzhi Xian', 1, 'wuzhi-xian'),
(38287, 744222, 'cn', 'Xi Xian', 1, 'xi-xian'),
(38288, 744222, 'cn', 'Xiangcheng Shi', 1, 'xiangcheng-shi'),
(38289, 744222, 'cn', 'Xiangcheng Xian', 1, 'xiangcheng-xian'),
(38290, 744222, 'cn', 'Xiayi Xian', 1, 'xiayi-xian'),
(38291, 744222, 'cn', 'Xichuan Xian', 1, 'xichuan-xian'),
(38292, 744222, 'cn', 'Xihua Xian', 1, 'xihua-xian'),
(38293, 744222, 'cn', 'Xin Xian', 1, 'xin-xian'),
(38294, 744222, 'cn', 'Xincai Xian', 1, 'xincai-xian'),
(38295, 744222, 'cn', 'Xingyang Xian', 1, 'xingyang-xian'),
(38296, 744222, 'cn', 'Xuchang', 1, 'xuchang'),
(38297, 744222, 'cn', 'Zhengzhou', 1, 'zhengzhou'),
(38298, 744222, 'cn', 'Zhoukou', 1, 'zhoukou'),
(38299, 744222, 'cn', 'Zhumadian', 1, 'zhumadian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744321, 'cn', 'Húbei', 1, 'hubei');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38300, 744321, 'cn', 'Anlu Xian', 1, 'anlu-xian'),
(38301, 744321, 'cn', 'Badong Xian', 1, 'badong-xian'),
(38302, 744321, 'cn', 'Baokang Xian', 1, 'baokang-xian'),
(38303, 744321, 'cn', 'Changyang Tujiazu Zizhixian', 1, 'changyang-tujiazu-zizhixian'),
(38304, 744321, 'cn', 'Chongyang Xian', 1, 'chongyang-xian'),
(38305, 744321, 'cn', 'Dangyang Shi', 1, 'dangyang-shi'),
(38306, 744321, 'cn', 'Danjiangkou Shi', 1, 'danjiangkou-shi'),
(38307, 744321, 'cn', 'Dawu Xian', 1, 'dawu-xian'),
(38308, 744321, 'cn', 'Daye Xian', 1, 'daye-xian'),
(38309, 744321, 'cn', 'Enshi Shi', 1, 'enshi-shi'),
(38310, 744321, 'cn', 'Exi Tujiazu Miaozu Zizhizhou', 1, 'exi-tujiazu-miaozu-zizhizhou'),
(38311, 744321, 'cn', 'Ezhou Shi', 1, 'ezhou-shi'),
(38312, 744321, 'cn', 'Fang Xian', 1, 'fang-xian'),
(38313, 744321, 'cn', 'Gong´an Xian', 1, 'gongan-xian'),
(38314, 744321, 'cn', 'Guangji Xian', 1, 'guangji-xian'),
(38315, 744321, 'cn', 'Gucheng Xian', 1, 'gucheng-xian'),
(38316, 744321, 'cn', 'Hanchuan Xian', 1, 'hanchuan-xian'),
(38317, 744321, 'cn', 'Hanyang Xian', 1, 'hanyang-xian'),
(38318, 744321, 'cn', 'Hefeng Xian', 1, 'hefeng-xian'),
(38319, 744321, 'cn', 'Honghu Xian', 1, 'honghu-xian'),
(38320, 744321, 'cn', 'Hong´an Xian', 1, 'hongan-xian'),
(38321, 744321, 'cn', 'Huanggang Diqu', 1, 'huanggang-diqu'),
(38322, 744321, 'cn', 'Huanggang Xian', 1, 'huanggang-xian'),
(38323, 744321, 'cn', 'Huangmei Xian', 1, 'huangmei-xian'),
(38324, 744321, 'cn', 'Huangpi Xian', 1, 'huangpi-xian'),
(38325, 744321, 'cn', 'Huangshi Shi', 1, 'huangshi-shi'),
(38326, 744321, 'cn', 'Hubei Sheng', 1, 'hubei-sheng'),
(38327, 744321, 'cn', 'Jiangling Xian', 1, 'jiangling-xian'),
(38328, 744321, 'cn', 'Jianli Xian', 1, 'jianli-xian'),
(38329, 744321, 'cn', 'Jianshi Xian', 1, 'jianshi-xian'),
(38330, 744321, 'cn', 'Jiayu Xian', 1, 'jiayu-xian'),
(38331, 744321, 'cn', 'Jingmen Shi', 1, 'jingmen-shi'),
(38332, 744321, 'cn', 'Jingshan Xian', 1, 'jingshan-xian'),
(38333, 744321, 'cn', 'Jingzhou Diqu', 1, 'jingzhou-diqu'),
(38334, 744321, 'cn', 'Laifeng Xian', 1, 'laifeng-xian'),
(38335, 744321, 'cn', 'Laohekou Shi', 1, 'laohekou-shi'),
(38336, 744321, 'cn', 'Lichuan Shi', 1, 'lichuan-shi'),
(38337, 744321, 'cn', 'Luotian Xian', 1, 'luotian-xian'),
(38338, 744321, 'cn', 'Macheng Shi', 1, 'macheng-shi'),
(38339, 744321, 'cn', 'Nanzhang Xian', 1, 'nanzhang-xian'),
(38340, 744321, 'cn', 'Puqi Shi', 1, 'puqi-shi'),
(38341, 744321, 'cn', 'Qianjiang Xian', 1, 'qianjiang-xian'),
(38342, 744321, 'cn', 'Qichun Xian', 1, 'qichun-xian'),
(38343, 744321, 'cn', 'Shashi Shi', 1, 'shashi-shi'),
(38344, 744321, 'cn', 'Shennongjia Linqu', 1, 'shennongjia-linqu'),
(38345, 744321, 'cn', 'Shishou Shi', 1, 'shishou-shi'),
(38346, 744321, 'cn', 'Shiyan Shi', 1, 'shiyan-shi'),
(38347, 744321, 'cn', 'Songzi Shi', 1, 'songzi-shi'),
(38348, 744321, 'cn', 'Suizhou Shi', 1, 'suizhou-shi'),
(38349, 744321, 'cn', 'Tianmen Xian', 1, 'tianmen-xian'),
(38350, 744321, 'cn', 'Tongcheng Xian', 1, 'tongcheng-xian'),
(38351, 744321, 'cn', 'Tongshan Xian', 1, 'tongshan-xian'),
(38352, 744321, 'cn', 'Wuchang Xian', 1, 'wuchang-xian'),
(38353, 744321, 'cn', 'Wufeng Tujiazu Zizhixian', 1, 'wufeng-tujiazu-zizhixian'),
(38354, 744321, 'cn', 'Wuhan', 1, 'wuhan'),
(38355, 744321, 'cn', 'Wuhan Shi', 1, 'wuhan-shi'),
(38356, 744321, 'cn', 'Xianfeng Xian', 1, 'xianfeng-xian'),
(38357, 744321, 'cn', 'Xiangfan Shi', 1, 'xiangfan-shi'),
(38358, 744321, 'cn', 'Xiangyang Xian', 1, 'xiangyang-xian'),
(38359, 744321, 'cn', 'Xianning Diqu', 1, 'xianning-diqu'),
(38360, 744321, 'cn', 'Xianning Shi', 1, 'xianning-shi'),
(38361, 744321, 'cn', 'Xiantao Shi', 1, 'xiantao-shi'),
(38362, 744321, 'cn', 'Xiaogan Diqu', 1, 'xiaogan-diqu'),
(38363, 744321, 'cn', 'Xiaogan Shi', 1, 'xiaogan-shi'),
(38364, 744321, 'cn', 'Xingshan Xian', 1, 'xingshan-xian'),
(38365, 744321, 'cn', 'Xinzhou Xian', 1, 'xinzhou-xian'),
(38366, 744321, 'cn', 'Xishui Xian', 1, 'xishui-xian'),
(38367, 744321, 'cn', 'Xuan´en Xian', 1, 'xuanen-xian'),
(38368, 744321, 'cn', 'Yangxin Xian', 1, 'yangxin-xian'),
(38369, 744321, 'cn', 'Yichang Shi', 1, 'yichang-shi'),
(38370, 744321, 'cn', 'Yichang Xian', 1, 'yichang-xian'),
(38371, 744321, 'cn', 'Yicheng Xian', 1, 'yicheng-xian'),
(38372, 744321, 'cn', 'Yidu Shi', 1, 'yidu-shi'),
(38373, 744321, 'cn', 'Yingcheng Shi', 1, 'yingcheng-shi'),
(38374, 744321, 'cn', 'Yingshan Xian', 1, 'yingshan-xian'),
(38375, 744321, 'cn', 'Yuan´an Xian', 1, 'yuanan-xian'),
(38376, 744321, 'cn', 'Yun Xian', 1, 'yun-xian'),
(38377, 744321, 'cn', 'Yunmeng Xian', 1, 'yunmeng-xian'),
(38378, 744321, 'cn', 'Yunxi Xian', 1, 'yunxi-xian'),
(38379, 744321, 'cn', 'Zaoyang Xian', 1, 'zaoyang-xian'),
(38380, 744321, 'cn', 'Zhijiang Shi', 1, 'zhijiang-shi'),
(38381, 744321, 'cn', 'Zhongxiang Xian', 1, 'zhongxiang-xian'),
(38382, 744321, 'cn', 'Zhushan Xian', 1, 'zhushan-xian'),
(38383, 744321, 'cn', 'Zhuxi Xian', 1, 'zhuxi-xian'),
(38384, 744321, 'cn', 'Zigui Xian', 1, 'zigui-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744408, 'cn', 'Húnán', 1, 'hunan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38385, 744408, 'cn', 'Anhua Xian', 1, 'anhua-xian'),
(38386, 744408, 'cn', 'Anren Xian', 1, 'anren-xian'),
(38387, 744408, 'cn', 'Anxiang Xian', 1, 'anxiang-xian'),
(38388, 744408, 'cn', 'Baojing Xian', 1, 'baojing-xian'),
(38389, 744408, 'cn', 'Chaling Xian', 1, 'chaling-xian'),
(38390, 744408, 'cn', 'Changde Shi', 1, 'changde-shi'),
(38391, 744408, 'cn', 'Changning Shi', 1, 'changning-shi'),
(38392, 744408, 'cn', 'Changsha', 1, 'changsha'),
(38393, 744408, 'cn', 'Changsha Shi', 1, 'changsha-shi'),
(38394, 744408, 'cn', 'Changsha Xian', 1, 'changsha-xian'),
(38395, 744408, 'cn', 'Chen Xian', 1, 'chen-xian'),
(38396, 744408, 'cn', 'Chengbu Miaozu Zizhixian', 1, 'chengbu-miaozu-zizhixian'),
(38397, 744408, 'cn', 'Chenxi Xian', 1, 'chenxi-xian'),
(38398, 744408, 'cn', 'Chenzhou Diqu', 1, 'chenzhou-diqu'),
(38399, 744408, 'cn', 'Chenzhou Shi', 1, 'chenzhou-shi'),
(38400, 744408, 'cn', 'Cili Xian', 1, 'cili-xian'),
(38401, 744408, 'cn', 'Dao Xian', 1, 'dao-xian'),
(38402, 744408, 'cn', 'Dongkou Xian', 1, 'dongkou-xian'),
(38403, 744408, 'cn', 'Dong´an Xian', 1, 'dongan-xian'),
(38404, 744408, 'cn', 'Fenghuang Xian', 1, 'fenghuang-xian'),
(38405, 744408, 'cn', 'Guidong Xian', 1, 'guidong-xian'),
(38406, 744408, 'cn', 'Guiyang Xian', 1, 'guiyang-xian'),
(38407, 744408, 'cn', 'Guzhang Xian', 1, 'guzhang-xian'),
(38408, 744408, 'cn', 'Hanshou Xian', 1, 'hanshou-xian'),
(38409, 744408, 'cn', 'Hengdong Xian', 1, 'hengdong-xian'),
(38410, 744408, 'cn', 'Hengnan Xian', 1, 'hengnan-xian'),
(38411, 744408, 'cn', 'Hengshan Xian', 1, 'hengshan-xian'),
(38412, 744408, 'cn', 'Hengyang Shi', 1, 'hengyang-shi'),
(38413, 744408, 'cn', 'Hengyang Xian', 1, 'hengyang-xian'),
(38414, 744408, 'cn', 'Hongjiang Shi', 1, 'hongjiang-shi'),
(38415, 744408, 'cn', 'Huaihua Shi', 1, 'huaihua-shi'),
(38416, 744408, 'cn', 'Huarong Xian', 1, 'huarong-xian'),
(38417, 744408, 'cn', 'Huayuan Xian', 1, 'huayuan-xian'),
(38418, 744408, 'cn', 'Huitong Xian', 1, 'huitong-xian'),
(38419, 744408, 'cn', 'Jiahe Xian', 1, 'jiahe-xian'),
(38420, 744408, 'cn', 'Jianghua Yaozu Zizhixian', 1, 'jianghua-yaozu-zizhixian'),
(38421, 744408, 'cn', 'Jiangyong Xian', 1, 'jiangyong-xian'),
(38422, 744408, 'cn', 'Jingzhou Miaozudongzu Zhizixian', 1, 'jingzhou-miaozudongzu-zhizixian'),
(38423, 744408, 'cn', 'Jinshi Shi', 1, 'jinshi-shi'),
(38424, 744408, 'cn', 'Jishou Shi', 1, 'jishou-shi'),
(38425, 744408, 'cn', 'Lanshan Xian', 1, 'lanshan-xian'),
(38426, 744408, 'cn', 'Leiyang Shi', 1, 'leiyang-shi'),
(38427, 744408, 'cn', 'Lengshuijiang Shi', 1, 'lengshuijiang-shi'),
(38428, 744408, 'cn', 'Lengshuitan Shi', 1, 'lengshuitan-shi'),
(38429, 744408, 'cn', 'Li Xian', 1, 'li-xian'),
(38430, 744408, 'cn', 'Lianyuan Shi', 1, 'lianyuan-shi'),
(38431, 744408, 'cn', 'Liling Shi', 1, 'liling-shi'),
(38432, 744408, 'cn', 'Linli Xian', 1, 'linli-xian'),
(38433, 744408, 'cn', 'Linwu Xian', 1, 'linwu-xian'),
(38434, 744408, 'cn', 'Linxiang Shi', 1, 'linxiang-shi'),
(38435, 744408, 'cn', 'Liuyang Xian', 1, 'liuyang-xian'),
(38436, 744408, 'cn', 'Longhui Xian', 1, 'longhui-xian'),
(38437, 744408, 'cn', 'Longshan Xian', 1, 'longshan-xian'),
(38438, 744408, 'cn', 'Loudi Diqu', 1, 'loudi-diqu'),
(38439, 744408, 'cn', 'Loudi Shi', 1, 'loudi-shi'),
(38440, 744408, 'cn', 'Luxi Xian', 1, 'luxi-xian'),
(38441, 744408, 'cn', 'Mayang Miaozu Zhizixian', 1, 'mayang-miaozu-zhizixian'),
(38442, 744408, 'cn', 'Miluo Xian', 1, 'miluo-xian'),
(38443, 744408, 'cn', 'Nan Xian', 1, 'nan-xian'),
(38444, 744408, 'cn', 'Ningxiang Xian', 1, 'ningxiang-xian'),
(38445, 744408, 'cn', 'Ningyuan Xian', 1, 'ningyuan-xian'),
(38446, 744408, 'cn', 'Pingjiang Xian', 1, 'pingjiang-xian'),
(38447, 744408, 'cn', 'Qidong Xian', 1, 'qidong-xian'),
(38448, 744408, 'cn', 'Qiyang Xian', 1, 'qiyang-xian'),
(38449, 744408, 'cn', 'Rucheng Xian', 1, 'rucheng-xian'),
(38450, 744408, 'cn', 'Sangzhi Xian', 1, 'sangzhi-xian'),
(38451, 744408, 'cn', 'Shaodong Xian', 1, 'shaodong-xian'),
(38452, 744408, 'cn', 'Shaoyang Shi', 1, 'shaoyang-shi'),
(38453, 744408, 'cn', 'Shaoyang Xian', 1, 'shaoyang-xian'),
(38454, 744408, 'cn', 'Shimen Xian', 1, 'shimen-xian'),
(38455, 744408, 'cn', 'Shuangfeng Xian', 1, 'shuangfeng-xian'),
(38456, 744408, 'cn', 'Shuangpai Xian', 1, 'shuangpai-xian'),
(38457, 744408, 'cn', 'Suining Xian', 1, 'suining-xian'),
(38458, 744408, 'cn', 'Taojiang Xian', 1, 'taojiang-xian'),
(38459, 744408, 'cn', 'Taoyuan Xian', 1, 'taoyuan-xian'),
(38460, 744408, 'cn', 'Tongdao Dongzu Zizhixian', 1, 'tongdao-dongzu-zizhixian'),
(38461, 744408, 'cn', 'Wangcheng Xian', 1, 'wangcheng-xian'),
(38462, 744408, 'cn', 'Wugang Xian', 1, 'wugang-xian'),
(38463, 744408, 'cn', 'Xiangtan Shi', 1, 'xiangtan-shi'),
(38464, 744408, 'cn', 'Xiangtan Xian', 1, 'xiangtan-xian'),
(38465, 744408, 'cn', 'Xiangxi Tujiazu Miaozu Zizhizhou', 1, 'xiangxi-tujiazu-miaozu-zizhizhou'),
(38466, 744408, 'cn', 'Xiangxiang Shi', 1, 'xiangxiang-shi'),
(38467, 744408, 'cn', 'Xiangyin Xian', 1, 'xiangyin-xian'),
(38468, 744408, 'cn', 'Xinhua Xian', 1, 'xinhua-xian'),
(38469, 744408, 'cn', 'Xinhuang Dongzu Zizhixian', 1, 'xinhuang-dongzu-zizhixian'),
(38470, 744408, 'cn', 'Xinning Xian', 1, 'xinning-xian'),
(38471, 744408, 'cn', 'Xinshao Xian', 1, 'xinshao-xian'),
(38472, 744408, 'cn', 'Xintian Xian', 1, 'xintian-xian'),
(38473, 744408, 'cn', 'Xupu Xian', 1, 'xupu-xian'),
(38474, 744408, 'cn', 'Yanling Xian', 1, 'yanling-xian'),
(38475, 744408, 'cn', 'Yiyang Diqu', 1, 'yiyang-diqu'),
(38476, 744408, 'cn', 'Yiyang Shi', 1, 'yiyang-shi'),
(38477, 744408, 'cn', 'Yiyang Xian', 1, 'yiyang-xian'),
(38478, 744408, 'cn', 'Yizhang Xian', 1, 'yizhang-xian'),
(38479, 744408, 'cn', 'Yongshun Xian', 1, 'yongshun-xian'),
(38480, 744408, 'cn', 'Yongxing Xian', 1, 'yongxing-xian'),
(38481, 744408, 'cn', 'Zhuzhou', 1, 'zhuzhou');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744506, 'cn', 'Jiangsu', 1, 'jiangsu');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38482, 744506, 'cn', 'Baoying Xian', 1, 'baoying-xian'),
(38483, 744506, 'cn', 'Binhai Xian', 1, 'binhai-xian'),
(38484, 744506, 'cn', 'Changshu Shi', 1, 'changshu-shi'),
(38485, 744506, 'cn', 'Changzhou Shi', 1, 'changzhou-shi'),
(38486, 744506, 'cn', 'Dafeng Xian', 1, 'dafeng-xian'),
(38487, 744506, 'cn', 'Dantu Xian', 1, 'dantu-xian'),
(38488, 744506, 'cn', 'Danyang Xian', 1, 'danyang-xian'),
(38489, 744506, 'cn', 'Donghai Xian', 1, 'donghai-xian'),
(38490, 744506, 'cn', 'Dongtai Xian', 1, 'dongtai-xian'),
(38491, 744506, 'cn', 'Feng Xian', 1, 'feng-xian'),
(38492, 744506, 'cn', 'Funing Xian', 1, 'funing-xian'),
(38493, 744506, 'cn', 'Ganyu Xian', 1, 'ganyu-xian'),
(38494, 744506, 'cn', 'Gaochun Xian', 1, 'gaochun-xian'),
(38495, 744506, 'cn', 'Gaoyou Shi', 1, 'gaoyou-shi'),
(38496, 744506, 'cn', 'Guannan Xian', 1, 'guannan-xian'),
(38497, 744506, 'cn', 'Guanyun Xian', 1, 'guanyun-xian'),
(38498, 744506, 'cn', 'Haimen Shi', 1, 'haimen-shi'),
(38499, 744506, 'cn', 'Hai´an Xian', 1, 'haian-xian'),
(38500, 744506, 'cn', 'Hanjiang Xian', 1, 'hanjiang-xian'),
(38501, 744506, 'cn', 'Hongze Xian', 1, 'hongze-xian'),
(38502, 744506, 'cn', 'Huaiyin Shi', 1, 'huaiyin-shi'),
(38503, 744506, 'cn', 'Huaiyin Xian', 1, 'huaiyin-xian'),
(38504, 744506, 'cn', 'Huai´an Xian', 1, 'huaian-xian'),
(38505, 744506, 'cn', 'Jiangdu Shi', 1, 'jiangdu-shi'),
(38506, 744506, 'cn', 'Jiangning Xian', 1, 'jiangning-xian'),
(38507, 744506, 'cn', 'Jiangpu Xian', 1, 'jiangpu-xian'),
(38508, 744506, 'cn', 'Jiangsu Sheng', 1, 'jiangsu-sheng'),
(38509, 744506, 'cn', 'Jiangyin Xian', 1, 'jiangyin-xian'),
(38510, 744506, 'cn', 'Jianhu Xian', 1, 'jianhu-xian'),
(38511, 744506, 'cn', 'Jingjiang Xian', 1, 'jingjiang-xian'),
(38512, 744506, 'cn', 'Jinhu Xian', 1, 'jinhu-xian'),
(38513, 744506, 'cn', 'Jintan Shi', 1, 'jintan-shi'),
(38514, 744506, 'cn', 'Jurong Xian', 1, 'jurong-xian'),
(38515, 744506, 'cn', 'Kunshan Shi', 1, 'kunshan-shi'),
(38516, 744506, 'cn', 'Lianshui Xian', 1, 'lianshui-xian'),
(38517, 744506, 'cn', 'Lianyungang Shi', 1, 'lianyungang-shi'),
(38518, 744506, 'cn', 'Lishui Xian', 1, 'lishui-xian'),
(38519, 744506, 'cn', 'Liyang Xian', 1, 'liyang-xian'),
(38520, 744506, 'cn', 'Luhe Xian', 1, 'luhe-xian'),
(38521, 744506, 'cn', 'Nanjing', 1, 'nanjing'),
(38522, 744506, 'cn', 'Nantong Xian', 1, 'nantong-xian'),
(38523, 744506, 'cn', 'Pei Xian', 1, 'pei-xian'),
(38524, 744506, 'cn', 'Pi Xian', 1, 'pi-xian'),
(38525, 744506, 'cn', 'Qidong Shi', 1, 'qidong-shi'),
(38526, 744506, 'cn', 'Rudong Xian', 1, 'rudong-xian'),
(38527, 744506, 'cn', 'Rugao Xian', 1, 'rugao-xian'),
(38528, 744506, 'cn', 'Sheyang Xian', 1, 'sheyang-xian'),
(38529, 744506, 'cn', 'Shuyang Xian', 1, 'shuyang-xian'),
(38530, 744506, 'cn', 'Sihong Xian', 1, 'sihong-xian'),
(38531, 744506, 'cn', 'Siyang Xian', 1, 'siyang-xian'),
(38532, 744506, 'cn', 'Suining Xian', 1, 'suining-xian'),
(38533, 744506, 'cn', 'Suqian Xian', 1, 'suqian-xian'),
(38534, 744506, 'cn', 'Suzhou Shi', 1, 'suzhou-shi'),
(38535, 744506, 'cn', 'Tai Xian', 1, 'tai-xian'),
(38536, 744506, 'cn', 'Taicang Xian', 1, 'taicang-xian'),
(38537, 744506, 'cn', 'Taixing Xian', 1, 'taixing-xian'),
(38538, 744506, 'cn', 'Taizhou Shi', 1, 'taizhou-shi'),
(38539, 744506, 'cn', 'Tongshan Xian', 1, 'tongshan-xian'),
(38540, 744506, 'cn', 'Wu Xian', 1, 'wu-xian'),
(38541, 744506, 'cn', 'Wujiang Shi', 1, 'wujiang-shi'),
(38542, 744506, 'cn', 'Wujin Xian', 1, 'wujin-xian'),
(38543, 744506, 'cn', 'Wuxi Shi', 1, 'wuxi-shi'),
(38544, 744506, 'cn', 'Wuxi Xian', 1, 'wuxi-xian'),
(38545, 744506, 'cn', 'Xiangshui Xian', 1, 'xiangshui-xian'),
(38546, 744506, 'cn', 'Xinghua Xian', 1, 'xinghua-xian'),
(38547, 744506, 'cn', 'Xinyi Xian', 1, 'xinyi-xian'),
(38548, 744506, 'cn', 'Xuyi Xian', 1, 'xuyi-xian'),
(38549, 744506, 'cn', 'Xuzhou Shi', 1, 'xuzhou-shi'),
(38550, 744506, 'cn', 'Yancheng Shi', 1, 'yancheng-shi'),
(38551, 744506, 'cn', 'Yangzhong Shi', 1, 'yangzhong-shi'),
(38552, 744506, 'cn', 'Yangzhou Shi', 1, 'yangzhou-shi'),
(38553, 744506, 'cn', 'Yixing Xian', 1, 'yixing-xian'),
(38554, 744506, 'cn', 'Yizheng Shi', 1, 'yizheng-shi'),
(38555, 744506, 'cn', 'Zhangjiagang Shi', 1, 'zhangjiagang-shi'),
(38556, 744506, 'cn', 'Zhenjiang Shi', 1, 'zhenjiang-shi');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744582, 'cn', 'Jiangxiiangxi', 1, 'jiangxiiangxi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38557, 744582, 'cn', 'Anfu Xian', 1, 'anfu-xian'),
(38558, 744582, 'cn', 'Anyi Xian', 1, 'anyi-xian'),
(38559, 744582, 'cn', 'Anyuan Xian', 1, 'anyuan-xian'),
(38560, 744582, 'cn', 'Boyang Xian', 1, 'boyang-xian'),
(38561, 744582, 'cn', 'Changjiang Qu', 1, 'changjiang-qu'),
(38562, 744582, 'cn', 'Chongren Xian', 1, 'chongren-xian'),
(38563, 744582, 'cn', 'Chongyi Xian', 1, 'chongyi-xian'),
(38564, 744582, 'cn', 'Dayu Xian', 1, 'dayu-xian'),
(38565, 744582, 'cn', 'Dexing Shi', 1, 'dexing-shi'),
(38566, 744582, 'cn', 'De´an Xian', 1, 'dean-xian'),
(38567, 744582, 'cn', 'Dingnan Xian', 1, 'dingnan-xian'),
(38568, 744582, 'cn', 'Dongxiang Xian', 1, 'dongxiang-xian'),
(38569, 744582, 'cn', 'Duchang Xian', 1, 'duchang-xian'),
(38570, 744582, 'cn', 'Fengcheng Shi', 1, 'fengcheng-shi'),
(38571, 744582, 'cn', 'Fengxin Xian', 1, 'fengxin-xian'),
(38572, 744582, 'cn', 'Fenyi Xian', 1, 'fenyi-xian'),
(38573, 744582, 'cn', 'Fuliang Xian', 1, 'fuliang-xian'),
(38574, 744582, 'cn', 'Fuzhou Diqu', 1, 'fuzhou-diqu'),
(38575, 744582, 'cn', 'Fuzhou Shi', 1, 'fuzhou-shi'),
(38576, 744582, 'cn', 'Gan Xian', 1, 'gan-xian'),
(38577, 744582, 'cn', 'Ganzhou Diqu', 1, 'ganzhou-diqu'),
(38578, 744582, 'cn', 'Ganzhou Shi', 1, 'ganzhou-shi'),
(38579, 744582, 'cn', 'Gao´an Shi', 1, 'gaoan-shi'),
(38580, 744582, 'cn', 'Guangchang Xian', 1, 'guangchang-xian'),
(38581, 744582, 'cn', 'Guangfeng Xian', 1, 'guangfeng-xian'),
(38582, 744582, 'cn', 'Guixi Shi', 1, 'guixi-shi'),
(38583, 744582, 'cn', 'Hengfeng Xian', 1, 'hengfeng-xian'),
(38584, 744582, 'cn', 'Huichang Xian', 1, 'huichang-xian'),
(38585, 744582, 'cn', 'Hukou Xian', 1, 'hukou-xian'),
(38586, 744582, 'cn', 'Jingdezhen Shi', 1, 'jingdezhen-shi'),
(38587, 744582, 'cn', 'Jinggangshan Shi', 1, 'jinggangshan-shi'),
(38588, 744582, 'cn', 'Jing´an Xian', 1, 'jingan-xian'),
(38589, 744582, 'cn', 'Jinxi Xian', 1, 'jinxi-xian'),
(38590, 744582, 'cn', 'Jinxian Xian', 1, 'jinxian-xian'),
(38591, 744582, 'cn', 'Jishui Xian', 1, 'jishui-xian'),
(38592, 744582, 'cn', 'Jiujiang Shi', 1, 'jiujiang-shi'),
(38593, 744582, 'cn', 'Jiujiang Xian', 1, 'jiujiang-xian'),
(38594, 744582, 'cn', 'Ji´an Diqu', 1, 'jian-diqu'),
(38595, 744582, 'cn', 'Ji´an Shi', 1, 'jian-shi'),
(38596, 744582, 'cn', 'Ji´an Xian', 1, 'jian-xian'),
(38597, 744582, 'cn', 'Leping Shi', 1, 'leping-shi'),
(38598, 744582, 'cn', 'Le´an Xian', 1, 'lean-xian'),
(38599, 744582, 'cn', 'Lianhua Xian', 1, 'lianhua-xian'),
(38600, 744582, 'cn', 'Lichuan Xian', 1, 'lichuan-xian'),
(38601, 744582, 'cn', 'Linchuan Shi', 1, 'linchuan-shi'),
(38602, 744582, 'cn', 'Longnan Xian', 1, 'longnan-xian'),
(38603, 744582, 'cn', 'Nanchang', 1, 'nanchang'),
(38604, 744582, 'cn', 'Nanchang Shi', 1, 'nanchang-shi'),
(38605, 744582, 'cn', 'Nanchang Xian', 1, 'nanchang-xian'),
(38606, 744582, 'cn', 'Nancheng Xian', 1, 'nancheng-xian'),
(38607, 744582, 'cn', 'Nanfeng Xian', 1, 'nanfeng-xian'),
(38608, 744582, 'cn', 'Nankang Shi', 1, 'nankang-shi'),
(38609, 744582, 'cn', 'Ningdu Xian', 1, 'ningdu-xian'),
(38610, 744582, 'cn', 'Ninggang Xian', 1, 'ninggang-xian'),
(38611, 744582, 'cn', 'Pengze Xian', 1, 'pengze-xian'),
(38612, 744582, 'cn', 'Pingxiang Shi', 1, 'pingxiang-shi'),
(38613, 744582, 'cn', 'Quannan Xian', 1, 'quannan-xian'),
(38614, 744582, 'cn', 'Ruichang Xian', 1, 'ruichang-xian'),
(38615, 744582, 'cn', 'Ruijin Shi', 1, 'ruijin-shi'),
(38616, 744582, 'cn', 'Shanggao Xian', 1, 'shanggao-xian'),
(38617, 744582, 'cn', 'Shangrao Diqu', 1, 'shangrao-diqu'),
(38618, 744582, 'cn', 'Shangrao Shi', 1, 'shangrao-shi'),
(38619, 744582, 'cn', 'Shangrao Xian', 1, 'shangrao-xian'),
(38620, 744582, 'cn', 'Shangyou Xian', 1, 'shangyou-xian'),
(38621, 744582, 'cn', 'Shicheng Xian', 1, 'shicheng-xian'),
(38622, 744582, 'cn', 'Suichuan Xian', 1, 'suichuan-xian'),
(38623, 744582, 'cn', 'Taihe Xian', 1, 'taihe-xian'),
(38624, 744582, 'cn', 'Tonggu Xian', 1, 'tonggu-xian'),
(38625, 744582, 'cn', 'Wanli Qu', 1, 'wanli-qu'),
(38626, 744582, 'cn', 'Wannian Xian', 1, 'wannian-xian'),
(38627, 744582, 'cn', 'Wanzai Xian', 1, 'wanzai-xian'),
(38628, 744582, 'cn', 'Wan´an Xian', 1, 'wanan-xian'),
(38629, 744582, 'cn', 'Wuning Xian', 1, 'wuning-xian'),
(38630, 744582, 'cn', 'Wuyuan Xian', 1, 'wuyuan-xian'),
(38631, 744582, 'cn', 'Xiajiang Xian', 1, 'xiajiang-xian'),
(38632, 744582, 'cn', 'Xinfeng Xian', 1, 'xinfeng-xian'),
(38633, 744582, 'cn', 'Xingan Xian', 1, 'xingan-xian'),
(38634, 744582, 'cn', 'Xingguo Xian', 1, 'xingguo-xian'),
(38635, 744582, 'cn', 'Xingzi Xian', 1, 'xingzi-xian'),
(38636, 744582, 'cn', 'Xinjian Xian', 1, 'xinjian-xian'),
(38637, 744582, 'cn', 'Xinyu Shi', 1, 'xinyu-shi'),
(38638, 744582, 'cn', 'Xiushui Xian', 1, 'xiushui-xian'),
(38639, 744582, 'cn', 'Xunwu Xian', 1, 'xunwu-xian'),
(38640, 744582, 'cn', 'Yanshan Xian', 1, 'yanshan-xian'),
(38641, 744582, 'cn', 'Yichun Diqu', 1, 'yichun-diqu'),
(38642, 744582, 'cn', 'Yichun Shi', 1, 'yichun-shi'),
(38643, 744582, 'cn', 'Yifeng Xian', 1, 'yifeng-xian'),
(38644, 744582, 'cn', 'Yihuang Xian', 1, 'yihuang-xian'),
(38645, 744582, 'cn', 'Yingtan Shi', 1, 'yingtan-shi'),
(38646, 744582, 'cn', 'Yiyang Xian', 1, 'yiyang-xian'),
(38647, 744582, 'cn', 'Yongfeng Xian', 1, 'yongfeng-xian'),
(38648, 744582, 'cn', 'Yongxin Xian', 1, 'yongxin-xian'),
(38649, 744582, 'cn', 'Yongxiu Xian', 1, 'yongxiu-xian'),
(38650, 744582, 'cn', 'Yudu Xian', 1, 'yudu-xian'),
(38651, 744582, 'cn', 'Yugan Xian', 1, 'yugan-xian'),
(38652, 744582, 'cn', 'Yujiang Xian', 1, 'yujiang-xian'),
(38653, 744582, 'cn', 'Yushan Xian', 1, 'yushan-xian'),
(38654, 744582, 'cn', 'Zhangshu Shi', 1, 'zhangshu-shi'),
(38655, 744582, 'cn', 'Zixi Xian', 1, 'zixi-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744682, 'cn', 'Jílín', 1, 'jilin');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38656, 744682, 'cn', 'Antu Xian', 1, 'antu-xian'),
(38657, 744682, 'cn', 'Baicheng Diqu', 1, 'baicheng-diqu'),
(38658, 744682, 'cn', 'Baicheng Shi', 1, 'baicheng-shi'),
(38659, 744682, 'cn', 'Baishan Shi', 1, 'baishan-shi'),
(38660, 744682, 'cn', 'Changbai Chaoxianzu Zizhixian', 1, 'changbai-chaoxianzu-zizhixian'),
(38661, 744682, 'cn', 'Changchun', 1, 'changchun'),
(38662, 744682, 'cn', 'Changchun Shi', 1, 'changchun-shi'),
(38663, 744682, 'cn', 'Changling Xian', 1, 'changling-xian'),
(38664, 744682, 'cn', 'Da´an Xian', 1, 'daan-xian'),
(38665, 744682, 'cn', 'Dehui Xian', 1, 'dehui-xian'),
(38666, 744682, 'cn', 'Dongfeng Xian', 1, 'dongfeng-xian'),
(38667, 744682, 'cn', 'Dongliao Xian', 1, 'dongliao-xian'),
(38668, 744682, 'cn', 'Dunhua Shi', 1, 'dunhua-shi'),
(38669, 744682, 'cn', 'Fusong Xian', 1, 'fusong-xian'),
(38670, 744682, 'cn', 'Fuyu Xian', 1, 'fuyu-xian'),
(38671, 744682, 'cn', 'Gongzhuling Shi', 1, 'gongzhuling-shi'),
(38672, 744682, 'cn', 'Helong Xian', 1, 'helong-xian'),
(38673, 744682, 'cn', 'Huadian Shi', 1, 'huadian-shi'),
(38674, 744682, 'cn', 'Huinan Xian', 1, 'huinan-xian'),
(38675, 744682, 'cn', 'Hunchun Xian', 1, 'hunchun-xian'),
(38676, 744682, 'cn', 'Jiangyuan Xian', 1, 'jiangyuan-xian'),
(38677, 744682, 'cn', 'Jiaohe Xian', 1, 'jiaohe-xian'),
(38678, 744682, 'cn', 'Jilin Shi', 1, 'jilin-shi'),
(38679, 744682, 'cn', 'Jingyu Xian', 1, 'jingyu-xian'),
(38680, 744682, 'cn', 'Jiutai Xian', 1, 'jiutai-xian'),
(38681, 744682, 'cn', 'Ji´an Xian', 1, 'jian-xian'),
(38682, 744682, 'cn', 'Liaoyuan Shi', 1, 'liaoyuan-shi'),
(38683, 744682, 'cn', 'Lishu Xian', 1, 'lishu-xian'),
(38684, 744682, 'cn', 'Liuhe Xian', 1, 'liuhe-xian'),
(38685, 744682, 'cn', 'Longjing Xian', 1, 'longjing-xian'),
(38686, 744682, 'cn', 'Meihekou Shi', 1, 'meihekou-shi'),
(38687, 744682, 'cn', 'Nong´an Xian', 1, 'nongan-xian'),
(38688, 744682, 'cn', 'Panshi Shi', 1, 'panshi-shi'),
(38689, 744682, 'cn', 'Qian Gorlos Mongolzu Zizhixian', 1, 'qian-gorlos-mongolzu-zizhixian'),
(38690, 744682, 'cn', 'Qian´an Xian', 1, 'qianan-xian'),
(38691, 744682, 'cn', 'Shuangliao Xian', 1, 'shuangliao-xian'),
(38692, 744682, 'cn', 'Shuangyang Xian', 1, 'shuangyang-xian'),
(38693, 744682, 'cn', 'Shulan Xian', 1, 'shulan-xian'),
(38694, 744682, 'cn', 'Siping Shi', 1, 'siping-shi'),
(38695, 744682, 'cn', 'Tao´an Xian', 1, 'taoan-xian'),
(38696, 744682, 'cn', 'Tonghua Shi', 1, 'tonghua-shi'),
(38697, 744682, 'cn', 'Tonghua Xian', 1, 'tonghua-xian'),
(38698, 744682, 'cn', 'Tongyu Xian', 1, 'tongyu-xian'),
(38699, 744682, 'cn', 'Tumen Shi', 1, 'tumen-shi'),
(38700, 744682, 'cn', 'Wangqing Xian', 1, 'wangqing-xian'),
(38701, 744682, 'cn', 'Yanbian Chaoxianzu Zizhizhou', 1, 'yanbian-chaoxianzu-zizhizhou'),
(38702, 744682, 'cn', 'Yanji Shi', 1, 'yanji-shi'),
(38703, 744682, 'cn', 'Yitong Xian', 1, 'yitong-xian'),
(38704, 744682, 'cn', 'Yongji Xian', 1, 'yongji-xian'),
(38705, 744682, 'cn', 'Yushu Xian', 1, 'yushu-xian'),
(38706, 744682, 'cn', 'Zhenlai Xian', 1, 'zhenlai-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744734, 'cn', 'Liáoníng', 1, 'liaoning');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38707, 744734, 'cn', 'Anshan Shi', 1, 'anshan-shi'),
(38708, 744734, 'cn', 'Bayujuan Qu', 1, 'bayujuan-qu'),
(38709, 744734, 'cn', 'Beining Shi', 1, 'beining-shi'),
(38710, 744734, 'cn', 'Beipiao Shi', 1, 'beipiao-shi'),
(38711, 744734, 'cn', 'Benxi Manzu Zizhixian', 1, 'benxi-manzu-zizhixian'),
(38712, 744734, 'cn', 'Benxi Shi', 1, 'benxi-shi'),
(38713, 744734, 'cn', 'Changhai Xian', 1, 'changhai-xian'),
(38714, 744734, 'cn', 'Changtu Xian', 1, 'changtu-xian'),
(38715, 744734, 'cn', 'Chaoyang Shi', 1, 'chaoyang-shi'),
(38716, 744734, 'cn', 'Chaoyang Xian', 1, 'chaoyang-xian'),
(38717, 744734, 'cn', 'Dalian Shi', 1, 'dalian-shi'),
(38718, 744734, 'cn', 'Dandong Shi', 1, 'dandong-shi'),
(38719, 744734, 'cn', 'Dashiqiao Shi', 1, 'dashiqiao-shi'),
(38720, 744734, 'cn', 'Dawa Xian', 1, 'dawa-xian'),
(38721, 744734, 'cn', 'Dengta Shi', 1, 'dengta-shi'),
(38722, 744734, 'cn', 'Donggang Shi', 1, 'donggang-shi'),
(38723, 744734, 'cn', 'Dongling Qu', 1, 'dongling-qu'),
(38724, 744734, 'cn', 'Faku Xian', 1, 'faku-xian'),
(38725, 744734, 'cn', 'Fengcheng Shi', 1, 'fengcheng-shi'),
(38726, 744734, 'cn', 'Fushun Shi', 1, 'fushun-shi'),
(38727, 744734, 'cn', 'Fushun Xian', 1, 'fushun-xian'),
(38728, 744734, 'cn', 'Fuxin Mongolzu Zizhixian', 1, 'fuxin-mongolzu-zizhixian'),
(38729, 744734, 'cn', 'Fuxin Shi', 1, 'fuxin-shi'),
(38730, 744734, 'cn', 'Gaizhou Shi', 1, 'gaizhou-shi'),
(38731, 744734, 'cn', 'Ganjingzi Qu', 1, 'ganjingzi-qu'),
(38732, 744734, 'cn', 'Gongchangling Qu', 1, 'gongchangling-qu'),
(38733, 744734, 'cn', 'Haicheng Shi', 1, 'haicheng-shi'),
(38734, 744734, 'cn', 'Harqin Zuoyi Mongolzu Zizhixian', 1, 'harqin-zuoyi-mongolzu-zizhixian'),
(38735, 744734, 'cn', 'Heishan Xian', 1, 'heishan-xian'),
(38736, 744734, 'cn', 'Hongwei Qu', 1, 'hongwei-qu'),
(38737, 744734, 'cn', 'Huanren Manzu Zizhixian', 1, 'huanren-manzu-zizhixian'),
(38738, 744734, 'cn', 'Huludao Shi', 1, 'huludao-shi'),
(38739, 744734, 'cn', 'Jianchang Xian', 1, 'jianchang-xian'),
(38740, 744734, 'cn', 'Jianping Xian', 1, 'jianping-xian'),
(38741, 744734, 'cn', 'Jinzhou Qu', 1, 'jinzhou-qu'),
(38742, 744734, 'cn', 'Jinzhou Shi', 1, 'jinzhou-shi'),
(38743, 744734, 'cn', 'Kaiyuan Shi', 1, 'kaiyuan-shi'),
(38744, 744734, 'cn', 'Kangping Xian', 1, 'kangping-xian'),
(38745, 744734, 'cn', 'Kuandian Manzu Zizhixian', 1, 'kuandian-manzu-zizhixian'),
(38746, 744734, 'cn', 'Laobian Qu', 1, 'laobian-qu'),
(38747, 744734, 'cn', 'Liaoyang Shi', 1, 'liaoyang-shi'),
(38748, 744734, 'cn', 'Liaoyang Xian', 1, 'liaoyang-xian'),
(38749, 744734, 'cn', 'Liaozhong Xian', 1, 'liaozhong-xian'),
(38750, 744734, 'cn', 'Linghai Shi', 1, 'linghai-shi'),
(38751, 744734, 'cn', 'Lingyuan Shi', 1, 'lingyuan-shi'),
(38752, 744734, 'cn', 'Longwan Qu', 1, 'longwan-qu'),
(38753, 744734, 'cn', 'Lüxukou Qu', 1, 'luxukou-qu'),
(38754, 744734, 'cn', 'Nanfen Qu', 1, 'nanfen-qu'),
(38755, 744734, 'cn', 'Nanpiao Qu', 1, 'nanpiao-qu'),
(38756, 744734, 'cn', 'Panjin Shi', 1, 'panjin-shi'),
(38757, 744734, 'cn', 'Panshan Xian', 1, 'panshan-xian'),
(38758, 744734, 'cn', 'Pulandian Shi', 1, 'pulandian-shi'),
(38759, 744734, 'cn', 'Qinghe Qu', 1, 'qinghe-qu'),
(38760, 744734, 'cn', 'Qinghemen Qu', 1, 'qinghemen-qu'),
(38761, 744734, 'cn', 'Qingyuan Manzu Zizhixian', 1, 'qingyuan-manzu-zizhixian'),
(38762, 744734, 'cn', 'Shenyang', 1, 'shenyang'),
(38763, 744734, 'cn', 'Shenyang Shi', 1, 'shenyang-shi'),
(38764, 744734, 'cn', 'Shuangtaizi Qu', 1, 'shuangtaizi-qu'),
(38765, 744734, 'cn', 'Suizhong Xian', 1, 'suizhong-xian'),
(38766, 744734, 'cn', 'Sujiatun Qu', 1, 'sujiatun-qu'),
(38767, 744734, 'cn', 'Tai´an Xian', 1, 'taian-xian'),
(38768, 744734, 'cn', 'Tiefa Shi', 1, 'tiefa-shi'),
(38769, 744734, 'cn', 'Tieling Shi', 1, 'tieling-shi'),
(38770, 744734, 'cn', 'Tieling Xian', 1, 'tieling-xian'),
(38771, 744734, 'cn', 'Wafangdian Shi', 1, 'wafangdian-shi'),
(38772, 744734, 'cn', 'Xifeng Xian', 1, 'xifeng-xian'),
(38773, 744734, 'cn', 'Xinbin Manzu Zizhixian', 1, 'xinbin-manzu-zizhixian'),
(38774, 744734, 'cn', 'Xinchengzi Qu', 1, 'xinchengzi-qu'),
(38775, 744734, 'cn', 'Xingcheng Shi', 1, 'xingcheng-shi'),
(38776, 744734, 'cn', 'Xinmin Shi', 1, 'xinmin-shi'),
(38777, 744734, 'cn', 'Xinqiu Qu', 1, 'xinqiu-qu'),
(38778, 744734, 'cn', 'Xiuyan Manzu Zizhixian', 1, 'xiuyan-manzu-zizhixian'),
(38779, 744734, 'cn', 'Yi Xian', 1, 'yi-xian'),
(38780, 744734, 'cn', 'Yingkou Shi', 1, 'yingkou-shi'),
(38781, 744734, 'cn', 'Zhangwu Xian', 1, 'zhangwu-xian'),
(38782, 744734, 'cn', 'Zhuanghe Shi', 1, 'zhuanghe-shi');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744811, 'cn', 'Qinghai', 1, 'qinghai');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38783, 744811, 'cn', 'Baima Xian', 1, 'baima-xian'),
(38784, 744811, 'cn', 'Chindu Xian', 1, 'chindu-xian'),
(38785, 744811, 'cn', 'Darlag Xian', 1, 'darlag-xian'),
(38786, 744811, 'cn', 'Datong Huizu Tuzu Zizhixian', 1, 'datong-huizu-tuzu-zizhixian'),
(38787, 744811, 'cn', 'Dulan Xian', 1, 'dulan-xian'),
(38788, 744811, 'cn', 'Gadê Xian', 1, 'gade-xian'),
(38789, 744811, 'cn', 'Gangca Xian', 1, 'gangca-xian'),
(38790, 744811, 'cn', 'Golmud Shi', 1, 'golmud-shi'),
(38791, 744811, 'cn', 'Golog Zangzu Zizhizhou', 1, 'golog-zangzu-zizhizhou'),
(38792, 744811, 'cn', 'Gonghe Xian', 1, 'gonghe-xian'),
(38793, 744811, 'cn', 'Guide Xian', 1, 'guide-xian'),
(38794, 744811, 'cn', 'Guinan Xian', 1, 'guinan-xian'),
(38795, 744811, 'cn', 'Haibei Zangzu Zizhizhou', 1, 'haibei-zangzu-zizhizhou'),
(38796, 744811, 'cn', 'Haidong Diqu', 1, 'haidong-diqu'),
(38797, 744811, 'cn', 'Hainan Zangzu Zizhizhou', 1, 'hainan-zangzu-zizhizhou'),
(38798, 744811, 'cn', 'Haixi Mongolzu Zangzu Zizhizhou', 1, 'haixi-mongolzu-zangzu-zizhizhou'),
(38799, 744811, 'cn', 'Haiyan Xian', 1, 'haiyan-xian'),
(38800, 744811, 'cn', 'Henan Mongolzu Zizhixian', 1, 'henan-mongolzu-zizhixian'),
(38801, 744811, 'cn', 'Hualong Huizu Zizhixian', 1, 'hualong-huizu-zizhixian'),
(38802, 744811, 'cn', 'Huangnan Zangzu Zizhizhou', 1, 'huangnan-zangzu-zizhizhou'),
(38803, 744811, 'cn', 'Huangyuan Xian', 1, 'huangyuan-xian'),
(38804, 744811, 'cn', 'Huangzhong Xian', 1, 'huangzhong-xian'),
(38805, 744811, 'cn', 'Huzhu Tuzu Zizhixian', 1, 'huzhu-tuzu-zizhixian'),
(38806, 744811, 'cn', 'Jainca Xian', 1, 'jainca-xian'),
(38807, 744811, 'cn', 'Jigzhi Xian', 1, 'jigzhi-xian'),
(38808, 744811, 'cn', 'Ledu Xian', 1, 'ledu-xian'),
(38809, 744811, 'cn', 'Madoi Xian', 1, 'madoi-xian'),
(38810, 744811, 'cn', 'Maqên Xian', 1, 'maqen-xian'),
(38811, 744811, 'cn', 'Menyuan Huizu Zizhixian', 1, 'menyuan-huizu-zizhixian'),
(38812, 744811, 'cn', 'Minhe Huizu Tuzu Zizhixian', 1, 'minhe-huizu-tuzu-zizhixian'),
(38813, 744811, 'cn', 'Nangqên Xian', 1, 'nangqen-xian'),
(38814, 744811, 'cn', 'Ping´an Xian', 1, 'pingan-xian'),
(38815, 744811, 'cn', 'Qilian Xian', 1, 'qilian-xian'),
(38816, 744811, 'cn', 'Qinghai Sheng', 1, 'qinghai-sheng'),
(38817, 744811, 'cn', 'Qumarlêb Xian', 1, 'qumarleb-xian'),
(38818, 744811, 'cn', 'Tianjun Xian', 1, 'tianjun-xian'),
(38819, 744811, 'cn', 'Tongde Xian', 1, 'tongde-xian'),
(38820, 744811, 'cn', 'Tongren Xian', 1, 'tongren-xian'),
(38821, 744811, 'cn', 'Ulan Xian', 1, 'ulan-xian'),
(38822, 744811, 'cn', 'Xinghai Xian', 1, 'xinghai-xian'),
(38823, 744811, 'cn', 'Xining', 1, 'xining'),
(38824, 744811, 'cn', 'Xining Shi', 1, 'xining-shi'),
(38825, 744811, 'cn', 'Xunhua Salarzu Zizhixian', 1, 'xunhua-salarzu-zizhixian'),
(38826, 744811, 'cn', 'Yushu Xian', 1, 'yushu-xian'),
(38827, 744811, 'cn', 'Yushu Zangzu Zizhizhou', 1, 'yushu-zangzu-zizhizhou'),
(38828, 744811, 'cn', 'Zadoi Xian', 1, 'zadoi-xian'),
(38829, 744811, 'cn', 'Zêkog Xian', 1, 'zekog-xian'),
(38830, 744811, 'cn', 'Zhidoi Xian', 1, 'zhidoi-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744860, 'cn', 'Shaanxi', 1, 'shaanxi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38831, 744860, 'cn', 'Ankang Diqu', 1, 'ankang-diqu'),
(38832, 744860, 'cn', 'Ankang Xian', 1, 'ankang-xian'),
(38833, 744860, 'cn', 'Ansai Xian', 1, 'ansai-xian'),
(38834, 744860, 'cn', 'Baihe Xian', 1, 'baihe-xian'),
(38835, 744860, 'cn', 'Baishui Xian', 1, 'baishui-xian'),
(38836, 744860, 'cn', 'Baoji Shi', 1, 'baoji-shi'),
(38837, 744860, 'cn', 'Baoji Xian', 1, 'baoji-xian'),
(38838, 744860, 'cn', 'Baqiao Qu', 1, 'baqiao-qu'),
(38839, 744860, 'cn', 'Bin Xian', 1, 'bin-xian'),
(38840, 744860, 'cn', 'Changwu Xian', 1, 'changwu-xian'),
(38841, 744860, 'cn', 'Chang´an Xian', 1, 'changan-xian'),
(38842, 744860, 'cn', 'Chengcheng Xian', 1, 'chengcheng-xian'),
(38843, 744860, 'cn', 'Chenggu Xian', 1, 'chenggu-xian'),
(38844, 744860, 'cn', 'Chunhua Xian', 1, 'chunhua-xian'),
(38845, 744860, 'cn', 'Dali Xian', 1, 'dali-xian'),
(38846, 744860, 'cn', 'Danfeng Xian', 1, 'danfeng-xian'),
(38847, 744860, 'cn', 'Dingbian Xian', 1, 'dingbian-xian'),
(38848, 744860, 'cn', 'Feng Xian', 1, 'feng-xian'),
(38849, 744860, 'cn', 'Fengxiang Xian', 1, 'fengxiang-xian'),
(38850, 744860, 'cn', 'Foping Xian', 1, 'foping-xian'),
(38851, 744860, 'cn', 'Fu Xian', 1, 'fu-xian'),
(38852, 744860, 'cn', 'Fufeng Xian', 1, 'fufeng-xian'),
(38853, 744860, 'cn', 'Fugu Xian', 1, 'fugu-xian'),
(38854, 744860, 'cn', 'Fuping Xian', 1, 'fuping-xian'),
(38855, 744860, 'cn', 'Ganquan Xian', 1, 'ganquan-xian'),
(38856, 744860, 'cn', 'Gaoling Xian', 1, 'gaoling-xian'),
(38857, 744860, 'cn', 'Hancheng Shi', 1, 'hancheng-shi'),
(38858, 744860, 'cn', 'Hanyin Xian', 1, 'hanyin-xian'),
(38859, 744860, 'cn', 'Hanzhong Diqu', 1, 'hanzhong-diqu'),
(38860, 744860, 'cn', 'Hanzhong Shi', 1, 'hanzhong-shi'),
(38861, 744860, 'cn', 'Hengshan Xian', 1, 'hengshan-xian'),
(38862, 744860, 'cn', 'Heyang Xian', 1, 'heyang-xian'),
(38863, 744860, 'cn', 'Hu Xian', 1, 'hu-xian'),
(38864, 744860, 'cn', 'Hua Xian', 1, 'hua-xian'),
(38865, 744860, 'cn', 'Huangling Xian', 1, 'huangling-xian'),
(38866, 744860, 'cn', 'Huanglong Xian', 1, 'huanglong-xian'),
(38867, 744860, 'cn', 'Huayin Xian', 1, 'huayin-xian'),
(38868, 744860, 'cn', 'Jia Xian', 1, 'jia-xian'),
(38869, 744860, 'cn', 'Jingbian Xian', 1, 'jingbian-xian'),
(38870, 744860, 'cn', 'Jingyang Xian', 1, 'jingyang-xian'),
(38871, 744860, 'cn', 'Langao Xian', 1, 'langao-xian'),
(38872, 744860, 'cn', 'Lantian Xian', 1, 'lantian-xian'),
(38873, 744860, 'cn', 'Lianhu Qu', 1, 'lianhu-qu'),
(38874, 744860, 'cn', 'Lintong Qu', 1, 'lintong-qu'),
(38875, 744860, 'cn', 'Linwei Qu', 1, 'linwei-qu'),
(38876, 744860, 'cn', 'Linyou Xian', 1, 'linyou-xian'),
(38877, 744860, 'cn', 'Liquan Xian', 1, 'liquan-xian'),
(38878, 744860, 'cn', 'Liuba Xian', 1, 'liuba-xian'),
(38879, 744860, 'cn', 'Long Xian', 1, 'long-xian'),
(38880, 744860, 'cn', 'Luochuan Xian', 1, 'luochuan-xian'),
(38881, 744860, 'cn', 'Luonan Xian', 1, 'luonan-xian'),
(38882, 744860, 'cn', 'Lüeyang Xian', 1, 'lueyang-xian'),
(38883, 744860, 'cn', 'Mei Xian', 1, 'mei-xian'),
(38884, 744860, 'cn', 'Mian Xian', 1, 'mian-xian'),
(38885, 744860, 'cn', 'Mizhi Xian', 1, 'mizhi-xian'),
(38886, 744860, 'cn', 'Nanzheng Xian', 1, 'nanzheng-xian'),
(38887, 744860, 'cn', 'Ningqiang Xian', 1, 'ningqiang-xian'),
(38888, 744860, 'cn', 'Ningshan Xian', 1, 'ningshan-xian'),
(38889, 744860, 'cn', 'Pingli Xian', 1, 'pingli-xian'),
(38890, 744860, 'cn', 'Pucheng Xian', 1, 'pucheng-xian'),
(38891, 744860, 'cn', 'Qian Xian', 1, 'qian-xian'),
(38892, 744860, 'cn', 'Qianyang Xian', 1, 'qianyang-xian'),
(38893, 744860, 'cn', 'Qindu Qu', 1, 'qindu-qu'),
(38894, 744860, 'cn', 'Qingjian Xian', 1, 'qingjian-xian'),
(38895, 744860, 'cn', 'Qishan Xian', 1, 'qishan-xian'),
(38896, 744860, 'cn', 'Sanyuan Xian', 1, 'sanyuan-xian'),
(38897, 744860, 'cn', 'Shaanxi Sheng', 1, 'shaanxi-sheng'),
(38898, 744860, 'cn', 'Shang Xian', 1, 'shang-xian'),
(38899, 744860, 'cn', 'Shangluo Diqu', 1, 'shangluo-diqu'),
(38900, 744860, 'cn', 'Shangnan Xian', 1, 'shangnan-xian'),
(38901, 744860, 'cn', 'Shanyang Xian', 1, 'shanyang-xian'),
(38902, 744860, 'cn', 'Shenmu Xian', 1, 'shenmu-xian'),
(38903, 744860, 'cn', 'Shiquan Xian', 1, 'shiquan-xian'),
(38904, 744860, 'cn', 'Suide Xian', 1, 'suide-xian'),
(38905, 744860, 'cn', 'Taibai Xian', 1, 'taibai-xian'),
(38906, 744860, 'cn', 'Tongchuan Shi', 1, 'tongchuan-shi'),
(38907, 744860, 'cn', 'Tongguan Xian', 1, 'tongguan-xian'),
(38908, 744860, 'cn', 'Weicheng Qu', 1, 'weicheng-qu'),
(38909, 744860, 'cn', 'Weinan Shi', 1, 'weinan-shi'),
(38910, 744860, 'cn', 'Weiyang Qu', 1, 'weiyang-qu'),
(38911, 744860, 'cn', 'Wubu Xian', 1, 'wubu-xian'),
(38912, 744860, 'cn', 'Wugong Xian', 1, 'wugong-xian'),
(38913, 744860, 'cn', 'Wuqi Xian', 1, 'wuqi-xian'),
(38914, 744860, 'cn', 'Xianyang Shi', 1, 'xianyang-shi'),
(38915, 744860, 'cn', 'Xincheng Qu', 1, 'xincheng-qu'),
(38916, 744860, 'cn', 'Xingping Shi', 1, 'xingping-shi'),
(38917, 744860, 'cn', 'Xixiang Xian', 1, 'xixiang-xian'),
(38918, 744860, 'cn', 'Xi´an', 1, 'xian'),
(38919, 744860, 'cn', 'Xi´an Shi', 1, 'xian-shi'),
(38920, 744860, 'cn', 'Xunyang Xian', 1, 'xunyang-xian'),
(38921, 744860, 'cn', 'Xunyi Xian', 1, 'xunyi-xian'),
(38922, 744860, 'cn', 'Yanchang Xian', 1, 'yanchang-xian'),
(38923, 744860, 'cn', 'Yanchuan Xian', 1, 'yanchuan-xian'),
(38924, 744860, 'cn', 'Yang Xian', 1, 'yang-xian'),
(38925, 744860, 'cn', 'Yangling Qu', 1, 'yangling-qu'),
(38926, 744860, 'cn', 'Yanta Qu', 1, 'yanta-qu'),
(38927, 744860, 'cn', 'Yan´an Diqu', 1, 'yanan-diqu'),
(38928, 744860, 'cn', 'Yan´an Shi', 1, 'yanan-shi'),
(38929, 744860, 'cn', 'Yao Xian', 1, 'yao-xian'),
(38930, 744860, 'cn', 'Yichuan Xian', 1, 'yichuan-xian'),
(38931, 744860, 'cn', 'Yuncheng', 1, 'yuncheng');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(744962, 'cn', 'Shandong', 1, 'shandong');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(38932, 744962, 'cn', 'Anqiu Shi', 1, 'anqiu-shi'),
(38933, 744962, 'cn', 'Bin Xian', 1, 'bin-xian'),
(38934, 744962, 'cn', 'Binzhou Shi', 1, 'binzhou-shi'),
(38935, 744962, 'cn', 'Boxing Xian', 1, 'boxing-xian'),
(38936, 744962, 'cn', 'Cangshan Xian', 1, 'cangshan-xian'),
(38937, 744962, 'cn', 'Cao Xian', 1, 'cao-xian'),
(38938, 744962, 'cn', 'Changdao Xian', 1, 'changdao-xian'),
(38939, 744962, 'cn', 'Changle Xian', 1, 'changle-xian'),
(38940, 744962, 'cn', 'Changqing Xian', 1, 'changqing-xian'),
(38941, 744962, 'cn', 'Changyi Shi', 1, 'changyi-shi'),
(38942, 744962, 'cn', 'Chengwu Xian', 1, 'chengwu-xian'),
(38943, 744962, 'cn', 'Chiping Xian', 1, 'chiping-xian'),
(38944, 744962, 'cn', 'Dezhou Shi', 1, 'dezhou-shi'),
(38945, 744962, 'cn', 'Dingtao Xian', 1, 'dingtao-xian'),
(38946, 744962, 'cn', 'Dongming Xian', 1, 'dongming-xian'),
(38947, 744962, 'cn', 'Dongping Xian', 1, 'dongping-xian'),
(38948, 744962, 'cn', 'Dongying Shi', 1, 'dongying-shi'),
(38949, 744962, 'cn', 'Dong´e Xian', 1, 'donge-xian'),
(38950, 744962, 'cn', 'Fei Xian', 1, 'fei-xian'),
(38951, 744962, 'cn', 'Feicheng Shi', 1, 'feicheng-shi'),
(38952, 744962, 'cn', 'Gaomi Shi', 1, 'gaomi-shi'),
(38953, 744962, 'cn', 'Gaoqing Xian', 1, 'gaoqing-xian'),
(38954, 744962, 'cn', 'Gaotang Xian', 1, 'gaotang-xian'),
(38955, 744962, 'cn', 'Guan Xian', 1, 'guan-xian'),
(38956, 744962, 'cn', 'Guangrao Xian', 1, 'guangrao-xian'),
(38957, 744962, 'cn', 'Haiyang Xian', 1, 'haiyang-xian'),
(38958, 744962, 'cn', 'Heze Diqu', 1, 'heze-diqu'),
(38959, 744962, 'cn', 'Heze Shi', 1, 'heze-shi'),
(38960, 744962, 'cn', 'Huantai Xian', 1, 'huantai-xian'),
(38961, 744962, 'cn', 'Huimin Diqu', 1, 'huimin-diqu'),
(38962, 744962, 'cn', 'Huimin Xian', 1, 'huimin-xian'),
(38963, 744962, 'cn', 'Jiaonan Shi', 1, 'jiaonan-shi'),
(38964, 744962, 'cn', 'Jiaozhou Shi', 1, 'jiaozhou-shi'),
(38965, 744962, 'cn', 'Jiaxiang Xian', 1, 'jiaxiang-xian'),
(38966, 744962, 'cn', 'Jimo Shi', 1, 'jimo-shi'),
(38967, 744962, 'cn', 'Jinan', 1, 'jinan'),
(38968, 744962, 'cn', 'Jinan Shi', 1, 'jinan-shi'),
(38969, 744962, 'cn', 'Jining Shi', 1, 'jining-shi'),
(38970, 744962, 'cn', 'Jinxiang Xian', 1, 'jinxiang-xian'),
(38971, 744962, 'cn', 'Jiyang Xian', 1, 'jiyang-xian'),
(38972, 744962, 'cn', 'Ju Xian', 1, 'ju-xian'),
(38973, 744962, 'cn', 'Juancheng Xian', 1, 'juancheng-xian'),
(38974, 744962, 'cn', 'Junan Xian', 1, 'junan-xian'),
(38975, 744962, 'cn', 'Juye Xian', 1, 'juye-xian'),
(38976, 744962, 'cn', 'Kenli Xian', 1, 'kenli-xian'),
(38977, 744962, 'cn', 'Laiwu Shi', 1, 'laiwu-shi'),
(38978, 744962, 'cn', 'Laixi Xian', 1, 'laixi-xian'),
(38979, 744962, 'cn', 'Laiyang Xian', 1, 'laiyang-xian'),
(38980, 744962, 'cn', 'Laoshan Xian', 1, 'laoshan-xian'),
(38981, 744962, 'cn', 'Leling Shi', 1, 'leling-shi'),
(38982, 744962, 'cn', 'Liangshan Xian', 1, 'liangshan-xian'),
(38983, 744962, 'cn', 'Liaocheng Diqu', 1, 'liaocheng-diqu'),
(38984, 744962, 'cn', 'Liaocheng Shi', 1, 'liaocheng-shi'),
(38985, 744962, 'cn', 'Licheng Xian', 1, 'licheng-xian'),
(38986, 744962, 'cn', 'Lijin Xian', 1, 'lijin-xian'),
(38987, 744962, 'cn', 'Ling Xian', 1, 'ling-xian'),
(38988, 744962, 'cn', 'Linqing Shi', 1, 'linqing-shi'),
(38989, 744962, 'cn', 'Linqu Xian', 1, 'linqu-xian'),
(38990, 744962, 'cn', 'Linshu Xian', 1, 'linshu-xian'),
(38991, 744962, 'cn', 'Linyi Diqu', 1, 'linyi-diqu'),
(38992, 744962, 'cn', 'Linyi Shi', 1, 'linyi-shi'),
(38993, 744962, 'cn', 'Linyi Xian', 1, 'linyi-xian'),
(38994, 744962, 'cn', 'Longkou Shi', 1, 'longkou-shi'),
(38995, 744962, 'cn', 'Mengyin Xian', 1, 'mengyin-xian'),
(38996, 744962, 'cn', 'Muping Xian', 1, 'muping-xian'),
(38997, 744962, 'cn', 'Ningjin Xian', 1, 'ningjin-xian'),
(38998, 744962, 'cn', 'Ningyang Xian', 1, 'ningyang-xian'),
(38999, 744962, 'cn', 'Penglai Shi', 1, 'penglai-shi'),
(39000, 744962, 'cn', 'Pingdu Shi', 1, 'pingdu-shi'),
(39001, 744962, 'cn', 'Pingyi Xian', 1, 'pingyi-xian'),
(39002, 744962, 'cn', 'Pingyin Xian', 1, 'pingyin-xian'),
(39003, 744962, 'cn', 'Pingyuan Xian', 1, 'pingyuan-xian'),
(39004, 744962, 'cn', 'Qihe Xian', 1, 'qihe-xian'),
(39005, 744962, 'cn', 'Qingdao Shi', 1, 'qingdao-shi'),
(39006, 744962, 'cn', 'Qingyun Xian', 1, 'qingyun-xian'),
(39007, 744962, 'cn', 'Qingzhou Shi', 1, 'qingzhou-shi'),
(39008, 744962, 'cn', 'Qixia Xian', 1, 'qixia-xian'),
(39009, 744962, 'cn', 'Qufu Shi', 1, 'qufu-shi'),
(39010, 744962, 'cn', 'Rizhao Shi', 1, 'rizhao-shi'),
(39011, 744962, 'cn', 'Rongcheng Xian', 1, 'rongcheng-xian'),
(39012, 744962, 'cn', 'Rushan Xian', 1, 'rushan-xian'),
(39013, 744962, 'cn', 'Shan Xian', 1, 'shan-xian'),
(39014, 744962, 'cn', 'Shandong Sheng', 1, 'shandong-sheng'),
(39015, 744962, 'cn', 'Shanghe Xian', 1, 'shanghe-xian'),
(39016, 744962, 'cn', 'Shen Xian', 1, 'shen-xian'),
(39017, 744962, 'cn', 'Shouguang Xian', 1, 'shouguang-xian'),
(39018, 744962, 'cn', 'Sishui Xian', 1, 'sishui-xian'),
(39019, 744962, 'cn', 'Tai´an Shi', 1, 'taian-shi'),
(39020, 744962, 'cn', 'Tancheng Xian', 1, 'tancheng-xian'),
(39021, 744962, 'cn', 'Teng Xian', 1, 'teng-xian'),
(39022, 744962, 'cn', 'Weifang Shi', 1, 'weifang-shi'),
(39023, 744962, 'cn', 'Weihai Shi', 1, 'weihai-shi'),
(39024, 744962, 'cn', 'Weishan Xian', 1, 'weishan-xian'),
(39025, 744962, 'cn', 'Wendeng Xian', 1, 'wendeng-xian'),
(39026, 744962, 'cn', 'Wenshang Xian', 1, 'wenshang-xian'),
(39027, 744962, 'cn', 'Wucheng Xian', 1, 'wucheng-xian'),
(39028, 744962, 'cn', 'Wudi Xian', 1, 'wudi-xian'),
(39029, 744962, 'cn', 'Wulian Xian', 1, 'wulian-xian'),
(39030, 744962, 'cn', 'Xiajin Xian', 1, 'xiajin-xian'),
(39031, 744962, 'cn', 'Xintai Shi', 1, 'xintai-shi'),
(39032, 744962, 'cn', 'Yantai', 1, 'yantai'),
(39033, 744962, 'cn', 'Zaozhuang', 1, 'zaozhuang'),
(39034, 744962, 'cn', 'Zibo', 1, 'zibo');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745066, 'cn', 'Shanxi', 1, 'shanxi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39035, 745066, 'cn', 'Anze Xian', 1, 'anze-xian'),
(39036, 745066, 'cn', 'Baode Xian', 1, 'baode-xian'),
(39037, 745066, 'cn', 'Changzhi Shi', 1, 'changzhi-shi'),
(39038, 745066, 'cn', 'Changzhi Xian', 1, 'changzhi-xian'),
(39039, 745066, 'cn', 'Dai Xian', 1, 'dai-xian'),
(39040, 745066, 'cn', 'Daning Xian', 1, 'daning-xian'),
(39041, 745066, 'cn', 'Datong Shi', 1, 'datong-shi'),
(39042, 745066, 'cn', 'Datong Xian', 1, 'datong-xian'),
(39043, 745066, 'cn', 'Dingxiang Xian', 1, 'dingxiang-xian'),
(39044, 745066, 'cn', 'Fangshan Xian', 1, 'fangshan-xian'),
(39045, 745066, 'cn', 'Fanshi Xian', 1, 'fanshi-xian'),
(39046, 745066, 'cn', 'Fenxi Xian', 1, 'fenxi-xian'),
(39047, 745066, 'cn', 'Fenyang Xian', 1, 'fenyang-xian'),
(39048, 745066, 'cn', 'Fushan Xian', 1, 'fushan-xian'),
(39049, 745066, 'cn', 'Gaoping Xian', 1, 'gaoping-xian'),
(39050, 745066, 'cn', 'Gu Xian', 1, 'gu-xian'),
(39051, 745066, 'cn', 'Guangling Xian', 1, 'guangling-xian'),
(39052, 745066, 'cn', 'Hejin Shi', 1, 'hejin-shi'),
(39053, 745066, 'cn', 'Hequ Xian', 1, 'hequ-xian'),
(39054, 745066, 'cn', 'Heshun Xian', 1, 'heshun-xian'),
(39055, 745066, 'cn', 'Hongtong Xian', 1, 'hongtong-xian'),
(39056, 745066, 'cn', 'Houma Shi', 1, 'houma-shi'),
(39057, 745066, 'cn', 'Huairen Xian', 1, 'huairen-xian'),
(39058, 745066, 'cn', 'Huguan Xian', 1, 'huguan-xian'),
(39059, 745066, 'cn', 'Hunyuan Xian', 1, 'hunyuan-xian'),
(39060, 745066, 'cn', 'Huozhou Shi', 1, 'huozhou-shi'),
(39061, 745066, 'cn', 'Ji Xian', 1, 'ji-xian'),
(39062, 745066, 'cn', 'Jiang Xian', 1, 'jiang-xian'),
(39063, 745066, 'cn', 'Jiaocheng Xian', 1, 'jiaocheng-xian'),
(39064, 745066, 'cn', 'Jiaokou Xian', 1, 'jiaokou-xian'),
(39065, 745066, 'cn', 'Jiexiu Xian', 1, 'jiexiu-xian'),
(39066, 745066, 'cn', 'Jincheng Shi', 1, 'jincheng-shi'),
(39067, 745066, 'cn', 'Jingle Xian', 1, 'jingle-xian'),
(39068, 745066, 'cn', 'Jinzhong Diqu', 1, 'jinzhong-diqu'),
(39069, 745066, 'cn', 'Jishan Xian', 1, 'jishan-xian'),
(39070, 745066, 'cn', 'Kelan Xian', 1, 'kelan-xian'),
(39071, 745066, 'cn', 'Lan Xian', 1, 'lan-xian'),
(39072, 745066, 'cn', 'Licheng Xian', 1, 'licheng-xian'),
(39073, 745066, 'cn', 'Lin Xian', 1, 'lin-xian'),
(39074, 745066, 'cn', 'Linfen Diqu', 1, 'linfen-diqu'),
(39075, 745066, 'cn', 'Linfen Shi', 1, 'linfen-shi'),
(39076, 745066, 'cn', 'Lingchuan Xian', 1, 'lingchuan-xian'),
(39077, 745066, 'cn', 'Lingqiu Xian', 1, 'lingqiu-xian'),
(39078, 745066, 'cn', 'Lingshi Xian', 1, 'lingshi-xian'),
(39079, 745066, 'cn', 'Linyi Xian', 1, 'linyi-xian'),
(39080, 745066, 'cn', 'Lishi Xian', 1, 'lishi-xian'),
(39081, 745066, 'cn', 'Liulin Xian', 1, 'liulin-xian'),
(39082, 745066, 'cn', 'Loufan Xian', 1, 'loufan-xian'),
(39083, 745066, 'cn', 'Lucheng Shi', 1, 'lucheng-shi'),
(39084, 745066, 'cn', 'Lüliang Diqu', 1, 'luliang-diqu'),
(39085, 745066, 'cn', 'Ningwu Xian', 1, 'ningwu-xian'),
(39086, 745066, 'cn', 'Pianguan Xian', 1, 'pianguan-xian'),
(39087, 745066, 'cn', 'Pingding Xian', 1, 'pingding-xian'),
(39088, 745066, 'cn', 'Pinglu Xian', 1, 'pinglu-xian'),
(39089, 745066, 'cn', 'Pingshun Xian', 1, 'pingshun-xian'),
(39090, 745066, 'cn', 'Pingyao Xian', 1, 'pingyao-xian'),
(39091, 745066, 'cn', 'Pu Xian', 1, 'pu-xian'),
(39092, 745066, 'cn', 'Qi Xian', 1, 'qi-xian'),
(39093, 745066, 'cn', 'Qin Xian', 1, 'qin-xian'),
(39094, 745066, 'cn', 'Qingxu Xian', 1, 'qingxu-xian'),
(39095, 745066, 'cn', 'Qinshui Xian', 1, 'qinshui-xian'),
(39096, 745066, 'cn', 'Qinyuan Xian', 1, 'qinyuan-xian'),
(39097, 745066, 'cn', 'Quwo Xian', 1, 'quwo-xian'),
(39098, 745066, 'cn', 'Ruicheng Xian', 1, 'ruicheng-xian'),
(39099, 745066, 'cn', 'Shanyin Xian', 1, 'shanyin-xian'),
(39100, 745066, 'cn', 'Shenchi Xian', 1, 'shenchi-xian'),
(39101, 745066, 'cn', 'Shilou Xian', 1, 'shilou-xian'),
(39102, 745066, 'cn', 'Shouyang Xian', 1, 'shouyang-xian'),
(39103, 745066, 'cn', 'Shuo Xian', 1, 'shuo-xian'),
(39104, 745066, 'cn', 'Taigu Xian', 1, 'taigu-xian'),
(39105, 745066, 'cn', 'Taiyuan', 1, 'taiyuan'),
(39106, 745066, 'cn', 'Taiyuan Shi', 1, 'taiyuan-shi'),
(39107, 745066, 'cn', 'Tianzhen Xian', 1, 'tianzhen-xian'),
(39108, 745066, 'cn', 'Tunliu Xian', 1, 'tunliu-xian'),
(39109, 745066, 'cn', 'Wanrong Xian', 1, 'wanrong-xian'),
(39110, 745066, 'cn', 'Wenshui Xian', 1, 'wenshui-xian'),
(39111, 745066, 'cn', 'Wenxi Xian', 1, 'wenxi-xian'),
(39112, 745066, 'cn', 'Wutai Xian', 1, 'wutai-xian'),
(39113, 745066, 'cn', 'Wuxiang Xian', 1, 'wuxiang-xian'),
(39114, 745066, 'cn', 'Wuzhai Xian', 1, 'wuzhai-xian'),
(39115, 745066, 'cn', 'Xi Xian', 1, 'xi-xian'),
(39116, 745066, 'cn', 'Xia Xian', 1, 'xia-xian'),
(39117, 745066, 'cn', 'Xiangfen Xian', 1, 'xiangfen-xian'),
(39118, 745066, 'cn', 'Xiangning Xian', 1, 'xiangning-xian'),
(39119, 745066, 'cn', 'Xiangyuan Xian', 1, 'xiangyuan-xian'),
(39120, 745066, 'cn', 'Xiaoyi Xian', 1, 'xiaoyi-xian'),
(39121, 745066, 'cn', 'Xing Xian', 1, 'xing-xian'),
(39122, 745066, 'cn', 'Xinjiang Xian', 1, 'xinjiang-xian'),
(39123, 745066, 'cn', 'Xinzhou Diqu', 1, 'xinzhou-diqu'),
(39124, 745066, 'cn', 'Xinzhou Shi', 1, 'xinzhou-shi'),
(39125, 745066, 'cn', 'Xiyang Xian', 1, 'xiyang-xian'),
(39126, 745066, 'cn', 'Yanbei Diqu', 1, 'yanbei-diqu'),
(39127, 745066, 'cn', 'Yangcheng Xian', 1, 'yangcheng-xian'),
(39128, 745066, 'cn', 'Yanggao Xian', 1, 'yanggao-xian'),
(39129, 745066, 'cn', 'Yangqu Xian', 1, 'yangqu-xian'),
(39130, 745066, 'cn', 'Yangquan Shi', 1, 'yangquan-shi'),
(39131, 745066, 'cn', 'Yicheng Xian', 1, 'yicheng-xian'),
(39132, 745066, 'cn', 'Ying Xian', 1, 'ying-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745166, 'cn', 'Sìchuan', 1, 'sichuan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39133, 745166, 'cn', 'Aba Xian', 1, 'aba-xian'),
(39134, 745166, 'cn', 'Aba Zangzu Zizhizhou', 1, 'aba-zangzu-zizhizhou'),
(39135, 745166, 'cn', 'An Xian', 1, 'an-xian'),
(39136, 745166, 'cn', 'Anyue Xian', 1, 'anyue-xian'),
(39137, 745166, 'cn', 'Baiyü Xian', 1, 'baiyu-xian'),
(39138, 745166, 'cn', 'Baoxing Xian', 1, 'baoxing-xian'),
(39139, 745166, 'cn', 'Barkam Xian', 1, 'barkam-xian'),
(39140, 745166, 'cn', 'Batang Xian', 1, 'batang-xian'),
(39141, 745166, 'cn', 'Bazhong Xian', 1, 'bazhong-xian'),
(39142, 745166, 'cn', 'Beichuan Xian', 1, 'beichuan-xian'),
(39143, 745166, 'cn', 'Butuo Xian', 1, 'butuo-xian'),
(39144, 745166, 'cn', 'Cangxi Xian', 1, 'cangxi-xian'),
(39145, 745166, 'cn', 'Changning Xian', 1, 'changning-xian'),
(39146, 745166, 'cn', 'Chengdu', 1, 'chengdu'),
(39147, 745166, 'cn', 'Chengdu Shi', 1, 'chengdu-shi'),
(39148, 745166, 'cn', 'Chongqing Xian', 1, 'chongqing-xian'),
(39149, 745166, 'cn', 'Da Xian', 1, 'da-xian'),
(39150, 745166, 'cn', 'Dachuan Diqu', 1, 'dachuan-diqu'),
(39151, 745166, 'cn', 'Dachuan Shi', 1, 'dachuan-shi'),
(39152, 745166, 'cn', 'Danba Xian', 1, 'danba-xian'),
(39153, 745166, 'cn', 'Danleng Xian', 1, 'danleng-xian'),
(39154, 745166, 'cn', 'Daocheng Xian', 1, 'daocheng-xian'),
(39155, 745166, 'cn', 'Dawu Xian', 1, 'dawu-xian'),
(39156, 745166, 'cn', 'Dayi Xian', 1, 'dayi-xian'),
(39157, 745166, 'cn', 'Dazhu Xian', 1, 'dazhu-xian'),
(39158, 745166, 'cn', 'Dechang Xian', 1, 'dechang-xian'),
(39159, 745166, 'cn', 'Dêgê Xian', 1, 'dege-xian'),
(39160, 745166, 'cn', 'Dêrong Xian', 1, 'derong-xian'),
(39161, 745166, 'cn', 'Deyang Shi', 1, 'deyang-shi'),
(39162, 745166, 'cn', 'Ebian Yizu Zizhixian', 1, 'ebian-yizu-zizhixian'),
(39163, 745166, 'cn', 'Emei Xian', 1, 'emei-xian'),
(39164, 745166, 'cn', 'Fushun Xian', 1, 'fushun-xian'),
(39165, 745166, 'cn', 'Ganluo Xian', 1, 'ganluo-xian'),
(39166, 745166, 'cn', 'Gao Xian', 1, 'gao-xian'),
(39167, 745166, 'cn', 'Garzê Xian', 1, 'garze-xian'),
(39168, 745166, 'cn', 'Garzê Zangzu Zizhizhou', 1, 'garze-zangzu-zizhizhou'),
(39169, 745166, 'cn', 'Gong Xian', 1, 'gong-xian'),
(39170, 745166, 'cn', 'Guan Xian', 1, 'guan-xian'),
(39171, 745166, 'cn', 'Guanghan Xian', 1, 'guanghan-xian'),
(39172, 745166, 'cn', 'Guangyuan Shi', 1, 'guangyuan-shi'),
(39173, 745166, 'cn', 'Guang´an Xian', 1, 'guangan-xian'),
(39174, 745166, 'cn', 'Gulin Xian', 1, 'gulin-xian'),
(39175, 745166, 'cn', 'Hanyuan Xian', 1, 'hanyuan-xian'),
(39176, 745166, 'cn', 'Heishui Xian', 1, 'heishui-xian'),
(39177, 745166, 'cn', 'Hejiang Xian', 1, 'hejiang-xian'),
(39178, 745166, 'cn', 'Hongya Xian', 1, 'hongya-xian'),
(39179, 745166, 'cn', 'Hongyuan Xian', 1, 'hongyuan-xian'),
(39180, 745166, 'cn', 'Huaying Shi', 1, 'huaying-shi'),
(39181, 745166, 'cn', 'Huidong Xian', 1, 'huidong-xian'),
(39182, 745166, 'cn', 'Huili Xian', 1, 'huili-xian'),
(39183, 745166, 'cn', 'Jiajiang Xian', 1, 'jiajiang-xian'),
(39184, 745166, 'cn', 'Jiange Xian', 1, 'jiange-xian'),
(39185, 745166, 'cn', 'Jiangyou Shi', 1, 'jiangyou-shi'),
(39186, 745166, 'cn', 'Jiang´an Xian', 1, 'jiangan-xian'),
(39187, 745166, 'cn', 'Jianyang Xian', 1, 'jianyang-xian'),
(39188, 745166, 'cn', 'Jinchuan Xian', 1, 'jinchuan-xian'),
(39189, 745166, 'cn', 'Jingyan Xian', 1, 'jingyan-xian'),
(39190, 745166, 'cn', 'Jintang Xian', 1, 'jintang-xian'),
(39191, 745166, 'cn', 'Jinyang Xian', 1, 'jinyang-xian'),
(39192, 745166, 'cn', 'Jiulong Xian', 1, 'jiulong-xian'),
(39193, 745166, 'cn', 'Junlian Xian', 1, 'junlian-xian'),
(39194, 745166, 'cn', 'Kaijiang Xian', 1, 'kaijiang-xian'),
(39195, 745166, 'cn', 'Kangding Xian', 1, 'kangding-xian'),
(39196, 745166, 'cn', 'Langzhong Xian', 1, 'langzhong-xian'),
(39197, 745166, 'cn', 'Leibo Xian', 1, 'leibo-xian'),
(39198, 745166, 'cn', 'Leshan Shi', 1, 'leshan-shi'),
(39199, 745166, 'cn', 'Lezhi Xian', 1, 'lezhi-xian'),
(39200, 745166, 'cn', 'Li Xian', 1, 'li-xian'),
(39201, 745166, 'cn', 'Liangshan Yizu Zizhizhou', 1, 'liangshan-yizu-zizhizhou'),
(39202, 745166, 'cn', 'Linshui Xian', 1, 'linshui-xian'),
(39203, 745166, 'cn', 'Litang Xian', 1, 'litang-xian'),
(39204, 745166, 'cn', 'Longchang Xian', 1, 'longchang-xian'),
(39205, 745166, 'cn', 'Lu Xian', 1, 'lu-xian'),
(39206, 745166, 'cn', 'Luding Xian', 1, 'luding-xian'),
(39207, 745166, 'cn', 'Luhuo Xian', 1, 'luhuo-xian'),
(39208, 745166, 'cn', 'Lushan Xian', 1, 'lushan-xian'),
(39209, 745166, 'cn', 'Luzhou Shi', 1, 'luzhou-shi'),
(39210, 745166, 'cn', 'Mabian Yizu Zizhixian', 1, 'mabian-yizu-zizhixian'),
(39211, 745166, 'cn', 'Maowen Qiangzu Zizhixian', 1, 'maowen-qiangzu-zizhixian'),
(39212, 745166, 'cn', 'Meigu Xian', 1, 'meigu-xian'),
(39213, 745166, 'cn', 'Meishan Xian', 1, 'meishan-xian'),
(39214, 745166, 'cn', 'Mianning Xian', 1, 'mianning-xian'),
(39215, 745166, 'cn', 'Mianyang Shi', 1, 'mianyang-shi'),
(39216, 745166, 'cn', 'Mianzhu Xian', 1, 'mianzhu-xian'),
(39217, 745166, 'cn', 'Mingshan Xian', 1, 'mingshan-xian'),
(39218, 745166, 'cn', 'Miyi Xian', 1, 'miyi-xian'),
(39219, 745166, 'cn', 'Muchuan Xian', 1, 'muchuan-xian'),
(39220, 745166, 'cn', 'Muli Zangzu Zizhixian', 1, 'muli-zangzu-zizhixian'),
(39221, 745166, 'cn', 'Nanbu Xian', 1, 'nanbu-xian'),
(39222, 745166, 'cn', 'Nanchong Diqu', 1, 'nanchong-diqu'),
(39223, 745166, 'cn', 'Nanchong Shi', 1, 'nanchong-shi'),
(39224, 745166, 'cn', 'Nanchong Xian', 1, 'nanchong-xian'),
(39225, 745166, 'cn', 'Nanjiang Xian', 1, 'nanjiang-xian'),
(39226, 745166, 'cn', 'Nanping Xian', 1, 'nanping-xian'),
(39227, 745166, 'cn', 'Nanxi Xian', 1, 'nanxi-xian'),
(39228, 745166, 'cn', 'Neijiang Shi', 1, 'neijiang-shi'),
(39229, 745166, 'cn', 'Neijiang Xian', 1, 'neijiang-xian'),
(39230, 745166, 'cn', 'Ningnan Xian', 1, 'ningnan-xian'),
(39231, 745166, 'cn', 'Panzhihua Shi', 1, 'panzhihua-shi'),
(39232, 745166, 'cn', 'Suining', 1, 'suining'),
(39233, 745166, 'cn', 'Ya\'an', 1, 'yaan'),
(39234, 745166, 'cn', 'Yibin', 1, 'yibin'),
(39235, 745166, 'cn', 'Zigong', 1, 'zigong'),
(39236, 745166, 'cn', 'Ziyang', 1, 'ziyang');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745271, 'cn', 'Yúnnán', 1, 'yunnan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39237, 745271, 'cn', 'Anning Xian', 1, 'anning-xian'),
(39238, 745271, 'cn', 'Baoshan Diqu', 1, 'baoshan-diqu'),
(39239, 745271, 'cn', 'Baoshan Shi', 1, 'baoshan-shi'),
(39240, 745271, 'cn', 'Binchuan Xian', 1, 'binchuan-xian'),
(39241, 745271, 'cn', 'Cangyuan Vazu Zizhixian', 1, 'cangyuan-vazu-zizhixian'),
(39242, 745271, 'cn', 'Changning Xian', 1, 'changning-xian'),
(39243, 745271, 'cn', 'Chenggong Xian', 1, 'chenggong-xian'),
(39244, 745271, 'cn', 'Chengjiang Xian', 1, 'chengjiang-xian'),
(39245, 745271, 'cn', 'Chuxiong Shi', 1, 'chuxiong-shi'),
(39246, 745271, 'cn', 'Chuxiong Yizu Zizhizhou', 1, 'chuxiong-yizu-zizhizhou'),
(39247, 745271, 'cn', 'Daguan Xian', 1, 'daguan-xian'),
(39248, 745271, 'cn', 'Dali Baizu Zizhizhou', 1, 'dali-baizu-zizhizhou'),
(39249, 745271, 'cn', 'Dali Shi', 1, 'dali-shi'),
(39250, 745271, 'cn', 'Dayao Xian', 1, 'dayao-xian'),
(39251, 745271, 'cn', 'Dehong Daizu Jingpozu Zizhizhou', 1, 'dehong-daizu-jingpozu-zizhizhou'),
(39252, 745271, 'cn', 'Dêqên Xian', 1, 'deqen-xian'),
(39253, 745271, 'cn', 'Dêqên Zangzu Zizhizhou', 1, 'deqen-zangzu-zizhizhou'),
(39254, 745271, 'cn', 'Dongchuan Shi', 1, 'dongchuan-shi'),
(39255, 745271, 'cn', 'Eryuan Xian', 1, 'eryuan-xian'),
(39256, 745271, 'cn', 'Eshan Yizu Zizhixian', 1, 'eshan-yizu-zizhixian'),
(39257, 745271, 'cn', 'Fengqing Xian', 1, 'fengqing-xian'),
(39258, 745271, 'cn', 'Fugong Xian', 1, 'fugong-xian'),
(39259, 745271, 'cn', 'Fumin Xian', 1, 'fumin-xian'),
(39260, 745271, 'cn', 'Funing Xian', 1, 'funing-xian'),
(39261, 745271, 'cn', 'Fuyuan Xian', 1, 'fuyuan-xian'),
(39262, 745271, 'cn', 'Gejiu Shi', 1, 'gejiu-shi'),
(39263, 745271, 'cn', 'Gengma Daizu Vazu Zizhixian', 1, 'gengma-daizu-vazu-zizhixian'),
(39264, 745271, 'cn', 'Gongshan Drungzu Nuzu Zizhixian', 1, 'gongshan-drungzu-nuzu-zizhixian'),
(39265, 745271, 'cn', 'Guangnan Xian', 1, 'guangnan-xian'),
(39266, 745271, 'cn', 'Hekou Yaozu Zizhixian', 1, 'hekou-yaozu-zizhixian'),
(39267, 745271, 'cn', 'Heqing Xian', 1, 'heqing-xian'),
(39268, 745271, 'cn', 'Honghe Hanizu Yizu Zizhizhou', 1, 'honghe-hanizu-yizu-zizhizhou'),
(39269, 745271, 'cn', 'Honghe Xian', 1, 'honghe-xian'),
(39270, 745271, 'cn', 'Huaning Xian', 1, 'huaning-xian'),
(39271, 745271, 'cn', 'Huaping Xian', 1, 'huaping-xian'),
(39272, 745271, 'cn', 'Huize Xian', 1, 'huize-xian'),
(39273, 745271, 'cn', 'Jianchuan Xian', 1, 'jianchuan-xian'),
(39274, 745271, 'cn', 'Jiangcheng Hanizu Yizu Zizhixian', 1, 'jiangcheng-hanizu-yizu-zizhixian'),
(39275, 745271, 'cn', 'Jiangchuan Xian', 1, 'jiangchuan-xian'),
(39276, 745271, 'cn', 'Jianshui Xian', 1, 'jianshui-xian'),
(39277, 745271, 'cn', 'Jingdong Yizu Zizhixian', 1, 'jingdong-yizu-zizhixian'),
(39278, 745271, 'cn', 'Jinggu Daizu Yizu Zizhixian', 1, 'jinggu-daizu-yizu-zizhixian'),
(39279, 745271, 'cn', 'Jinghong Shi', 1, 'jinghong-shi'),
(39280, 745271, 'cn', 'Jinning Xian', 1, 'jinning-xian'),
(39281, 745271, 'cn', 'Jinping Miaozu Yaozu Daizu Zizhixian', 1, 'jinping-miaozu-yaozu-daizu-zizhixian'),
(39282, 745271, 'cn', 'Kaiyuan Shi', 1, 'kaiyuan-shi'),
(39283, 745271, 'cn', 'Kunming', 1, 'kunming'),
(39284, 745271, 'cn', 'Kunming Shi', 1, 'kunming-shi'),
(39285, 745271, 'cn', 'Lancang Lahuzu Zizhixian', 1, 'lancang-lahuzu-zizhixian'),
(39286, 745271, 'cn', 'Lanping Xian', 1, 'lanping-xian'),
(39287, 745271, 'cn', 'Lianghe Xian', 1, 'lianghe-xian'),
(39288, 745271, 'cn', 'Lijiang Diqu', 1, 'lijiang-diqu'),
(39289, 745271, 'cn', 'Lijiang Naxizu Zizhixian', 1, 'lijiang-naxizu-zizhixian'),
(39290, 745271, 'cn', 'Lincang Diqu', 1, 'lincang-diqu'),
(39291, 745271, 'cn', 'Lincang Xian', 1, 'lincang-xian'),
(39292, 745271, 'cn', 'Longchuan Xian', 1, 'longchuan-xian'),
(39293, 745271, 'cn', 'Longling Xian', 1, 'longling-xian'),
(39294, 745271, 'cn', 'Ludian Xian', 1, 'ludian-xian'),
(39295, 745271, 'cn', 'Lufeng Xian', 1, 'lufeng-xian'),
(39296, 745271, 'cn', 'Luliang Xian', 1, 'luliang-xian'),
(39297, 745271, 'cn', 'Lunan Yizu Zizhixian', 1, 'lunan-yizu-zizhixian'),
(39298, 745271, 'cn', 'Luoping Xian', 1, 'luoping-xian'),
(39299, 745271, 'cn', 'Luquan Yizu Miaozu Zizhixian', 1, 'luquan-yizu-miaozu-zizhixian'),
(39300, 745271, 'cn', 'Lushui Xian', 1, 'lushui-xian'),
(39301, 745271, 'cn', 'Luxi Xian', 1, 'luxi-xian'),
(39302, 745271, 'cn', 'Lüchun Xian', 1, 'luchun-xian'),
(39303, 745271, 'cn', 'Maguan Xian', 1, 'maguan-xian'),
(39304, 745271, 'cn', 'Malipo Xian', 1, 'malipo-xian'),
(39305, 745271, 'cn', 'Malong Xian', 1, 'malong-xian'),
(39306, 745271, 'cn', 'Menghai Xian', 1, 'menghai-xian'),
(39307, 745271, 'cn', 'Mengla Xian', 1, 'mengla-xian'),
(39308, 745271, 'cn', 'Menglian Daizu Lahuzu Vazu Zizhixian', 1, 'menglian-daizu-lahuzu-vazu-zizhixian'),
(39309, 745271, 'cn', 'Mengzi Xian', 1, 'mengzi-xian'),
(39310, 745271, 'cn', 'Midu Xian', 1, 'midu-xian'),
(39311, 745271, 'cn', 'Mile Xian', 1, 'mile-xian'),
(39312, 745271, 'cn', 'Mojiang Hanizu Zizhixian', 1, 'mojiang-hanizu-zizhixian'),
(39313, 745271, 'cn', 'Mouding Xian', 1, 'mouding-xian'),
(39314, 745271, 'cn', 'Nanhua Xian', 1, 'nanhua-xian'),
(39315, 745271, 'cn', 'Nanjian Yizu Zizhixian', 1, 'nanjian-yizu-zizhixian'),
(39316, 745271, 'cn', 'Ninglang Yizu Zizhixian', 1, 'ninglang-yizu-zizhixian'),
(39317, 745271, 'cn', 'Nujiang Lisuzu Zizhizhou', 1, 'nujiang-lisuzu-zizhizhou'),
(39318, 745271, 'cn', 'Pingbian Miaozu Zizhixian', 1, 'pingbian-miaozu-zizhixian'),
(39319, 745271, 'cn', 'Pu´er Hanizu Yizu Zizhixian', 1, 'puer-hanizu-yizu-zizhixian'),
(39320, 745271, 'cn', 'Qiaojia Xian', 1, 'qiaojia-xian'),
(39321, 745271, 'cn', 'Qiubei Xian', 1, 'qiubei-xian'),
(39322, 745271, 'cn', 'Qujing Diqu', 1, 'qujing-diqu'),
(39323, 745271, 'cn', 'Qujing Shi', 1, 'qujing-shi'),
(39324, 745271, 'cn', 'Ruili Xian', 1, 'ruili-xian'),
(39325, 745271, 'cn', 'Shidian Xian', 1, 'shidian-xian'),
(39326, 745271, 'cn', 'Shiping Xian', 1, 'shiping-xian'),
(39327, 745271, 'cn', 'Shizong Xian', 1, 'shizong-xian'),
(39328, 745271, 'cn', 'Shuangbai Xian', 1, 'shuangbai-xian'),
(39329, 745271, 'cn', 'Shuangjiang Lahuzu Vazu Blangzu Daizu Zizhixian', 1, 'shuangjiang-lahuzu-vazu-blangzu-daizu-zizhixian'),
(39330, 745271, 'cn', 'Shuifu Xian', 1, 'shuifu-xian'),
(39331, 745271, 'cn', 'Simao Diqu', 1, 'simao-diqu'),
(39332, 745271, 'cn', 'Simao Xian', 1, 'simao-xian'),
(39333, 745271, 'cn', 'Songming Xian', 1, 'songming-xian'),
(39334, 745271, 'cn', 'Suijiang Xian', 1, 'suijiang-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745370, 'cn', 'Zhèjiang', 1, 'zhejiang');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39335, 745370, 'cn', 'Anji Xian', 1, 'anji-xian'),
(39336, 745370, 'cn', 'Beilun Qu', 1, 'beilun-qu'),
(39337, 745370, 'cn', 'Cangnan Xian', 1, 'cangnan-xian'),
(39338, 745370, 'cn', 'Changshan Xian', 1, 'changshan-xian'),
(39339, 745370, 'cn', 'Changxing Xian', 1, 'changxing-xian'),
(39340, 745370, 'cn', 'Chun´an Xian', 1, 'chunan-xian'),
(39341, 745370, 'cn', 'Cixi Shi', 1, 'cixi-shi'),
(39342, 745370, 'cn', 'Daishan Xian', 1, 'daishan-xian'),
(39343, 745370, 'cn', 'Deqing Xian', 1, 'deqing-xian'),
(39344, 745370, 'cn', 'Dinghai Qu', 1, 'dinghai-qu'),
(39345, 745370, 'cn', 'Dongtou Xian', 1, 'dongtou-xian'),
(39346, 745370, 'cn', 'Dongyang Shi', 1, 'dongyang-shi'),
(39347, 745370, 'cn', 'Fenghua Shi', 1, 'fenghua-shi'),
(39348, 745370, 'cn', 'Fuyang Shi', 1, 'fuyang-shi'),
(39349, 745370, 'cn', 'Haining Shi', 1, 'haining-shi'),
(39350, 745370, 'cn', 'Haiyan Xian', 1, 'haiyan-xian'),
(39351, 745370, 'cn', 'Hangzhou', 1, 'hangzhou'),
(39352, 745370, 'cn', 'Hangzhou Shi', 1, 'hangzhou-shi'),
(39353, 745370, 'cn', 'Huangyan Qu', 1, 'huangyan-qu'),
(39354, 745370, 'cn', 'Huzhou Shi', 1, 'huzhou-shi'),
(39355, 745370, 'cn', 'Jiande Shi', 1, 'jiande-shi'),
(39356, 745370, 'cn', 'Jiangshan Shi', 1, 'jiangshan-shi'),
(39357, 745370, 'cn', 'Jiashan Xian', 1, 'jiashan-xian'),
(39358, 745370, 'cn', 'Jiaxing Shi', 1, 'jiaxing-shi'),
(39359, 745370, 'cn', 'Jingning Shezu Zizhixian', 1, 'jingning-shezu-zizhixian'),
(39360, 745370, 'cn', 'Jinhua Shi', 1, 'jinhua-shi'),
(39361, 745370, 'cn', 'Jinhua Xian', 1, 'jinhua-xian'),
(39362, 745370, 'cn', 'Jinyun Xian', 1, 'jinyun-xian'),
(39363, 745370, 'cn', 'Kaihua Xian', 1, 'kaihua-xian'),
(39364, 745370, 'cn', 'Lanxi Shi', 1, 'lanxi-shi'),
(39365, 745370, 'cn', 'Linhai Shi', 1, 'linhai-shi'),
(39366, 745370, 'cn', 'Lin´an Shi', 1, 'linan-shi'),
(39367, 745370, 'cn', 'Lishui Shi', 1, 'lishui-shi'),
(39368, 745370, 'cn', 'Longquan Shi', 1, 'longquan-shi'),
(39369, 745370, 'cn', 'Longwan Qu', 1, 'longwan-qu'),
(39370, 745370, 'cn', 'Longyou Xian', 1, 'longyou-xian'),
(39371, 745370, 'cn', 'Luqiao Qu', 1, 'luqiao-qu'),
(39372, 745370, 'cn', 'Ningbo Shi', 1, 'ningbo-shi'),
(39373, 745370, 'cn', 'Ninghai Xian', 1, 'ninghai-xian'),
(39374, 745370, 'cn', 'Ouhai Xian', 1, 'ouhai-xian'),
(39375, 745370, 'cn', 'Pan´an Xian', 1, 'panan-xian'),
(39376, 745370, 'cn', 'Pinghu Shi', 1, 'pinghu-shi'),
(39377, 745370, 'cn', 'Pingyang Xian', 1, 'pingyang-xian'),
(39378, 745370, 'cn', 'Pujiang Xian', 1, 'pujiang-xian'),
(39379, 745370, 'cn', 'Putuo Qu', 1, 'putuo-qu'),
(39380, 745370, 'cn', 'Qingtian Xian', 1, 'qingtian-xian'),
(39381, 745370, 'cn', 'Qingyuan Xian', 1, 'qingyuan-xian'),
(39382, 745370, 'cn', 'Qu Xian', 1, 'qu-xian'),
(39383, 745370, 'cn', 'Quzhou Shi', 1, 'quzhou-shi'),
(39384, 745370, 'cn', 'Rui´an Shi', 1, 'ruian-shi'),
(39385, 745370, 'cn', 'Sanmen Xian', 1, 'sanmen-xian'),
(39386, 745370, 'cn', 'Shangyu Shi', 1, 'shangyu-shi'),
(39387, 745370, 'cn', 'Shaoxing Shi', 1, 'shaoxing-shi'),
(39388, 745370, 'cn', 'Shaoxing Xian', 1, 'shaoxing-xian'),
(39389, 745370, 'cn', 'Shengsi Xian', 1, 'shengsi-xian'),
(39390, 745370, 'cn', 'Shengzhou Shi', 1, 'shengzhou-shi'),
(39391, 745370, 'cn', 'Songyang Xian', 1, 'songyang-xian'),
(39392, 745370, 'cn', 'Suichang Xian', 1, 'suichang-xian'),
(39393, 745370, 'cn', 'Taishun Xian', 1, 'taishun-xian'),
(39394, 745370, 'cn', 'Taizhou Shi', 1, 'taizhou-shi'),
(39395, 745370, 'cn', 'Tiantai Xian', 1, 'tiantai-xian'),
(39396, 745370, 'cn', 'Tonglu Xian', 1, 'tonglu-xian'),
(39397, 745370, 'cn', 'Tongxiang Shi', 1, 'tongxiang-shi'),
(39398, 745370, 'cn', 'Wencheng Xian', 1, 'wencheng-xian'),
(39399, 745370, 'cn', 'Wenling Shi', 1, 'wenling-shi'),
(39400, 745370, 'cn', 'Wenzhou Shi', 1, 'wenzhou-shi'),
(39401, 745370, 'cn', 'Wuyi Xian', 1, 'wuyi-xian'),
(39402, 745370, 'cn', 'Xiangshan Xian', 1, 'xiangshan-xian'),
(39403, 745370, 'cn', 'Xianju Xian', 1, 'xianju-xian'),
(39404, 745370, 'cn', 'Xiaoshan Shi', 1, 'xiaoshan-shi'),
(39405, 745370, 'cn', 'Xinchang Xian', 1, 'xinchang-xian'),
(39406, 745370, 'cn', 'Yin Xian', 1, 'yin-xian'),
(39407, 745370, 'cn', 'Yiwu Shi', 1, 'yiwu-shi'),
(39408, 745370, 'cn', 'Yongjia Xian', 1, 'yongjia-xian'),
(39409, 745370, 'cn', 'Yongkang Shi', 1, 'yongkang-shi'),
(39410, 745370, 'cn', 'Yueqing Shi', 1, 'yueqing-shi'),
(39411, 745370, 'cn', 'Yuhang Shi', 1, 'yuhang-shi'),
(39412, 745370, 'cn', 'Yuhuan Xian', 1, 'yuhuan-xian'),
(39413, 745370, 'cn', 'Yunhe Xian', 1, 'yunhe-xian'),
(39414, 745370, 'cn', 'Yuyao Shi', 1, 'yuyao-shi'),
(39415, 745370, 'cn', 'Zhejiang Sheng', 1, 'zhejiang-sheng'),
(39416, 745370, 'cn', 'Zhenhai Qu', 1, 'zhenhai-qu'),
(39417, 745370, 'cn', 'Zhoushan Shi', 1, 'zhoushan-shi'),
(39418, 745370, 'cn', 'Zhuji Shi', 1, 'zhuji-shi');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745455, 'cn', 'Zhuang de Guangxi', 1, 'zhuang-de-guangxi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39419, 745455, 'cn', 'Bama Yaozu Zizhixian', 1, 'bama-yaozu-zizhixian'),
(39420, 745455, 'cn', 'Beihai Shi', 1, 'beihai-shi'),
(39421, 745455, 'cn', 'Beiliu Xian', 1, 'beiliu-xian'),
(39422, 745455, 'cn', 'Binyang Xian', 1, 'binyang-xian'),
(39423, 745455, 'cn', 'Bobai Xian', 1, 'bobai-xian'),
(39424, 745455, 'cn', 'Bose Diqu', 1, 'bose-diqu'),
(39425, 745455, 'cn', 'Bose Shi', 1, 'bose-shi'),
(39426, 745455, 'cn', 'Cangwu Xian', 1, 'cangwu-xian'),
(39427, 745455, 'cn', 'Cenxi Xian', 1, 'cenxi-xian'),
(39428, 745455, 'cn', 'Chongzuo Xian', 1, 'chongzuo-xian'),
(39429, 745455, 'cn', 'Chuanshan Xiang', 1, 'chuanshan-xiang'),
(39430, 745455, 'cn', 'Daxin Xian', 1, 'daxin-xian'),
(39431, 745455, 'cn', 'Debao Xian', 1, 'debao-xian'),
(39432, 745455, 'cn', 'Donglan Xian', 1, 'donglan-xian'),
(39433, 745455, 'cn', 'Du´an Yaozu Zizhixian', 1, 'duan-yaozu-zizhixian'),
(39434, 745455, 'cn', 'Fangcheng Gezu Zizhixian', 1, 'fangcheng-gezu-zizhixian'),
(39435, 745455, 'cn', 'Fengshan Xian', 1, 'fengshan-xian'),
(39436, 745455, 'cn', 'Fuchuan Yaozu Zizhixian', 1, 'fuchuan-yaozu-zizhixian'),
(39437, 745455, 'cn', 'Fusui Xian', 1, 'fusui-xian'),
(39438, 745455, 'cn', 'Gongcheng Xian', 1, 'gongcheng-xian'),
(39439, 745455, 'cn', 'Guangxi Zhuangzu Zizhiqu', 1, 'guangxi-zhuangzu-zizhiqu'),
(39440, 745455, 'cn', 'Guanyang Xian', 1, 'guanyang-xian'),
(39441, 745455, 'cn', 'Gui Xian', 1, 'gui-xian'),
(39442, 745455, 'cn', 'Guilin Shi', 1, 'guilin-shi'),
(39443, 745455, 'cn', 'Guiping Xian', 1, 'guiping-xian'),
(39444, 745455, 'cn', 'He Xian', 1, 'he-xian'),
(39445, 745455, 'cn', 'Hechi Diqu', 1, 'hechi-diqu'),
(39446, 745455, 'cn', 'Hechi Shi', 1, 'hechi-shi'),
(39447, 745455, 'cn', 'Heng Xian', 1, 'heng-xian'),
(39448, 745455, 'cn', 'Hepu Xian', 1, 'hepu-xian'),
(39449, 745455, 'cn', 'Heshan Shi', 1, 'heshan-shi'),
(39450, 745455, 'cn', 'Huanjiang Maonanzu Zizhixian', 1, 'huanjiang-maonanzu-zizhixian'),
(39451, 745455, 'cn', 'Jingxi Xian', 1, 'jingxi-xian'),
(39452, 745455, 'cn', 'Jinxiu Yaozu Zizhixian', 1, 'jinxiu-yaozu-zizhixian'),
(39453, 745455, 'cn', 'Laibin Xian', 1, 'laibin-xian'),
(39454, 745455, 'cn', 'Leye Xian', 1, 'leye-xian'),
(39455, 745455, 'cn', 'Lingchuan Xian', 1, 'lingchuan-xian'),
(39456, 745455, 'cn', 'Lingshan Xian', 1, 'lingshan-xian'),
(39457, 745455, 'cn', 'Lingui Xian', 1, 'lingui-xian'),
(39458, 745455, 'cn', 'Lingyun Xian', 1, 'lingyun-xian'),
(39459, 745455, 'cn', 'Lipu Xian', 1, 'lipu-xian'),
(39460, 745455, 'cn', 'Liucheng Xian', 1, 'liucheng-xian'),
(39461, 745455, 'cn', 'Liujiang Xian', 1, 'liujiang-xian'),
(39462, 745455, 'cn', 'Liuzhou Diqu', 1, 'liuzhou-diqu'),
(39463, 745455, 'cn', 'Liuzhou Shi', 1, 'liuzhou-shi'),
(39464, 745455, 'cn', 'Longlin Gezu Zizhixian', 1, 'longlin-gezu-zizhixian'),
(39465, 745455, 'cn', 'Longsheng Gezu Zizhixian', 1, 'longsheng-gezu-zizhixian'),
(39466, 745455, 'cn', 'Longzhou Xian', 1, 'longzhou-xian'),
(39467, 745455, 'cn', 'Long´an Xian', 1, 'longan-xian'),
(39468, 745455, 'cn', 'Luchuan Xian', 1, 'luchuan-xian'),
(39469, 745455, 'cn', 'Luocheng Mulamzu Zizhixian', 1, 'luocheng-mulamzu-zizhixian'),
(39470, 745455, 'cn', 'Luzhai Xian', 1, 'luzhai-xian'),
(39471, 745455, 'cn', 'Mashan Xian', 1, 'mashan-xian'),
(39472, 745455, 'cn', 'Mengshan Xian', 1, 'mengshan-xian'),
(39473, 745455, 'cn', 'Nandan Xian', 1, 'nandan-xian'),
(39474, 745455, 'cn', 'Nanning', 1, 'nanning'),
(39475, 745455, 'cn', 'Nanning Diqu', 1, 'nanning-diqu'),
(39476, 745455, 'cn', 'Nanning Shi', 1, 'nanning-shi'),
(39477, 745455, 'cn', 'Napo Xian', 1, 'napo-xian'),
(39478, 745455, 'cn', 'Ningming Xian', 1, 'ningming-xian'),
(39479, 745455, 'cn', 'Pingguo Xian', 1, 'pingguo-xian'),
(39480, 745455, 'cn', 'Pingle Xian', 1, 'pingle-xian'),
(39481, 745455, 'cn', 'Pingnan Xian', 1, 'pingnan-xian'),
(39482, 745455, 'cn', 'Pingxiang Shi', 1, 'pingxiang-shi'),
(39483, 745455, 'cn', 'Pubei Xian', 1, 'pubei-xian'),
(39484, 745455, 'cn', 'Qinzhou Diqu', 1, 'qinzhou-diqu'),
(39485, 745455, 'cn', 'Qinzhou Shi', 1, 'qinzhou-shi'),
(39486, 745455, 'cn', 'Quanzhou Xian', 1, 'quanzhou-xian'),
(39487, 745455, 'cn', 'Rong Xian', 1, 'rong-xian'),
(39488, 745455, 'cn', 'Rongshui Miaozu Zizhixian', 1, 'rongshui-miaozu-zizhixian'),
(39489, 745455, 'cn', 'Rong´an Xian', 1, 'rongan-xian'),
(39490, 745455, 'cn', 'Sanjiang Dongzu Zizhixian', 1, 'sanjiang-dongzu-zizhixian'),
(39491, 745455, 'cn', 'Shanglin Xian', 1, 'shanglin-xian'),
(39492, 745455, 'cn', 'Shangsi Xian', 1, 'shangsi-xian'),
(39493, 745455, 'cn', 'Teng Xian', 1, 'teng-xian'),
(39494, 745455, 'cn', 'Tiandeng Xian', 1, 'tiandeng-xian'),
(39495, 745455, 'cn', 'Tiandong Xian', 1, 'tiandong-xian'),
(39496, 745455, 'cn', 'Tianlin Xian', 1, 'tianlin-xian'),
(39497, 745455, 'cn', 'Tianyang Xian', 1, 'tianyang-xian'),
(39498, 745455, 'cn', 'Tian´e Xian', 1, 'tiane-xian'),
(39499, 745455, 'cn', 'Wuming Xian', 1, 'wuming-xian'),
(39500, 745455, 'cn', 'Wuxuan Xian', 1, 'wuxuan-xian'),
(39501, 745455, 'cn', 'Wuzhou Diqu', 1, 'wuzhou-diqu'),
(39502, 745455, 'cn', 'Wuzhou Shi', 1, 'wuzhou-shi'),
(39503, 745455, 'cn', 'Xiangzhou Xian', 1, 'xiangzhou-xian'),
(39504, 745455, 'cn', 'Xilin Xian', 1, 'xilin-xian'),
(39505, 745455, 'cn', 'Xincheng Xian', 1, 'xincheng-xian'),
(39506, 745455, 'cn', 'Xing´an Xian', 1, 'xingan-xian'),
(39507, 745455, 'cn', 'Yangshuo Xian', 1, 'yangshuo-xian'),
(39508, 745455, 'cn', 'Yishan Xian', 1, 'yishan-xian'),
(39509, 745455, 'cn', 'Yongfu Xian', 1, 'yongfu-xian'),
(39510, 745455, 'cn', 'Yongning Xian', 1, 'yongning-xian'),
(39511, 745455, 'cn', 'Yulin Diqu', 1, 'yulin-diqu'),
(39512, 745455, 'cn', 'Yulin Shi', 1, 'yulin-shi'),
(39513, 745455, 'cn', 'Zhaoping Xian', 1, 'zhaoping-xian'),
(39514, 745455, 'cn', 'Zhongshan Xian', 1, 'zhongshan-xian'),
(39515, 745455, 'cn', 'Ziyuan Xian', 1, 'ziyuan-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745553, 'cn', 'Mongolia Interior', 1, 'mongolia-interior');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39516, 745553, 'cn', 'Abag Qi', 1, 'abag-qi'),
(39517, 745553, 'cn', 'Alxa Meng', 1, 'alxa-meng'),
(39518, 745553, 'cn', 'Alxa Youqi', 1, 'alxa-youqi'),
(39519, 745553, 'cn', 'Alxa Zuoqi', 1, 'alxa-zuoqi'),
(39520, 745553, 'cn', 'Aohan Qi', 1, 'aohan-qi'),
(39521, 745553, 'cn', 'Ar Horqin Qi', 1, 'ar-horqin-qi'),
(39522, 745553, 'cn', 'Arun Qi', 1, 'arun-qi'),
(39523, 745553, 'cn', 'Bairin Youqi', 1, 'bairin-youqi'),
(39524, 745553, 'cn', 'Bairin Zuoqi', 1, 'bairin-zuoqi'),
(39525, 745553, 'cn', 'Baotou Shi', 1, 'baotou-shi'),
(39526, 745553, 'cn', 'Bayannur Meng', 1, 'bayannur-meng'),
(39527, 745553, 'cn', 'Chen Barag Qi', 1, 'chen-barag-qi'),
(39528, 745553, 'cn', 'Chifeng Shi', 1, 'chifeng-shi'),
(39529, 745553, 'cn', 'Dalad Qi', 1, 'dalad-qi'),
(39530, 745553, 'cn', 'Darhan Muminggan Lianheqi', 1, 'darhan-muminggan-lianheqi'),
(39531, 745553, 'cn', 'Dengkou Xian', 1, 'dengkou-xian'),
(39532, 745553, 'cn', 'Dong Ujimqin Qi', 1, 'dong-ujimqin-qi'),
(39533, 745553, 'cn', 'Dongsheng Shi', 1, 'dongsheng-shi'),
(39534, 745553, 'cn', 'Duolun Xian', 1, 'duolun-xian'),
(39535, 745553, 'cn', 'Ejin Horo Qi', 1, 'ejin-horo-qi'),
(39536, 745553, 'cn', 'Ejin Qi', 1, 'ejin-qi'),
(39537, 745553, 'cn', 'Erenhot Shi', 1, 'erenhot-shi'),
(39538, 745553, 'cn', 'Ergun Youqi', 1, 'ergun-youqi'),
(39539, 745553, 'cn', 'Ergun Zuoqi', 1, 'ergun-zuoqi'),
(39540, 745553, 'cn', 'Ewenkizu Zizhiqi', 1, 'ewenkizu-zizhiqi'),
(39541, 745553, 'cn', 'Fengzhen Shi', 1, 'fengzhen-shi'),
(39542, 745553, 'cn', 'Guyang Xian', 1, 'guyang-xian'),
(39543, 745553, 'cn', 'Hailar Shi', 1, 'hailar-shi'),
(39544, 745553, 'cn', 'Hanggin Houqi', 1, 'hanggin-houqi'),
(39545, 745553, 'cn', 'Hanggin Qi', 1, 'hanggin-qi'),
(39546, 745553, 'cn', 'Harqin Qi', 1, 'harqin-qi'),
(39547, 745553, 'cn', 'Hexigten Qi', 1, 'hexigten-qi'),
(39548, 745553, 'cn', 'Hinggan Meng', 1, 'hinggan-meng'),
(39549, 745553, 'cn', 'Hohhot', 1, 'hohhot'),
(39550, 745553, 'cn', 'Hohhot Shi', 1, 'hohhot-shi'),
(39551, 745553, 'cn', 'Horinger Xian', 1, 'horinger-xian'),
(39552, 745553, 'cn', 'Horqin Youyi Qianqi', 1, 'horqin-youyi-qianqi'),
(39553, 745553, 'cn', 'Horqin Youyi Zhongqi', 1, 'horqin-youyi-zhongqi'),
(39554, 745553, 'cn', 'Horqin Zuoyi Houqi', 1, 'horqin-zuoyi-houqi'),
(39555, 745553, 'cn', 'Horqin Zuoyi Zhongqi', 1, 'horqin-zuoyi-zhongqi'),
(39556, 745553, 'cn', 'Huade Xian', 1, 'huade-xian'),
(39557, 745553, 'cn', 'Hulun Buir Meng', 1, 'hulun-buir-meng'),
(39558, 745553, 'cn', 'Hure Qi', 1, 'hure-qi'),
(39559, 745553, 'cn', 'Ih Ju Meng', 1, 'ih-ju-meng'),
(39560, 745553, 'cn', 'Inner Mongolia Autonomous Region', 1, 'inner-mongolia-autonomous-region'),
(39561, 745553, 'cn', 'Jalaid Qi', 1, 'jalaid-qi'),
(39562, 745553, 'cn', 'Jarud Qi', 1, 'jarud-qi'),
(39563, 745553, 'cn', 'Jining Shi', 1, 'jining-shi'),
(39564, 745553, 'cn', 'Jirem Meng', 1, 'jirem-meng'),
(39565, 745553, 'cn', 'Jungar Qi', 1, 'jungar-qi'),
(39566, 745553, 'cn', 'Kailu Xian', 1, 'kailu-xian'),
(39567, 745553, 'cn', 'Liangcheng Xian', 1, 'liangcheng-xian'),
(39568, 745553, 'cn', 'Linhe Shi', 1, 'linhe-shi'),
(39569, 745553, 'cn', 'Linxi Xian', 1, 'linxi-xian'),
(39570, 745553, 'cn', 'Manzhouli Shi', 1, 'manzhouli-shi'),
(39571, 745553, 'cn', 'Morin Dawa Daurzu Zizhiqi', 1, 'morin-dawa-daurzu-zizhiqi'),
(39572, 745553, 'cn', 'Naiman Qi', 1, 'naiman-qi'),
(39573, 745553, 'cn', 'Ningcheng Xian', 1, 'ningcheng-xian'),
(39574, 745553, 'cn', 'Ongniud Qi', 1, 'ongniud-qi'),
(39575, 745553, 'cn', 'Oroqen Zizhiqi', 1, 'oroqen-zizhiqi'),
(39576, 745553, 'cn', 'Otog Qi', 1, 'otog-qi'),
(39577, 745553, 'cn', 'Otog Qianqi', 1, 'otog-qianqi'),
(39578, 745553, 'cn', 'Qahar Youyi Houqi', 1, 'qahar-youyi-houqi'),
(39579, 745553, 'cn', 'Qahar Youyi Qianqi', 1, 'qahar-youyi-qianqi'),
(39580, 745553, 'cn', 'Qahar Youyi Zhongqi', 1, 'qahar-youyi-zhongqi'),
(39581, 745553, 'cn', 'Qingshuihe Xian', 1, 'qingshuihe-xian'),
(39582, 745553, 'cn', 'Shangdu Xian', 1, 'shangdu-xian'),
(39583, 745553, 'cn', 'Siziwang Qi', 1, 'siziwang-qi'),
(39584, 745553, 'cn', 'Sonid Youqi', 1, 'sonid-youqi'),
(39585, 745553, 'cn', 'Sonid Zuoqi', 1, 'sonid-zuoqi'),
(39586, 745553, 'cn', 'Taibus Qi', 1, 'taibus-qi'),
(39587, 745553, 'cn', 'Togtoh Xian', 1, 'togtoh-xian'),
(39588, 745553, 'cn', 'Tongliao Shi', 1, 'tongliao-shi'),
(39589, 745553, 'cn', 'Tumd Youqi', 1, 'tumd-youqi'),
(39590, 745553, 'cn', 'Tumd Zouqi', 1, 'tumd-zouqi'),
(39591, 745553, 'cn', 'Tuquan Xian', 1, 'tuquan-xian'),
(39592, 745553, 'cn', 'Ulan Hot Shi', 1, 'ulan-hot-shi'),
(39593, 745553, 'cn', 'Ulanqab Meng', 1, 'ulanqab-meng'),
(39594, 745553, 'cn', 'Urad Houqi', 1, 'urad-houqi'),
(39595, 745553, 'cn', 'Urad Qianqi', 1, 'urad-qianqi'),
(39596, 745553, 'cn', 'Urad Zhongqi', 1, 'urad-zhongqi'),
(39597, 745553, 'cn', 'Uxin Qi', 1, 'uxin-qi'),
(39598, 745553, 'cn', 'Wuchuan Xian', 1, 'wuchuan-xian'),
(39599, 745553, 'cn', 'Wuhai Shi', 1, 'wuhai-shi'),
(39600, 745553, 'cn', 'Wuyuan Xian', 1, 'wuyuan-xian'),
(39601, 745553, 'cn', 'Xi Ujimqin Qi', 1, 'xi-ujimqin-qi'),
(39602, 745553, 'cn', 'Xianghuang Qi', 1, 'xianghuang-qi'),
(39603, 745553, 'cn', 'Xilin Gol Meng', 1, 'xilin-gol-meng'),
(39604, 745553, 'cn', 'Xilinhot Shi', 1, 'xilinhot-shi'),
(39605, 745553, 'cn', 'Xin Barag Youqi', 1, 'xin-barag-youqi'),
(39606, 745553, 'cn', 'Xinghe Xian', 1, 'xinghe-xian'),
(39607, 745553, 'cn', 'Yakeshi Shi', 1, 'yakeshi-shi'),
(39608, 745553, 'cn', 'Zalantun Shi', 1, 'zalantun-shi'),
(39609, 745553, 'cn', 'Zhenglan Qi', 1, 'zhenglan-qi'),
(39610, 745553, 'cn', 'Zhengxiangbai Qi', 1, 'zhengxiangbai-qi'),
(39611, 745553, 'cn', 'Zhuozi Xian', 1, 'zhuozi-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745650, 'cn', 'Hui de Níngxià', 1, 'hui-de-ningxia');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39612, 745650, 'cn', 'Guyuan Diqu', 1, 'guyuan-diqu'),
(39613, 745650, 'cn', 'Guyuan Xian', 1, 'guyuan-xian'),
(39614, 745650, 'cn', 'Haiyuan Xian', 1, 'haiyuan-xian'),
(39615, 745650, 'cn', 'Helan Xian', 1, 'helan-xian'),
(39616, 745650, 'cn', 'Jingyuan Xian', 1, 'jingyuan-xian'),
(39617, 745650, 'cn', 'Lingwu Xian', 1, 'lingwu-xian'),
(39618, 745650, 'cn', 'Longde Xian', 1, 'longde-xian'),
(39619, 745650, 'cn', 'Ningxia Huizu Zizhiqu', 1, 'ningxia-huizu-zizhiqu'),
(39620, 745650, 'cn', 'Pengyang Xian', 1, 'pengyang-xian'),
(39621, 745650, 'cn', 'Pingluo Xian', 1, 'pingluo-xian'),
(39622, 745650, 'cn', 'Qingtongxia Shi', 1, 'qingtongxia-shi'),
(39623, 745650, 'cn', 'Shizuishan Shi', 1, 'shizuishan-shi'),
(39624, 745650, 'cn', 'Taole Xian', 1, 'taole-xian'),
(39625, 745650, 'cn', 'Tongxin Xian', 1, 'tongxin-xian'),
(39626, 745650, 'cn', 'Wuzhong Shi', 1, 'wuzhong-shi'),
(39627, 745650, 'cn', 'Xiji Xian', 1, 'xiji-xian'),
(39628, 745650, 'cn', 'Yanchi Xian', 1, 'yanchi-xian'),
(39629, 745650, 'cn', 'Yinchuan', 1, 'yinchuan'),
(39630, 745650, 'cn', 'Yinchuan Shi', 1, 'yinchuan-shi'),
(39631, 745650, 'cn', 'Yinnan Diqu', 1, 'yinnan-diqu'),
(39632, 745650, 'cn', 'Yongning Xian', 1, 'yongning-xian'),
(39633, 745650, 'cn', 'Zhongning Xian', 1, 'zhongning-xian'),
(39634, 745650, 'cn', 'Zhongwei Xian', 1, 'zhongwei-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745674, 'cn', 'Uigur de Xinjian', 1, 'uigur-de-xinjian');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39635, 745674, 'cn', 'Akqi Xian', 1, 'akqi-xian'),
(39636, 745674, 'cn', 'Aksu Diqu', 1, 'aksu-diqu'),
(39637, 745674, 'cn', 'Aksu Shi', 1, 'aksu-shi'),
(39638, 745674, 'cn', 'Akto Xian', 1, 'akto-xian'),
(39639, 745674, 'cn', 'Altay Diqu', 1, 'altay-diqu'),
(39640, 745674, 'cn', 'Altay Shi', 1, 'altay-shi'),
(39641, 745674, 'cn', 'Artux Shi', 1, 'artux-shi'),
(39642, 745674, 'cn', 'Awat Xian', 1, 'awat-xian'),
(39643, 745674, 'cn', 'Bachu Xian', 1, 'bachu-xian'),
(39644, 745674, 'cn', 'Baicheng Xian', 1, 'baicheng-xian'),
(39645, 745674, 'cn', 'Barkol Kazak Zizhixian', 1, 'barkol-kazak-zizhixian'),
(39646, 745674, 'cn', 'Bayingolin Mongol Zizhizhou', 1, 'bayingolin-mongol-zizhizhou'),
(39647, 745674, 'cn', 'Bohu Xian', 1, 'bohu-xian'),
(39648, 745674, 'cn', 'Bole Shi', 1, 'bole-shi'),
(39649, 745674, 'cn', 'Bortala Mongol Zizhizhou', 1, 'bortala-mongol-zizhizhou'),
(39650, 745674, 'cn', 'Burqin Xian', 1, 'burqin-xian'),
(39651, 745674, 'cn', 'Changji Huizu Zizhizhou', 1, 'changji-huizu-zizhizhou'),
(39652, 745674, 'cn', 'Changji Shi', 1, 'changji-shi'),
(39653, 745674, 'cn', 'Emin Xian', 1, 'emin-xian'),
(39654, 745674, 'cn', 'Fuhai Xian', 1, 'fuhai-xian'),
(39655, 745674, 'cn', 'Fukang Xian', 1, 'fukang-xian'),
(39656, 745674, 'cn', 'Fuyun Xian', 1, 'fuyun-xian'),
(39657, 745674, 'cn', 'Gongliu Xian', 1, 'gongliu-xian'),
(39658, 745674, 'cn', 'Habahe Xian', 1, 'habahe-xian'),
(39659, 745674, 'cn', 'Hami Diqu', 1, 'hami-diqu'),
(39660, 745674, 'cn', 'Hami Shi', 1, 'hami-shi'),
(39661, 745674, 'cn', 'Hoboksar Mongol Zizhixian', 1, 'hoboksar-mongol-zizhixian'),
(39662, 745674, 'cn', 'Hotan Diqu', 1, 'hotan-diqu'),
(39663, 745674, 'cn', 'Hotan Shi', 1, 'hotan-shi'),
(39664, 745674, 'cn', 'Hotan Xian', 1, 'hotan-xian'),
(39665, 745674, 'cn', 'Huocheng Xian', 1, 'huocheng-xian'),
(39666, 745674, 'cn', 'Hutubi Xian', 1, 'hutubi-xian'),
(39667, 745674, 'cn', 'Ili Diqu', 1, 'ili-diqu'),
(39668, 745674, 'cn', 'Ili Kazak Zizhizhou', 1, 'ili-kazak-zizhizhou'),
(39669, 745674, 'cn', 'Jeminay Xian', 1, 'jeminay-xian'),
(39670, 745674, 'cn', 'Jiashi Xian', 1, 'jiashi-xian'),
(39671, 745674, 'cn', 'Jimsar Xian', 1, 'jimsar-xian'),
(39672, 745674, 'cn', 'Jinghe Xian', 1, 'jinghe-xian'),
(39673, 745674, 'cn', 'Kalpin Xian', 1, 'kalpin-xian'),
(39674, 745674, 'cn', 'Karamay Shi', 1, 'karamay-shi'),
(39675, 745674, 'cn', 'Kashi Diqu', 1, 'kashi-diqu'),
(39676, 745674, 'cn', 'Kashi Shi', 1, 'kashi-shi'),
(39677, 745674, 'cn', 'Kizilsu Kirgiz Zizhizhou', 1, 'kizilsu-kirgiz-zizhizhou'),
(39678, 745674, 'cn', 'Korla Shi', 1, 'korla-shi'),
(39679, 745674, 'cn', 'Kuqa Xian', 1, 'kuqa-xian'),
(39680, 745674, 'cn', 'Kuytun Shi', 1, 'kuytun-shi'),
(39681, 745674, 'cn', 'Lop Xian', 1, 'lop-xian'),
(39682, 745674, 'cn', 'Luntai Xian', 1, 'luntai-xian'),
(39683, 745674, 'cn', 'Manas Xian', 1, 'manas-xian'),
(39684, 745674, 'cn', 'Markit Xian', 1, 'markit-xian'),
(39685, 745674, 'cn', 'Minfeng Xian', 1, 'minfeng-xian'),
(39686, 745674, 'cn', 'Miquan Xian', 1, 'miquan-xian'),
(39687, 745674, 'cn', 'Mori Kazak Zizhixian', 1, 'mori-kazak-zizhixian'),
(39688, 745674, 'cn', 'Moyu Xia', 1, 'moyu-xia'),
(39689, 745674, 'cn', 'Nilka Xian', 1, 'nilka-xian'),
(39690, 745674, 'cn', 'Pishan Xian', 1, 'pishan-xian'),
(39691, 745674, 'cn', 'Qapqal Xibe Zizhixian', 1, 'qapqal-xibe-zizhixian'),
(39692, 745674, 'cn', 'Qiemo Xian', 1, 'qiemo-xian'),
(39693, 745674, 'cn', 'Qinghe Xian', 1, 'qinghe-xian'),
(39694, 745674, 'cn', 'Qira Xian', 1, 'qira-xian'),
(39695, 745674, 'cn', 'Qitai Xian', 1, 'qitai-xian'),
(39696, 745674, 'cn', 'Ruoqiang Xian', 1, 'ruoqiang-xian'),
(39697, 745674, 'cn', 'Shache Xian', 1, 'shache-xian'),
(39698, 745674, 'cn', 'Shanshan Xian', 1, 'shanshan-xian'),
(39699, 745674, 'cn', 'Shawan Xian', 1, 'shawan-xian'),
(39700, 745674, 'cn', 'Shihezi Shi', 1, 'shihezi-shi'),
(39701, 745674, 'cn', 'Shufu Xian', 1, 'shufu-xian'),
(39702, 745674, 'cn', 'Shule Xian', 1, 'shule-xian'),
(39703, 745674, 'cn', 'Tacheng Diqu', 1, 'tacheng-diqu'),
(39704, 745674, 'cn', 'Tacheng Shi', 1, 'tacheng-shi'),
(39705, 745674, 'cn', 'Taxkorgan Tajik Zizhixian', 1, 'taxkorgan-tajik-zizhixian'),
(39706, 745674, 'cn', 'Tekes Xian', 1, 'tekes-xian'),
(39707, 745674, 'cn', 'Toksun Xian', 1, 'toksun-xian'),
(39708, 745674, 'cn', 'Toli Xian', 1, 'toli-xian'),
(39709, 745674, 'cn', 'Turpan Diqu', 1, 'turpan-diqu'),
(39710, 745674, 'cn', 'Turpan Shi', 1, 'turpan-shi'),
(39711, 745674, 'cn', 'Usu Xian', 1, 'usu-xian'),
(39712, 745674, 'cn', 'Wenquan Xian', 1, 'wenquan-xian'),
(39713, 745674, 'cn', 'Wensu Xian', 1, 'wensu-xian'),
(39714, 745674, 'cn', 'Wuqia Xian', 1, 'wuqia-xian'),
(39715, 745674, 'cn', 'Wushi Xian', 1, 'wushi-xian'),
(39716, 745674, 'cn', 'Xayar Xian', 1, 'xayar-xian'),
(39717, 745674, 'cn', 'Xinhe Xian', 1, 'xinhe-xian'),
(39718, 745674, 'cn', 'Xinjiang Uygur Zizhiqu', 1, 'xinjiang-uygur-zizhiqu'),
(39719, 745674, 'cn', 'Xinyuan Xian', 1, 'xinyuan-xian'),
(39720, 745674, 'cn', 'Yecheng Xian', 1, 'yecheng-xian'),
(39721, 745674, 'cn', 'Yengisar Xian', 1, 'yengisar-xian'),
(39722, 745674, 'cn', 'Yining Shi', 1, 'yining-shi'),
(39723, 745674, 'cn', 'Yining Xian', 1, 'yining-xian'),
(39724, 745674, 'cn', 'Yiwu Xian', 1, 'yiwu-xian'),
(39725, 745674, 'cn', 'Yopurga Xian', 1, 'yopurga-xian'),
(39726, 745674, 'cn', 'Ürümqi', 1, 'urumqi'),
(39727, 745674, 'cn', 'Ürümqi Shi', 1, 'urumqi-shi'),
(39728, 745674, 'cn', 'Ürümqi Xian', 1, 'urumqi-xian'),
(39729, 745674, 'cn', 'Yuli Xian', 1, 'yuli-xian'),
(39730, 745674, 'cn', 'Yumin Xian', 1, 'yumin-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745772, 'cn', 'Tibet', 1, 'tibet');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39731, 745772, 'cn', 'Lhasa', 1, 'lhasa'),
(39732, 745772, 'cn', 'Ngari', 1, 'ngari'),
(39733, 745772, 'cn', 'Nyingchi', 1, 'nyingchi'),
(39734, 745772, 'cn', 'Qamdo', 1, 'qamdo'),
(39735, 745772, 'cn', 'Shannan', 1, 'shannan'),
(39736, 745772, 'cn', 'Xigaze', 1, 'xigaze');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745779, 'cn', 'Pekín', 1, 'pekin');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39737, 745779, 'cn', 'Beijing Shi', 1, 'beijing-shi'),
(39738, 745779, 'cn', 'Changping Xian', 1, 'changping-xian'),
(39739, 745779, 'cn', 'Chaoyang Qu', 1, 'chaoyang-qu'),
(39740, 745779, 'cn', 'Chongwen Qu', 1, 'chongwen-qu'),
(39741, 745779, 'cn', 'Daxing Xian', 1, 'daxing-xian'),
(39742, 745779, 'cn', 'Dongcheng Qu', 1, 'dongcheng-qu'),
(39743, 745779, 'cn', 'Fangshan Qu', 1, 'fangshan-qu'),
(39744, 745779, 'cn', 'Fengtai Qu', 1, 'fengtai-qu'),
(39745, 745779, 'cn', 'Haidian Qu', 1, 'haidian-qu'),
(39746, 745779, 'cn', 'Huairou Xian', 1, 'huairou-xian'),
(39747, 745779, 'cn', 'Mentougou Qu', 1, 'mentougou-qu'),
(39748, 745779, 'cn', 'Miyun Xian', 1, 'miyun-xian'),
(39749, 745779, 'cn', 'Pinggu Xian', 1, 'pinggu-xian'),
(39750, 745779, 'cn', 'Shijingshan Qu', 1, 'shijingshan-qu'),
(39751, 745779, 'cn', 'Shunyi Xian', 1, 'shunyi-xian'),
(39752, 745779, 'cn', 'Tongzhou Qu', 1, 'tongzhou-qu'),
(39753, 745779, 'cn', 'Xicheng Qu', 1, 'xicheng-qu'),
(39754, 745779, 'cn', 'Xuanwu Qu', 1, 'xuanwu-qu'),
(39755, 745779, 'cn', 'Yanqing Xian', 1, 'yanqing-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745799, 'cn', 'Chónqgìng', 1, 'chonqging');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39756, 745799, 'cn', 'Banan Qu', 1, 'banan-qu'),
(39757, 745799, 'cn', 'Beibei Qu', 1, 'beibei-qu'),
(39758, 745799, 'cn', 'Bishan Xian', 1, 'bishan-xian'),
(39759, 745799, 'cn', 'Changshou Xian', 1, 'changshou-xian'),
(39760, 745799, 'cn', 'Chengkou Xian', 1, 'chengkou-xian'),
(39761, 745799, 'cn', 'Chongqing', 1, 'chongqing'),
(39762, 745799, 'cn', 'Dadukou Qu', 1, 'dadukou-qu'),
(39763, 745799, 'cn', 'Dazu Xian', 1, 'dazu-xian'),
(39764, 745799, 'cn', 'Dianjiang Xian', 1, 'dianjiang-xian'),
(39765, 745799, 'cn', 'Fengdu Xian', 1, 'fengdu-xian'),
(39766, 745799, 'cn', 'Fengjie Xian', 1, 'fengjie-xian'),
(39767, 745799, 'cn', 'Fuling Qu', 1, 'fuling-qu'),
(39768, 745799, 'cn', 'Fuling Shi', 1, 'fuling-shi'),
(39769, 745799, 'cn', 'Hechuan Shi', 1, 'hechuan-shi'),
(39770, 745799, 'cn', 'Jiangbei Qu', 1, 'jiangbei-qu'),
(39771, 745799, 'cn', 'Jiangjin Shi', 1, 'jiangjin-shi'),
(39772, 745799, 'cn', 'Kai Xian', 1, 'kai-xian'),
(39773, 745799, 'cn', 'Liangping Xian', 1, 'liangping-xian'),
(39774, 745799, 'cn', 'Nanchuan Shi', 1, 'nanchuan-shi'),
(39775, 745799, 'cn', 'Nan´an Qu', 1, 'nanan-qu'),
(39776, 745799, 'cn', 'Pengshui Miaozu Tujiazu Zizhixian', 1, 'pengshui-miaozu-tujiazu-zizhixian'),
(39777, 745799, 'cn', 'Qianjiang Tujiazu Miaozu Zizhixian', 1, 'qianjiang-tujiazu-miaozu-zizhixian'),
(39778, 745799, 'cn', 'Qijiang Xian', 1, 'qijiang-xian'),
(39779, 745799, 'cn', 'Rongchang Xian', 1, 'rongchang-xian'),
(39780, 745799, 'cn', 'Shapingba Qu', 1, 'shapingba-qu'),
(39781, 745799, 'cn', 'Shizhu Tujiazu Zizhixian', 1, 'shizhu-tujiazu-zizhixian'),
(39782, 745799, 'cn', 'Tongliang Xian', 1, 'tongliang-xian'),
(39783, 745799, 'cn', 'Tongnan Xian', 1, 'tongnan-xian'),
(39784, 745799, 'cn', 'Wansheng Qu', 1, 'wansheng-qu'),
(39785, 745799, 'cn', 'Wanxian Qu', 1, 'wanxian-qu'),
(39786, 745799, 'cn', 'Wanxian Shi', 1, 'wanxian-shi'),
(39787, 745799, 'cn', 'Wulong Xian', 1, 'wulong-xian'),
(39788, 745799, 'cn', 'Wushan Xian', 1, 'wushan-xian'),
(39789, 745799, 'cn', 'Wuxi Xian', 1, 'wuxi-xian'),
(39790, 745799, 'cn', 'Xiushan Tujiazu Miaozu Zizhixian', 1, 'xiushan-tujiazu-miaozu-zizhixian'),
(39791, 745799, 'cn', 'Yongchuan Shi', 1, 'yongchuan-shi'),
(39792, 745799, 'cn', 'Youyang Tujiazu Miaozu Zizhixian', 1, 'youyang-tujiazu-miaozu-zizhixian'),
(39793, 745799, 'cn', 'Yubei Qu', 1, 'yubei-qu'),
(39794, 745799, 'cn', 'Yunyang Xian', 1, 'yunyang-xian'),
(39795, 745799, 'cn', 'Yuzhong Qu', 1, 'yuzhong-qu'),
(39796, 745799, 'cn', 'Zhong Xian', 1, 'zhong-xian');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745841, 'cn', 'Shànghai', 1, 'shanghai');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39797, 745841, 'cn', 'Baoshan Xian', 1, 'baoshan-xian'),
(39798, 745841, 'cn', 'Changning Qu', 1, 'changning-qu'),
(39799, 745841, 'cn', 'Chongming Xian', 1, 'chongming-xian'),
(39800, 745841, 'cn', 'Chuansha Xian', 1, 'chuansha-xian'),
(39801, 745841, 'cn', 'Fengxian Xian', 1, 'fengxian-xian'),
(39802, 745841, 'cn', 'Hongkou Qu', 1, 'hongkou-qu'),
(39803, 745841, 'cn', 'Huangpu Qu', 1, 'huangpu-qu'),
(39804, 745841, 'cn', 'Jiading Xian', 1, 'jiading-xian'),
(39805, 745841, 'cn', 'Jing´an Qu', 1, 'jingan-qu'),
(39806, 745841, 'cn', 'Jinshan Xian', 1, 'jinshan-xian'),
(39807, 745841, 'cn', 'Luwan Qu', 1, 'luwan-qu'),
(39808, 745841, 'cn', 'Nanhui Xian', 1, 'nanhui-xian'),
(39809, 745841, 'cn', 'Nanshi Qu', 1, 'nanshi-qu'),
(39810, 745841, 'cn', 'Putuo Qu', 1, 'putuo-qu'),
(39811, 745841, 'cn', 'Qingpu Xian', 1, 'qingpu-xian'),
(39812, 745841, 'cn', 'Shanghai', 1, 'shanghai'),
(39813, 745841, 'cn', 'Shanghai Xian', 1, 'shanghai-xian'),
(39814, 745841, 'cn', 'Songjiang Xian', 1, 'songjiang-xian'),
(39815, 745841, 'cn', 'Wusong Qu', 1, 'wusong-qu'),
(39816, 745841, 'cn', 'Xuhui Qu', 1, 'xuhui-qu'),
(39817, 745841, 'cn', 'Yangpu Qu', 1, 'yangpu-qu'),
(39818, 745841, 'cn', 'Zhabei Qu', 1, 'zhabei-qu');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745864, 'cn', 'Tianjin', 1, 'tianjin');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39819, 745864, 'cn', 'Baodi Xian', 1, 'baodi-xian'),
(39820, 745864, 'cn', 'Beijiao Qu', 1, 'beijiao-qu'),
(39821, 745864, 'cn', 'Dagang Qu', 1, 'dagang-qu'),
(39822, 745864, 'cn', 'Dongjiao Qu', 1, 'dongjiao-qu'),
(39823, 745864, 'cn', 'Hangu Qu', 1, 'hangu-qu'),
(39824, 745864, 'cn', 'Hebei Qu', 1, 'hebei-qu'),
(39825, 745864, 'cn', 'Hedong Qu', 1, 'hedong-qu'),
(39826, 745864, 'cn', 'Heping Qu', 1, 'heping-qu'),
(39827, 745864, 'cn', 'Hexi Qu', 1, 'hexi-qu'),
(39828, 745864, 'cn', 'Hongqiao Qu', 1, 'hongqiao-qu'),
(39829, 745864, 'cn', 'Ji Xian', 1, 'ji-xian'),
(39830, 745864, 'cn', 'Jinghai Xian', 1, 'jinghai-xian'),
(39831, 745864, 'cn', 'Nanjiao Qu', 1, 'nanjiao-qu'),
(39832, 745864, 'cn', 'Nankai Qu', 1, 'nankai-qu'),
(39833, 745864, 'cn', 'Ninghe Xian', 1, 'ninghe-xian'),
(39834, 745864, 'cn', 'Tanggu Qu', 1, 'tanggu-qu'),
(39835, 745864, 'cn', 'Tianjin', 1, 'tianjin'),
(39836, 745864, 'cn', 'Tianjin Shi', 1, 'tianjin-shi'),
(39837, 745864, 'cn', 'Wuqing Xian', 1, 'wuqing-xian'),
(39838, 745864, 'cn', 'Xijiao Qu', 1, 'xijiao-qu');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745885, 'cn', 'Hong Kong', 1, 'hong-kong');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39839, 745885, 'cn', 'Hong Kong', 1, 'hong-kong'),
(39840, 745885, 'cn', 'Kowloon', 1, 'kowloon'),
(39841, 745885, 'cn', 'Nuevos Territorios', 1, 'nuevos-territorios');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(745889, 'cn', 'Macao', 1, 'macao');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(39843, 745889, 'cn', 'Coloane', 1, 'coloane'),
(39842, 745889, 'cn', 'Macao', 1, 'macao'),
(39844, 745889, 'cn', 'Taipa', 1, 'taipa');

