INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Afghanistan_1', 'state_______________240'),
('country_Afghanistan_1', 'state______________241'),
('country_Afghanistan_1', 'state____________242'),
('country_Afghanistan_1', 'state________243'),
('country_Afghanistan_1', 'state______________244'),
('country_Afghanistan_1', 'state________________245'),
('country_Afghanistan_1', 'state__________246'),
('country_Afghanistan_1', 'state______________247'),
('country_Afghanistan_1', 'state__________248'),
('country_Afghanistan_1', 'state________249'),
('country_Afghanistan_1', 'state____________250'),
('country_Afghanistan_1', 'state__________251'),
('country_Afghanistan_1', 'state______________252'),
('country_Afghanistan_1', 'state__________253'),
('country_Afghanistan_1', 'state______________254'),
('country_Afghanistan_1', 'state______________255'),
('country_Afghanistan_1', 'state__________256'),
('country_Afghanistan_1', 'state____________257'),
('country_Afghanistan_1', 'state____________258'),
('country_Afghanistan_1', 'state____________259'),
('country_Afghanistan_1', 'state__________260'),
('country_Afghanistan_1', 'state________________261'),
('country_Afghanistan_1', 'state______________262'),
('country_Afghanistan_1', 'state________________263'),
('country_Afghanistan_1', 'state________________264'),
('country_Afghanistan_1', 'state____________265'),
('country_Afghanistan_1', 'state______________266'),
('country_Afghanistan_1', 'state_______________267'),
('country_Afghanistan_1', 'state____________268'),
('country_Afghanistan_1', 'state______________269'),
('country_Afghanistan_1', 'state___________270'),
('country_Afghanistan_1', 'state__________271'),
('country_Afghanistan_1', 'state__________272'),
('country_Afghanistan_1', 'state__________273'),
('country_Albania_2', 'state_Beratit_274'),
('country_Albania_2', 'state_Bulqiz__s_275'),
('country_Albania_2', 'state_Dibr__s_276'),
('country_Albania_2', 'state_Delvin__s_277'),
('country_Albania_2', 'state_Durr__sit_278'),
('country_Albania_2', 'state_Devollit_279'),
('country_Albania_2', 'state_Elbasanit_280'),
('country_Albania_2', 'state_Kolonj__s_281'),
('country_Albania_2', 'state_Fierit_282'),
('country_Albania_2', 'state_Gjirokastr__s_283'),
('country_Albania_2', 'state_Gramshit_284'),
('country_Albania_2', 'state_Hasit_285'),
('country_Albania_2', 'state_Kavaj__s_286'),
('country_Albania_2', 'state_Kurbinit_287'),
('country_Albania_2', 'state_Ku__ov__s_288'),
('country_Albania_2', 'state_Kor____s_289'),
('country_Albania_2', 'state_Kruj__s_290'),
('country_Albania_2', 'state_Kuk__sit_291'),
('country_Albania_2', 'state_Librazhdit_292'),
('country_Albania_2', 'state_Lezh__s_293'),
('country_Albania_2', 'state_Lushnj__s_294'),
('country_Albania_2', 'state_Mallakastr__s_295'),
('country_Albania_2', 'state_Mal__sis___s___Madhe_296'),
('country_Albania_2', 'state_Mirdit__s_297'),
('country_Albania_2', 'state_Matit_298'),
('country_Albania_2', 'state_Pogradecit_299'),
('country_Albania_2', 'state_Peqinit_300'),
('country_Albania_2', 'state_P__rmetit_301'),
('country_Albania_2', 'state_Puk__s_302'),
('country_Albania_2', 'state_Shkodr__s_303'),
('country_Albania_2', 'state_Skraparit_304'),
('country_Albania_2', 'state_Sarand__s_305'),
('country_Albania_2', 'state_Tepelen__s_306'),
('country_Albania_2', 'state_Tropoj__s_307'),
('country_Albania_2', 'state_Tiran__s_308'),
('country_Albania_2', 'state_Vlor__s_309'),
('country_Algeria_3', 'state_______________________310'),
('country_Algeria_3', 'state_______________________311'),
('country_Algeria_3', 'state___________________________312'),
('country_Algeria_3', 'state________________________________313'),
('country_Algeria_3', 'state_______________________314'),
('country_Algeria_3', 'state_______________________315'),
('country_Algeria_3', 'state_______________________316'),
('country_Algeria_3', 'state_____________________317'),
('country_Algeria_3', 'state___________________318'),
('country_Algeria_3', 'state___________________________319'),
('country_Algeria_3', 'state___________________________320'),
('country_Algeria_3', 'state_____________________321'),
('country_Algeria_3', 'state______________322'),
('country_Algeria_3', 'state_______________________323'),
('country_Algeria_3', 'state_________________324'),
('country_Algeria_3', 'state___________________________325'),
('country_Algeria_3', 'state________________________________326'),
('country_Algeria_3', 'state_____________________327'),
('country_Algeria_3', 'state_____________________328'),
('country_Algeria_3', 'state_______________________329'),
('country_Algeria_3', 'state__________________330'),
('country_Algeria_3', 'state__________________________________331'),
('country_Algeria_3', 'state_______________________332'),
('country_Algeria_3', 'state_______________________333'),
('country_Algeria_3', 'state________________334'),
('country_Algeria_3', 'state_________________________335'),
('country_Algeria_3', 'state___________________________336'),
('country_Algeria_3', 'state___________________________337'),
('country_Algeria_3', 'state_______________________338'),
('country_Algeria_3', 'state____________339'),
('country_Algeria_3', 'state____________340'),
('country_Algeria_3', 'state_______________________341'),
('country_Algeria_3', 'state_______________________342'),
('country_Algeria_3', 'state____________________________________343'),
('country_Algeria_3', 'state___________________________344'),
('country_Algeria_3', 'state_________________________345'),
('country_Algeria_3', 'state____________346'),
('country_Algeria_3', 'state___________________________347'),
('country_Algeria_3', 'state_________________________348'),
('country_Algeria_3', 'state_______________________349'),
('country_Algeria_3', 'state______________________________350'),
('country_Algeria_3', 'state_________________________351'),
('country_Algeria_3', 'state_____________________352'),
('country_Algeria_3', 'state________________________________353'),
('country_Algeria_3', 'state___________________________354'),
('country_Algeria_3', 'state________________________________355'),
('country_Algeria_3', 'state_________________________356'),
('country_Algeria_3', 'state_________________________357'),
('country_American_Samoa_4', 'state_Eastern_358'),
('country_American_Samoa_4', 'state_Manu_a_359'),
('country_American_Samoa_4', 'state_Rose_Island_360'),
('country_American_Samoa_4', 'state_Swains_Island_361'),
('country_American_Samoa_4', 'state_Western_362'),
('country_Andorra_5', 'state_Andorra_la_Vella_363'),
('country_Andorra_5', 'state_Canillo_364'),
('country_Andorra_5', 'state_Encamp_365'),
('country_Andorra_5', 'state_Escaldes_Engordany_366'),
('country_Andorra_5', 'state_La_Massana_367'),
('country_Andorra_5', 'state_Ordino_368'),
('country_Andorra_5', 'state_Sant_Juli___de_L__ria_369'),
('country_Angola_6', 'state_Bengo_370'),
('country_Angola_6', 'state_Benguela_371'),
('country_Angola_6', 'state_Bi___372'),
('country_Angola_6', 'state_Cabinda_373'),
('country_Angola_6', 'state_Cuando_Cubango_374'),
('country_Angola_6', 'state_Cuanza_Norte_375'),
('country_Angola_6', 'state_Cuanza_Sul_376'),
('country_Angola_6', 'state_Cunene_377'),
('country_Angola_6', 'state_Huambo_378'),
('country_Angola_6', 'state_Hu__la_379'),
('country_Angola_6', 'state_Luanda_380'),
('country_Angola_6', 'state_Lunda_Norte_381'),
('country_Angola_6', 'state_Lunda_Sul_382'),
('country_Angola_6', 'state_Malanje_383'),
('country_Angola_6', 'state_Moxico_384'),
('country_Angola_6', 'state_Namibe_385'),
('country_Angola_6', 'state_U__ge_386'),
('country_Angola_6', 'state_Zaire_387'),
('country_Antigua_and_Barbuda_9', 'state_Barbuda_388'),
('country_Antigua_and_Barbuda_9', 'state_Saint_George_389'),
('country_Antigua_and_Barbuda_9', 'state_Saint_John_390'),
('country_Antigua_and_Barbuda_9', 'state_Saint_Mary_391'),
('country_Antigua_and_Barbuda_9', 'state_Saint_Paul_392'),
('country_Antigua_and_Barbuda_9', 'state_Saint_Peter_393'),
('country_Antigua_and_Barbuda_9', 'state_Saint_Philip_394'),
('country_Argentina_10', 'state_Salta_395'),
('country_Argentina_10', 'state_Buenos_Aires_Province_396'),
('country_Argentina_10', 'state_Capital_Federal_397'),
('country_Argentina_10', 'state_San_Luis_398'),
('country_Argentina_10', 'state_Entre_R__os_399'),
('country_Argentina_10', 'state_La_Rioja_400'),
('country_Argentina_10', 'state_Santiago_del_Estero_401'),
('country_Argentina_10', 'state_Chaco_402'),
('country_Argentina_10', 'state_San_Juan_403'),
('country_Argentina_10', 'state_Catamarca_404'),
('country_Argentina_10', 'state_La_Pampa_405'),
('country_Argentina_10', 'state_Mendoza_406'),
('country_Argentina_10', 'state_Misiones_407'),
('country_Argentina_10', 'state_Formosa_408'),
('country_Argentina_10', 'state_Neuqu__n_409'),
('country_Argentina_10', 'state_R__o_Negro_410'),
('country_Argentina_10', 'state_Santa_Fe_411'),
('country_Argentina_10', 'state_Tucum__n_412'),
('country_Argentina_10', 'state_Chubut_413'),
('country_Argentina_10', 'state_Tierra_del_Fuego_414'),
('country_Argentina_10', 'state_Corrientes_415'),
('country_Argentina_10', 'state_C__rdoba_416'),
('country_Argentina_10', 'state_Jujuy_417'),
('country_Argentina_10', 'state_Santa_Cruz_418'),
('country_Armenia_11', 'state____________________419'),
('country_Armenia_11', 'state______________420'),
('country_Armenia_11', 'state________________421'),
('country_Armenia_11', 'state____________422'),
('country_Armenia_11', 'state________________________423'),
('country_Armenia_11', 'state______________424'),
('country_Armenia_11', 'state__________425'),
('country_Armenia_11', 'state____________426'),
('country_Armenia_11', 'state________________427'),
('country_Armenia_11', 'state______________428'),
('country_Armenia_11', 'state___________________429'),
('country_Australia_13', 'state_Australian_Capital_Territory_430'),
('country_Australia_13', 'state_New_South_Wales_431'),
('country_Australia_13', 'state_Northern_Territory_432'),
('country_Australia_13', 'state_Queensland_433'),
('country_Australia_13', 'state_South_Australia_434'),
('country_Australia_13', 'state_Tasmania_435'),
('country_Australia_13', 'state_Victoria_436'),
('country_Australia_13', 'state_Western_Australia_437'),
('country_Austria_14', 'state_Burgenland_438'),
('country_Austria_14', 'state_K__rnten_439'),
('country_Austria_14', 'state_Nieder__sterreich_440'),
('country_Austria_14', 'state_Ober__sterreich_441'),
('country_Austria_14', 'state_Salzburg_442'),
('country_Austria_14', 'state_Steiermark_443'),
('country_Austria_14', 'state_Tirol_444'),
('country_Austria_14', 'state_Voralberg_445'),
('country_Austria_14', 'state_Wien_446'),
('country_Azerbaijan_15', 'state___li_Bayraml___447'),
('country_Azerbaijan_15', 'state_Ab__eron_448'),
('country_Azerbaijan_15', 'state_A__cab__di_449'),
('country_Azerbaijan_15', 'state_A__dam_450'),
('country_Azerbaijan_15', 'state_A__da___451'),
('country_Azerbaijan_15', 'state_A__stafa_452'),
('country_Azerbaijan_15', 'state_A__su_453'),
('country_Azerbaijan_15', 'state_Astara_454'),
('country_Azerbaijan_15', 'state_Bak___455'),
('country_Azerbaijan_15', 'state_Bab__k_456'),
('country_Azerbaijan_15', 'state_Balak__n_457'),
('country_Azerbaijan_15', 'state_B__rd___458'),
('country_Azerbaijan_15', 'state_Beyl__qan_459'),
('country_Azerbaijan_15', 'state_Bil__suvar_460'),
('country_Azerbaijan_15', 'state_C__bray__l_461'),
('country_Azerbaijan_15', 'state_C__lilabab_462'),
('country_Azerbaijan_15', 'state_Julfa_463'),
('country_Azerbaijan_15', 'state_Da__k__s__n_464'),
('country_Azerbaijan_15', 'state_D__v____i_465'),
('country_Azerbaijan_15', 'state_F__zuli_466'),
('country_Azerbaijan_15', 'state_G__nc___467'),
('country_Azerbaijan_15', 'state_G__d__b__y_468'),
('country_Azerbaijan_15', 'state_Goranboy_469'),
('country_Azerbaijan_15', 'state_G__y__ay_470'),
('country_Azerbaijan_15', 'state_Hac__qabul_471'),
('country_Azerbaijan_15', 'state___mi__li_472'),
('country_Azerbaijan_15', 'state___smay__ll___473'),
('country_Azerbaijan_15', 'state_K__lb__c__r_474'),
('country_Azerbaijan_15', 'state_K__rd__mir_475'),
('country_Azerbaijan_15', 'state_L__nk__ran_476'),
('country_Azerbaijan_15', 'state_La____n_477'),
('country_Azerbaijan_15', 'state_L__nk__ran_478'),
('country_Azerbaijan_15', 'state_Lerik_479'),
('country_Azerbaijan_15', 'state_Masall___480'),
('country_Azerbaijan_15', 'state_Ming____evir_481'),
('country_Azerbaijan_15', 'state_Naftalan_482'),
('country_Azerbaijan_15', 'state_Neft__ala_483'),
('country_Azerbaijan_15', 'state_O__uz_484'),
('country_Azerbaijan_15', 'state_Ordubad_485'),
('country_Azerbaijan_15', 'state_Q__b__l___486'),
('country_Azerbaijan_15', 'state_Qax_487'),
('country_Azerbaijan_15', 'state_Qazax_488'),
('country_Azerbaijan_15', 'state_Qobustan_489'),
('country_Azerbaijan_15', 'state_Quba_490'),
('country_Azerbaijan_15', 'state_Qubadl___491'),
('country_Azerbaijan_15', 'state_Qusar_492'),
('country_Azerbaijan_15', 'state_____ki_493'),
('country_Azerbaijan_15', 'state_Saatl___494'),
('country_Azerbaijan_15', 'state_Sabirabad_495'),
('country_Azerbaijan_15', 'state_S__d__r__k_496'),
('country_Azerbaijan_15', 'state___ahbuz_497'),
('country_Azerbaijan_15', 'state_____ki_498'),
('country_Azerbaijan_15', 'state_Salyan_499'),
('country_Azerbaijan_15', 'state_Sumqay__t_500'),
('country_Azerbaijan_15', 'state___amax___501'),
('country_Azerbaijan_15', 'state_____mkir_502'),
('country_Azerbaijan_15', 'state_Samux_503'),
('country_Azerbaijan_15', 'state_____rur_504'),
('country_Azerbaijan_15', 'state_Siy__z__n_505'),
('country_Azerbaijan_15', 'state___u__a__City__506'),
('country_Azerbaijan_15', 'state___u__a_507'),
('country_Azerbaijan_15', 'state_T__rt__r_508'),
('country_Azerbaijan_15', 'state_Tovuz_509'),
('country_Azerbaijan_15', 'state_Ucar_510'),
('country_Azerbaijan_15', 'state_Xank__ndi_511'),
('country_Azerbaijan_15', 'state_Xa__maz_512'),
('country_Azerbaijan_15', 'state_Xanlar_513'),
('country_Azerbaijan_15', 'state_X__z___514'),
('country_Azerbaijan_15', 'state_Xocal___515'),
('country_Azerbaijan_15', 'state_Xocav__nd_516'),
('country_Azerbaijan_15', 'state_Yard__ml___517'),
('country_Azerbaijan_15', 'state_Yevlax__City__518'),
('country_Azerbaijan_15', 'state_Yevlax_519'),
('country_Azerbaijan_15', 'state_Z__ngilan_520'),
('country_Azerbaijan_15', 'state_Zaqatala_521'),
('country_Azerbaijan_15', 'state_Z__rdab_522'),
('country_Azerbaijan_15', 'state_Nakhichevan_523'),
('country_Bahamas_16', 'state_Acklins_and_Crooked_Islands_524'),
('country_Bahamas_16', 'state_Bimini_525'),
('country_Bahamas_16', 'state_Cat_Island_526'),
('country_Bahamas_16', 'state_Exuma_527'),
('country_Bahamas_16', 'state_Freeport_528'),
('country_Bahamas_16', 'state_Fresh_Creek_529'),
('country_Bahamas_16', 'state_Governor_s_Harbour_530'),
('country_Bahamas_16', 'state_Green_Turtle_Cay_531'),
('country_Bahamas_16', 'state_Harbour_Island_532'),
('country_Bahamas_16', 'state_High_Rock_533'),
('country_Bahamas_16', 'state_Inagua_534'),
('country_Bahamas_16', 'state_Kemps_Bay_535'),
('country_Bahamas_16', 'state_Long_Island_536'),
('country_Bahamas_16', 'state_Marsh_Harbour_537'),
('country_Bahamas_16', 'state_Mayaguana_538'),
('country_Bahamas_16', 'state_New_Providence_539'),
('country_Bahamas_16', 'state_Nicholls_Town_and_Berry_Islands_540'),
('country_Bahamas_16', 'state_Ragged_Island_541'),
('country_Bahamas_16', 'state_Rock_Sound_542'),
('country_Bahamas_16', 'state_San_Salvador_and_Rum_Cay_543'),
('country_Bahamas_16', 'state_Sandy_Point_544'),
('country_Bahrain_17', 'state__________545'),
('country_Bahrain_17', 'state______________546'),
('country_Bahrain_17', 'state________________547'),
('country_Bahrain_17', 'state_____________548'),
('country_Bahrain_17', 'state_________________________________549'),
('country_Bahrain_17', 'state__________550'),
('country_Bahrain_17', 'state_____________________________551'),
('country_Bahrain_17', 'state_____________________552'),
('country_Bahrain_17', 'state________________________________________________553'),
('country_Bahrain_17', 'state_______________________________554'),
('country_Bahrain_17', 'state_________________555'),
('country_Bahrain_17', 'state___________________556'),
('country_Bangladesh_18', 'state_Bandarban_557'),
('country_Bangladesh_18', 'state_Barguna_558'),
('country_Bangladesh_18', 'state_Bogra_559'),
('country_Bangladesh_18', 'state_Brahmanbaria_560'),
('country_Bangladesh_18', 'state_Bagerhat_561'),
('country_Bangladesh_18', 'state_Barisal_562'),
('country_Bangladesh_18', 'state_Bhola_563'),
('country_Bangladesh_18', 'state_Comilla_564'),
('country_Bangladesh_18', 'state_Chandpur_565'),
('country_Bangladesh_18', 'state_Chittagong_566'),
('country_Bangladesh_18', 'state_Cox_s_Bazar_567'),
('country_Bangladesh_18', 'state_Chuadanga_568'),
('country_Bangladesh_18', 'state_Dhaka_569'),
('country_Bangladesh_18', 'state_Dinajpur_570'),
('country_Bangladesh_18', 'state_Faridpur_571'),
('country_Bangladesh_18', 'state_Feni_572'),
('country_Bangladesh_18', 'state_Gopalganj_573'),
('country_Bangladesh_18', 'state_Gazipur_574'),
('country_Bangladesh_18', 'state_Gaibandha_575'),
('country_Bangladesh_18', 'state_Habiganj_576'),
('country_Bangladesh_18', 'state_Jamalpur_577'),
('country_Bangladesh_18', 'state_Jessore_578'),
('country_Bangladesh_18', 'state_Jhenaidah_579'),
('country_Bangladesh_18', 'state_Jaipurhat_580'),
('country_Bangladesh_18', 'state_Jhalakati_581'),
('country_Bangladesh_18', 'state_Kishoreganj_582'),
('country_Bangladesh_18', 'state_Khulna_583'),
('country_Bangladesh_18', 'state_Kurigram_584'),
('country_Bangladesh_18', 'state_Khagrachari_585'),
('country_Bangladesh_18', 'state_Kushtia_586'),
('country_Bangladesh_18', 'state_Lakshmipur_587'),
('country_Bangladesh_18', 'state_Lalmonirhat_588'),
('country_Bangladesh_18', 'state_Manikganj_589'),
('country_Bangladesh_18', 'state_Mymensingh_590'),
('country_Bangladesh_18', 'state_Munshiganj_591'),
('country_Bangladesh_18', 'state_Madaripur_592'),
('country_Bangladesh_18', 'state_Magura_593'),
('country_Bangladesh_18', 'state_Moulvibazar_594'),
('country_Bangladesh_18', 'state_Meherpur_595'),
('country_Bangladesh_18', 'state_Narayanganj_596'),
('country_Bangladesh_18', 'state_Netrakona_597'),
('country_Bangladesh_18', 'state_Narsingdi_598'),
('country_Bangladesh_18', 'state_Narail_599'),
('country_Bangladesh_18', 'state_Natore_600'),
('country_Bangladesh_18', 'state_Nawabganj_601'),
('country_Bangladesh_18', 'state_Nilphamari_602'),
('country_Bangladesh_18', 'state_Noakhali_603'),
('country_Bangladesh_18', 'state_Naogaon_604'),
('country_Bangladesh_18', 'state_Pabna_605'),
('country_Bangladesh_18', 'state_Pirojpur_606'),
('country_Bangladesh_18', 'state_Patuakhali_607'),
('country_Bangladesh_18', 'state_Panchagarh_608'),
('country_Bangladesh_18', 'state_Rajbari_609'),
('country_Bangladesh_18', 'state_Rajshahi_610'),
('country_Bangladesh_18', 'state_Rangpur_611'),
('country_Bangladesh_18', 'state_Rangamati_612'),
('country_Bangladesh_18', 'state_Sherpur_613'),
('country_Bangladesh_18', 'state_Satkhira_614'),
('country_Bangladesh_18', 'state_Sirajganj_615'),
('country_Bangladesh_18', 'state_Sylhet_616'),
('country_Bangladesh_18', 'state_Sunamganj_617'),
('country_Bangladesh_18', 'state_Shariatpur_618'),
('country_Bangladesh_18', 'state_Tangail_619'),
('country_Bangladesh_18', 'state_Thakurgaon_620'),
('country_Barbados_19', 'state_Saint_Andrew_621'),
('country_Barbados_19', 'state_Christ_Church_622'),
('country_Barbados_19', 'state_Saint_Peter_623'),
('country_Barbados_19', 'state_Saint_George_624'),
('country_Barbados_19', 'state_Saint_John_625'),
('country_Barbados_19', 'state_Saint_Lucy_626'),
('country_Barbados_19', 'state_Saint_Michael_627'),
('country_Barbados_19', 'state_Saint_Joseph_628'),
('country_Barbados_19', 'state_Saint_Philip_629'),
('country_Barbados_19', 'state_Saint_James_630'),
('country_Barbados_19', 'state_Saint_Thomas_631'),
('country_Belarus_20', 'state_______________________________________632'),
('country_Belarus_20', 'state___________________________________________633'),
('country_Belarus_20', 'state_____________________________________________634'),
('country_Belarus_20', 'state___________________________________________635'),
('country_Belarus_20', 'state_____________________________________636'),
('country_Belarus_20', 'state_________________________________________637'),
('country_Belgium_21', 'state_Brussel_638'),
('country_Belgium_21', 'state_Antwerpen_639'),
('country_Belgium_21', 'state_Vlaams_Brabant_640'),
('country_Belgium_21', 'state_Limburg_641'),
('country_Belgium_21', 'state_Oost_Vlaanderen_642'),
('country_Belgium_21', 'state_West_Vlaanderen_643'),
('country_Belgium_21', 'state_Brabant_Wallon_644'),
('country_Belgium_21', 'state_Hainaut_645'),
('country_Belgium_21', 'state_Li__ge_L__ttich_646'),
('country_Belgium_21', 'state_Luxembourg_647'),
('country_Belgium_21', 'state_Namur_648'),
('country_Belize_22', 'state_Belize_District_649'),
('country_Belize_22', 'state_Cayo_District_650'),
('country_Belize_22', 'state_Corozal_District_651'),
('country_Belize_22', 'state_Orange_Walk_District_652'),
('country_Belize_22', 'state_Stann_Creek_District_653'),
('country_Belize_22', 'state_Toledo_District_654'),
('country_Benin_23', 'state_Alibori_655'),
('country_Benin_23', 'state_Atakora_656'),
('country_Benin_23', 'state_Atlantique_657'),
('country_Benin_23', 'state_Borgou_658'),
('country_Benin_23', 'state_Collines_659'),
('country_Benin_23', 'state_Donga_660'),
('country_Benin_23', 'state_Kouffo_661'),
('country_Benin_23', 'state_Littoral_662'),
('country_Benin_23', 'state_Mono_663'),
('country_Benin_23', 'state_Ou__m___664'),
('country_Benin_23', 'state_Plateau_665'),
('country_Benin_23', 'state_Zou_666'),
('country_Bermuda_24', 'state_Devonshire_667'),
('country_Bermuda_24', 'state_Hamilton_City_668'),
('country_Bermuda_24', 'state_Hamilton_669'),
('country_Bermuda_24', 'state_Paget_670'),
('country_Bermuda_24', 'state_Pembroke_671'),
('country_Bermuda_24', 'state_Sandys_672'),
('country_Bermuda_24', 'state_Saint_George_City_673'),
('country_Bermuda_24', 'state_Saint_George_s_674'),
('country_Bermuda_24', 'state_Smiths_675'),
('country_Bermuda_24', 'state_Southampton_676'),
('country_Bermuda_24', 'state_Warwick_677'),
('country_Bhutan_25', 'state_Paro_678'),
('country_Bhutan_25', 'state_Chukha_679'),
('country_Bhutan_25', 'state_Haa_680'),
('country_Bhutan_25', 'state_Samtse_681'),
('country_Bhutan_25', 'state_Thimphu_682'),
('country_Bhutan_25', 'state_Tsirang_683'),
('country_Bhutan_25', 'state_Dagana_684'),
('country_Bhutan_25', 'state_Punakha_685'),
('country_Bhutan_25', 'state_Wangdue_Phodrang_686'),
('country_Bhutan_25', 'state_Sarpang_687'),
('country_Bhutan_25', 'state_Trongsa_688'),
('country_Bhutan_25', 'state_Bumthang_689'),
('country_Bhutan_25', 'state_Zhemgang_690'),
('country_Bhutan_25', 'state_Trashigang_691'),
('country_Bhutan_25', 'state_Mongar_692'),
('country_Bhutan_25', 'state_Pemagatshel_693'),
('country_Bhutan_25', 'state_Luentse_694'),
('country_Bhutan_25', 'state_Samdrup_Jongkhar_695'),
('country_Bhutan_25', 'state_Gasa_696'),
('country_Bhutan_25', 'state_Trashiyangse_697'),
('country_Bolivia_26', 'state_El_Beni_698'),
('country_Bolivia_26', 'state_Cochabamba_699'),
('country_Bolivia_26', 'state_Chuquisaca_700'),
('country_Bolivia_26', 'state_La_Paz_701'),
('country_Bolivia_26', 'state_Pando_702'),
('country_Bolivia_26', 'state_Oruro_703'),
('country_Bolivia_26', 'state_Potos___704'),
('country_Bolivia_26', 'state_Santa_Cruz_705'),
('country_Bolivia_26', 'state_Tarija_706'),
('country_Botswana_28', 'state_Central_707'),
('country_Botswana_28', 'state_Ghanzi_708'),
('country_Botswana_28', 'state_Kgalagadi_709'),
('country_Botswana_28', 'state_Kgatleng_710'),
('country_Botswana_28', 'state_Kweneng_711'),
('country_Botswana_28', 'state_North_East_712'),
('country_Botswana_28', 'state_North_West_713'),
('country_Botswana_28', 'state_South_East_714'),
('country_Botswana_28', 'state_Southern_715'),
('country_Brazil_30', 'state_Acre_716'),
('country_Brazil_30', 'state_Alagoas_717'),
('country_Brazil_30', 'state_Amaz__nia_718'),
('country_Brazil_30', 'state_Amap___719'),
('country_Brazil_30', 'state_Bahia_720'),
('country_Brazil_30', 'state_Cear___721'),
('country_Brazil_30', 'state_Distrito_Federal_722'),
('country_Brazil_30', 'state_Esp__rito_Santo_723'),
('country_Brazil_30', 'state_Goi__s_724'),
('country_Brazil_30', 'state_Maranh__o_725'),
('country_Brazil_30', 'state_Minas_Gerais_726'),
('country_Brazil_30', 'state_Mato_Grosso_do_Sul_727'),
('country_Brazil_30', 'state_Mato_Grosso_728'),
('country_Brazil_30', 'state_Par___729'),
('country_Brazil_30', 'state_Para__ba_730'),
('country_Brazil_30', 'state_Pernambuco_731'),
('country_Brazil_30', 'state_Piau___732'),
('country_Brazil_30', 'state_Paran___733'),
('country_Brazil_30', 'state_Rio_de_Janeiro_734'),
('country_Brazil_30', 'state_Rio_Grande_do_Norte_735'),
('country_Brazil_30', 'state_Rond__nia_736'),
('country_Brazil_30', 'state_Roraima_737'),
('country_Brazil_30', 'state_Rio_Grande_do_Sul_738'),
('country_Brazil_30', 'state_Santa_Catarina_739')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Brazil_30', 'state_Sergipe_740'),
('country_Brazil_30', 'state_S__o_Paulo_741'),
('country_Brazil_30', 'state_Tocantins_742'),
('country_British_Indian_Ocean_Territory_31', 'state_Peros_Banhos_743'),
('country_British_Indian_Ocean_Territory_31', 'state_Salomon_Islands_744'),
('country_British_Indian_Ocean_Territory_31', 'state_Nelsons_Island_745'),
('country_British_Indian_Ocean_Territory_31', 'state_Three_Brothers_746'),
('country_British_Indian_Ocean_Territory_31', 'state_Eagle_Islands_747'),
('country_British_Indian_Ocean_Territory_31', 'state_Danger_Island_748'),
('country_British_Indian_Ocean_Territory_31', 'state_Egmont_Islands_749'),
('country_British_Indian_Ocean_Territory_31', 'state_Diego_Garcia_750'),
('country_Brunei_Darussalam_32', 'state_Belait_751'),
('country_Brunei_Darussalam_32', 'state_Brunei_Muara_752'),
('country_Brunei_Darussalam_32', 'state_Temburong_753'),
('country_Brunei_Darussalam_32', 'state_Tutong_754'),
('country_Bulgaria_33', 'state_Blagoevgrad_755'),
('country_Bulgaria_33', 'state_Burgas_756'),
('country_Bulgaria_33', 'state_Varna_757'),
('country_Bulgaria_33', 'state_Veliko_Tarnovo_758'),
('country_Bulgaria_33', 'state_Vidin_759'),
('country_Bulgaria_33', 'state_Vratsa_760'),
('country_Bulgaria_33', 'state_Gabrovo_761'),
('country_Bulgaria_33', 'state_Dobrich_762'),
('country_Bulgaria_33', 'state_Kardzhali_763'),
('country_Bulgaria_33', 'state_Kyustendil_764'),
('country_Bulgaria_33', 'state_Lovech_765'),
('country_Bulgaria_33', 'state_Montana_766'),
('country_Bulgaria_33', 'state_Pazardzhik_767'),
('country_Bulgaria_33', 'state_Pernik_768'),
('country_Bulgaria_33', 'state_Pleven_769'),
('country_Bulgaria_33', 'state_Plovdiv_770'),
('country_Bulgaria_33', 'state_Razgrad_771'),
('country_Bulgaria_33', 'state_Ruse_772'),
('country_Bulgaria_33', 'state_Silistra_773'),
('country_Bulgaria_33', 'state_Sliven_774'),
('country_Bulgaria_33', 'state_Smolyan_775'),
('country_Bulgaria_33', 'state_Sofia_776'),
('country_Bulgaria_33', 'state_Sofia_Province_777'),
('country_Bulgaria_33', 'state_Stara_Zagora_778'),
('country_Bulgaria_33', 'state_Targovishte_779'),
('country_Bulgaria_33', 'state_Haskovo_780'),
('country_Bulgaria_33', 'state_Shumen_781'),
('country_Bulgaria_33', 'state_Yambol_782'),
('country_Burkina_Faso_34', 'state_Bal___783'),
('country_Burkina_Faso_34', 'state_Bam_784'),
('country_Burkina_Faso_34', 'state_Banwa_785'),
('country_Burkina_Faso_34', 'state_Baz__ga_786'),
('country_Burkina_Faso_34', 'state_Bougouriba_787'),
('country_Burkina_Faso_34', 'state_Boulgou_788'),
('country_Burkina_Faso_34', 'state_Boulkiemd___789'),
('country_Burkina_Faso_34', 'state_Komo___790'),
('country_Burkina_Faso_34', 'state_Ganzourgou_791'),
('country_Burkina_Faso_34', 'state_Gnagna_792'),
('country_Burkina_Faso_34', 'state_Gourma_793'),
('country_Burkina_Faso_34', 'state_Houet_794'),
('country_Burkina_Faso_34', 'state_Ioba_795'),
('country_Burkina_Faso_34', 'state_Kadiogo_796'),
('country_Burkina_Faso_34', 'state_K__n__dougou_797'),
('country_Burkina_Faso_34', 'state_Komondjari_798'),
('country_Burkina_Faso_34', 'state_Kompienga_799'),
('country_Burkina_Faso_34', 'state_Koulp__logo_800'),
('country_Burkina_Faso_34', 'state_Kossi_801'),
('country_Burkina_Faso_34', 'state_Kouritenga_802'),
('country_Burkina_Faso_34', 'state_Kourw__ogo_803'),
('country_Burkina_Faso_34', 'state_L__raba_804'),
('country_Burkina_Faso_34', 'state_Loroum_805'),
('country_Burkina_Faso_34', 'state_Mouhoun_806'),
('country_Burkina_Faso_34', 'state_Namentenga_807'),
('country_Burkina_Faso_34', 'state_Naouri_808'),
('country_Burkina_Faso_34', 'state_Nayala_809'),
('country_Burkina_Faso_34', 'state_Noumbiel_810'),
('country_Burkina_Faso_34', 'state_Oubritenga_811'),
('country_Burkina_Faso_34', 'state_Oudalan_812'),
('country_Burkina_Faso_34', 'state_Passor___813'),
('country_Burkina_Faso_34', 'state_Poni_814'),
('country_Burkina_Faso_34', 'state_S__no_815'),
('country_Burkina_Faso_34', 'state_Sissili_816'),
('country_Burkina_Faso_34', 'state_Sanmatenga_817'),
('country_Burkina_Faso_34', 'state_Sangui___818'),
('country_Burkina_Faso_34', 'state_Soum_819'),
('country_Burkina_Faso_34', 'state_Sourou_820'),
('country_Burkina_Faso_34', 'state_Tapoa_821'),
('country_Burkina_Faso_34', 'state_Tui_822'),
('country_Burkina_Faso_34', 'state_Yagha_823'),
('country_Burkina_Faso_34', 'state_Yatenga_824'),
('country_Burkina_Faso_34', 'state_Ziro_825'),
('country_Burkina_Faso_34', 'state_Zondoma_826'),
('country_Burkina_Faso_34', 'state_Zoundw__ogo_827'),
('country_Burundi_35', 'state_Bubanza_828'),
('country_Burundi_35', 'state_Bujumbura_Mairie_829'),
('country_Burundi_35', 'state_Bururi_830'),
('country_Burundi_35', 'state_Cankuzo_831'),
('country_Burundi_35', 'state_Cibitoke_832'),
('country_Burundi_35', 'state_Gitega_833'),
('country_Burundi_35', 'state_Karuzi_834'),
('country_Burundi_35', 'state_Kayanza_835'),
('country_Burundi_35', 'state_Kirundo_836'),
('country_Burundi_35', 'state_Makamba_837'),
('country_Burundi_35', 'state_Muramvya_838'),
('country_Burundi_35', 'state_Muyinga_839'),
('country_Burundi_35', 'state_Mwaro_840'),
('country_Burundi_35', 'state_Ngozi_841'),
('country_Burundi_35', 'state_Rutana_842'),
('country_Burundi_35', 'state_Ruyigi_843'),
('country_Cameroon_37', 'state_Adamaoua_844'),
('country_Cameroon_37', 'state_Centre_845'),
('country_Cameroon_37', 'state_Extr__me_Nord_846'),
('country_Cameroon_37', 'state_Est_847'),
('country_Cameroon_37', 'state_Littoral_848'),
('country_Cameroon_37', 'state_Nord_849'),
('country_Cameroon_37', 'state_Nord_Ouest_850'),
('country_Cameroon_37', 'state_Ouest_851'),
('country_Cameroon_37', 'state_Sud_852'),
('country_Cameroon_37', 'state_Sud_Ouest_853'),
('country_Canada_38', 'state_Alberta_854'),
('country_Canada_38', 'state_British_Columbia_855'),
('country_Canada_38', 'state_Manitoba_856'),
('country_Canada_38', 'state_New_Brunswick_857'),
('country_Canada_38', 'state_Newfoundland_and_Labrador_858'),
('country_Canada_38', 'state_Nova_Scotia_859'),
('country_Canada_38', 'state_Northwest_Territories_860'),
('country_Canada_38', 'state_Nunavut_861'),
('country_Canada_38', 'state_Ontario_862'),
('country_Canada_38', 'state_Prince_Edward_Island_863'),
('country_Canada_38', 'state_Quebec_864'),
('country_Canada_38', 'state_Saskatchewan_865'),
('country_Canada_38', 'state_Yukon_Territory_866'),
('country_Cape_Verde_39', 'state_Brava_867'),
('country_Cape_Verde_39', 'state_Boa_Vista_868'),
('country_Cape_Verde_39', 'state_Santa_Catarina_869'),
('country_Cape_Verde_39', 'state_Santa_Cruz_870'),
('country_Cape_Verde_39', 'state_Calheta_de_S__o_Miguel_871'),
('country_Cape_Verde_39', 'state_Maio_872'),
('country_Cape_Verde_39', 'state_Mosteiros_873'),
('country_Cape_Verde_39', 'state_Pa__l_874'),
('country_Cape_Verde_39', 'state_Porto_Novo_875'),
('country_Cape_Verde_39', 'state_Praia_876'),
('country_Cape_Verde_39', 'state_Ribeira_Grande_877'),
('country_Cape_Verde_39', 'state_S__o_Domingos_878'),
('country_Cape_Verde_39', 'state_S__o_Filipe_879'),
('country_Cape_Verde_39', 'state_Sal_880'),
('country_Cape_Verde_39', 'state_S__o_Nicolau_881'),
('country_Cape_Verde_39', 'state_S__o_Vicente_882'),
('country_Cape_Verde_39', 'state_Tarrafal_883'),
('country_Cayman_Islands_40', 'state_Creek_884'),
('country_Cayman_Islands_40', 'state_Midland_886'),
('country_Cayman_Islands_40', 'state_South_Town_887'),
('country_Cayman_Islands_40', 'state_Spot_Bay_888'),
('country_Cayman_Islands_40', 'state_Stake_Bay_889'),
('country_Cayman_Islands_40', 'state_West_End_890'),
('country_Cayman_Islands_40', 'state_Western_891'),
('country_Central_African_Republic_41', 'state_Ouham_892'),
('country_Central_African_Republic_41', 'state_Bamingui_Bangoran_893'),
('country_Central_African_Republic_41', 'state_Bangui_894'),
('country_Central_African_Republic_41', 'state_Basse_Kotto_895'),
('country_Central_African_Republic_41', 'state_Haute_Kotto_896'),
('country_Central_African_Republic_41', 'state_Haut_Mbomou_897'),
('country_Central_African_Republic_41', 'state_Mamb__r___Kad_____898'),
('country_Central_African_Republic_41', 'state_Nana_Gr__bizi_899'),
('country_Central_African_Republic_41', 'state_K__mo_900'),
('country_Central_African_Republic_41', 'state_Lobaye_901'),
('country_Central_African_Republic_41', 'state_Mbomou_902'),
('country_Central_African_Republic_41', 'state_Ombella_M_Poko_903'),
('country_Central_African_Republic_41', 'state_Nana_Mamb__r___904'),
('country_Central_African_Republic_41', 'state_Ouham_Pend___905'),
('country_Central_African_Republic_41', 'state_Sangha_Mba__r___906'),
('country_Central_African_Republic_41', 'state_Ouaka_907'),
('country_Central_African_Republic_41', 'state_Vakaga_908'),
('country_Chad_42', 'state_Batha_909'),
('country_Chad_42', 'state_Borkou_Ennedi_Tibesti_910'),
('country_Chad_42', 'state_Biltine_911'),
('country_Chad_42', 'state_Chari_Baguirmi_912'),
('country_Chad_42', 'state_Gu__ra_913'),
('country_Chad_42', 'state_Kanem_914'),
('country_Chad_42', 'state_Lac_915'),
('country_Chad_42', 'state_Logone_Oriental_916'),
('country_Chad_42', 'state_Logone_Occidental_917'),
('country_Chad_42', 'state_Moyen_Chari_918'),
('country_Chad_42', 'state_Mayo_K__bbi_919'),
('country_Chad_42', 'state_Ouadda___920'),
('country_Chad_42', 'state_Salamat_921'),
('country_Chad_42', 'state_Tandjil___922'),
('country_Chile_43', 'state_Ais__n_del_General_Carlos_Iba__ez_923'),
('country_Chile_43', 'state_Antofagasta_924'),
('country_Chile_43', 'state_La_Araucan__a_925'),
('country_Chile_43', 'state_Atacama_926'),
('country_Chile_43', 'state_Biob__o_927'),
('country_Chile_43', 'state_Coquimbo_928'),
('country_Chile_43', 'state_Libertador_Bernardo_O_Higgins_929'),
('country_Chile_43', 'state_Los_Lagos_930'),
('country_Chile_43', 'state_Magallanes_y_de_la_Antartica_931'),
('country_Chile_43', 'state_Maule_932'),
('country_Chile_43', 'state_Metropolitana_de_Santiago_933'),
('country_Chile_43', 'state_Tarapac___934'),
('country_Chile_43', 'state_Valpara__so_935'),
('country_China_44', 'state________936'),
('country_China_44', 'state________937'),
('country_China_44', 'state________938'),
('country_China_44', 'state________939'),
('country_China_44', 'state____________________940'),
('country_China_44', 'state________941'),
('country_China_44', 'state________942'),
('country_China_44', 'state______________943'),
('country_China_44', 'state________944'),
('country_China_44', 'state________945'),
('country_China_44', 'state________946'),
('country_China_44', 'state________947'),
('country_China_44', 'state________948'),
('country_China_44', 'state________949'),
('country_China_44', 'state________950'),
('country_China_44', 'state________951'),
('country_China_44', 'state________952'),
('country_China_44', 'state________953'),
('country_China_44', 'state________954'),
('country_China_44', 'state_______________________955'),
('country_China_44', 'state________956'),
('country_China_44', 'state________957'),
('country_China_44', 'state________958'),
('country_China_44', 'state________959'),
('country_China_44', 'state________960'),
('country_China_44', 'state_________________961'),
('country_China_44', 'state________962'),
('country_China_44', 'state________963'),
('country_China_44', 'state________964'),
('country_China_44', 'state________965'),
('country_China_44', 'state________966'),
('country_China_44', 'state________967'),
('country_China_44', 'state________968'),
('country_China_44', 'state________969'),
('country_Cocos__Keeling__Islands_46', 'state_Direction_Island_970'),
('country_Cocos__Keeling__Islands_46', 'state_Home_Island_971'),
('country_Cocos__Keeling__Islands_46', 'state_Horsburgh_Island_972'),
('country_Cocos__Keeling__Islands_46', 'state_South_Island_973'),
('country_Cocos__Keeling__Islands_46', 'state_West_Island_974'),
('country_Colombia_47', 'state_Amazonas_975'),
('country_Colombia_47', 'state_Antioquia_976'),
('country_Colombia_47', 'state_Arauca_977'),
('country_Colombia_47', 'state_Atl__ntico_978'),
('country_Colombia_47', 'state_Bol__var_979'),
('country_Colombia_47', 'state_Boyac___980'),
('country_Colombia_47', 'state_Caldas_981'),
('country_Colombia_47', 'state_Caquet___982'),
('country_Colombia_47', 'state_Casanare_983'),
('country_Colombia_47', 'state_Cauca_984'),
('country_Colombia_47', 'state_Cesar_985'),
('country_Colombia_47', 'state_Choc___986'),
('country_Colombia_47', 'state_C__rdoba_987'),
('country_Colombia_47', 'state_Cundinamarca_988'),
('country_Colombia_47', 'state_Bogot___Distrito_Capital_989'),
('country_Colombia_47', 'state_Guain__a_990'),
('country_Colombia_47', 'state_Guaviare_991'),
('country_Colombia_47', 'state_La_Guajira_993'),
('country_Colombia_47', 'state_Magdalena_994'),
('country_Colombia_47', 'state_Meta_995'),
('country_Colombia_47', 'state_Nari__o_996'),
('country_Colombia_47', 'state_Norte_de_Santander_997'),
('country_Colombia_47', 'state_Putumayo_998'),
('country_Colombia_47', 'state_Quind__o_999'),
('country_Colombia_47', 'state_Risaralda_1000'),
('country_Colombia_47', 'state_Santander_1001'),
('country_Colombia_47', 'state_San_Andr__s_y_Providencia_1002'),
('country_Colombia_47', 'state_Sucre_1003'),
('country_Colombia_47', 'state_Tolima_1004'),
('country_Colombia_47', 'state_Valle_del_Cauca_1005'),
('country_Colombia_47', 'state_Vaup__s_1006'),
('country_Colombia_47', 'state_Vichada_1007'),
('country_Comoros_48', 'state_Anjouan_1008'),
('country_Comoros_48', 'state_Grande_Comore_1009'),
('country_Comoros_48', 'state_Moh__li_1010'),
('country_Congo_49', 'state_Congo_Central_1011'),
('country_Congo_49', 'state_Bandundu_1012'),
('country_Congo_49', 'state___quateur_1013'),
('country_Congo_49', 'state_Katanga_1014'),
('country_Congo_49', 'state_Kasai_Oriental_1015'),
('country_Congo_49', 'state_Kinshasa_1016'),
('country_Congo_49', 'state_Kasai_Occidental_1017'),
('country_Congo_49', 'state_Maniema_1018'),
('country_Congo_49', 'state_Nord_Kivu_1019'),
('country_Congo_49', 'state_Orientale_1020'),
('country_Congo_49', 'state_Sud_Kivu_1021'),
('country_Cook_Islands_50', 'state_Pukapuka_1022'),
('country_Cook_Islands_50', 'state_Rakahanga_1023'),
('country_Cook_Islands_50', 'state_Manihiki_1024'),
('country_Cook_Islands_50', 'state_Penrhyn_1025'),
('country_Cook_Islands_50', 'state_Nassau_Island_1026'),
('country_Cook_Islands_50', 'state_Surwarrow_1027'),
('country_Cook_Islands_50', 'state_Palmerston_1028'),
('country_Cook_Islands_50', 'state_Aitutaki_1029'),
('country_Cook_Islands_50', 'state_Manuae_1030'),
('country_Cook_Islands_50', 'state_Takutea_1031'),
('country_Cook_Islands_50', 'state_Mitiaro_1032'),
('country_Cook_Islands_50', 'state_Atiu_1033'),
('country_Cook_Islands_50', 'state_Mauke_1034'),
('country_Cook_Islands_50', 'state_Rarotonga_1035'),
('country_Cook_Islands_50', 'state_Mangaia_1036'),
('country_Costa_Rica_51', 'state_Alajuela_1037'),
('country_Costa_Rica_51', 'state_Cartago_1038'),
('country_Costa_Rica_51', 'state_Guanacaste_1039'),
('country_Costa_Rica_51', 'state_Heredia_1040'),
('country_Costa_Rica_51', 'state_Lim__n_1041'),
('country_Costa_Rica_51', 'state_Puntarenas_1042'),
('country_Costa_Rica_51', 'state_San_Jos___1043'),
('country_Cote_D_Ivoire_52', 'state_Lagunes_1044'),
('country_Cote_D_Ivoire_52', 'state_Haut_Sassandra_1045'),
('country_Cote_D_Ivoire_52', 'state_Savanes_1046'),
('country_Cote_D_Ivoire_52', 'state_Vall__e_du_Bandama_1047'),
('country_Cote_D_Ivoire_52', 'state_Moyen_Como___1048'),
('country_Cote_D_Ivoire_52', 'state_Dix_Huit_1049'),
('country_Cote_D_Ivoire_52', 'state_Lacs_1050'),
('country_Cote_D_Ivoire_52', 'state_Zanzan_1051'),
('country_Cote_D_Ivoire_52', 'state_Bas_Sassandra_1052'),
('country_Cote_D_Ivoire_52', 'state_Dengu__l___1053'),
('country_Cote_D_Ivoire_52', 'state_N_zi_Como___1054'),
('country_Cote_D_Ivoire_52', 'state_Marahou___1055'),
('country_Cote_D_Ivoire_52', 'state_Sud_Como___1056'),
('country_Cote_D_Ivoire_52', 'state_Worodouqou_1057'),
('country_Cote_D_Ivoire_52', 'state_Sud_Bandama_1058'),
('country_Cote_D_Ivoire_52', 'state_Agn__bi_1059'),
('country_Cote_D_Ivoire_52', 'state_Bafing_1060'),
('country_Cote_D_Ivoire_52', 'state_Fromager_1061'),
('country_Cote_D_Ivoire_52', 'state_Moyen_Cavally_1062'),
('country_Croatia_53', 'state_Zagreba__ka___upanija_1063'),
('country_Croatia_53', 'state_Krapinsko_zagorska___upanija_1064'),
('country_Croatia_53', 'state_Sisa__ko_moslava__ka___upanija_1065'),
('country_Croatia_53', 'state_Karlova__ka___upanija_1066'),
('country_Croatia_53', 'state_Vara__dinska___upanija_1067'),
('country_Croatia_53', 'state_Koprivni__ko_kri__eva__ka___upanija_1068'),
('country_Croatia_53', 'state_Bjelovarsko_bilogorska___upanija_1069'),
('country_Croatia_53', 'state_Primorsko_goranska___upanija_1070'),
('country_Croatia_53', 'state_Li__ko_senjska___upanija_1071'),
('country_Croatia_53', 'state_Viroviti__ko_podravska___upanija_1072'),
('country_Croatia_53', 'state_Po__e__ko_slavonska___upanija_1073'),
('country_Croatia_53', 'state_Brodsko_posavska___upanija_1074'),
('country_Croatia_53', 'state_Zadarska___upanija_1075'),
('country_Croatia_53', 'state_Osje__ko_baranjska___upanija_1076'),
('country_Croatia_53', 'state___ibensko_kninska___upanija_1077'),
('country_Croatia_53', 'state_Vukovarsko_srijemska___upanija_1078'),
('country_Croatia_53', 'state_Splitsko_dalmatinska___upanija_1079'),
('country_Croatia_53', 'state_Istarska___upanija_1080'),
('country_Croatia_53', 'state_Dubrova__ko_neretvanska___upanija_1081'),
('country_Croatia_53', 'state_Me__imurska___upanija_1082'),
('country_Croatia_53', 'state_Zagreb_1083'),
('country_Cuba_54', 'state_Pinar_del_R__o_1084'),
('country_Cuba_54', 'state_La_Habana_1085'),
('country_Cuba_54', 'state_Ciudad_de_La_Habana_1086'),
('country_Cuba_54', 'state_Matanzas_1087'),
('country_Cuba_54', 'state_Villa_Clara_1088'),
('country_Cuba_54', 'state_Cienfuegos_1089'),
('country_Cuba_54', 'state_Sancti_Sp__ritus_1090'),
('country_Cuba_54', 'state_Ciego_de___vila_1091'),
('country_Cuba_54', 'state_Camag__ey_1092'),
('country_Cuba_54', 'state_Las_Tunas_1093'),
('country_Cuba_54', 'state_Holgu__n_1094'),
('country_Cuba_54', 'state_Granma_1095'),
('country_Cuba_54', 'state_Santiago_de_Cuba_1096'),
('country_Cuba_54', 'state_Guant__namo_1097'),
('country_Cuba_54', 'state_Isla_de_la_Juventud_1098'),
('country_Cyprus_55', 'state_________v_______1099'),
('country_Cyprus_55', 'state__________________1100'),
('country_Cyprus_55', 'state______________________1101'),
('country_Cyprus_55', 'state________________1102'),
('country_Cyprus_55', 'state________________1103'),
('country_Cyprus_55', 'state____________1104'),
('country_Czech_Republic_56', 'state_Jiho__esk___kraj_1105'),
('country_Czech_Republic_56', 'state_Jihomoravsk___kraj_1106'),
('country_Czech_Republic_56', 'state_Karlovarsk___kraj_1107'),
('country_Czech_Republic_56', 'state_Vyso__ina_kraj_1108'),
('country_Czech_Republic_56', 'state_Kr__lov__hradeck___kraj_1109'),
('country_Czech_Republic_56', 'state_Libereck___kraj_1110'),
('country_Czech_Republic_56', 'state_Moravskoslezsk___kraj_1111'),
('country_Czech_Republic_56', 'state_Olomouck___kraj_1112'),
('country_Czech_Republic_56', 'state_Pardubick___kraj_1113'),
('country_Czech_Republic_56', 'state_Plze__sk___kraj_1114'),
('country_Czech_Republic_56', 'state_Hlavn___m__sto_Praha_1115'),
('country_Czech_Republic_56', 'state_St__edo__esk___kraj_1116'),
('country_Czech_Republic_56', 'state___steck___kraj_1117'),
('country_Czech_Republic_56', 'state_Zl__nsk___kraj_1118'),
('country_Denmark_57', 'state_K__benhavn_1120'),
('country_Denmark_57', 'state___rhus_Amt_1122'),
('country_Denmark_57', 'state_Nordjyllands_Amt_1126'),
('country_Denmark_57', 'state_Roskilde_Amt_1129'),
('country_Denmark_57', 'state_Vejle_Amt_1132'),
('country_Djibouti_58', 'state_Region_d_Ali_Sabieh_1135'),
('country_Djibouti_58', 'state_Region_d_Arta_1136'),
('country_Djibouti_58', 'state_Region_de_Dikhil_1137'),
('country_Djibouti_58', 'state_Ville_de_Djibouti_1138'),
('country_Djibouti_58', 'state_Region_d_Obock_1139'),
('country_Djibouti_58', 'state_Region_de_Tadjourah_1140'),
('country_Dominica_59', 'state_Saint_Andrew_Parish_1141'),
('country_Dominica_59', 'state_Saint_David_Parish_1142'),
('country_Dominica_59', 'state_Saint_George_Parish_1143'),
('country_Dominica_59', 'state_Saint_John_Parish_1144'),
('country_Dominica_59', 'state_Saint_Joseph_Parish_1145'),
('country_Dominica_59', 'state_Saint_Luke_Parish_1146'),
('country_Dominica_59', 'state_Saint_Mark_Parish_1147'),
('country_Dominica_59', 'state_Saint_Patrick_Parish_1148'),
('country_Dominica_59', 'state_Saint_Paul_Parish_1149'),
('country_Dominica_59', 'state_Saint_Peter_Parish_1150'),
('country_Dominican_Republic_60', 'state_Distrito_Nacional_1151'),
('country_Dominican_Republic_60', 'state___zua_1152'),
('country_Dominican_Republic_60', 'state_Baoruco_1153'),
('country_Dominican_Republic_60', 'state_Barahona_1154'),
('country_Dominican_Republic_60', 'state_Dajab__n_1155'),
('country_Dominican_Republic_60', 'state_Duarte_1156'),
('country_Dominican_Republic_60', 'state_El__as_Pi__a_1157'),
('country_Dominican_Republic_60', 'state_El_Seibo_1158'),
('country_Dominican_Republic_60', 'state_Espaillat_1159'),
('country_Dominican_Republic_60', 'state_Independencia_1160'),
('country_Dominican_Republic_60', 'state_La_Altagracia_1161'),
('country_Dominican_Republic_60', 'state_La_Romana_1162'),
('country_Dominican_Republic_60', 'state_La_Vega_1163'),
('country_Dominican_Republic_60', 'state_Mar__a_Trinidad_S__nchez_1164'),
('country_Dominican_Republic_60', 'state_Monte_Cristi_1165'),
('country_Dominican_Republic_60', 'state_Pedernales_1166'),
('country_Dominican_Republic_60', 'state_Peravia_1167'),
('country_Dominican_Republic_60', 'state_Puerto_Plata_1168'),
('country_Dominican_Republic_60', 'state_Salcedo_1169'),
('country_Dominican_Republic_60', 'state_Saman___1170'),
('country_Dominican_Republic_60', 'state_San_Crist__bal_1171'),
('country_Dominican_Republic_60', 'state_San_Juan_1172'),
('country_Dominican_Republic_60', 'state_San_Pedro_de_Macor__s_1173'),
('country_Dominican_Republic_60', 'state_S__nchez_Ram__rez_1174'),
('country_Dominican_Republic_60', 'state_Santiago_1175'),
('country_Dominican_Republic_60', 'state_Santiago_Rodr__guez_1176'),
('country_Dominican_Republic_60', 'state_Valverde_1177'),
('country_Dominican_Republic_60', 'state_Monse__or_Nouel_1178'),
('country_Dominican_Republic_60', 'state_Monte_Plata_1179'),
('country_Dominican_Republic_60', 'state_Hato_Mayor_1180'),
('country_East_Timor_61', 'state_Aileu_1181'),
('country_East_Timor_61', 'state_Ainaro_1182'),
('country_East_Timor_61', 'state_Baucau_1183'),
('country_East_Timor_61', 'state_Bobonaro_1184'),
('country_East_Timor_61', 'state_Cova_Lima_1185'),
('country_East_Timor_61', 'state_Dili_1186'),
('country_East_Timor_61', 'state_Ermera_1187'),
('country_East_Timor_61', 'state_Lautem_1188'),
('country_East_Timor_61', 'state_Liqui_____1189'),
('country_East_Timor_61', 'state_Manufahi_1190'),
('country_East_Timor_61', 'state_Manatuto_1191'),
('country_East_Timor_61', 'state_Oecussi_1192'),
('country_East_Timor_61', 'state_Viqueque_1193'),
('country_Ecuador_62', 'state_Azuay_1194'),
('country_Ecuador_62', 'state_Bol__var_1195'),
('country_Ecuador_62', 'state_Carchi_1196'),
('country_Ecuador_62', 'state_Orellana_1197'),
('country_Ecuador_62', 'state_Esmeraldas_1198'),
('country_Ecuador_62', 'state_Ca__ar_1199'),
('country_Ecuador_62', 'state_Guayas_1200'),
('country_Ecuador_62', 'state_Chimborazo_1201'),
('country_Ecuador_62', 'state_Imbabura_1202'),
('country_Ecuador_62', 'state_Loja_1203'),
('country_Ecuador_62', 'state_Manab___1204'),
('country_Ecuador_62', 'state_Napo_1205'),
('country_Ecuador_62', 'state_El_Oro_1206'),
('country_Ecuador_62', 'state_Pichincha_1207'),
('country_Ecuador_62', 'state_Los_R__os_1208'),
('country_Ecuador_62', 'state_Morona_Santiago_1209'),
('country_Ecuador_62', 'state_Tungurahua_1210'),
('country_Ecuador_62', 'state_Sucumb__os_1211'),
('country_Ecuador_62', 'state_Gal__pagos_1212'),
('country_Ecuador_62', 'state_Cotopaxi_1213'),
('country_Ecuador_62', 'state_Pastaza_1214'),
('country_Ecuador_62', 'state_Zamora_Chinchipe_1215'),
('country_Egypt_63', 'state______________________1216'),
('country_Egypt_63', 'state____________1217'),
('country_Egypt_63', 'state____________1218'),
('country_Egypt_63', 'state_________________________1219'),
('country_Egypt_63', 'state________________1220'),
('country_Egypt_63', 'state_________________1221'),
('country_Egypt_63', 'state________________1222'),
('country_Egypt_63', 'state__________________1223'),
('country_Egypt_63', 'state____________1224'),
('country_Egypt_63', 'state______________1225'),
('country_Egypt_63', 'state________________1226'),
('country_Egypt_63', 'state______________1227'),
('country_Egypt_63', 'state________________________1228'),
('country_Egypt_63', 'state_____________________1229'),
('country_Egypt_63', 'state____________________1230'),
('country_Egypt_63', 'state___________________1231'),
('country_Egypt_63', 'state________1232'),
('country_Egypt_63', 'state___________________________1233'),
('country_Egypt_63', 'state__________________1234'),
('country_Egypt_63', 'state____________1235'),
('country_Egypt_63', 'state______________________________1236'),
('country_Egypt_63', 'state_________________________1237'),
('country_Egypt_63', 'state___________________________________1238')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Egypt_63', 'state_____________________1239'),
('country_Egypt_63', 'state______________1240'),
('country_Egypt_63', 'state___________________________1241'),
('country_El_Salvador_64', 'state_Ahuachap__n_1242'),
('country_El_Salvador_64', 'state_Caba__as_1243'),
('country_El_Salvador_64', 'state_Chalatenango_1244'),
('country_El_Salvador_64', 'state_Cuscatl__n_1245'),
('country_El_Salvador_64', 'state_La_Libertad_1246'),
('country_El_Salvador_64', 'state_Moraz__n_1247'),
('country_El_Salvador_64', 'state_La_Paz_1248'),
('country_El_Salvador_64', 'state_Santa_Ana_1249'),
('country_El_Salvador_64', 'state_San_Miguel_1250'),
('country_El_Salvador_64', 'state_Sonsonate_1251'),
('country_El_Salvador_64', 'state_San_Salvador_1252'),
('country_El_Salvador_64', 'state_San_Vicente_1253'),
('country_El_Salvador_64', 'state_La_Uni__n_1254'),
('country_El_Salvador_64', 'state_Usulut__n_1255'),
('country_Equatorial_Guinea_65', 'state_Annob__n_1256'),
('country_Equatorial_Guinea_65', 'state_Bioko_Norte_1257'),
('country_Equatorial_Guinea_65', 'state_Bioko_Sur_1258'),
('country_Equatorial_Guinea_65', 'state_Centro_Sur_1259'),
('country_Equatorial_Guinea_65', 'state_Ki___Ntem_1260'),
('country_Equatorial_Guinea_65', 'state_Litoral_1261'),
('country_Equatorial_Guinea_65', 'state_Wele_Nzas_1262'),
('country_Eritrea_66', 'state_Zoba_Anseba_1263'),
('country_Eritrea_66', 'state_Zoba_Debubawi_Keyih_Bahri_1264'),
('country_Eritrea_66', 'state_Zoba_Debub_1265'),
('country_Eritrea_66', 'state_Zoba_Gash_Barka_1266'),
('country_Eritrea_66', 'state_Zoba_Ma_akel_1267'),
('country_Eritrea_66', 'state_Zoba_Semienawi_Keyih_Bahri_1268'),
('country_Estonia_67', 'state_Harju_maakond_1269'),
('country_Estonia_67', 'state_Hiiu_maakond_1270'),
('country_Estonia_67', 'state_Ida_Viru_maakond_1271'),
('country_Estonia_67', 'state_J__geva_maakond_1272'),
('country_Estonia_67', 'state_J__rva_maakond_1273'),
('country_Estonia_67', 'state_L____ne_maakond_1274'),
('country_Estonia_67', 'state_L____ne_Viru_maakond_1275'),
('country_Estonia_67', 'state_P__lva_maakond_1276'),
('country_Estonia_67', 'state_P__rnu_maakond_1277'),
('country_Estonia_67', 'state_Rapla_maakond_1278'),
('country_Estonia_67', 'state_Saare_maakond_1279'),
('country_Estonia_67', 'state_Tartu_maakond_1280'),
('country_Estonia_67', 'state_Valga_maakond_1281'),
('country_Estonia_67', 'state_Viljandi_maakond_1282'),
('country_Estonia_67', 'state_V__ru_maakond_1283'),
('country_Ethiopia_68', 'state_____________________1284'),
('country_Ethiopia_68', 'state___________1285'),
('country_Ethiopia_68', 'state___________1286'),
('country_Ethiopia_68', 'state______________________________1287'),
('country_Ethiopia_68', 'state______________1288'),
('country_Ethiopia_68', 'state___________________________1289'),
('country_Ethiopia_68', 'state_____________________1290'),
('country_Ethiopia_68', 'state______________1291'),
('country_Ethiopia_68', 'state___________1292'),
('country_Ethiopia_68', 'state___________________________________________________________1293'),
('country_Ethiopia_68', 'state______________1294'),
('country_Fiji_71', 'state_Central_1295'),
('country_Fiji_71', 'state_Northern_1296'),
('country_Fiji_71', 'state_Eastern_1297'),
('country_Fiji_71', 'state_Rotuma_1298'),
('country_Fiji_71', 'state_Western_1299'),
('country_Finland_72', 'state_Ahvenanmaan_maakunta_1300'),
('country_Finland_72', 'state_Etel___Suomen_l____ni_1301'),
('country_Finland_72', 'state_It___Suomen_l____ni_1302'),
('country_Finland_72', 'state_Lapin_l____ni_1303'),
('country_Finland_72', 'state_L__nsi_Suomen_l____ni_1304'),
('country_Finland_72', 'state_Oulun_l____ni_1305'),
('country_France_73', 'state_Ain_1306'),
('country_France_73', 'state_Aisne_1307'),
('country_France_73', 'state_Allier_1308'),
('country_France_73', 'state_Alpes_de_Haute_Provence_1309'),
('country_France_73', 'state_Hautes_Alpes_1310'),
('country_France_73', 'state_Alpes_Maritimes_1311'),
('country_France_73', 'state_Ard__che_1312'),
('country_France_73', 'state_Ardennes_1313'),
('country_France_73', 'state_Ari__ge_1314'),
('country_France_73', 'state_Aube_1315'),
('country_France_73', 'state_Aude_1316'),
('country_France_73', 'state_Aveyron_1317'),
('country_France_73', 'state_Bouches_du_Rh__ne_1318'),
('country_France_73', 'state_Calvados_1319'),
('country_France_73', 'state_Cantal_1320'),
('country_France_73', 'state_Charente_1321'),
('country_France_73', 'state_Charente_Maritime_1322'),
('country_France_73', 'state_Cher_1323'),
('country_France_73', 'state_Corr__ze_1324'),
('country_France_73', 'state_C__te_d_Or_1325'),
('country_France_73', 'state_C__tes_d_Armor_1326'),
('country_France_73', 'state_Creuse_1327'),
('country_France_73', 'state_Dordogne_1328'),
('country_France_73', 'state_Doubs_1329'),
('country_France_73', 'state_Dr__me_1330'),
('country_France_73', 'state_Eure_1331'),
('country_France_73', 'state_Eure_et_Loir_1332'),
('country_France_73', 'state_Finist__re_1333'),
('country_France_73', 'state_Corse_du_Sud_1334'),
('country_France_73', 'state_Haute_Corse_1335'),
('country_France_73', 'state_Gard_1336'),
('country_France_73', 'state_Haute_Garonne_1337'),
('country_France_73', 'state_Gers_1338'),
('country_France_73', 'state_Gironde_1339'),
('country_France_73', 'state_H__rault_1340'),
('country_France_73', 'state_Ille_et_Vilaine_1341'),
('country_France_73', 'state_Indre_1342'),
('country_France_73', 'state_Indre_et_Loire_1343'),
('country_France_73', 'state_Is__re_1344'),
('country_France_73', 'state_Jura_1345'),
('country_France_73', 'state_Landes_1346'),
('country_France_73', 'state_Loir_et_Cher_1347'),
('country_France_73', 'state_Loire_1348'),
('country_France_73', 'state_Haute_Loire_1349'),
('country_France_73', 'state_Loire_Atlantique_1350'),
('country_France_73', 'state_Loiret_1351'),
('country_France_73', 'state_Lot_1352'),
('country_France_73', 'state_Lot_et_Garonne_1353'),
('country_France_73', 'state_Loz__re_1354'),
('country_France_73', 'state_Maine_et_Loire_1355'),
('country_France_73', 'state_Manche_1356'),
('country_France_73', 'state_Marne_1357'),
('country_France_73', 'state_Haute_Marne_1358'),
('country_France_73', 'state_Mayenne_1359'),
('country_France_73', 'state_Meurthe_et_Moselle_1360'),
('country_France_73', 'state_Meuse_1361'),
('country_France_73', 'state_Morbihan_1362'),
('country_France_73', 'state_Moselle_1363'),
('country_France_73', 'state_Ni__vre_1364'),
('country_France_73', 'state_Nord_1365'),
('country_France_73', 'state_Oise_1366'),
('country_France_73', 'state_Orne_1367'),
('country_France_73', 'state_Pas_de_Calais_1368'),
('country_France_73', 'state_Puy_de_D__me_1369'),
('country_France_73', 'state_Pyr__n__es_Atlantiques_1370'),
('country_France_73', 'state_Hautes_Pyr__n__es_1371'),
('country_France_73', 'state_Pyr__n__es_Orientales_1372'),
('country_France_73', 'state_Bas_Rhin_1373'),
('country_France_73', 'state_Haut_Rhin_1374'),
('country_France_73', 'state_Rh__ne_1375'),
('country_France_73', 'state_Haute_Sa__ne_1376'),
('country_France_73', 'state_Sa__ne_et_Loire_1377'),
('country_France_73', 'state_Sarthe_1378'),
('country_France_73', 'state_Savoie_1379'),
('country_France_73', 'state_Haute_Savoie_1380'),
('country_France_73', 'state_Paris_1381'),
('country_France_73', 'state_Seine_Maritime_1382'),
('country_France_73', 'state_Seine_et_Marne_1383'),
('country_France_73', 'state_Yvelines_1384'),
('country_France_73', 'state_Deux_S__vres_1385'),
('country_France_73', 'state_Somme_1386'),
('country_France_73', 'state_Tarn_1387'),
('country_France_73', 'state_Tarn_et_Garonne_1388'),
('country_France_73', 'state_Var_1389'),
('country_France_73', 'state_Vaucluse_1390'),
('country_France_73', 'state_Vend__e_1391'),
('country_France_73', 'state_Vienne_1392'),
('country_France_73', 'state_Haute_Vienne_1393'),
('country_France_73', 'state_Vosges_1394'),
('country_France_73', 'state_Yonne_1395'),
('country_France_73', 'state_Territoire_de_Belfort_1396'),
('country_France_73', 'state_Essonne_1397'),
('country_France_73', 'state_Hauts_de_Seine_1398'),
('country_France_73', 'state_Seine_Saint_Denis_1399'),
('country_France_73', 'state_Val_de_Marne_1400'),
('country_France_73', 'state_Val_d_Oise_1401'),
('country_France_73', 'state_Territoire_des_Nouvelle_Cal__donie_et_Dependances_1402'),
('country_France_73', 'state_Polyn__sie_Fran__aise_1403'),
('country_France_73', 'state_Saint_Pierre_et_Miquelon_1404'),
('country_France_73', 'state_Terres_australes_et_antarctiques_fran__aises_1405'),
('country_France_73', 'state_Mayotte_1406'),
('country_France_73', 'state_Territoire_des___les_Wallis_et_Futuna_1407'),
('country_France_73', 'country_Guadeloupe_87'),
('country_France_73', 'country_Reunion_174'),
('country_France_73', 'country_Martinique_134'),
('country_French_Polynesia_76', 'state_Archipel_des_Marquises_1408'),
('country_French_Polynesia_76', 'state_Archipel_des_Tuamotu_1409'),
('country_French_Polynesia_76', 'state_Archipel_des_Tubuai_1410'),
('country_French_Polynesia_76', 'state_Iles_du_Vent_1411'),
('country_French_Polynesia_76', 'state_Iles_Sous_le_Vent__1412'),
('country_French_Southern_Territories_77', 'state_Iles_Crozet_1413'),
('country_French_Southern_Territories_77', 'state_Iles_Kerguelen_1414'),
('country_French_Southern_Territories_77', 'state_Ile_Amsterdam_1415'),
('country_French_Southern_Territories_77', 'state_Ile_Saint_Paul_1416'),
('country_French_Southern_Territories_77', 'state_Adelie_Land_1417'),
('country_Gabon_78', 'state_Estuaire_1418'),
('country_Gabon_78', 'state_Haut_Ogooue_1419'),
('country_Gabon_78', 'state_Moyen_Ogooue_1420'),
('country_Gabon_78', 'state_Ngounie_1421'),
('country_Gabon_78', 'state_Nyanga_1422'),
('country_Gabon_78', 'state_Ogooue_Ivindo_1423'),
('country_Gabon_78', 'state_Ogooue_Lolo_1424'),
('country_Gabon_78', 'state_Ogooue_Maritime_1425'),
('country_Gabon_78', 'state_Woleu_Ntem_1426'),
('country_Gambia_79', 'state_Lower_River_4562'),
('country_Gambia_79', 'state_Central_River_4563'),
('country_Gambia_79', 'state_North_Bank_4564'),
('country_Gambia_79', 'state_Upper_River_4565'),
('country_Gambia_79', 'state_Western_4566'),
('country_Gambia_79', 'state_Banjul_4567'),
('country_Ghana_82', 'state_Ashanti_1427'),
('country_Ghana_82', 'state_Brong_Ahafo_1428'),
('country_Ghana_82', 'state_Central_1429'),
('country_Ghana_82', 'state_Eastern_1430'),
('country_Ghana_82', 'state_Greater_Accra_1431'),
('country_Ghana_82', 'state_Northern_1432'),
('country_Ghana_82', 'state_Upper_East_1433'),
('country_Ghana_82', 'state_Upper_West_1434'),
('country_Ghana_82', 'state_Volta_1435'),
('country_Ghana_82', 'state_Western_1436'),
('country_Georgia_80', 'state__________________________1437'),
('country_Georgia_80', 'state_________________1438'),
('country_Georgia_80', 'state_________________1439'),
('country_Georgia_80', 'state_______________________1440'),
('country_Georgia_80', 'state____________________1441'),
('country_Georgia_80', 'state____________________________________1442'),
('country_Georgia_80', 'state_____________________________________________1443'),
('country_Georgia_80', 'state_________________________________________________________________________________1444'),
('country_Georgia_80', 'state_____________________________________________1445'),
('country_Georgia_80', 'state_________________________________1446'),
('country_Georgia_80', 'state________________________________________________________________1447'),
('country_Georgia_80', 'state_______________________1448'),
('country_Germany_81', 'state_Berlin_1449'),
('country_Germany_81', 'state_Brandenburg_1450'),
('country_Germany_81', 'state_Baden_W__rttemberg_1451'),
('country_Germany_81', 'state_Bayern_1452'),
('country_Germany_81', 'state_Bremen_1453'),
('country_Germany_81', 'state_Hessen_1454'),
('country_Germany_81', 'state_Hamburg_1455'),
('country_Germany_81', 'state_Mecklenburg_Vorpommern_1456'),
('country_Germany_81', 'state_Niedersachsen_1457'),
('country_Germany_81', 'state_Nordrhein_Westfalen_1458'),
('country_Germany_81', 'state_Rheinland_Pfalz_1459'),
('country_Germany_81', 'state_Schleswig_Holstein_1460'),
('country_Germany_81', 'state_Saarland_1461'),
('country_Germany_81', 'state_Sachsen_1462'),
('country_Germany_81', 'state_Sachsen_Anhalt_1463'),
('country_Germany_81', 'state_Th__ringen_1464'),
('country_Greece_84', 'state________________________________1475'),
('country_Greece_84', 'state________________1476'),
('country_Greece_84', 'state______________1477'),
('country_Greece_84', 'state____________________1478'),
('country_Greece_84', 'state__________________1479'),
('country_Greece_84', 'state______________1480'),
('country_Greece_84', 'state__________________1481'),
('country_Greece_84', 'state________________1482'),
('country_Greece_84', 'state_____________1483'),
('country_Greece_84', 'state____________1484'),
('country_Greece_84', 'state__________________1485'),
('country_Greece_84', 'state________________1486'),
('country_Greece_84', 'state__________________1487'),
('country_Greece_84', 'state__________________1488'),
('country_Greece_84', 'state________________1489'),
('country_Greece_84', 'state______________________1490'),
('country_Greece_84', 'state________________1491'),
('country_Greece_84', 'state__________1492'),
('country_Greece_84', 'state____________________1493'),
('country_Greece_84', 'state__________________1494'),
('country_Greece_84', 'state________________1495'),
('country_Greece_84', 'state__________________1496'),
('country_Greece_84', 'state______________1497'),
('country_Greece_84', 'state__________________1498'),
('country_Greece_84', 'state________________1499'),
('country_Greece_84', 'state________________1500'),
('country_Greece_84', 'state____________1501'),
('country_Greece_84', 'state______________1502'),
('country_Greece_84', 'state________________________1503'),
('country_Greece_84', 'state______________1504'),
('country_Greece_84', 'state__________________1505'),
('country_Greece_84', 'state______________1506'),
('country_Greece_84', 'state______________1507'),
('country_Greece_84', 'state____________1508'),
('country_Greece_84', 'state______________1509'),
('country_Greece_84', 'state______________1510'),
('country_Greece_84', 'state________________1511'),
('country_Greece_84', 'state____________________1512'),
('country_Greece_84', 'state___________________1513'),
('country_Greece_84', 'state____________1514'),
('country_Greece_84', 'state____________1515'),
('country_Greece_84', 'state______________1516'),
('country_Greece_84', 'state______________________1517'),
('country_Greece_84', 'state__________________1518'),
('country_Greece_84', 'state______________1519'),
('country_Greece_84', 'state____________1520'),
('country_Greece_84', 'state__________1521'),
('country_Greece_84', 'state__________________1522'),
('country_Greece_84', 'state______________1523'),
('country_Greece_84', 'state________________1524'),
('country_Greece_84', 'state______________1525'),
('country_Greece_84', 'state______________1526'),
('country_Greenland_85', 'state_Avannaa_1527'),
('country_Greenland_85', 'state_Tunu__1528'),
('country_Greenland_85', 'state_Kitaa_1529'),
('country_Grenada_86', 'state_Saint_David_1531'),
('country_Grenada_86', 'state_Saint_Mark_1534'),
('country_Grenada_86', 'state_Saint_Patrick_1535'),
('country_Guatemala_89', 'state_Alta_Verapaz_1536'),
('country_Guatemala_89', 'state_Baja_Verapaz_1537'),
('country_Guatemala_89', 'state_Chimaltenango_1538'),
('country_Guatemala_89', 'state_Chiquimula_1539'),
('country_Guatemala_89', 'state_Escuintla_1540'),
('country_Guatemala_89', 'state_Guatemala_1541'),
('country_Guatemala_89', 'state_Huehuetenango_1542'),
('country_Guatemala_89', 'state_Izabal_1543'),
('country_Guatemala_89', 'state_Jalapa_1544'),
('country_Guatemala_89', 'state_Jutiapa_1545'),
('country_Guatemala_89', 'state_El_Pet__n_1546'),
('country_Guatemala_89', 'state_El_Progreso_1547'),
('country_Guatemala_89', 'state_El_Quich___1548'),
('country_Guatemala_89', 'state_Quetzaltenango_1549'),
('country_Guatemala_89', 'state_Retalhuleu_1550'),
('country_Guatemala_89', 'state_Sacatep__quez_1551'),
('country_Guatemala_89', 'state_San_Marcos_1552'),
('country_Guatemala_89', 'state_Solol___1553'),
('country_Guatemala_89', 'state_Santa_Rosa_1554'),
('country_Guatemala_89', 'state_Suchitep__quez_1555'),
('country_Guatemala_89', 'state_Totonicap__n_1556'),
('country_Guatemala_89', 'state_Zacapa_1557'),
('country_Guinea_90', 'state_Beyla_1558'),
('country_Guinea_90', 'state_Boffa_1559'),
('country_Guinea_90', 'state_Bok___1560'),
('country_Guinea_90', 'state_Coyah_1561'),
('country_Guinea_90', 'state_Dabola_1562'),
('country_Guinea_90', 'state_Dinguiraye_1563'),
('country_Guinea_90', 'state_Dalaba_1564'),
('country_Guinea_90', 'state_Dubr__ka_1565'),
('country_Guinea_90', 'state_Faranah_1566'),
('country_Guinea_90', 'state_For__cariah_1567'),
('country_Guinea_90', 'state_Fria_1568'),
('country_Guinea_90', 'state_Gaoual_1569'),
('country_Guinea_90', 'state_Gu__k__dou_1570'),
('country_Guinea_90', 'state_Kankan_1571'),
('country_Guinea_90', 'state_Koubia_1572'),
('country_Guinea_90', 'state_Kindia_1573'),
('country_Guinea_90', 'state_K__rouan___1574'),
('country_Guinea_90', 'state_Koundara_1575'),
('country_Guinea_90', 'state_Kouroussa_1576'),
('country_Guinea_90', 'state_Kissidougou_1577'),
('country_Guinea_90', 'state_Lab___1578'),
('country_Guinea_90', 'state_L__louma_1579'),
('country_Guinea_90', 'state_Lola_1580'),
('country_Guinea_90', 'state_Macenta_1581'),
('country_Guinea_90', 'state_Mandiana_1582'),
('country_Guinea_90', 'state_Mali_1583'),
('country_Guinea_90', 'state_Mamou_1584'),
('country_Guinea_90', 'state_Nz__r__kor___1585'),
('country_Guinea_90', 'state_Pita_1586'),
('country_Guinea_90', 'state_Siguiri_1587'),
('country_Guinea_90', 'state_T__lim__l___1588'),
('country_Guinea_90', 'state_Tougu___1589'),
('country_Guinea_90', 'state_Yomou_1590'),
('country_Guinea_Bissau_91', 'state_Bafata_1591'),
('country_Guinea_Bissau_91', 'state_Biombo_1592'),
('country_Guinea_Bissau_91', 'state_Bissau_1593'),
('country_Guinea_Bissau_91', 'state_Bolama_1594'),
('country_Guinea_Bissau_91', 'state_Cacheu_1595'),
('country_Guinea_Bissau_91', 'state_Gabu_1596'),
('country_Guinea_Bissau_91', 'state_Oio_1597'),
('country_Guinea_Bissau_91', 'state_Quinara_1598'),
('country_Guinea_Bissau_91', 'state_Tombali_1599'),
('country_Guyana_92', 'state_Barima_Waini_1600'),
('country_Guyana_92', 'state_Cuyuni_Mazaruni_1601'),
('country_Guyana_92', 'state_Demerara_Mahaica_1602'),
('country_Guyana_92', 'state_East_Berbice_Corentyne_1603'),
('country_Guyana_92', 'state_Essequibo_Islands_West_Demerara_1604'),
('country_Guyana_92', 'state_Mahaica_Berbice_1605'),
('country_Guyana_92', 'state_Pomeroon_Supenaam_1606'),
('country_Guyana_92', 'state_Potaro_Siparuni_1607'),
('country_Guyana_92', 'state_Upper_Demerara_Berbice_1608'),
('country_Guyana_92', 'state_Upper_Takutu_Upper_Essequibo_1609'),
('country_Haiti_93', 'state_Artibonite_1610'),
('country_Haiti_93', 'state_Grand_Anse_1612'),
('country_Haiti_93', 'state_Nippes_1613'),
('country_Haiti_93', 'state_Nord_1614'),
('country_Haiti_93', 'state_Nord_Est_1615'),
('country_Haiti_93', 'state_Nord_Ouest_1616'),
('country_Haiti_93', 'state_Sud_1618'),
('country_Haiti_93', 'state_Sud_Est_1619'),
('country_Heard_and_McDonald_Islands_94', 'state_Flat_Island_1620'),
('country_Heard_and_McDonald_Islands_94', 'state_McDonald_Island_1621'),
('country_Heard_and_McDonald_Islands_94', 'state_Shag_Island_1622'),
('country_Heard_and_McDonald_Islands_94', 'state_Heard_Island_1623'),
('country_Honduras_95', 'state_Atl__ntida_1624'),
('country_Honduras_95', 'state_Choluteca_1625'),
('country_Honduras_95', 'state_Col__n_1626'),
('country_Honduras_95', 'state_Comayagua_1627'),
('country_Honduras_95', 'state_Cop__n_1628'),
('country_Honduras_95', 'state_Cort__s_1629'),
('country_Honduras_95', 'state_El_Para__so_1630'),
('country_Honduras_95', 'state_Francisco_Moraz__n_1631'),
('country_Honduras_95', 'state_Gracias_a_Dios_1632'),
('country_Honduras_95', 'state_Islas_de_la_Bah__a_1633'),
('country_Honduras_95', 'state_Intibuc___1634'),
('country_Honduras_95', 'state_Lempira_1635'),
('country_Honduras_95', 'state_La_Paz_1636'),
('country_Honduras_95', 'state_Ocotepeque_1637'),
('country_Honduras_95', 'state_Olancho_1638'),
('country_Honduras_95', 'state_Santa_B__rbara_1639'),
('country_Honduras_95', 'state_Valle_1640'),
('country_Honduras_95', 'state_Yoro_1641'),
('country_Hong_Kong_96', 'state___________1642'),
('country_Hong_Kong_96', 'state________1643'),
('country_Hong_Kong_96', 'state________1644'),
('country_Hong_Kong_96', 'state___________1645'),
('country_Hong_Kong_96', 'state______________1646'),
('country_Hong_Kong_96', 'state___________1647'),
('country_Hong_Kong_96', 'state______________1648'),
('country_Hong_Kong_96', 'state______________1649'),
('country_Hong_Kong_96', 'state______________1650'),
('country_Hong_Kong_96', 'state___________1651'),
('country_Hong_Kong_96', 'state___________1652'),
('country_Hong_Kong_96', 'state________1653'),
('country_Hong_Kong_96', 'state___________1654'),
('country_Hong_Kong_96', 'state___________1655'),
('country_Hong_Kong_96', 'state___________1656'),
('country_Hong_Kong_96', 'state___________1657'),
('country_Hong_Kong_96', 'state___________1658'),
('country_Hong_Kong_96', 'state___________1659'),
('country_Hungary_97', 'state_Baranja_megye_1660'),
('country_Hungary_97', 'state_B__k__scsaba_1661'),
('country_Hungary_97', 'state_B__k__s_megye_1662'),
('country_Hungary_97', 'state_B__cs_Kiskun_megye_1663'),
('country_Hungary_97', 'state_Budapest_1664'),
('country_Hungary_97', 'state_Borsod_Aba__j_Zempl__n_megye_1665'),
('country_Hungary_97', 'state_Csongr__d_megye_1666'),
('country_Hungary_97', 'state_Debrecen_1667'),
('country_Hungary_97', 'state_Duna__jv__ros_1668'),
('country_Hungary_97', 'state_Eger_1669'),
('country_Hungary_97', 'state_Fej__r_megye_1670'),
('country_Hungary_97', 'state_Gy__r_Moson_Sopron_megye_1671'),
('country_Hungary_97', 'state_Gy__r_1672'),
('country_Hungary_97', 'state_Hajd___Bihar_megye_1673'),
('country_Hungary_97', 'state_Heves_megye_1674'),
('country_Hungary_97', 'state_H__dmez__v__s__rhely_1675'),
('country_Hungary_97', 'state_J__sz_Nagykun_Szolnok_megye_1676'),
('country_Hungary_97', 'state_Kom__rom_Esztergom_megye_1677'),
('country_Hungary_97', 'state_Kecskem__t_1678'),
('country_Hungary_97', 'state_Kaposv__r_1679'),
('country_Hungary_97', 'state_Miskolc_1680'),
('country_Hungary_97', 'state_Nagykanizsa_1681'),
('country_Hungary_97', 'state_N__gr__d_megye_1682'),
('country_Hungary_97', 'state_Ny__regyh__za_1683'),
('country_Hungary_97', 'state_Pest_megye_1684'),
('country_Hungary_97', 'state_P__cs_1685'),
('country_Hungary_97', 'state_Szeged_1686'),
('country_Hungary_97', 'state_Sz__kesfeh__rv__r_1687'),
('country_Hungary_97', 'state_Szombathely_1688'),
('country_Hungary_97', 'state_Szolnok_1689'),
('country_Hungary_97', 'state_Sopron_1690'),
('country_Hungary_97', 'state_Somogy_megye_1691'),
('country_Hungary_97', 'state_Szeksz__rd_1692'),
('country_Hungary_97', 'state_Salg__tarj__n_1693'),
('country_Hungary_97', 'state_Szabolcs_Szatm__r_Bereg_megye_1694'),
('country_Hungary_97', 'state_Tatab__nya_1695'),
('country_Hungary_97', 'state_Tolna_megye_1696'),
('country_Hungary_97', 'state_Vas_megye_1697'),
('country_Hungary_97', 'state_Veszpr__m_megye_1698'),
('country_Hungary_97', 'state_Veszpr__m_1699'),
('country_Hungary_97', 'state_Zala_megye_1700'),
('country_Hungary_97', 'state_Zalaegerszeg_1701'),
('country_Iceland_98', 'state_H__fu__borgarsv____i___1702'),
('country_Iceland_98', 'state_Su__urnes_1703'),
('country_Iceland_98', 'state_Vesturland_1704'),
('country_Iceland_98', 'state_Vestfir__ir_1705'),
('country_Iceland_98', 'state_Nor__urland_vestra_1706'),
('country_Iceland_98', 'state_Nor__urland_eystra_1707'),
('country_Iceland_98', 'state_Austfir__ir_1708'),
('country_Iceland_98', 'state_Su__urland_1709'),
('country_India_99', 'state_________________________________________________________________1710'),
('country_India_99', 'state_______________________________________1711'),
('country_India_99', 'state__________________________________________1712'),
('country_India_99', 'state___________1713'),
('country_India_99', 'state_________________1714'),
('country_India_99', 'state_______________________1715'),
('country_India_99', 'state_____________________________1716'),
('country_India_99', 'state_______________________________1717'),
('country_India_99', 'state____________________1718'),
('country_India_99', 'state_____________________________________________________1719'),
('country_India_99', 'state______________1720'),
('country_India_99', 'state____________________1721'),
('country_India_99', 'state_______________________________________1722'),
('country_India_99', 'state_______________________1723'),
('country_India_99', 'state____________________1724'),
('country_India_99', 'state___________________________________________1725'),
('country_India_99', 'state____________________1726'),
('country_India_99', 'state_________________1727'),
('country_India_99', 'state________________________________1728'),
('country_India_99', 'state____________________1729'),
('country_India_99', 'state________________________________1730'),
('country_India_99', 'state____________________1731'),
('country_India_99', 'state_________________________________1732'),
('country_India_99', 'state_______________________1733'),
('country_India_99', 'state__________________________1734'),
('country_India_99', 'state____________________1735'),
('country_India_99', 'state_________________1736'),
('country_India_99', 'state________________________________1737'),
('country_India_99', 'state__________________________1738'),
('country_India_99', 'state_______________________1739'),
('country_India_99', 'state______________________________1740'),
('country_India_99', 'state__________________________1741'),
('country_India_99', 'state_____________________________1742'),
('country_India_99', 'state____________________________________1743'),
('country_India_99', 'state________________________________1744'),
('country_India_99', 'state_Telangana_4561'),
('country_Indonesia_100', 'state_Aceh_1745'),
('country_Indonesia_100', 'state_Bali_1746'),
('country_Indonesia_100', 'state_Bangka_Belitung_1747'),
('country_Indonesia_100', 'state_Bengkulu_1748'),
('country_Indonesia_100', 'state_Banten_1749'),
('country_Indonesia_100', 'state_Gorontalo_1750')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Indonesia_100', 'state_Papua_1751'),
('country_Indonesia_100', 'state_Jambi_1752'),
('country_Indonesia_100', 'state_Jawa_Timur_1753'),
('country_Indonesia_100', 'state_Jakarta_Raya_1754'),
('country_Indonesia_100', 'state_Jawa_Barat_1755'),
('country_Indonesia_100', 'state_Jawa_Tengah_1756'),
('country_Indonesia_100', 'state_Kalimantan_Barat_1757'),
('country_Indonesia_100', 'state_Kalimantan_Timur_1758'),
('country_Indonesia_100', 'state_Kalimantan_Selatan_1759'),
('country_Indonesia_100', 'state_Kalimantan_Tengah_1760'),
('country_Indonesia_100', 'state_Lampung_1761'),
('country_Indonesia_100', 'state_Maluku_1762'),
('country_Indonesia_100', 'state_Maluku_Utara_1763'),
('country_Indonesia_100', 'state_Nusa_Tenggara_Barat_1764'),
('country_Indonesia_100', 'state_Nusa_Tenggara_Timur_1765'),
('country_Indonesia_100', 'state_Riau_1766'),
('country_Indonesia_100', 'state_Sumatera_Barat_1767'),
('country_Indonesia_100', 'state_Sulawesi_Tenggara_1768'),
('country_Indonesia_100', 'state_Sumatera_Selatan_1769'),
('country_Indonesia_100', 'state_Sulawesi_Selatan_1770'),
('country_Indonesia_100', 'state_Sulawesi_Tengah_1771'),
('country_Indonesia_100', 'state_Sulawesi_Utara_1772'),
('country_Indonesia_100', 'state_Sumatera_Utara_1773'),
('country_Indonesia_100', 'state_Yogyakarta_1774'),
('country_Iran_101', 'state__________________________________________1775'),
('country_Iran_101', 'state__________________________________________1776'),
('country_Iran_101', 'state___________________________1777'),
('country_Iran_101', 'state___________________________1778'),
('country_Iran_101', 'state_________________________4575'),
('country_Iran_101', 'state_________________________1779'),
('country_Iran_101', 'state_________________________1780'),
('country_Iran_101', 'state_________________________1781'),
('country_Iran_101', 'state_______________________________________________1782'),
('country_Iran_101', 'state____________________________________1783'),
('country_Iran_101', 'state_________________________4573'),
('country_Iran_101', 'state_________________________4574'),
('country_Iran_101', 'state_____________________________1784'),
('country_Iran_101', 'state_________________________1785'),
('country_Iran_101', 'state_________________________1786'),
('country_Iran_101', 'state________________________________________________1787'),
('country_Iran_101', 'state_______________________1788'),
('country_Iran_101', 'state_________________________1802'),
('country_Iran_101', 'state___________________1800'),
('country_Iran_101', 'state_____________________________1790'),
('country_Iran_101', 'state_________________________1789'),
('country_Iran_101', 'state_______________________________1791'),
('country_Iran_101', 'state____________________________________________________1792'),
('country_Iran_101', 'state___________________________1801'),
('country_Iran_101', 'state_________________________1793'),
('country_Iran_101', 'state___________________________1794'),
('country_Iran_101', 'state_______________________________1795'),
('country_Iran_101', 'state_________________________1796'),
('country_Iran_101', 'state_____________________________1797'),
('country_Iran_101', 'state_________________________1798'),
('country_Iran_101', 'state_____________________1799'),
('country_Iraq_102', 'state_____________________________1803'),
('country_Iraq_102', 'state____________1804'),
('country_Iraq_102', 'state___________________________1805'),
('country_Iraq_102', 'state__________1806'),
('country_Iraq_102', 'state_________________________1807'),
('country_Iraq_102', 'state__________1808'),
('country_Iraq_102', 'state____________1809'),
('country_Iraq_102', 'state_____________1810'),
('country_Iraq_102', 'state______________1811'),
('country_Iraq_102', 'state____________1812'),
('country_Iraq_102', 'state______________1813'),
('country_Iraq_102', 'state____________1814'),
('country_Iraq_102', 'state____________1815'),
('country_Iraq_102', 'state__________________1816'),
('country_Iraq_102', 'state_____________________1817'),
('country_Iraq_102', 'state___________________________________1818'),
('country_Iraq_102', 'state________________1819'),
('country_Iraq_102', 'state__________1820'),
('country_Ireland_103', 'state_Corcaigh_1821'),
('country_Ireland_103', 'state_Contae_an_Chl__ir_1822'),
('country_Ireland_103', 'state_An_Cabh__n_1823'),
('country_Ireland_103', 'state_Ceatharlach_1824'),
('country_Ireland_103', 'state_Baile___tha_Cliath_1825'),
('country_Ireland_103', 'state_D__n_na_nGall_1826'),
('country_Ireland_103', 'state_Gaillimh_1827'),
('country_Ireland_103', 'state_Cill_Dara_1828'),
('country_Ireland_103', 'state_Cill_Chainnigh_1829'),
('country_Ireland_103', 'state_Contae_Chiarra___1830'),
('country_Ireland_103', 'state_An_Longfort_1831'),
('country_Ireland_103', 'state_Contae_L___1832'),
('country_Ireland_103', 'state_Luimneach_1833'),
('country_Ireland_103', 'state_Contae_Liatroma_1834'),
('country_Ireland_103', 'state_Contae_Laoise_1835'),
('country_Ireland_103', 'state_Contae_na_M___1836'),
('country_Ireland_103', 'state_Muineach__n_1837'),
('country_Ireland_103', 'state_Contae_Mhaigh_Eo_1838'),
('country_Ireland_103', 'state_Contae_U__bh_Fhail___1839'),
('country_Ireland_103', 'state_Ros_Com__in_1840'),
('country_Ireland_103', 'state_Sligeach_1841'),
('country_Ireland_103', 'state_Tiobraid___rann_1842'),
('country_Ireland_103', 'state_Port_Lairge_1843'),
('country_Ireland_103', 'state_Contae_na_hIarmh___1844'),
('country_Ireland_103', 'state_Cill_Mhant__in_1845'),
('country_Ireland_103', 'state_Loch_Garman_1846'),
('country_Israel_104', 'state_____________________1847'),
('country_Israel_104', 'state___________________1848'),
('country_Israel_104', 'state________________1849'),
('country_Israel_104', 'state_____________________1850'),
('country_Israel_104', 'state______________________1851'),
('country_Israel_104', 'state_____________________1852'),
('country_Italy_105', 'state_Agrigento_1853'),
('country_Italy_105', 'state_Alessandria_1854'),
('country_Italy_105', 'state_Ancona_1855'),
('country_Italy_105', 'state_Valle_d_Aosta_1856'),
('country_Italy_105', 'state_Ascoli_Piceno_1857'),
('country_Italy_105', 'state_L_Aquila_1858'),
('country_Italy_105', 'state_Arezzo_1859'),
('country_Italy_105', 'state_Asti_1860'),
('country_Italy_105', 'state_Avellino_1861'),
('country_Italy_105', 'state_Bari_1862'),
('country_Italy_105', 'state_Bergamo_1863'),
('country_Italy_105', 'state_Biella_1864'),
('country_Italy_105', 'state_Belluno_1865'),
('country_Italy_105', 'state_Benevento_1866'),
('country_Italy_105', 'state_Bologna_1867'),
('country_Italy_105', 'state_Brindisi_1868'),
('country_Italy_105', 'state_Brescia_1869'),
('country_Italy_105', 'state_Barletta_Andria_Trani_1870'),
('country_Italy_105', 'state_Alto_Adige_1871'),
('country_Italy_105', 'state_Cagliari_1872'),
('country_Italy_105', 'state_Campobasso_1873'),
('country_Italy_105', 'state_Caserta_1874'),
('country_Italy_105', 'state_Chieti_1875'),
('country_Italy_105', 'state_Carbonia_Iglesias_1876'),
('country_Italy_105', 'state_Caltanissetta_1877'),
('country_Italy_105', 'state_Cuneo_1878'),
('country_Italy_105', 'state_Como_1879'),
('country_Italy_105', 'state_Cremona_1880'),
('country_Italy_105', 'state_Cosenza_1881'),
('country_Italy_105', 'state_Catania_1882'),
('country_Italy_105', 'state_Catanzaro_1883'),
('country_Italy_105', 'state_Enna_1884'),
('country_Italy_105', 'state_Ferrara_1885'),
('country_Italy_105', 'state_Foggia_1886'),
('country_Italy_105', 'state_Firenze_1887'),
('country_Italy_105', 'state_Fermo_1888'),
('country_Italy_105', 'state_Forl___Cesena_1889'),
('country_Italy_105', 'state_Frosinone_1890'),
('country_Italy_105', 'state_Genova_1891'),
('country_Italy_105', 'state_Gorizia_1892'),
('country_Italy_105', 'state_Grosseto_1893'),
('country_Italy_105', 'state_Imperia_1894'),
('country_Italy_105', 'state_Isernia_1895'),
('country_Italy_105', 'state_Crotone_1896'),
('country_Italy_105', 'state_Lecco_1897'),
('country_Italy_105', 'state_Lecce_1898'),
('country_Italy_105', 'state_Livorno_1899'),
('country_Italy_105', 'state_Lodi_1900'),
('country_Italy_105', 'state_Latina_1901'),
('country_Italy_105', 'state_Lucca_1902'),
('country_Italy_105', 'state_Macerata_1903'),
('country_Italy_105', 'state_Medio_Campidano_1904'),
('country_Italy_105', 'state_Messina_1905'),
('country_Italy_105', 'state_Milano_1906'),
('country_Italy_105', 'state_Mantova_1907'),
('country_Italy_105', 'state_Modena_1908'),
('country_Italy_105', 'state_Massa_Carrara_1909'),
('country_Italy_105', 'state_Matera_1910'),
('country_Italy_105', 'state_Monza_e_Brianza_1911'),
('country_Italy_105', 'state_Napoli_1912'),
('country_Italy_105', 'state_Novara_1913'),
('country_Italy_105', 'state_Nuoro_1914'),
('country_Italy_105', 'state_Ogliastra_1915'),
('country_Italy_105', 'state_Oristano_1916'),
('country_Italy_105', 'state_Olbia_Tempio_1917'),
('country_Italy_105', 'state_Palermo_1918'),
('country_Italy_105', 'state_Piacenza_1919'),
('country_Italy_105', 'state_Padova_1920'),
('country_Italy_105', 'state_Pescara_1921'),
('country_Italy_105', 'state_Perugia_1922'),
('country_Italy_105', 'state_Pisa_1923'),
('country_Italy_105', 'state_Pordenone_1924'),
('country_Italy_105', 'state_Prato_1925'),
('country_Italy_105', 'state_Parma_1926'),
('country_Italy_105', 'state_Pesaro_e_Urbino_1927'),
('country_Italy_105', 'state_Pistoia_1928'),
('country_Italy_105', 'state_Pavia_1929'),
('country_Italy_105', 'state_Potenza_1930'),
('country_Italy_105', 'state_Ravenna_1931'),
('country_Italy_105', 'state_Reggio_Calabria_1932'),
('country_Italy_105', 'state_Reggio_Emilia_1933'),
('country_Italy_105', 'state_Ragusa_1934'),
('country_Italy_105', 'state_Rieti_1935'),
('country_Italy_105', 'state_Roma_1936'),
('country_Italy_105', 'state_Rimini_1937'),
('country_Italy_105', 'state_Rovigo_1938'),
('country_Italy_105', 'state_Salerno_1939'),
('country_Italy_105', 'state_Siena_1940'),
('country_Italy_105', 'state_Sondrio_1941'),
('country_Italy_105', 'state_La_Spezia_1942'),
('country_Italy_105', 'state_Siracusa_1943'),
('country_Italy_105', 'state_Sassari_1944'),
('country_Italy_105', 'state_Savona_1945'),
('country_Italy_105', 'state_Taranto_1946'),
('country_Italy_105', 'state_Teramo_1947'),
('country_Italy_105', 'state_Trento_1948'),
('country_Italy_105', 'state_Torino_1949'),
('country_Italy_105', 'state_Trapani_1950'),
('country_Italy_105', 'state_Terni_1951'),
('country_Italy_105', 'state_Trieste_1952'),
('country_Italy_105', 'state_Treviso_1953'),
('country_Italy_105', 'state_Udine_1954'),
('country_Italy_105', 'state_Varese_1955'),
('country_Italy_105', 'state_Verbano_Cusio_Ossola_1956'),
('country_Italy_105', 'state_Vercelli_1957'),
('country_Italy_105', 'state_Venezia_1958'),
('country_Italy_105', 'state_Vicenza_1959'),
('country_Italy_105', 'state_Verona_1960'),
('country_Italy_105', 'state_Viterbo_1961'),
('country_Italy_105', 'state_Vibo_Valentia_1962'),
('country_Jamaica_106', 'state_Kingston_1963'),
('country_Jamaica_106', 'state_Half_Way_Tree_1964'),
('country_Jamaica_106', 'state_Morant_Bay_1965'),
('country_Jamaica_106', 'state_Port_Antonio_1966'),
('country_Jamaica_106', 'state_Port_Maria_1967'),
('country_Jamaica_106', 'state_Saint_Ann_s_Bay_1968'),
('country_Jamaica_106', 'state_Falmouth_1969'),
('country_Jamaica_106', 'state_Montego_Bay_1970'),
('country_Jamaica_106', 'state_Lucea_1971'),
('country_Jamaica_106', 'state_Savanna_la_Mar_1972'),
('country_Jamaica_106', 'state_Black_River_1973'),
('country_Jamaica_106', 'state_Mandeville_1974'),
('country_Jamaica_106', 'state_May_Pen_1975'),
('country_Jamaica_106', 'state_Spanish_Town_1976'),
('country_Japan_', '1977'),
('country_Japan_107', 'state________1978'),
('country_Japan_107', 'state________1979'),
('country_Japan_107', 'state________1980'),
('country_Japan_107', 'state________1981'),
('country_Japan_107', 'state________1982'),
('country_Japan_107', 'state________1983'),
('country_Japan_107', 'state________1984'),
('country_Japan_107', 'state________1985'),
('country_Japan_107', 'state________1986'),
('country_Japan_107', 'state________1987'),
('country_Japan_107', 'state________1988'),
('country_Japan_107', 'state________1989'),
('country_Japan_107', 'state___________1990'),
('country_Japan_107', 'state________1991'),
('country_Japan_107', 'state________1992'),
('country_Japan_107', 'state________1993'),
('country_Japan_107', 'state________1994'),
('country_Japan_107', 'state________1995'),
('country_Japan_107', 'state________1996'),
('country_Japan_107', 'state________1997'),
('country_Japan_107', 'state________1998'),
('country_Japan_107', 'state________1999'),
('country_Japan_107', 'state________2000'),
('country_Japan_107', 'state________2001'),
('country_Japan_107', 'state________2002'),
('country_Japan_107', 'state________2003'),
('country_Japan_107', 'state________2004'),
('country_Japan_107', 'state________2005'),
('country_Japan_107', 'state___________2006'),
('country_Japan_107', 'state________2007'),
('country_Japan_107', 'state________2008'),
('country_Japan_107', 'state________2009'),
('country_Japan_107', 'state________2010'),
('country_Japan_107', 'state________2011'),
('country_Japan_107', 'state________2012'),
('country_Japan_107', 'state________2013'),
('country_Japan_107', 'state________2014'),
('country_Japan_107', 'state________2015'),
('country_Japan_107', 'state________2016'),
('country_Japan_107', 'state________2017'),
('country_Japan_107', 'state________2018'),
('country_Japan_107', 'state________2019'),
('country_Japan_107', 'state________2020'),
('country_Japan_107', 'state________2021'),
('country_Japan_107', 'state___________2022'),
('country_Japan_107', 'state________2023'),
('country_Jordan_108', 'state_________________________2024'),
('country_Jordan_108', 'state_____________________________2025'),
('country_Jordan_108', 'state___________________________2026'),
('country_Jordan_108', 'state_____________________________2027'),
('country_Jordan_108', 'state_____________________________2028'),
('country_Jordan_108', 'state_____________________________2029'),
('country_Jordan_108', 'state_____________________2030'),
('country_Jordan_108', 'state_______________________2031'),
('country_Jordan_108', 'state_________________________2032'),
('country_Jordan_108', 'state___________________________2033'),
('country_Jordan_108', 'state_________________________2034'),
('country_Jordan_108', 'state_______________________2035'),
('country_Kazakhstan_109', 'state______________2036'),
('country_Kazakhstan_109', 'state_Almaty_City_2037'),
('country_Kazakhstan_109', 'state______________2038'),
('country_Kazakhstan_109', 'state______________2039'),
('country_Kazakhstan_109', 'state______________2040'),
('country_Kazakhstan_109', 'state______________2041'),
('country_Kazakhstan_109', 'state_______________________________2042'),
('country_Kazakhstan_109', 'state__________________2043'),
('country_Kazakhstan_109', 'state____________________2044'),
('country_Kazakhstan_109', 'state_____________________________________2045'),
('country_Kazakhstan_109', 'state__________________2046'),
('country_Kazakhstan_109', 'state____________________2047'),
('country_Kazakhstan_109', 'state__________________2048'),
('country_Kazakhstan_109', 'state____________________2049'),
('country_Kazakhstan_109', 'state_______________________________2050'),
('country_Kazakhstan_109', 'state_______________________________________2051'),
('country_Kazakhstan_109', 'state______________2052'),
('country_Kenya_110', 'state_Nairobi_2053'),
('country_Kenya_110', 'state_Central_2054'),
('country_Kenya_110', 'state_Mombasa_2055'),
('country_Kenya_110', 'state_Eastern_2056'),
('country_Kenya_110', 'state_North_Eastern_2057'),
('country_Kenya_110', 'state_Nyanza_2058'),
('country_Kenya_110', 'state_Rift_Valley_2059'),
('country_Kenya_110', 'state_Western_2060'),
('country_Kiribati_111', 'state_Gilbert_Islands_2061'),
('country_Kiribati_111', 'state_Line_Islands_2062'),
('country_Kiribati_111', 'state_Phoenix_Islands_2063'),
('country_Korea__North_112', 'state___________2064'),
('country_Korea__North_112', 'state_______________2065'),
('country_Korea__North_112', 'state_______________2066'),
('country_Korea__North_112', 'state_______________2067'),
('country_Korea__North_112', 'state_______________2068'),
('country_Korea__North_112', 'state___________2069'),
('country_Korea__North_112', 'state___________2070'),
('country_Korea__North_112', 'state__________________2071'),
('country_Korea__North_112', 'state__________________2072'),
('country_Korea__North_112', 'state_______________2073'),
('country_Korea__North_112', 'state_______________2074'),
('country_Korea__North_112', 'state__________________2075'),
('country_Korea__North_112', 'state___________2076'),
('country_Korea__South_113', 'state_________________2077'),
('country_Korea__South_113', 'state__________________2078'),
('country_Korea__South_113', 'state__________________2079'),
('country_Korea__South_113', 'state_________________2080'),
('country_Korea__South_113', 'state__________________2081'),
('country_Korea__South_113', 'state__________________2082'),
('country_Korea__South_113', 'state__________________2083'),
('country_Korea__South_113', 'state___________2084'),
('country_Korea__South_113', 'state___________2085'),
('country_Korea__South_113', 'state_______________2086'),
('country_Korea__South_113', 'state_______________2087'),
('country_Korea__South_113', 'state_______________2088'),
('country_Korea__South_113', 'state_______________2089'),
('country_Korea__South_113', 'state_______________2090'),
('country_Korea__South_113', 'state_______________2091'),
('country_Korea__South_113', 'state_______________________2092'),
('country_Kuwait_114', 'state________________2093'),
('country_Kuwait_114', 'state____________________2094'),
('country_Kuwait_114', 'state________________2095'),
('country_Kuwait_114', 'state________________2096'),
('country_Kuwait_114', 'state__________2097'),
('country_Kuwait_114', 'state_________________________2098'),
('country_Kyrgyzstan_115', 'state_____________________________2099'),
('country_Kyrgyzstan_115', 'state_______________________2100'),
('country_Kyrgyzstan_115', 'state______________2101'),
('country_Kyrgyzstan_115', 'state____________________________________2102'),
('country_Kyrgyzstan_115', 'state___________________________2103'),
('country_Kyrgyzstan_115', 'state_____________________2104'),
('country_Kyrgyzstan_115', 'state___________________________2105'),
('country_Kyrgyzstan_115', 'state________________________________2106'),
('country_Laos_116', 'state_______________________2107'),
('country_Laos_116', 'state_______________________2108'),
('country_Laos_116', 'state_____________________________2109'),
('country_Laos_116', 'state__________________________2110'),
('country_Laos_116', 'state____________________2111'),
('country_Laos_116', 'state_______________________2112'),
('country_Laos_116', 'state________________________________2113'),
('country_Laos_116', 'state_____________________________2114'),
('country_Laos_116', 'state_______________________2115'),
('country_Laos_116', 'state_______________________2116'),
('country_Laos_116', 'state_______________________2117'),
('country_Laos_116', 'state___________________________________2118'),
('country_Laos_116', 'state____________________2119'),
('country_Laos_116', 'state____________________2120'),
('country_Laos_116', 'state__________________________2121'),
('country_Laos_116', 'state_________________2122'),
('country_Laos_116', 'state_______________________2123'),
('country_Laos_116', 'state__________________________2124'),
('country_Latvia_117', 'state_Aizkraukles_rajons_2125'),
('country_Latvia_117', 'state_Al__ksnes_rajons_2126'),
('country_Latvia_117', 'state_Balvu_rajons_2127'),
('country_Latvia_117', 'state_Bauskas_rajons_2128'),
('country_Latvia_117', 'state_C__su_rajons_2129'),
('country_Latvia_117', 'state_Daugavpils_rajons_2130'),
('country_Latvia_117', 'state_Daugpilis_2131'),
('country_Latvia_117', 'state_Dobeles_rajons_2132'),
('country_Latvia_117', 'state_Gulbenes_rajons_2133'),
('country_Latvia_117', 'state_Jelgava_2134'),
('country_Latvia_117', 'state_J__kabpils_rajons_2135'),
('country_Latvia_117', 'state_Jelgavas_rajons_2136'),
('country_Latvia_117', 'state_J__rmala_2137'),
('country_Latvia_117', 'state_Kr__slavas_rajons_2138'),
('country_Latvia_117', 'state_Kuld__gas_rajons_2139'),
('country_Latvia_117', 'state_Liep__jas_rajons_2140'),
('country_Latvia_117', 'state_Limba__u_rajons_2141'),
('country_Latvia_117', 'state_Liepoja_2142'),
('country_Latvia_117', 'state_Ludzas_rajons_2143'),
('country_Latvia_117', 'state_Madonas_rajons_2144'),
('country_Latvia_117', 'state_Ogres_rajons_2145'),
('country_Latvia_117', 'state_Prei__u_rajons_2146'),
('country_Latvia_117', 'state_R__zeknes_rajons_2147'),
('country_Latvia_117', 'state_R__zekne_2148'),
('country_Latvia_117', 'state_R__gas_rajons_2149'),
('country_Latvia_117', 'state_R__ga_2150'),
('country_Latvia_117', 'state_Saldus_rajons_2151'),
('country_Latvia_117', 'state_Talsu_rajons_2152'),
('country_Latvia_117', 'state_Tukuma_rajons_2153'),
('country_Latvia_117', 'state_Ventspils_rajons_2154'),
('country_Latvia_117', 'state_Ventspils_2155'),
('country_Latvia_117', 'state_Valkas_rajons_2156'),
('country_Latvia_117', 'state_Valmieras_rajons_2157'),
('country_Lesotho_119', 'state_Maseru_2158'),
('country_Lesotho_119', 'state_Butha_Buthe_2159'),
('country_Lesotho_119', 'state_Leribe_2160'),
('country_Lesotho_119', 'state_Berea_2161'),
('country_Lesotho_119', 'state_Mafeteng_2162'),
('country_Lesotho_119', 'state_Mohale_s_Hoek_2163'),
('country_Lesotho_119', 'state_Quthing_2164'),
('country_Lesotho_119', 'state_Qacha_s_Nek_2165'),
('country_Lesotho_119', 'state_Mokhotlong_2166'),
('country_Lesotho_119', 'state_Thaba_Tseka_2167'),
('country_Liberia_120', 'state_Bong_2168'),
('country_Liberia_120', 'state_Bomi_2169'),
('country_Liberia_120', 'state_Grand_Cape_Mount_2170'),
('country_Liberia_120', 'state_Grand_Bassa_2171'),
('country_Liberia_120', 'state_Grand_Gedeh_2172'),
('country_Liberia_120', 'state_Grand_Kru_2173'),
('country_Liberia_120', 'state_Gbarpolu_2174'),
('country_Liberia_120', 'state_Lofa_2175'),
('country_Liberia_120', 'state_Margibi_2176'),
('country_Liberia_120', 'state_Montserrado_2177'),
('country_Liberia_120', 'state_Maryland_2178'),
('country_Liberia_120', 'state_Nimba_2179'),
('country_Liberia_120', 'state_River_Gee_2180'),
('country_Liberia_120', 'state_Rivercess_2181'),
('country_Liberia_120', 'state_Sinoe_2182'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Ajd__biy___2183'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Bangh__z___2184'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Bu__n__n_2185'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Ban___Wal__d_2186'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Darnah_2187'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Ghad__mis_2188'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Ghary__n_2189'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Gh__t_2190'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al____iz__m_al_Akh___ar_2191'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Jabal_al_Akh___ar_2192'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Jaghb__b_2193'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Jif__rah_2194'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Jufrah_2195'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Kufrah_2196'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Marqab_2197'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Mi__r__tah_2198'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Marj_2199'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Murzuq_2200'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Mizdah_2201'),
('country_Libyan_Arab_Jamahiriya_121', 'state_N__l__t_2202'),
('country_Libyan_Arab_Jamahiriya_121', 'state_An_Nuqa___al_Khams_2203'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Qubbah_2204'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_Qa__r__n_2205'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Sabh___2206'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Ash_Sh____i_2207'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Surt_2208'),
('country_Libyan_Arab_Jamahiriya_121', 'state___abr__tah___urm__n_2209'),
('country_Libyan_Arab_Jamahiriya_121', 'state___ar__bulus_2210'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Tarh__nah_Masall__tah_2211'),
('country_Libyan_Arab_Jamahiriya_121', 'state_T__j__r___wa_an_Naw________al_Arb_____2212'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Al_W_____ah_2213'),
('country_Libyan_Arab_Jamahiriya_121', 'state_W__d___al____ay__t_2214'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Yafran_J__d___2215'),
('country_Libyan_Arab_Jamahiriya_121', 'state_Az_Z__wiyah_2216'),
('country_Liechtenstein_122', 'state_Balzers_2217'),
('country_Liechtenstein_122', 'state_Eschen_2218'),
('country_Liechtenstein_122', 'state_Gamprin_2219'),
('country_Liechtenstein_122', 'state_Mauren_2220'),
('country_Liechtenstein_122', 'state_Planken_2221'),
('country_Liechtenstein_122', 'state_Ruggell_2222'),
('country_Liechtenstein_122', 'state_Schaan_2223'),
('country_Liechtenstein_122', 'state_Schellenberg_2224'),
('country_Liechtenstein_122', 'state_Triesen_2225'),
('country_Liechtenstein_122', 'state_Triesenberg_2226'),
('country_Liechtenstein_122', 'state_Vaduz_2227'),
('country_Lithuania_123', 'state_Alytaus_Apskritis_2228'),
('country_Lithuania_123', 'state_Klaip__dos_Apskritis_2229'),
('country_Lithuania_123', 'state_Kauno_Apskritis_2230'),
('country_Lithuania_123', 'state_Marijampol__s_Apskritis_2231'),
('country_Lithuania_123', 'state_Panev____io_Apskritis_2232'),
('country_Lithuania_123', 'state___iauli___Apskritis_2233'),
('country_Lithuania_123', 'state_Taurag__s_Apskritis_2234'),
('country_Lithuania_123', 'state_Tel__i___Apskritis_2235'),
('country_Lithuania_123', 'state_Utenos_Apskritis_2236'),
('country_Lithuania_123', 'state_Vilniaus_Apskritis_2237'),
('country_Luxembourg_124', 'state_Diekirch_2238'),
('country_Luxembourg_124', 'state_Grevenmacher_2239'),
('country_Luxembourg_124', 'state_Luxemburg_2240'),
('country_Macau_125', 'state___________2241'),
('country_Macau_125', 'state___________2242'),
('country_Macedonia_126', 'state_Berovo_2243'),
('country_Macedonia_126', 'state___________________________________2244'),
('country_Macedonia_126', 'state________________2245'),
('country_Macedonia_126', 'state__________________2246'),
('country_Macedonia_126', 'state______________2247')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Macedonia_126', 'state______________2248'),
('country_Macedonia_126', 'state_______________________________________2249'),
('country_Macedonia_126', 'state________________2250'),
('country_Macedonia_126', 'state____________________2251'),
('country_Macedonia_126', 'state__________2252'),
('country_Macedonia_126', 'state_________________________2253'),
('country_Macedonia_126', 'state______________2254'),
('country_Macedonia_126', 'state________________2255'),
('country_Macedonia_126', 'state________________2256'),
('country_Macedonia_126', 'state___________________________2257'),
('country_Macedonia_126', 'state__________________2258'),
('country_Macedonia_126', 'state________________2259'),
('country_Macedonia_126', 'state__________________2260'),
('country_Macedonia_126', 'state_________________________________2261'),
('country_Macedonia_126', 'state______________2262'),
('country_Macedonia_126', 'state_______________________2263'),
('country_Macedonia_126', 'state________________2264'),
('country_Macedonia_126', 'state__________________________2265'),
('country_Macedonia_126', 'state________________2266'),
('country_Macedonia_126', 'state______________2267'),
('country_Macedonia_126', 'state______________2268'),
('country_Macedonia_126', 'state______________2269'),
('country_Macedonia_126', 'state____________2270'),
('country_Macedonia_126', 'state__________________2271'),
('country_Macedonia_126', 'state__________________2272'),
('country_Macedonia_126', 'state__________________2273'),
('country_Macedonia_126', 'state____________________2274'),
('country_Macedonia_126', 'state__________________________________2275'),
('country_Macedonia_126', 'state______________2276'),
('country_Macedonia_126', 'state______________2277'),
('country_Macedonia_126', 'state____________________2278'),
('country_Macedonia_126', 'state______________2279'),
('country_Macedonia_126', 'state__________________2280'),
('country_Macedonia_126', 'state____________________2281'),
('country_Macedonia_126', 'state____________2282'),
('country_Macedonia_126', 'state__________2283'),
('country_Macedonia_126', 'state______________2284'),
('country_Macedonia_126', 'state___________________________2285'),
('country_Macedonia_126', 'state___________________2286'),
('country_Macedonia_126', 'state_________________________2287'),
('country_Macedonia_126', 'state________________2288'),
('country_Macedonia_126', 'state______________2289'),
('country_Macedonia_126', 'state_______________________2290'),
('country_Macedonia_126', 'state__________________2291'),
('country_Macedonia_126', 'state____________2292'),
('country_Macedonia_126', 'state________________2293'),
('country_Macedonia_126', 'state________________________2294'),
('country_Macedonia_126', 'state_________________________2295'),
('country_Macedonia_126', 'state______________________2296'),
('country_Macedonia_126', 'state__________________2297'),
('country_Macedonia_126', 'state__________________2298'),
('country_Macedonia_126', 'state____________________2299'),
('country_Macedonia_126', 'state____________2300'),
('country_Macedonia_126', 'state___________________2301'),
('country_Macedonia_126', 'state________________2302'),
('country_Macedonia_126', 'state_______________________2303'),
('country_Macedonia_126', 'state__________________2304'),
('country_Macedonia_126', 'state____________________2305'),
('country_Macedonia_126', 'state__________________2306'),
('country_Macedonia_126', 'state_______________________2307'),
('country_Macedonia_126', 'state____________2308'),
('country_Macedonia_126', 'state________________2309'),
('country_Macedonia_126', 'state________________2310'),
('country_Macedonia_126', 'state______________2311'),
('country_Macedonia_126', 'state_______________________________2312'),
('country_Macedonia_126', 'state____________2313'),
('country_Macedonia_126', 'state________________2314'),
('country_Macedonia_126', 'state__________________2315'),
('country_Macedonia_126', 'state______________2316'),
('country_Macedonia_126', 'state________________2317'),
('country_Macedonia_126', 'state______________________2318'),
('country_Macedonia_126', 'state____________2319'),
('country_Macedonia_126', 'state____________2320'),
('country_Macedonia_126', 'state_________________________2321'),
('country_Macedonia_126', 'state________________2322'),
('country_Macedonia_126', 'state____________________2323'),
('country_Macedonia_126', 'state__________________2324'),
('country_Macedonia_126', 'state________________2325'),
('country_Macedonia_126', 'state____________2326'),
('country_Madagascar_127', 'state_Toamasina_2327'),
('country_Madagascar_127', 'state_Antsiranana_2328'),
('country_Madagascar_127', 'state_Fianarantsoa_2329'),
('country_Madagascar_127', 'state_Mahajanga_2330'),
('country_Madagascar_127', 'state_Antananarivo_2331'),
('country_Madagascar_127', 'state_Toliara_2332'),
('country_Malawi_128', 'state_Balaka_2333'),
('country_Malawi_128', 'state_Blantyre_2334'),
('country_Malawi_128', 'state_Chikwawa_2336'),
('country_Malawi_128', 'state_Chiradzulu_2337'),
('country_Malawi_128', 'state_Chitipa_2338'),
('country_Malawi_128', 'state_Dedza_2339'),
('country_Malawi_128', 'state_Dowa_2340'),
('country_Malawi_128', 'state_Karonga_2341'),
('country_Malawi_128', 'state_Kasungu_2342'),
('country_Malawi_128', 'state_Likoma_Island_2343'),
('country_Malawi_128', 'state_Lilongwe_2344'),
('country_Malawi_128', 'state_Machinga_2345'),
('country_Malawi_128', 'state_Mangochi_2346'),
('country_Malawi_128', 'state_Mchinji_2347'),
('country_Malawi_128', 'state_Mulanje_2348'),
('country_Malawi_128', 'state_Mwanza_2349'),
('country_Malawi_128', 'state_Mzimba_2350'),
('country_Malawi_128', 'state_Northern_2351'),
('country_Malawi_128', 'state_Nkhata_2352'),
('country_Malawi_128', 'state_Nkhotakota_2353'),
('country_Malawi_128', 'state_Nsanje_2354'),
('country_Malawi_128', 'state_Ntcheu_2355'),
('country_Malawi_128', 'state_Ntchisi_2356'),
('country_Malawi_128', 'state_Phalombe_2357'),
('country_Malawi_128', 'state_Rumphi_2358'),
('country_Malawi_128', 'state_Southern_2359'),
('country_Malawi_128', 'state_Salima_2360'),
('country_Malawi_128', 'state_Thyolo_2361'),
('country_Malawi_128', 'state_Zomba_2362'),
('country_Malaysia_129', 'state_Johor_Darul_Takzim_2363'),
('country_Malaysia_129', 'state_Kedah_Darul_Aman_2364'),
('country_Malaysia_129', 'state_Kelantan_Darul_Naim_2365'),
('country_Malaysia_129', 'state_Melaka_Negeri_Bersejarah_2366'),
('country_Malaysia_129', 'state_Negeri_Sembilan_Darul_Khusus_2367'),
('country_Malaysia_129', 'state_Pahang_Darul_Makmur_2368'),
('country_Malaysia_129', 'state_Pulau_Pinang_2369'),
('country_Malaysia_129', 'state_Perak_Darul_Ridzuan_2370'),
('country_Malaysia_129', 'state_Perlis_Indera_Kayangan_2371'),
('country_Malaysia_129', 'state_Selangor_Darul_Ehsan_2372'),
('country_Malaysia_129', 'state_Terengganu_Darul_Iman_2373'),
('country_Malaysia_129', 'state_Sabah_Negeri_Di_Bawah_Bayu_2374'),
('country_Malaysia_129', 'state_Sarawak_Bumi_Kenyalang_2375'),
('country_Malaysia_129', 'state_Wilayah_Persekutuan_Kuala_Lumpur_2376'),
('country_Malaysia_129', 'state_Wilayah_Persekutuan_Labuan_2377'),
('country_Malaysia_129', 'state_Wilayah_Persekutuan_Putrajaya_2378'),
('country_Maldives_130', 'state_Thiladhunmathi_Uthuru_2379'),
('country_Maldives_130', 'state_Thiladhunmathi_Dhekunu_2380'),
('country_Maldives_130', 'state_Miladhunmadulu_Uthuru_2381'),
('country_Maldives_130', 'state_Miladhunmadulu_Dhekunu_2382'),
('country_Maldives_130', 'state_Maalhosmadulu_Uthuru_2383'),
('country_Maldives_130', 'state_Maalhosmadulu_Dhekunu_2384'),
('country_Maldives_130', 'state_Faadhippolhu_2385'),
('country_Maldives_130', 'state_Male_Atoll_2386'),
('country_Maldives_130', 'state_Ari_Atoll_Uthuru_2387'),
('country_Maldives_130', 'state_Ari_Atoll_Dheknu_2388'),
('country_Maldives_130', 'state_Felidhe_Atoll_2389'),
('country_Maldives_130', 'state_Mulaku_Atoll_2390'),
('country_Maldives_130', 'state_Nilandhe_Atoll_Uthuru_2391'),
('country_Maldives_130', 'state_Nilandhe_Atoll_Dhekunu_2392'),
('country_Maldives_130', 'state_Kolhumadulu_2393'),
('country_Maldives_130', 'state_Hadhdhunmathi_2394'),
('country_Maldives_130', 'state_Huvadhu_Atoll_Uthuru_2395'),
('country_Maldives_130', 'state_Huvadhu_Atoll_Dhekunu_2396'),
('country_Maldives_130', 'state_Fua_Mulaku_2397'),
('country_Maldives_130', 'state_Addu_2398'),
('country_Mali_131', 'state_Kayes_2399'),
('country_Mali_131', 'state_Koulikoro_2400'),
('country_Mali_131', 'state_Sikasso_2401'),
('country_Mali_131', 'state_S__gou_2402'),
('country_Mali_131', 'state_Mopti_2403'),
('country_Mali_131', 'state_Tombouctou_2404'),
('country_Mali_131', 'state_Gao_2405'),
('country_Mali_131', 'state_Kidal_2406'),
('country_Mali_131', 'state_Bamako_2407'),
('country_Malta_132', 'state_malta_2408'),
('country_Malta_132', 'state_gozo_2409'),
('country_Marshall_Islands_133', 'state_Ailuk_2476'),
('country_Marshall_Islands_133', 'state_Ailinglapalap_2477'),
('country_Marshall_Islands_133', 'state_Arno_2478'),
('country_Marshall_Islands_133', 'state_Aur_2479'),
('country_Marshall_Islands_133', 'state_Ebon_2480'),
('country_Marshall_Islands_133', 'state_Eniwetok_2481'),
('country_Marshall_Islands_133', 'state_Jabat_2482'),
('country_Marshall_Islands_133', 'state_Jaluit_2483'),
('country_Marshall_Islands_133', 'state_Kili_2484'),
('country_Marshall_Islands_133', 'state_Kwajalein_2485'),
('country_Marshall_Islands_133', 'state_Lae_2486'),
('country_Marshall_Islands_133', 'state_Lib_2487'),
('country_Marshall_Islands_133', 'state_Likiep_2488'),
('country_Marshall_Islands_133', 'state_Majuro_2489'),
('country_Marshall_Islands_133', 'state_Maloelap_2490'),
('country_Marshall_Islands_133', 'state_Mejit_2491'),
('country_Marshall_Islands_133', 'state_Mili_2492'),
('country_Marshall_Islands_133', 'state_Namorik_2493'),
('country_Marshall_Islands_133', 'state_Namu_2494'),
('country_Marshall_Islands_133', 'state_Rongelap_2495'),
('country_Marshall_Islands_133', 'state_Ujae_2496'),
('country_Marshall_Islands_133', 'state_Ujelang_2497'),
('country_Marshall_Islands_133', 'state_Utirik_2498'),
('country_Marshall_Islands_133', 'state_Wotje_2499'),
('country_Marshall_Islands_133', 'state_Wotho_2500'),
('country_Mauritania_135', 'state____________________________________2501'),
('country_Mauritania_135', 'state____________________________________2502'),
('country_Mauritania_135', 'state___________________________2503'),
('country_Mauritania_135', 'state_______________________2504'),
('country_Mauritania_135', 'state_____________________________2505'),
('country_Mauritania_135', 'state_____________________________2506'),
('country_Mauritania_135', 'state_______________________2507'),
('country_Mauritania_135', 'state______________________________________2508'),
('country_Mauritania_135', 'state_______________________2509'),
('country_Mauritania_135', 'state______________________________2510'),
('country_Mauritania_135', 'state______________________________2511'),
('country_Mauritania_135', 'state___________________________2512'),
('country_Mauritania_135', 'state________________2513'),
('country_Mauritius_136', 'state_Agalega_Islands_2514'),
('country_Mauritius_136', 'state_Black_River_2515'),
('country_Mauritius_136', 'state_Beau_Bassin_Rose_Hill_2516'),
('country_Mauritius_136', 'state_Cargados_Carajos_Shoals_2517'),
('country_Mauritius_136', 'state_Curepipe_2518'),
('country_Mauritius_136', 'state_Flacq_2519'),
('country_Mauritius_136', 'state_Grand_Port_2520'),
('country_Mauritius_136', 'state_Moka_2521'),
('country_Mauritius_136', 'state_Pamplemousses_2522'),
('country_Mauritius_136', 'state_Port_Louis_2523'),
('country_Mauritius_136', 'state_Port_Louis_City_2524'),
('country_Mauritius_136', 'state_Plaines_Wilhems_2525'),
('country_Mauritius_136', 'state_Quatre_Bornes_2526'),
('country_Mauritius_136', 'state_Rodrigues_2527'),
('country_Mauritius_136', 'state_Riviere_du_Rempart_2528'),
('country_Mauritius_136', 'state_Savanne_2529'),
('country_Mauritius_136', 'state_Vacoas_Phoenix_2530'),
('country_Mexico_138', 'state_Aguascalientes_2531'),
('country_Mexico_138', 'state_Baja_California_2532'),
('country_Mexico_138', 'state_Baja_California_Sur_2533'),
('country_Mexico_138', 'state_Campeche_2534'),
('country_Mexico_138', 'state_Chihuahua_2535'),
('country_Mexico_138', 'state_Chiapas_2536'),
('country_Mexico_138', 'state_Coahuila_2537'),
('country_Mexico_138', 'state_Colima_2538'),
('country_Mexico_138', 'state_Distrito_Federal_2539'),
('country_Mexico_138', 'state_Durango_2540'),
('country_Mexico_138', 'state_Guerrero_2541'),
('country_Mexico_138', 'state_Guanajuato_2542'),
('country_Mexico_138', 'state_Hidalgo_2543'),
('country_Mexico_138', 'state_Jalisco_2544'),
('country_Mexico_138', 'state_Mexico_2545'),
('country_Mexico_138', 'state_Michoac__n_2546'),
('country_Mexico_138', 'state_Morelos_2547'),
('country_Mexico_138', 'state_Nayarit_2548'),
('country_Mexico_138', 'state_Nuevo_Le__n_2549'),
('country_Mexico_138', 'state_Oaxaca_2550'),
('country_Mexico_138', 'state_Puebla_2551'),
('country_Mexico_138', 'state_Quer__taro_2552'),
('country_Mexico_138', 'state_Quintana_Roo_2553'),
('country_Mexico_138', 'state_Sinaloa_2554'),
('country_Mexico_138', 'state_San_Luis_Potos___2555'),
('country_Mexico_138', 'state_Sonora_2556'),
('country_Mexico_138', 'state_Tabasco_2557'),
('country_Mexico_138', 'state_Tamaulipas_2558'),
('country_Mexico_138', 'state_Tlaxcala_2559'),
('country_Mexico_138', 'state_Veracruz_2560'),
('country_Mexico_138', 'state_Yucatan_2561'),
('country_Mexico_138', 'state_Zacatecas_2562'),
('country_Micronesia_139', 'state_Kosrae_2563'),
('country_Micronesia_139', 'state_Pohnpei_2564'),
('country_Micronesia_139', 'state_Chuuk_2565'),
('country_Micronesia_139', 'state_Yap_2566'),
('country_Moldova_140', 'state_B__l__i_2567'),
('country_Moldova_140', 'state_Cahul_2568'),
('country_Moldova_140', 'state_Chi__in__u_2569'),
('country_Moldova_140', 'state_Edine___2570'),
('country_Moldova_140', 'state_G__g__uzia_2571'),
('country_Moldova_140', 'state_L__pu__na_2572'),
('country_Moldova_140', 'state_Orhei_2573'),
('country_Moldova_140', 'state_St__nga_Nistrului_2574'),
('country_Moldova_140', 'state_Soroca_2575'),
('country_Moldova_140', 'state_Tighina_2576'),
('country_Moldova_140', 'state_Ungheni_2577'),
('country_Monaco_141', 'state_Monte_Carlo_2578'),
('country_Monaco_141', 'state_La_Rousse_2579'),
('country_Monaco_141', 'state_Larvotto_2580'),
('country_Monaco_141', 'state_Monaco_Ville_2581'),
('country_Monaco_141', 'state_Saint_Michel_2582'),
('country_Monaco_141', 'state_Condamine_2583'),
('country_Monaco_141', 'state_La_Colle_2584'),
('country_Monaco_141', 'state_Les_R__voires_2585'),
('country_Monaco_141', 'state_Moneghetti_2586'),
('country_Monaco_141', 'state_Fontvieille_2587'),
('country_Mongolia_142', 'state________________________2588'),
('country_Mongolia_142', 'state_______________________2589'),
('country_Mongolia_142', 'state________________________________2590'),
('country_Mongolia_142', 'state_________________________2591'),
('country_Mongolia_142', 'state___________________________2592'),
('country_Mongolia_142', 'state_____________________2593'),
('country_Mongolia_142', 'state___________________2594'),
('country_Mongolia_142', 'state___________________2595'),
('country_Mongolia_142', 'state___________________________2596'),
('country_Mongolia_142', 'state_______________________________2597'),
('country_Mongolia_142', 'state_____________________________2598'),
('country_Mongolia_142', 'state_________________________________2599'),
('country_Mongolia_142', 'state_________________________2600'),
('country_Mongolia_142', 'state_____________________________2601'),
('country_Mongolia_142', 'state_________________________2602'),
('country_Mongolia_142', 'state_______________________________2603'),
('country_Mongolia_142', 'state_________________________________2604'),
('country_Mongolia_142', 'state________________________________2605'),
('country_Mongolia_142', 'state_________________________2606'),
('country_Mongolia_142', 'state_________________________________2607'),
('country_Mongolia_142', 'state________________________________2608'),
('country_Mongolia_142', 'state_____________________________2609'),
('country_Montserrat_143', 'state_Saint_Anthony_2610'),
('country_Montserrat_143', 'state_Saint_Georges_2611'),
('country_Montserrat_143', 'state_Saint_Peter_2612'),
('country_Mozambique_145', 'state_Niassa_2613'),
('country_Mozambique_145', 'state_Manica_2614'),
('country_Mozambique_145', 'state_Gaza_2615'),
('country_Mozambique_145', 'state_Inhambane_2616'),
('country_Mozambique_145', 'state_Maputo_2617'),
('country_Mozambique_145', 'state_Maputo_cidade_2618'),
('country_Mozambique_145', 'state_Nampula_2619'),
('country_Mozambique_145', 'state_Cabo_Delgado_2620'),
('country_Mozambique_145', 'state_Zamb__zia_2621'),
('country_Mozambique_145', 'state_Sofala_2622'),
('country_Mozambique_145', 'state_Tete_2623'),
('country_Myanmar_146', 'state_________________________________________2624'),
('country_Myanmar_146', 'state______________________________________2625'),
('country_Myanmar_146', 'state_________________________________________2626'),
('country_Myanmar_146', 'state____________________________________________2627'),
('country_Myanmar_146', 'state___________________________________________________________2628'),
('country_Myanmar_146', 'state_______________________________________________2629'),
('country_Myanmar_146', 'state__________________________________________________2630'),
('country_Myanmar_146', 'state_____________________________________________________2631'),
('country_Myanmar_146', 'state_____________________________________________________2632'),
('country_Myanmar_146', 'state_______________________________________________2633'),
('country_Myanmar_146', 'state__________________________________________________2634'),
('country_Myanmar_146', 'state__________________________________________________2635'),
('country_Myanmar_146', 'state_____________________________________________________2636'),
('country_Myanmar_146', 'state__________________________________________________2637'),
('country_Namibia_147', 'state_Caprivi_2638'),
('country_Namibia_147', 'state_Erongo_2639'),
('country_Namibia_147', 'state_Hardap_2640'),
('country_Namibia_147', 'state_Karas_2641'),
('country_Namibia_147', 'state_Khomas_2642'),
('country_Namibia_147', 'state_Kunene_2643'),
('country_Namibia_147', 'state_Otjozondjupa_2644'),
('country_Namibia_147', 'state_Omaheke_2645'),
('country_Namibia_147', 'state_Okavango_2646'),
('country_Namibia_147', 'state_Oshana_2647'),
('country_Namibia_147', 'state_Omusati_2648'),
('country_Namibia_147', 'state_Oshikoto_2649'),
('country_Namibia_147', 'state_Ohangwena_2650'),
('country_Nauru_148', 'state_Aiwo_2651'),
('country_Nauru_148', 'state_Anabar_2652'),
('country_Nauru_148', 'state_Anetan_2653'),
('country_Nauru_148', 'state_Anibare_2654'),
('country_Nauru_148', 'state_Baiti_2655'),
('country_Nauru_148', 'state_Boe_2656'),
('country_Nauru_148', 'state_Buada_2657'),
('country_Nauru_148', 'state_Denigomodu_2658'),
('country_Nauru_148', 'state_Ewa_2659'),
('country_Nauru_148', 'state_Ijuw_2660'),
('country_Nauru_148', 'state_Meneng_2661'),
('country_Nauru_148', 'state_Nibok_2662'),
('country_Nauru_148', 'state_Uaboe_2663'),
('country_Nauru_148', 'state_Yaren_2664'),
('country_Nepal_149', 'state_Bagmati_2665'),
('country_Nepal_149', 'state_Bheri_2666'),
('country_Nepal_149', 'state_Dhawalagiri_2667'),
('country_Nepal_149', 'state_Gandaki_2668'),
('country_Nepal_149', 'state_Janakpur_2669'),
('country_Nepal_149', 'state_Karnali_2670'),
('country_Nepal_149', 'state_Kosi_2671'),
('country_Nepal_149', 'state_Lumbini_2672'),
('country_Nepal_149', 'state_Mahakali_2673'),
('country_Nepal_149', 'state_Mechi_2674'),
('country_Nepal_149', 'state_Narayani_2675'),
('country_Nepal_149', 'state_Rapti_2676'),
('country_Nepal_149', 'state_Sagarmatha_2677'),
('country_Nepal_149', 'state_Seti_2678'),
('country_Netherlands_150', 'state_Drenthe_2679'),
('country_Netherlands_150', 'state_Flevoland_2680'),
('country_Netherlands_150', 'state_Friesland_2681'),
('country_Netherlands_150', 'state_Gelderland_2682'),
('country_Netherlands_150', 'state_Groningen_2683'),
('country_Netherlands_150', 'state_Limburg_2684'),
('country_Netherlands_150', 'state_Noord_Brabant_2685'),
('country_Netherlands_150', 'state_Noord_Holland_2686'),
('country_Netherlands_150', 'state_Overijssel_2687'),
('country_Netherlands_150', 'state_Utrecht_2688'),
('country_Netherlands_150', 'state_Zeeland_2689'),
('country_Netherlands_150', 'state_Zuid_Holland_2690'),
('country_New_Caledonia_152', 'state_Province_des___les_2691'),
('country_New_Caledonia_152', 'state_Province_Nord_2692'),
('country_New_Caledonia_152', 'state_Province_Sud_2693'),
('country_New_Zealand_153', 'state_Auckland_2694'),
('country_New_Zealand_153', 'state_Bay_of_Plenty_2695'),
('country_New_Zealand_153', 'state_Canterbury_2696'),
('country_New_Zealand_153', 'state_Gisborne_2697'),
('country_New_Zealand_153', 'state_Hawke_s_Bay_2698'),
('country_New_Zealand_153', 'state_Marlborough_2699'),
('country_New_Zealand_153', 'state_Manawatu_Wanganui_2700'),
('country_New_Zealand_153', 'state_Nelson_2701'),
('country_New_Zealand_153', 'state_Northland_2702'),
('country_New_Zealand_153', 'state_Otago_2703'),
('country_New_Zealand_153', 'state_Southland_2704'),
('country_New_Zealand_153', 'state_Tasman_2705'),
('country_New_Zealand_153', 'state_Taranaki_2706'),
('country_New_Zealand_153', 'state_Wellington_2707'),
('country_New_Zealand_153', 'state_Waikato_2708'),
('country_New_Zealand_153', 'state_West_Coast_2709'),
('country_Nicaragua_154', 'state_Atl__ntico_Norte_2710'),
('country_Nicaragua_154', 'state_Atl__ntico_Sur_2711'),
('country_Nicaragua_154', 'state_Boaco_2712'),
('country_Nicaragua_154', 'state_Carazo_2713'),
('country_Nicaragua_154', 'state_Chinandega_2714'),
('country_Nicaragua_154', 'state_Chontales_2715'),
('country_Nicaragua_154', 'state_Estel___2716'),
('country_Nicaragua_154', 'state_Granada_2717'),
('country_Nicaragua_154', 'state_Jinotega_2718'),
('country_Nicaragua_154', 'state_Le__n_2719'),
('country_Nicaragua_154', 'state_Madriz_2720'),
('country_Nicaragua_154', 'state_Managua_2721'),
('country_Nicaragua_154', 'state_Masaya_2722'),
('country_Nicaragua_154', 'state_Matagalpa_2723'),
('country_Nicaragua_154', 'state_Nueva_Segovia_2724'),
('country_Nicaragua_154', 'state_Rivas_2725'),
('country_Nicaragua_154', 'state_R__o_San_Juan_2726'),
('country_Niger_155', 'state_Agadez_2727'),
('country_Niger_155', 'state_Daffa_2728'),
('country_Niger_155', 'state_Dosso_2729'),
('country_Niger_155', 'state_Maradi_2730'),
('country_Niger_155', 'state_Tahoua_2731'),
('country_Niger_155', 'state_Tillab__ry_2732'),
('country_Niger_155', 'state_Zinder_2733'),
('country_Niger_155', 'state_Niamey_2734'),
('country_Nigeria_156', 'state_Abia_State_2735'),
('country_Nigeria_156', 'state_Adamawa_State_2736'),
('country_Nigeria_156', 'state_Akwa_Ibom_State_2737'),
('country_Nigeria_156', 'state_Anambra_State_2738'),
('country_Nigeria_156', 'state_Bauchi_State_2739'),
('country_Nigeria_156', 'state_Benue_State_2740'),
('country_Nigeria_156', 'state_Borno_State_2741'),
('country_Nigeria_156', 'state_Bayelsa_State_2742'),
('country_Nigeria_156', 'state_Cross_River_State_2743'),
('country_Nigeria_156', 'state_Delta_State_2744'),
('country_Nigeria_156', 'state_Ebonyi_State_2745'),
('country_Nigeria_156', 'state_Edo_State_2746'),
('country_Nigeria_156', 'state_Ekiti_State_2747'),
('country_Nigeria_156', 'state_Enugu_State_2748'),
('country_Nigeria_156', 'state_FCT_Abuja_4569')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Nigeria_156', 'state_Gombe_State_2749'),
('country_Nigeria_156', 'state_Imo_State_2750'),
('country_Nigeria_156', 'state_Jigawa_State_2751'),
('country_Nigeria_156', 'state_Kebbi_State_2752'),
('country_Nigeria_156', 'state_Kaduna_State_2753'),
('country_Nigeria_156', 'state_Kano_State_2754'),
('country_Nigeria_156', 'state_Kogi_State_2755'),
('country_Nigeria_156', 'state_Katsina_State_2756'),
('country_Nigeria_156', 'state_Kwara_State_2757'),
('country_Nigeria_156', 'state_Lagos_State_2758'),
('country_Nigeria_156', 'state_Nassarawa_State_2759'),
('country_Nigeria_156', 'state_Niger_State_2760'),
('country_Nigeria_156', 'state_Ogun_State_2761'),
('country_Nigeria_156', 'state_Ondo_State_2762'),
('country_Nigeria_156', 'state_Osun_State_2763'),
('country_Nigeria_156', 'state_Oyo_State_2764'),
('country_Nigeria_156', 'state_Plateau_State_2765'),
('country_Nigeria_156', 'state_Rivers_State_2766'),
('country_Nigeria_156', 'state_Sokoto_State_2767'),
('country_Nigeria_156', 'state_Taraba_State_2768'),
('country_Nigeria_156', 'state_Yobe_State_4568'),
('country_Nigeria_156', 'state_Zamfara_State_2769'),
('country_Northern_Mariana_Islands_159', 'state_Northern_Islands_2770'),
('country_Northern_Mariana_Islands_159', 'state_Rota_2771'),
('country_Northern_Mariana_Islands_159', 'state_Saipan_2772'),
('country_Northern_Mariana_Islands_159', 'state_Tinian_2773'),
('country_Norway_160', 'state___stfold_fylke_2774'),
('country_Norway_160', 'state_Akershus_fylke_2775'),
('country_Norway_160', 'state_Oslo_fylke_2776'),
('country_Norway_160', 'state_Hedmark_fylke_2777'),
('country_Norway_160', 'state_Oppland_fylke_2778'),
('country_Norway_160', 'state_Buskerud_fylke_2779'),
('country_Norway_160', 'state_Vestfold_fylke_2780'),
('country_Norway_160', 'state_Telemark_fylke_2781'),
('country_Norway_160', 'state_Aust_Agder_fylke_2782'),
('country_Norway_160', 'state_Vest_Agder_fylke_2783'),
('country_Norway_160', 'state_Rogaland_fylke_2784'),
('country_Norway_160', 'state_Hordaland_fylke_2785'),
('country_Norway_160', 'state_Sogn_og_Fjordane_fylke_2786'),
('country_Norway_160', 'state_M__re_og_Romsdal_fylke_2787'),
('country_Norway_160', 'state_S__r_Tr__ndelag_fylke_2788'),
('country_Norway_160', 'state_Nord_Tr__ndelag_fylke_2789'),
('country_Norway_160', 'state_Nordland_fylke_2790'),
('country_Norway_160', 'state_Troms_fylke_2791'),
('country_Norway_160', 'state_Finnmark_fylke_2792'),
('country_Oman_161', 'state________________2793'),
('country_Oman_161', 'state__________________2794'),
('country_Oman_161', 'state__________2795'),
('country_Oman_161', 'state__________2796'),
('country_Oman_161', 'state____________2797'),
('country_Oman_161', 'state________________2798'),
('country_Oman_161', 'state______________2799'),
('country_Oman_161', 'state________________2800'),
('country_Pakistan_162', 'state__________________2801'),
('country_Pakistan_162', 'state_________________________________2802'),
('country_Pakistan_162', 'state_____________________2803'),
('country_Pakistan_162', 'state______________________________2804'),
('country_Pakistan_162', 'state_________________________________________2805'),
('country_Pakistan_162', 'state____________2806'),
('country_Pakistan_162', 'state__________2807'),
('country_Pakistan_162', 'state___________________________________________2808'),
('country_Palau_163', 'state_Aimeliik_2809'),
('country_Palau_163', 'state_Airai_2810'),
('country_Palau_163', 'state_Angaur_2811'),
('country_Palau_163', 'state_Hatohobei_2812'),
('country_Palau_163', 'state_Kayangel_2813'),
('country_Palau_163', 'state_Koror_2814'),
('country_Palau_163', 'state_Melekeok_2815'),
('country_Palau_163', 'state_Ngaraard_2816'),
('country_Palau_163', 'state_Ngarchelong_2817'),
('country_Palau_163', 'state_Ngardmau_2818'),
('country_Palau_163', 'state_Ngatpang_2819'),
('country_Palau_163', 'state_Ngchesar_2820'),
('country_Palau_163', 'state_Ngeremlengui_2821'),
('country_Palau_163', 'state_Ngiwal_2822'),
('country_Palau_163', 'state_Peleliu_2823'),
('country_Palau_163', 'state_Sonsorol_2824'),
('country_Panama_164', 'state_Bocas_del_Toro_2825'),
('country_Panama_164', 'state_Cocl___2826'),
('country_Panama_164', 'state_Col__n_2827'),
('country_Panama_164', 'state_Chiriqu___2828'),
('country_Panama_164', 'state_Dari__n_2829'),
('country_Panama_164', 'state_Herrera_2830'),
('country_Panama_164', 'state_Los_Santos_2831'),
('country_Panama_164', 'state_Panam___2832'),
('country_Panama_164', 'state_Veraguas_2833'),
('country_Panama_164', 'state_Panam_Oeste_4570'),
('country_Panama_164', 'state_Ember__4577'),
('country_Panama_164', 'state_Kuna_Yala_2834'),
('country_Panama_164', 'state_ng_be_bugl__4578'),
('country_Panama_164', 'state_Naso_Tjr_Di_4591'),
('country_Papua_New_Guinea_165', 'state_Chimbu_2835'),
('country_Papua_New_Guinea_165', 'state_Central_2836'),
('country_Papua_New_Guinea_165', 'state_East_New_Britain_2837'),
('country_Papua_New_Guinea_165', 'state_Eastern_Highlands_2838'),
('country_Papua_New_Guinea_165', 'state_Enga_2839'),
('country_Papua_New_Guinea_165', 'state_East_Sepik_2840'),
('country_Papua_New_Guinea_165', 'state_Gulf_2841'),
('country_Papua_New_Guinea_165', 'state_Milne_Bay_2842'),
('country_Papua_New_Guinea_165', 'state_Morobe_2843'),
('country_Papua_New_Guinea_165', 'state_Madang_2844'),
('country_Papua_New_Guinea_165', 'state_Manus_2845'),
('country_Papua_New_Guinea_165', 'state_National_Capital_District_2846'),
('country_Papua_New_Guinea_165', 'state_New_Ireland_2847'),
('country_Papua_New_Guinea_165', 'state_Northern_2848'),
('country_Papua_New_Guinea_165', 'state_North_Solomons_2849'),
('country_Papua_New_Guinea_165', 'state_Sandaun_2850'),
('country_Papua_New_Guinea_165', 'state_Southern_Highlands_2851'),
('country_Papua_New_Guinea_165', 'state_West_New_Britain_2852'),
('country_Papua_New_Guinea_165', 'state_Western_Highlands_2853'),
('country_Papua_New_Guinea_165', 'state_Western_2854'),
('country_Paraguay_166', 'state_Concepci__n_2855'),
('country_Paraguay_166', 'state_San_Pedro_2856'),
('country_Paraguay_166', 'state_Cordillera_2857'),
('country_Paraguay_166', 'state_Guair___2858'),
('country_Paraguay_166', 'state_Caaguaz___2859'),
('country_Paraguay_166', 'state_Caazap___2860'),
('country_Paraguay_166', 'state_Itap__a_2861'),
('country_Paraguay_166', 'state_Misiones_2862'),
('country_Paraguay_166', 'state_Paraguar___2863'),
('country_Paraguay_166', 'state_Alto_Paran___2864'),
('country_Paraguay_166', 'state_Central_2865'),
('country_Paraguay_166', 'state___eembuc___2866'),
('country_Paraguay_166', 'state_Amambay_2867'),
('country_Paraguay_166', 'state_Canindey___2868'),
('country_Paraguay_166', 'state_Presidente_Hayes_2869'),
('country_Paraguay_166', 'state_Alto_Paraguay_2870'),
('country_Paraguay_166', 'state_Boquer__n_2871'),
('country_Paraguay_166', 'state_Asunci__n_2872'),
('country_Peru_167', 'state_Ancash_2874'),
('country_Peru_167', 'state_Apur__mac_2875'),
('country_Peru_167', 'state_Arequipa_2876'),
('country_Peru_167', 'state_Ayacucho_2877'),
('country_Peru_167', 'state_Cajamarca_2878'),
('country_Peru_167', 'state_Callao_2879'),
('country_Peru_167', 'state_Cuzco_2880'),
('country_Peru_167', 'state_Hu__nuco_2881'),
('country_Peru_167', 'state_Huancavelica_2882'),
('country_Peru_167', 'state_Ica_2883'),
('country_Peru_167', 'state_Jun__n_2884'),
('country_Peru_167', 'state_La_Libertad_2885'),
('country_Peru_167', 'state_Lambayeque_2886'),
('country_Peru_167', 'state_Lima_2887'),
('country_Peru_167', 'state_Loreto_2888'),
('country_Peru_167', 'state_Madre_de_Dios_2889'),
('country_Peru_167', 'state_Moquegua_2890'),
('country_Peru_167', 'state_Pasco_2891'),
('country_Peru_167', 'state_Piura_2892'),
('country_Peru_167', 'state_Puno_2893'),
('country_Peru_167', 'state_San_Mart__n_2894'),
('country_Peru_167', 'state_Tacna_2895'),
('country_Peru_167', 'state_Tumbes_2896'),
('country_Peru_167', 'state_Ucayali_2897'),
('country_Philippines_168', 'state_Abra_2898'),
('country_Philippines_168', 'state_Agusan_del_Norte_2899'),
('country_Philippines_168', 'state_Agusan_del_Sur_2900'),
('country_Philippines_168', 'state_Aklan_2901'),
('country_Philippines_168', 'state_Albay_2902'),
('country_Philippines_168', 'state_Antique_2903'),
('country_Philippines_168', 'state_Apayao_2904'),
('country_Philippines_168', 'state_Aurora_2905'),
('country_Philippines_168', 'state_Basilan_2907'),
('country_Philippines_168', 'state_Bataan_2906'),
('country_Philippines_168', 'state_Batangas_2911'),
('country_Philippines_168', 'state_Batanes_2912'),
('country_Philippines_168', 'state_Benguet_2908'),
('country_Philippines_168', 'state_Biliran_2909'),
('country_Philippines_168', 'state_Bohol_2910'),
('country_Philippines_168', 'state_Bukidnon_2913'),
('country_Philippines_168', 'state_Bulacan_2914'),
('country_Philippines_168', 'state_Cagayan_2915'),
('country_Philippines_168', 'state_Camarines_Norte_2917'),
('country_Philippines_168', 'state_Camarines_Sur_2919'),
('country_Philippines_168', 'state_Camiguin_2916'),
('country_Philippines_168', 'state_Capiz_2918'),
('country_Philippines_168', 'state_Catanduanes_2920'),
('country_Philippines_168', 'state_Cavite_2921'),
('country_Philippines_168', 'state_Cebu_2922'),
('country_Philippines_168', 'state_Compostela_Valley_2923'),
('country_Philippines_168', 'state_Cotabato_2948'),
('country_Philippines_168', 'state_Davao_del_Sur_2925'),
('country_Philippines_168', 'state_Davao_del_Norte_2926'),
('country_Philippines_168', 'state_Davao_Oriental_2924'),
('country_Philippines_168', 'state_Eastern_Samar_2927'),
('country_Philippines_168', 'state_Guimaras_2928'),
('country_Philippines_168', 'state_Ifugao_2929'),
('country_Philippines_168', 'state_Ilocos_Norte_2931'),
('country_Philippines_168', 'state_Ilocos_Sur_2932'),
('country_Philippines_168', 'state_Iloilo_2930'),
('country_Philippines_168', 'state_Isabela_2933'),
('country_Philippines_168', 'state_Kalinga_2934'),
('country_Philippines_168', 'state_La_Union_2939'),
('country_Philippines_168', 'state_Laguna_2935'),
('country_Philippines_168', 'state_Lanao_del_Norte_2936'),
('country_Philippines_168', 'state_Lanao_del_Sur_2937'),
('country_Philippines_168', 'state_Leyte_2938'),
('country_Philippines_168', 'state_Maguindanao_2941'),
('country_Philippines_168', 'state_Marinduque_2940'),
('country_Philippines_168', 'state_Masbate_2942'),
('country_Philippines_168', 'state_Metro_Manila_4572'),
('country_Philippines_168', 'state_Mindoro_Occidental_2943'),
('country_Philippines_168', 'state_Mindoro_Oriental_2944'),
('country_Philippines_168', 'state_Misamis_Occidental_2946'),
('country_Philippines_168', 'state_Misamis_Oriental_2947'),
('country_Philippines_168', 'state_Negros_Occidental_2950'),
('country_Philippines_168', 'state_Negros_Oriental_2951'),
('country_Philippines_168', 'state_Northern_Samar_2949'),
('country_Philippines_168', 'state_Mountain_Province_2945'),
('country_Philippines_168', 'state_Nueva_Ecija_2952'),
('country_Philippines_168', 'state_Nueva_Vizcaya_2953'),
('country_Philippines_168', 'state_Palawan_2956'),
('country_Philippines_168', 'state_Pampanga_2954'),
('country_Philippines_168', 'state_Pangasinan_2955'),
('country_Philippines_168', 'state_Quezon_2957'),
('country_Philippines_168', 'state_Quirino_2958'),
('country_Philippines_168', 'state_Rizal_2959'),
('country_Philippines_168', 'state_Romblon_2960'),
('country_Philippines_168', 'state_Samar_2972'),
('country_Philippines_168', 'state_Sarangani_2961'),
('country_Philippines_168', 'state_Siquijor_2963'),
('country_Philippines_168', 'state_Sorsogon_2966'),
('country_Philippines_168', 'state_South_Cotabato_2962'),
('country_Philippines_168', 'state_Southern_Leyte_2964'),
('country_Philippines_168', 'state_Sultan_Kudarat_2967'),
('country_Philippines_168', 'state_Sulu_2965'),
('country_Philippines_168', 'state_Surigao_del_Norte_2968'),
('country_Philippines_168', 'state_Surigao_del_Sur_2969'),
('country_Philippines_168', 'state_Tarlac_2970'),
('country_Philippines_168', 'state_Tawi_Tawi_2971'),
('country_Philippines_168', 'state_Zambales_2975'),
('country_Philippines_168', 'state_Zamboanga_del_Norte_2973'),
('country_Philippines_168', 'state_Zamboanga_del_Sur_2974'),
('country_Philippines_168', 'state_Zamboanga_Sibugay_2976'),
('country_Poland_170', 'state_Dolno__l__skie_2977'),
('country_Poland_170', 'state_Kujawsko_Pomorskie_2978'),
('country_Poland_170', 'state_Lubelskie_2979'),
('country_Poland_170', 'state_Lubuskie_2980'),
('country_Poland_170', 'state_____dzkie_2981'),
('country_Poland_170', 'state_Ma__opolskie_2982'),
('country_Poland_170', 'state_Mazowieckie_2983'),
('country_Poland_170', 'state_Opolskie_2984'),
('country_Poland_170', 'state_Podkarpackie_2985'),
('country_Poland_170', 'state_Podlaskie_2986'),
('country_Poland_170', 'state_Pomorskie_2987'),
('country_Poland_170', 'state___l__skie_2988'),
('country_Poland_170', 'state___wi__tokrzyskie_2989'),
('country_Poland_170', 'state_Warmi__sko_Mazurskie_2990'),
('country_Poland_170', 'state_Wielkopolskie_2991'),
('country_Poland_170', 'state_Zachodniopomorskie_2992'),
('country_Portugal_171', 'state_Aveiro_2993'),
('country_Portugal_171', 'state_Beja_2994'),
('country_Portugal_171', 'state_Braga_2995'),
('country_Portugal_171', 'state_Bragan__a_2996'),
('country_Portugal_171', 'state_Castelo_Branco_2997'),
('country_Portugal_171', 'state_Coimbra_2998'),
('country_Portugal_171', 'state___vora_2999'),
('country_Portugal_171', 'state_Faro_3000'),
('country_Portugal_171', 'state_Guarda_3001'),
('country_Portugal_171', 'state_Leiria_3002'),
('country_Portugal_171', 'state_Lisboa_3003'),
('country_Portugal_171', 'state_Portalegre_3004'),
('country_Portugal_171', 'state_Porto_3005'),
('country_Portugal_171', 'state_Santar__m_3006'),
('country_Portugal_171', 'state_Set__bal_3007'),
('country_Portugal_171', 'state_Viana_do_Castelo_3008'),
('country_Portugal_171', 'state_Vila_Real_3009'),
('country_Portugal_171', 'state_Viseu_3010'),
('country_Portugal_171', 'state_Regi__o_Aut__noma_dos_A__ores_3011'),
('country_Portugal_171', 'state_Regi__o_Aut__noma_da_Madeira_3012'),
('country_Qatar_173', 'state______________3013'),
('country_Qatar_173', 'state__________________3014'),
('country_Qatar_173', 'state___________________________3015'),
('country_Qatar_173', 'state__________________3016'),
('country_Qatar_173', 'state____________3017'),
('country_Qatar_173', 'state______________3018'),
('country_Qatar_173', 'state______________3019'),
('country_Qatar_173', 'state______________3020'),
('country_Qatar_173', 'state_______________3021'),
('country_Qatar_173', 'state______________3022'),
('country_Romania_175', 'state_Alba_3023'),
('country_Romania_175', 'state_Arge___3024'),
('country_Romania_175', 'state_Arad_3025'),
('country_Romania_175', 'state_Bucure__ti_3026'),
('country_Romania_175', 'state_Bac__u_3027'),
('country_Romania_175', 'state_Bihor_3028'),
('country_Romania_175', 'state_Bistri__a_N__s__ud_3029'),
('country_Romania_175', 'state_Br__ila_3030'),
('country_Romania_175', 'state_Boto__ani_3031'),
('country_Romania_175', 'state_Bra__ov_3032'),
('country_Romania_175', 'state_Buz__u_3033'),
('country_Romania_175', 'state_Cluj_3034'),
('country_Romania_175', 'state_C__l__ra__i_3035'),
('country_Romania_175', 'state_Cara___Severin_3036'),
('country_Romania_175', 'state_Constan__a_3037'),
('country_Romania_175', 'state_Covasna_3038'),
('country_Romania_175', 'state_D__mbovi__a_3039'),
('country_Romania_175', 'state_Dolj_3040'),
('country_Romania_175', 'state_Gorj_3041'),
('country_Romania_175', 'state_Gala__i_3042'),
('country_Romania_175', 'state_Giurgiu_3043'),
('country_Romania_175', 'state_Hunedoara_3044'),
('country_Romania_175', 'state_Harghita_3045'),
('country_Romania_175', 'state_Ilfov_3046'),
('country_Romania_175', 'state_Ialomi__a_3047'),
('country_Romania_175', 'state_Ia__i_3048'),
('country_Romania_175', 'state_Mehedin__i_3049'),
('country_Romania_175', 'state_Maramure___3050'),
('country_Romania_175', 'state_Mure___3051'),
('country_Romania_175', 'state_Neam___3052'),
('country_Romania_175', 'state_Olt_3053'),
('country_Romania_175', 'state_Prahova_3054'),
('country_Romania_175', 'state_Sibiu_3055'),
('country_Romania_175', 'state_S__laj_3056'),
('country_Romania_175', 'state_Satu_Mare_3057'),
('country_Romania_175', 'state_Suceava_3058'),
('country_Romania_175', 'state_Tulcea_3059'),
('country_Romania_175', 'state_Timi___3060'),
('country_Romania_175', 'state_Teleorman_3061'),
('country_Romania_175', 'state_V__lcea_3062'),
('country_Romania_175', 'state_Vrancea_3063'),
('country_Romania_175', 'state_Vaslui_3064'),
('country_Russia_176', 'state_______________________________________3065'),
('country_Russia_176', 'state_____________________________________3067'),
('country_Russia_176', 'state_______________________________3068'),
('country_Russia_176', 'state_____________________________________3069'),
('country_Russia_176', 'state_______________________________________________3070'),
('country_Russia_176', 'state_____________________________________________3071'),
('country_Russia_176', 'state___________________________________________________3072'),
('country_Russia_176', 'state_____________________________________________3073'),
('country_Russia_176', 'state_____________________________________3074'),
('country_Russia_176', 'state_________________________________________3075'),
('country_Russia_176', 'state_____________________________________________3076'),
('country_Russia_176', 'state___________________________________________3077'),
('country_Russia_176', 'state__________________________________________________________3079'),
('country_Russia_176', 'state_____________________________________________3080'),
('country_Russia_176', 'state___________________________________________3081'),
('country_Russia_176', 'state_____________________________________________3083'),
('country_Russia_176', 'state_______________________________________3084'),
('country_Russia_176', 'state_________________________________________3085'),
('country_Russia_176', 'state_________________________________________3086'),
('country_Russia_176', 'state____________________________________________________________________3087'),
('country_Russia_176', 'state____________________________________________________________________3088'),
('country_Russia_176', 'state_______________________________________3089'),
('country_Russia_176', 'state___________________________________________3090'),
('country_Russia_176', 'state___________________________________________________3091'),
('country_Russia_176', 'state_________________________________________3092'),
('country_Russia_176', 'state___________________________________3093'),
('country_Russia_176', 'state______________________________________________________________________________________3094'),
('country_Russia_176', 'state_____________________________________3095'),
('country_Russia_176', 'state_______________________________________3096'),
('country_Russia_176', 'state__________________3097'),
('country_Russia_176', 'state___________________________________________3098'),
('country_Russia_176', 'state_______________________________________3099'),
('country_Russia_176', 'state___________________________________3100'),
('country_Russia_176', 'state___________________________________________3102'),
('country_Russia_176', 'state_________________________________________3103'),
('country_Russia_176', 'state___________________________________3104'),
('country_Russia_176', 'state_______________________________________________3105'),
('country_Russia_176', 'state_____________________________________3106'),
('country_Russia_176', 'state___________________________________________3107'),
('country_Russia_176', 'state__________________________________________3108'),
('country_Russia_176', 'state___________________________________________3109'),
('country_Russia_176', 'state_________________________________________3110'),
('country_Russia_176', 'state________________3111'),
('country_Russia_176', 'state_________________________________________3112'),
('country_Russia_176', 'state________________________________________________________3113'),
('country_Russia_176', 'state_____________________________________________3114'),
('country_Russia_176', 'state_______________________________________________3115'),
('country_Russia_176', 'state_______________________________________________3116'),
('country_Russia_176', 'state_________________________________3117'),
('country_Russia_176', 'state_____________________________________________3118'),
('country_Russia_176', 'state_______________________________________3119'),
('country_Russia_176', 'state_________________________________________3120'),
('country_Russia_176', 'state_________________________________3121'),
('country_Russia_176', 'state_______________________________________3122'),
('country_Russia_176', 'state_________________________________________3123'),
('country_Russia_176', 'state_______________________________________3124'),
('country_Russia_176', 'state____________________________________________________3125'),
('country_Russia_176', 'state___________________________________________3126'),
('country_Russia_176', 'state_______________________________________3127'),
('country_Russia_176', 'state___________________________________________3128'),
('country_Russia_176', 'state___________________________________________________________________________3129'),
('country_Russia_176', 'state_________________________________________3130'),
('country_Russia_176', 'state_________________________________3131'),
('country_Russia_176', 'state_________________________________________3132'),
('country_Russia_176', 'state_____________________________________________3133'),
('country_Russia_176', 'state_____________________________________________3134'),
('country_Russia_176', 'state_________________________________________3135'),
('country_Russia_176', 'state___________________________________3137'),
('country_Russia_176', 'state_____________________________________3138'),
('country_Russia_176', 'state_____________________________________3139'),
('country_Russia_176', 'state___________________________________3140'),
('country_Russia_176', 'state_______________________________________3141'),
('country_Russia_176', 'state_______________________________________________3142'),
('country_Russia_176', 'state___________________________________________3143'),
('country_Russia_176', 'state_______________________________________________3145'),
('country_Russia_176', 'state_____________________________________________3146'),
('country_Russia_176', 'state___________________________________________3147'),
('country_Russia_176', 'state___________________________________________3148'),
('country_Russia_176', 'state_____________________________3149'),
('country_Russia_176', 'state_____________________________________________________________________3150'),
('country_Russia_176', 'state___________________________________________3151'),
('country_Russia_176', 'state______________________________________________________________3152'),
('country_Russia_176', 'state_____________________________4571'),
('country_Rwanda_177', 'state_Nord_3153'),
('country_Rwanda_177', 'state_Est_3154'),
('country_Rwanda_177', 'state_Sud_3155'),
('country_Rwanda_177', 'state_Ouest_3156'),
('country_Rwanda_177', 'state_Kigali_3157'),
('country_Saint_Kitts_and_Nevis_178', 'state_Saint_Kitts_3158'),
('country_Saint_Kitts_and_Nevis_178', 'state_Nevis_3159'),
('country_Saint_Lucia_179', 'state_Anse_la_Raye_3160'),
('country_Saint_Lucia_179', 'state_Castries_3161'),
('country_Saint_Lucia_179', 'state_Choiseul_3162'),
('country_Saint_Lucia_179', 'state_Dauphin_3163'),
('country_Saint_Lucia_179', 'state_Dennery_3164'),
('country_Saint_Lucia_179', 'state_Gros_Islet_3165'),
('country_Saint_Lucia_179', 'state_Laborie_3166'),
('country_Saint_Lucia_179', 'state_Micoud_3167'),
('country_Saint_Lucia_179', 'state_Praslin_3168'),
('country_Saint_Lucia_179', 'state_Soufriere_3169'),
('country_Saint_Lucia_179', 'state_Vieux_Fort_3170'),
('country_Saint_Vincent_and_the_Grenadines_180', 'state_Charlotte_3171'),
('country_Saint_Vincent_and_the_Grenadines_180', 'state_Grenadines_3172'),
('country_Samoa_181', 'state_A_ana_3177'),
('country_Samoa_181', 'state_Aiga_i_le_Tai_3178'),
('country_Samoa_181', 'state_Atua_3179'),
('country_Samoa_181', 'state_Fa_asaleleaga_3180'),
('country_Samoa_181', 'state_Gaga_emauga_3181'),
('country_Samoa_181', 'state_Gaga_ifomauga_3182'),
('country_Samoa_181', 'state_Palauli_3183'),
('country_Samoa_181', 'state_Satupa_itea_3184'),
('country_Samoa_181', 'state_Tuamasaga_3185'),
('country_Samoa_181', 'state_Va_a_o_Fonoti_3186'),
('country_Samoa_181', 'state_Vaisigano_3187'),
('country_San_Marino_182', 'state_Acquaviva_3188'),
('country_San_Marino_182', 'state_Borgo_Maggiore_3189'),
('country_San_Marino_182', 'state_Chiesanuova_3190'),
('country_San_Marino_182', 'state_Domagnano_3191'),
('country_San_Marino_182', 'state_Faetano_3192'),
('country_San_Marino_182', 'state_Fiorentino_3193'),
('country_San_Marino_182', 'state_Montegiardino_3194'),
('country_San_Marino_182', 'state_Citta_di_San_Marino_3195'),
('country_San_Marino_182', 'state_Serravalle_3196'),
('country_Sao_Tome_and_Principe_183', 'state_Pr__ncipe_3197'),
('country_Sao_Tome_and_Principe_183', 'state_S__o_Tom___3198'),
('country_Saudi_Arabia_184', 'state______________3199'),
('country_Saudi_Arabia_184', 'state_______________________3200'),
('country_Saudi_Arabia_184', 'state________________3201'),
('country_Saudi_Arabia_184', 'state________________3202'),
('country_Saudi_Arabia_184', 'state______________3203'),
('country_Saudi_Arabia_184', 'state__________3204'),
('country_Saudi_Arabia_184', 'state__________3205'),
('country_Saudi_Arabia_184', 'state_______________________________3206'),
('country_Saudi_Arabia_184', 'state____________3207'),
('country_Saudi_Arabia_184', 'state____________3208'),
('country_Saudi_Arabia_184', 'state______________3209'),
('country_Saudi_Arabia_184', 'state____________3210'),
('country_Saudi_Arabia_184', 'state__________3211'),
('country_Senegal_185', 'state_Dakar_3212'),
('country_Senegal_185', 'state_Diourbel_3213'),
('country_Senegal_185', 'state_Fatick_3214'),
('country_Senegal_185', 'state_Kaolack_3215'),
('country_Senegal_185', 'state_Kolda_3216'),
('country_Senegal_185', 'state_Louga_3217'),
('country_Senegal_185', 'state_Matam_3218'),
('country_Senegal_185', 'state_Saint_Louis_3219'),
('country_Senegal_185', 'state_Tambacounda_3220'),
('country_Senegal_185', 'state_Thies__3221'),
('country_Senegal_185', 'state_Ziguinchor_3222'),
('country_Seychelles_186', 'state_Anse_aux_Pins_3223'),
('country_Seychelles_186', 'state_Anse_Boileau_3224'),
('country_Seychelles_186', 'state_Anse_Etoile_3225'),
('country_Seychelles_186', 'state_Anse_Louis_3226'),
('country_Seychelles_186', 'state_Anse_Royale_3227'),
('country_Seychelles_186', 'state_Baie_Lazare_3228'),
('country_Seychelles_186', 'state_Baie_Sainte_Anne_3229'),
('country_Seychelles_186', 'state_Beau_Vallon_3230'),
('country_Seychelles_186', 'state_Bel_Air_3231'),
('country_Seychelles_186', 'state_Bel_Ombre_3232'),
('country_Seychelles_186', 'state_Cascade_3233'),
('country_Seychelles_186', 'state_Glacis_3234'),
('country_Seychelles_186', 'state_Grand__Anse__on_Mahe__3235'),
('country_Seychelles_186', 'state_Grand__Anse__on_Praslin__3236'),
('country_Seychelles_186', 'state_La_Digue_3237'),
('country_Seychelles_186', 'state_La_Riviere_Anglaise_3238'),
('country_Seychelles_186', 'state_Mont_Buxton_3239'),
('country_Seychelles_186', 'state_Mont_Fleuri_3240'),
('country_Seychelles_186', 'state_Plaisance_3241'),
('country_Seychelles_186', 'state_Pointe_La_Rue_3242'),
('country_Seychelles_186', 'state_Port_Glaud_3243'),
('country_Seychelles_186', 'state_Saint_Louis_3244'),
('country_Seychelles_186', 'state_Takamaka_3245'),
('country_Sierra_Leone_187', 'state_Eastern_3246'),
('country_Slovakia_189', 'state_Banskobystrick___kraj_3250'),
('country_Slovakia_189', 'state_Bratislavsk___kraj_3251'),
('country_Slovakia_189', 'state_Ko__ick___kraj_3252'),
('country_Slovakia_189', 'state_Nitriansk___kraj_3253')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Slovakia_189', 'state_Pre__ovsk___kraj_3254'),
('country_Slovakia_189', 'state_Trnavsk___kraj_3255'),
('country_Slovakia_189', 'state_Tren__iansk___kraj_3256'),
('country_Slovakia_189', 'state___ilinsk___kraj_3257'),
('country_Slovenia_190', 'state_Ajdov____ina_3258'),
('country_Slovenia_190', 'state_Beltinci_3259'),
('country_Slovenia_190', 'state_Bled_3260'),
('country_Slovenia_190', 'state_Bohinj_3261'),
('country_Slovenia_190', 'state_Borovnica_3262'),
('country_Slovenia_190', 'state_Bovec_3263'),
('country_Slovenia_190', 'state_Brda_3264'),
('country_Slovenia_190', 'state_Brezovica_3265'),
('country_Slovenia_190', 'state_Bre__ice_3266'),
('country_Slovenia_190', 'state_Ti__ina_3267'),
('country_Slovenia_190', 'state_Celje_3268'),
('country_Slovenia_190', 'state_Cerklje_na_Gorenjskem_3269'),
('country_Slovenia_190', 'state_Cerknica_3270'),
('country_Slovenia_190', 'state_Cerkno_3271'),
('country_Slovenia_190', 'state___ren__ovci_3272'),
('country_Slovenia_190', 'state___rna_na_Koro__kem_3273'),
('country_Slovenia_190', 'state___rnomelj_3274'),
('country_Slovenia_190', 'state_Destrnik_3275'),
('country_Slovenia_190', 'state_Diva__a_3276'),
('country_Slovenia_190', 'state_Dobrepolje_3277'),
('country_Slovenia_190', 'state_Dobrova_Polhov_Gradec_3278'),
('country_Slovenia_190', 'state_Dol_pri_Ljubljani_3279'),
('country_Slovenia_190', 'state_Dom__ale_3280'),
('country_Slovenia_190', 'state_Dornava_3281'),
('country_Slovenia_190', 'state_Dravograd_3282'),
('country_Slovenia_190', 'state_Duplek_3283'),
('country_Slovenia_190', 'state_Gorenja_vas_Poljane_3284'),
('country_Slovenia_190', 'state_Gori__nica_3285'),
('country_Slovenia_190', 'state_Gornja_Radgona_3286'),
('country_Slovenia_190', 'state_Gornji_Grad_3287'),
('country_Slovenia_190', 'state_Gornji_Petrovci_3288'),
('country_Slovenia_190', 'state_Grosuplje_3289'),
('country_Slovenia_190', 'state___alovci_3290'),
('country_Slovenia_190', 'state_Hrastnik_3291'),
('country_Slovenia_190', 'state_Hrpelje_Kozina_3292'),
('country_Slovenia_190', 'state_Idrija_3293'),
('country_Slovenia_190', 'state_Ig_3294'),
('country_Slovenia_190', 'state_Ilirska_Bistrica_3295'),
('country_Slovenia_190', 'state_Ivan__na_Gorica_3296'),
('country_Slovenia_190', 'state_Izola_3297'),
('country_Slovenia_190', 'state_Jesenice_3298'),
('country_Slovenia_190', 'state_Jur__inci_3299'),
('country_Slovenia_190', 'state_Kamnik_3300'),
('country_Slovenia_190', 'state_Kanal_ob_So__i_3301'),
('country_Slovenia_190', 'state_Kidri__evo_3302'),
('country_Slovenia_190', 'state_Kobarid_3303'),
('country_Slovenia_190', 'state_Kobilje_3304'),
('country_Slovenia_190', 'state_Ko__evje_3305'),
('country_Slovenia_190', 'state_Komen_3306'),
('country_Slovenia_190', 'state_Koper_3307'),
('country_Slovenia_190', 'state_Kozje_3308'),
('country_Slovenia_190', 'state_Kranj_3309'),
('country_Slovenia_190', 'state_Kranjska_Gora_3310'),
('country_Slovenia_190', 'state_Kr__ko_3311'),
('country_Slovenia_190', 'state_Kungota_3312'),
('country_Slovenia_190', 'state_Kuzma_3313'),
('country_Slovenia_190', 'state_La__ko_3314'),
('country_Slovenia_190', 'state_Lenart_3315'),
('country_Slovenia_190', 'state_Lendava_3316'),
('country_Slovenia_190', 'state_Litija_3317'),
('country_Slovenia_190', 'state_Ljubljana_3318'),
('country_Slovenia_190', 'state_Ljubno_3319'),
('country_Slovenia_190', 'state_Ljutomer_3320'),
('country_Slovenia_190', 'state_Logatec_3321'),
('country_Slovenia_190', 'state_Lo__ka_Dolina_3322'),
('country_Slovenia_190', 'state_Lo__ki_Potok_3323'),
('country_Slovenia_190', 'state_Lu__e_3324'),
('country_Slovenia_190', 'state_Lukovica_3325'),
('country_Slovenia_190', 'state_Maj__perk_3326'),
('country_Slovenia_190', 'state_Maribor_3327'),
('country_Slovenia_190', 'state_Medvode_3328'),
('country_Slovenia_190', 'state_Menge___3329'),
('country_Slovenia_190', 'state_Metlika_3330'),
('country_Slovenia_190', 'state_Me__ica_3331'),
('country_Slovenia_190', 'state_Miren_Kostanjevica_3332'),
('country_Slovenia_190', 'state_Mislinja_3333'),
('country_Slovenia_190', 'state_Morav__e_3334'),
('country_Slovenia_190', 'state_Moravske_Toplice_3335'),
('country_Slovenia_190', 'state_Mozirje_3336'),
('country_Slovenia_190', 'state_Murska_Sobota_3337'),
('country_Slovenia_190', 'state_Muta_3338'),
('country_Slovenia_190', 'state_Naklo_3339'),
('country_Slovenia_190', 'state_Nazarje_3340'),
('country_Slovenia_190', 'state_Nova_Gorica_3341'),
('country_Slovenia_190', 'state_Novo_mesto_3342'),
('country_Slovenia_190', 'state_Odranci_3343'),
('country_Slovenia_190', 'state_Ormo___3344'),
('country_Slovenia_190', 'state_Osilnica_3345'),
('country_Slovenia_190', 'state_Pesnica_3346'),
('country_Slovenia_190', 'state_Piran_3347'),
('country_Slovenia_190', 'state_Pivka_3348'),
('country_Slovenia_190', 'state_Pod__etrtek_3349'),
('country_Slovenia_190', 'state_Podvelka_3350'),
('country_Slovenia_190', 'state_Postojna_3351'),
('country_Slovenia_190', 'state_Preddvor_3352'),
('country_Slovenia_190', 'state_Ptuj_3353'),
('country_Slovenia_190', 'state_Puconci_3354'),
('country_Slovenia_190', 'state_Ra__e_Fram_3355'),
('country_Slovenia_190', 'state_Rade__e_3356'),
('country_Slovenia_190', 'state_Radenci_3357'),
('country_Slovenia_190', 'state_Radlje_ob_Dravi_3358'),
('country_Slovenia_190', 'state_Radovljica_3359'),
('country_Slovenia_190', 'state_Ravne_na_Koro__kem_3360'),
('country_Slovenia_190', 'state_Ribnica_3361'),
('country_Slovenia_190', 'state_Roga__ka_Slatina_3362'),
('country_Slovenia_190', 'state_Roga__ovci_3363'),
('country_Slovenia_190', 'state_Rogatec_3364'),
('country_Slovenia_190', 'state_Ru__e_3365'),
('country_Slovenia_190', 'state_Semi___3366'),
('country_Slovenia_190', 'state_Sevnica_3367'),
('country_Slovenia_190', 'state_Se__ana_3368'),
('country_Slovenia_190', 'state_Slovenj_Gradec_3369'),
('country_Slovenia_190', 'state_Slovenska_Bistrica_3370'),
('country_Slovenia_190', 'state_Slovenske_Konjice_3371'),
('country_Slovenia_190', 'state_Star__e_3372'),
('country_Slovenia_190', 'state_Sveti_Jurij_3373'),
('country_Slovenia_190', 'state___en__ur_3374'),
('country_Slovenia_190', 'state___entilj_3375'),
('country_Slovenia_190', 'state___entjernej_3376'),
('country_Slovenia_190', 'state___entjur_pri_Celju_3377'),
('country_Slovenia_190', 'state___kocjan_3378'),
('country_Slovenia_190', 'state___kofja_Loka_3379'),
('country_Slovenia_190', 'state___kofljica_3380'),
('country_Slovenia_190', 'state___marje_pri_Jel__ah_3381'),
('country_Slovenia_190', 'state___martno_ob_Paki_3382'),
('country_Slovenia_190', 'state___o__tanj_3383'),
('country_Slovenia_190', 'state___tore_3384'),
('country_Slovenia_190', 'state_Tolmin_3385'),
('country_Slovenia_190', 'state_Trbovlje_3386'),
('country_Slovenia_190', 'state_Trebnje_3387'),
('country_Slovenia_190', 'state_Tr__i___3388'),
('country_Slovenia_190', 'state_Turni____e_3389'),
('country_Slovenia_190', 'state_Velenje_3390'),
('country_Slovenia_190', 'state_Velike_La____e_3391'),
('country_Slovenia_190', 'state_Videm_3392'),
('country_Slovenia_190', 'state_Vipava_3393'),
('country_Slovenia_190', 'state_Vitanje_3394'),
('country_Slovenia_190', 'state_Vodice_3395'),
('country_Slovenia_190', 'state_Vojnik_3396'),
('country_Slovenia_190', 'state_Vrhnika_3397'),
('country_Slovenia_190', 'state_Vuzenica_3398'),
('country_Slovenia_190', 'state_Zagorje_ob_Savi_3399'),
('country_Slovenia_190', 'state_Zavr___3400'),
('country_Slovenia_190', 'state_Zre__e_3401'),
('country_Slovenia_190', 'state___elezniki_3402'),
('country_Slovenia_190', 'state___iri_3403'),
('country_Slovenia_190', 'state_Benedikt_3404'),
('country_Slovenia_190', 'state_Bistrica_ob_Sotli_3405'),
('country_Slovenia_190', 'state_Bloke_3406'),
('country_Slovenia_190', 'state_Braslov__e_3407'),
('country_Slovenia_190', 'state_Cankova_3408'),
('country_Slovenia_190', 'state_Cerkvenjak_3409'),
('country_Slovenia_190', 'state_Dobje_3410'),
('country_Slovenia_190', 'state_Dobrna_3411'),
('country_Slovenia_190', 'state_Dobrovnik_3412'),
('country_Slovenia_190', 'state_Dolenjske_Toplice_3413'),
('country_Slovenia_190', 'state_Grad_3414'),
('country_Slovenia_190', 'state_Hajdina_3415'),
('country_Slovenia_190', 'state_Ho__e_Slivnica_3416'),
('country_Slovenia_190', 'state_Hodo___3417'),
('country_Slovenia_190', 'state_Horjul_3418'),
('country_Slovenia_190', 'state_Jezersko_3419'),
('country_Slovenia_190', 'state_Komenda_3420'),
('country_Slovenia_190', 'state_Kostel_3421'),
('country_Slovenia_190', 'state_Kri__evci_3422'),
('country_Slovenia_190', 'state_Lovrenc_na_Pohorju_3423'),
('country_Slovenia_190', 'state_Markovci_3424'),
('country_Slovenia_190', 'state_Miklav___na_Dravskem_polju_3425'),
('country_Slovenia_190', 'state_Mirna_Pe___3426'),
('country_Slovenia_190', 'state_Oplotnica_3427'),
('country_Slovenia_190', 'state_Podlehnik_3428'),
('country_Slovenia_190', 'state_Polzela_3429'),
('country_Slovenia_190', 'state_Prebold_3430'),
('country_Slovenia_190', 'state_Prevalje_3431'),
('country_Slovenia_190', 'state_Razkri__je_3432'),
('country_Slovenia_190', 'state_Ribnica_na_Pohorju_3433'),
('country_Slovenia_190', 'state_Selnica_ob_Dravi_3434'),
('country_Slovenia_190', 'state_Sodra__ica_3435'),
('country_Slovenia_190', 'state_Sol__ava_3436'),
('country_Slovenia_190', 'state_Sveta_Ana_3437'),
('country_Slovenia_190', 'state_Sveti_Andra___v_Slovenskih_goricah_3438'),
('country_Slovenia_190', 'state___empeter_Vrtojba_3439'),
('country_Slovenia_190', 'state_Tabor_3440'),
('country_Slovenia_190', 'state_Trnovska_vas_3441'),
('country_Slovenia_190', 'state_Trzin_3442'),
('country_Slovenia_190', 'state_Velika_Polana_3443'),
('country_Slovenia_190', 'state_Ver__ej_3444'),
('country_Slovenia_190', 'state_Vransko_3445'),
('country_Slovenia_190', 'state___alec_3446'),
('country_Slovenia_190', 'state___etale_3447'),
('country_Slovenia_190', 'state___irovnica_3448'),
('country_Slovenia_190', 'state___u__emberk_3449'),
('country_Slovenia_190', 'state___martno_pri_Litiji_3450'),
('country_Solomon_Islands_191', 'state_Guadalcanal_3453'),
('country_Solomon_Islands_191', 'state_Honiara_3454'),
('country_Solomon_Islands_191', 'state_Isabel_3455'),
('country_Solomon_Islands_191', 'state_Makira_3456'),
('country_Solomon_Islands_191', 'state_Malaita_3457'),
('country_Solomon_Islands_191', 'state_Rennell_and_Bellona_3458'),
('country_Solomon_Islands_191', 'state_Temotu_3459'),
('country_Somalia_192', 'state_Awdal_3461'),
('country_Somalia_192', 'state_Bakool_3462'),
('country_Somalia_192', 'state_Banaadir_3463'),
('country_Somalia_192', 'state_Bari_3464'),
('country_Somalia_192', 'state_Bay_3465'),
('country_Somalia_192', 'state_Gedo_3466'),
('country_Somalia_192', 'state_Galguduud_3467'),
('country_Somalia_192', 'state_Hiiraan_3468'),
('country_Somalia_192', 'state_Jubbada_Dhexe_3469'),
('country_Somalia_192', 'state_Jubbada_Hoose_3470'),
('country_Somalia_192', 'state_Mudug_3471'),
('country_Somalia_192', 'state_Nugaal_3472'),
('country_Somalia_192', 'state_Shabeellaha_Dhexe_3473'),
('country_Somalia_192', 'state_Sanaag_3474'),
('country_Somalia_192', 'state_Shabeellaha_Hoose_3475'),
('country_Somalia_192', 'state_Sool_3476'),
('country_Somalia_192', 'state_Togdheer_3477'),
('country_Somalia_192', 'state_Woqooyi_Galbeed_3478'),
('country_South_Africa_193', 'state_Eastern_Cape_3479'),
('country_South_Africa_193', 'state_Free_State_3480'),
('country_South_Africa_193', 'state_Gauteng_3481'),
('country_South_Africa_193', 'state_Limpopo_3482'),
('country_South_Africa_193', 'state_Mpumalanga_3483'),
('country_South_Africa_193', 'state_Northern_Cape_3484'),
('country_South_Africa_193', 'state_KwaZulu_Natal_3485'),
('country_South_Africa_193', 'state_Western_Cape_3487'),
('country_South_Africa_193', 'state_North_West_4556'),
('country_Spain_195', 'state_Granada_4504'),
('country_Spain_195', 'state_Le__n_4505'),
('country_Spain_195', 'state_Alicante_3490'),
('country_Spain_195', 'state_Albacete_3491'),
('country_Spain_195', 'state_Almer__a_3492'),
('country_Spain_195', 'state___vila_3494'),
('country_Spain_195', 'state_Barcelona_3495'),
('country_Spain_195', 'state_Badajoz_3496'),
('country_Spain_195', 'state_Vizcaya_3497'),
('country_Spain_195', 'state_Burgos_3498'),
('country_Spain_195', 'state_A_Coru__a_3499'),
('country_Spain_195', 'state_C__diz_3500'),
('country_Spain_195', 'state_C__ceres_3501'),
('country_Spain_195', 'state_Ceuta_3502'),
('country_Spain_195', 'state_C__rdoba_3506'),
('country_Spain_195', 'state_Ciudad_Real_3507'),
('country_Spain_195', 'state_Castell__n_3508'),
('country_Spain_195', 'state_Cuenca_3510'),
('country_Spain_195', 'state_Las_Palmas_3513'),
('country_Spain_195', 'state_Girona_3514'),
('country_Spain_195', 'state_Guadalajara_3516'),
('country_Spain_195', 'state_Huelva_3517'),
('country_Spain_195', 'state_Huesca_3518'),
('country_Spain_195', 'state_Ja__n_3520'),
('country_Spain_195', 'state_Lleida_3521'),
('country_Spain_195', 'state_La_Rioja_3523'),
('country_Spain_195', 'state_Lugo_3524'),
('country_Spain_195', 'state_Madrid_3525'),
('country_Spain_195', 'state_M__laga_3526'),
('country_Spain_195', 'state_Melilla_3527'),
('country_Spain_195', 'state_Murcia_3528'),
('country_Spain_195', 'state_Navarre_3529'),
('country_Spain_195', 'state_Asturias_3530'),
('country_Spain_195', 'state_Ourense_3531'),
('country_Spain_195', 'state_Palencia_3532'),
('country_Spain_195', 'state_Baleares_3533'),
('country_Spain_195', 'state_Pontevedra_3534'),
('country_Spain_195', 'state_Cantabria_3536'),
('country_Spain_195', 'state_Salamanca_3537'),
('country_Spain_195', 'state_Seville_3538'),
('country_Spain_195', 'state_Segovia_3539'),
('country_Spain_195', 'state_Soria_3540'),
('country_Spain_195', 'state_Guip__zcoa_3541'),
('country_Spain_195', 'state_Tarragona_3542'),
('country_Spain_195', 'state_Teruel_3543'),
('country_Spain_195', 'state_Santa_Cruz_De_Tenerife_3544'),
('country_Spain_195', 'state_Toledo_3545'),
('country_Spain_195', 'state_Valencia_3546'),
('country_Spain_195', 'state_Valladolid_3547'),
('country_Spain_195', 'state___lava_3548'),
('country_Spain_195', 'state_Zaragoza_3549'),
('country_Spain_195', 'state_Zamora_3550'),
('country_Sri_Lanka_196', 'state_North_Central_3552'),
('country_Sri_Lanka_196', 'state_North_3553'),
('country_Sri_Lanka_196', 'state_North_Western_3555'),
('country_Sri_Lanka_196', 'state_Uva_3557'),
('country_Sri_Lanka_196', 'state_Sabaragamuwa_3558'),
('country_Sudan_199', 'state_______________________3560'),
('country_Sudan_199', 'state_________________________3561'),
('country_Sudan_199', 'state__________________3562'),
('country_Sudan_199', 'state___________________________3563'),
('country_Sudan_199', 'state________________3564'),
('country_Sudan_199', 'state________________3565'),
('country_Sudan_199', 'state______________3566'),
('country_Sudan_199', 'state_________________________3567'),
('country_Sudan_199', 'state_________________________3568'),
('country_Sudan_199', 'state__________________3569'),
('country_Sudan_199', 'state___________________________________3570'),
('country_Sudan_199', 'state_____________________________3571'),
('country_Sudan_199', 'state____________________________3572'),
('country_Sudan_199', 'state_____________________3573'),
('country_Sudan_199', 'state_____________________3574'),
('country_Sudan_199', 'state_______________________3575'),
('country_Sudan_199', 'state_______________________3576'),
('country_Sudan_199', 'state______________3577'),
('country_Sudan_199', 'state__________3578'),
('country_Sudan_199', 'state______________________________3579'),
('country_Sudan_199', 'state______________________________3580'),
('country_Sudan_199', 'state_______________________3581'),
('country_Sudan_199', 'state_______________________3582'),
('country_Sudan_199', 'state_____________________________3583'),
('country_Sudan_199', 'state__________3584'),
('country_Sudan_199', 'state____________3585'),
('country_Suriname_200', 'state_Brokopondo_3586'),
('country_Suriname_200', 'state_Commewijne_3587'),
('country_Suriname_200', 'state_Coronie_3588'),
('country_Suriname_200', 'state_Marowijne_3589'),
('country_Suriname_200', 'state_Nickerie_3590'),
('country_Suriname_200', 'state_Paramaribo_3591'),
('country_Suriname_200', 'state_Para_3592'),
('country_Suriname_200', 'state_Saramacca_3593'),
('country_Suriname_200', 'state_Sipaliwini_3594'),
('country_Suriname_200', 'state_Wanica_3595'),
('country_Swaziland_202', 'state_Hhohho_3596'),
('country_Swaziland_202', 'state_Lubombo_3597'),
('country_Swaziland_202', 'state_Manzini_3598'),
('country_Swaziland_202', 'state_Shiselweni_3599'),
('country_Sweden_203', 'state_Stockholms_l__n_3600'),
('country_Sweden_203', 'state_Uppsala_l__n_3601'),
('country_Sweden_203', 'state_S__dermanlands_l__n_3602'),
('country_Sweden_203', 'state___sterg__tlands_l__n_3603'),
('country_Sweden_203', 'state_J__nk__pings_l__n_3604'),
('country_Sweden_203', 'state_Kronobergs_l__n_3605'),
('country_Sweden_203', 'state_Kalmar_l__n_3606'),
('country_Sweden_203', 'state_Gotlands_l__n_3607'),
('country_Sweden_203', 'state_Blekinge_l__n_3608'),
('country_Sweden_203', 'state_Sk__ne_l__n_3609'),
('country_Sweden_203', 'state_Hallands_l__n_3610'),
('country_Sweden_203', 'state_V__stra_G__talands_l__n_3611'),
('country_Sweden_203', 'state_V__rmlands_l__n__3612'),
('country_Sweden_203', 'state___rebro_l__n_3613'),
('country_Sweden_203', 'state_V__stmanlands_l__n__3614'),
('country_Sweden_203', 'state_Dalarnas_l__n_3615'),
('country_Sweden_203', 'state_G__vleborgs_l__n_3616'),
('country_Sweden_203', 'state_V__sternorrlands_l__n_3617'),
('country_Sweden_203', 'state_J__mtlands_l__n_3618'),
('country_Sweden_203', 'state_V__sterbottens_l__n_3619'),
('country_Sweden_203', 'state_Norrbottens_l__n_3620'),
('country_Switzerland_204', 'state_Z__rich_3621'),
('country_Switzerland_204', 'state_Bern_3622'),
('country_Switzerland_204', 'state_Luzern_3623'),
('country_Switzerland_204', 'state_Uri_3624'),
('country_Switzerland_204', 'state_Schwyz_3625'),
('country_Switzerland_204', 'state_Obwalden_3626'),
('country_Switzerland_204', 'state_Nidwalden_3627'),
('country_Switzerland_204', 'state_Glasrus_3628'),
('country_Switzerland_204', 'state_Zug_3629'),
('country_Switzerland_204', 'state_Fribourg_3630'),
('country_Switzerland_204', 'state_Solothurn_3631'),
('country_Switzerland_204', 'state_Basel_Stadt_3632'),
('country_Switzerland_204', 'state_Basel_Landschaft_3633'),
('country_Switzerland_204', 'state_Schaffhausen_3634'),
('country_Switzerland_204', 'state_Appenzell_Ausserrhoden_3635'),
('country_Switzerland_204', 'state_Appenzell_Innerrhoden_3636'),
('country_Switzerland_204', 'state_Saint_Gallen_3637'),
('country_Switzerland_204', 'state_Graub__nden_3638'),
('country_Switzerland_204', 'state_Aargau_3639'),
('country_Switzerland_204', 'state_Thurgau_3640'),
('country_Switzerland_204', 'state_Ticino_3641'),
('country_Switzerland_204', 'state_Vaud_3642'),
('country_Switzerland_204', 'state_Valais_3643'),
('country_Switzerland_204', 'state_Nuech__tel_3644'),
('country_Switzerland_204', 'state_Gen__ve_3645'),
('country_Switzerland_204', 'state_Jura_3646'),
('country_Syrian_Arab_Republic_205', 'state__________3647'),
('country_Syrian_Arab_Republic_205', 'state__________3648'),
('country_Syrian_Arab_Republic_205', 'state___________________3649'),
('country_Syrian_Arab_Republic_205', 'state______________3650'),
('country_Syrian_Arab_Republic_205', 'state________3651'),
('country_Syrian_Arab_Republic_205', 'state________3652'),
('country_Syrian_Arab_Republic_205', 'state__________3653'),
('country_Syrian_Arab_Republic_205', 'state__________3654'),
('country_Syrian_Arab_Republic_205', 'state__________________3655'),
('country_Syrian_Arab_Republic_205', 'state__________________3656'),
('country_Syrian_Arab_Republic_205', 'state____________3657'),
('country_Syrian_Arab_Republic_205', 'state_________________3658'),
('country_Syrian_Arab_Republic_205', 'state__________________3659'),
('country_Syrian_Arab_Republic_205', 'state____________3660'),
('country_Taiwan_206', 'state___________3661'),
('country_Taiwan_206', 'state___________3662'),
('country_Taiwan_206', 'state___________3663'),
('country_Taiwan_206', 'state___________3664'),
('country_Taiwan_206', 'state___________3665'),
('country_Taiwan_206', 'state___________3666'),
('country_Taiwan_206', 'state___________3667'),
('country_Taiwan_206', 'state___________3668'),
('country_Taiwan_206', 'state___________3669'),
('country_Taiwan_206', 'state___________3670'),
('country_Taiwan_206', 'state___________3671'),
('country_Taiwan_206', 'state___________3672'),
('country_Taiwan_206', 'state___________3673'),
('country_Taiwan_206', 'state___________3674'),
('country_Taiwan_206', 'state___________3675'),
('country_Taiwan_206', 'state___________3676'),
('country_Taiwan_206', 'state___________3677'),
('country_Taiwan_206', 'state___________3678'),
('country_Taiwan_206', 'state___________3679'),
('country_Taiwan_206', 'state___________3680'),
('country_Taiwan_206', 'state___________3681'),
('country_Taiwan_206', 'state___________3682'),
('country_Taiwan_206', 'state___________3683'),
('country_Tajikistan_207', 'state_____________________________3684'),
('country_Tajikistan_207', 'state____________3685'),
('country_Tajikistan_207', 'state________3686'),
('country_Tanzania_208', 'state_Arusha_3687'),
('country_Tanzania_208', 'state_Dar_es_Salaam_3688'),
('country_Tanzania_208', 'state_Dodoma_3689'),
('country_Tanzania_208', 'state_Iringa_3690'),
('country_Tanzania_208', 'state_Kagera_3691'),
('country_Tanzania_208', 'state_Pemba_Sever_3692'),
('country_Tanzania_208', 'state_Zanzibar_Sever_3693'),
('country_Tanzania_208', 'state_Kigoma_3694'),
('country_Tanzania_208', 'state_Kilimanjaro_3695'),
('country_Tanzania_208', 'state_Pemba_Jih_3696'),
('country_Tanzania_208', 'state_Zanzibar_Jih_3697'),
('country_Tanzania_208', 'state_Lindi_3698'),
('country_Tanzania_208', 'state_Mara_3699'),
('country_Tanzania_208', 'state_Mbeya_3700'),
('country_Tanzania_208', 'state_Zanzibar_Z__pad_3701'),
('country_Tanzania_208', 'state_Morogoro_3702'),
('country_Tanzania_208', 'state_Mtwara_3703'),
('country_Tanzania_208', 'state_Mwanza_3704'),
('country_Tanzania_208', 'state_Pwani_3705'),
('country_Tanzania_208', 'state_Rukwa_3706'),
('country_Tanzania_208', 'state_Ruvuma_3707'),
('country_Tanzania_208', 'state_Shinyanga_3708'),
('country_Tanzania_208', 'state_Singida_3709'),
('country_Tanzania_208', 'state_Tabora_3710'),
('country_Tanzania_208', 'state_Tanga_3711'),
('country_Tanzania_208', 'state_Manyara_3712'),
('country_Thailand_209', 'state_________________________________________3713'),
('country_Thailand_209', 'state___________________________________3714'),
('country_Thailand_209', 'state_______________________3715'),
('country_Thailand_209', 'state__________________________3716'),
('country_Thailand_209', 'state_______________________________________________3717'),
('country_Thailand_209', 'state_______________________3718'),
('country_Thailand_209', 'state____________________3719'),
('country_Thailand_209', 'state_____________________________3720'),
('country_Thailand_209', 'state____________________3721'),
('country_Thailand_209', 'state_______________________3722'),
('country_Thailand_209', 'state____________________3723'),
('country_Thailand_209', 'state_________________3724'),
('country_Thailand_209', 'state__________________________3725'),
('country_Thailand_209', 'state______________3726'),
('country_Thailand_209', 'state________________________________3727'),
('country_Thailand_209', 'state________________________________3728'),
('country_Thailand_209', 'state_______________________3729'),
('country_Thailand_209', 'state_______________________3730'),
('country_Thailand_209', 'state________________________________3731'),
('country_Thailand_209', 'state_____________________________3732'),
('country_Thailand_209', 'state__________________________3733'),
('country_Thailand_209', 'state__________________________3734'),
('country_Thailand_209', 'state___________________________________3735'),
('country_Thailand_209', 'state_________________3736'),
('country_Thailand_209', 'state_______________________3737'),
('country_Thailand_209', 'state________________________________3738'),
('country_Thailand_209', 'state___________________________________3739'),
('country_Thailand_209', 'state_______________________3740'),
('country_Thailand_209', 'state__________________________3741'),
('country_Thailand_209', 'state___________3742'),
('country_Thailand_209', 'state_______________________3743'),
('country_Thailand_209', 'state_____________________________3744'),
('country_Thailand_209', 'state__________________________3745'),
('country_Thailand_209', 'state_____________________________3746'),
('country_Thailand_209', 'state____________________3747'),
('country_Thailand_209', 'state____________________3748'),
('country_Thailand_209', 'state__________________________3749'),
('country_Thailand_209', 'state_____________________________3750'),
('country_Thailand_209', 'state_________________3751'),
('country_Thailand_209', 'state_________________3752'),
('country_Thailand_209', 'state_____________________________3753'),
('country_Thailand_209', 'state______________3754'),
('country_Thailand_209', 'state_________________3755'),
('country_Thailand_209', 'state__________________________3756'),
('country_Thailand_209', 'state________________________________3757'),
('country_Thailand_209', 'state_____________________________3758'),
('country_Thailand_209', 'state_____________________________3759'),
('country_Thailand_209', 'state_____________________________3760'),
('country_Thailand_209', 'state___________3761')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_Thailand_209', 'state_______________________3762'),
('country_Thailand_209', 'state_________________3763'),
('country_Thailand_209', 'state____________________3764'),
('country_Thailand_209', 'state_______________________3765'),
('country_Thailand_209', 'state_____________________________3766'),
('country_Thailand_209', 'state________________________________3767'),
('country_Thailand_209', 'state____________________3768'),
('country_Thailand_209', 'state_____________________________3769'),
('country_Thailand_209', 'state___________________________________3770'),
('country_Thailand_209', 'state__________________________3771'),
('country_Thailand_209', 'state_______________________________________________3772'),
('country_Thailand_209', 'state_________________________________________3773'),
('country_Thailand_209', 'state____________________3774'),
('country_Thailand_209', 'state_________________3775'),
('country_Thailand_209', 'state____________________3776'),
('country_Thailand_209', 'state______________________________________3777'),
('country_Thailand_209', 'state_________________3778'),
('country_Thailand_209', 'state_________________3779'),
('country_Thailand_209', 'state_________________3780'),
('country_Thailand_209', 'state______________3781'),
('country_Thailand_209', 'state______________3782'),
('country_Thailand_209', 'state____________________3783'),
('country_Thailand_209', 'state_______________________3784'),
('country_Thailand_209', 'state______________3785'),
('country_Thailand_209', 'state__________________________3786'),
('country_Togo_210', 'state_Centrale_3787'),
('country_Togo_210', 'state_Kara_3788'),
('country_Togo_210', 'state_Maritime_3789'),
('country_Togo_210', 'state_Plateaux_3790'),
('country_Togo_210', 'state_Savanes_3791'),
('country_Tokelau_211', 'state_Atafu_3792'),
('country_Tokelau_211', 'state_Fakaofo_3793'),
('country_Tokelau_211', 'state_Nukunonu_3794'),
('country_Tonga_212', 'state_Ha_apai_3795'),
('country_Tonga_212', 'state_Tongatapu_3796'),
('country_Tonga_212', 'state_Vava_u_3797'),
('country_Trinidad_and_Tobago_213', 'state_Arima_3798'),
('country_Trinidad_and_Tobago_213', 'state_Chaguanas_3799'),
('country_Trinidad_and_Tobago_213', 'state_Couva_Tabaquite_Talparo_3800'),
('country_Trinidad_and_Tobago_213', 'state_Diego_Martin_3801'),
('country_Trinidad_and_Tobago_213', 'state_Eastern_Tobago_3802'),
('country_Trinidad_and_Tobago_213', 'state_Rio_Claro_Mayaro_3803'),
('country_Trinidad_and_Tobago_213', 'state_Penal_Debe_3804'),
('country_Trinidad_and_Tobago_213', 'state_Point_Fortin_3805'),
('country_Trinidad_and_Tobago_213', 'state_Port_of_Spain_3806'),
('country_Trinidad_and_Tobago_213', 'state_Princes_Town_3807'),
('country_Trinidad_and_Tobago_213', 'state_San_Fernando_3808'),
('country_Trinidad_and_Tobago_213', 'state_Sangre_Grande_3809'),
('country_Trinidad_and_Tobago_213', 'state_San_Juan_Laventille_3810'),
('country_Trinidad_and_Tobago_213', 'state_Siparia_3811'),
('country_Trinidad_and_Tobago_213', 'state_Tunapuna_Piarco_3812'),
('country_Trinidad_and_Tobago_213', 'state_Western_Tobago_3813'),
('country_Tunisia_214', 'state_____________________3814'),
('country_Tunisia_214', 'state_________________________3815'),
('country_Tunisia_214', 'state__________________________3816'),
('country_Tunisia_214', 'state_______________________3817'),
('country_Tunisia_214', 'state_____________________3818'),
('country_Tunisia_214', 'state_______________________3819'),
('country_Tunisia_214', 'state_______________________3820'),
('country_Tunisia_214', 'state_____________________3821'),
('country_Tunisia_214', 'state_________________________3822'),
('country_Tunisia_214', 'state_______________________3823'),
('country_Tunisia_214', 'state_________________________3824'),
('country_Tunisia_214', 'state_____________________________3825'),
('country_Tunisia_214', 'state___________________________3826'),
('country_Tunisia_214', 'state________________________________3827'),
('country_Tunisia_214', 'state_____________________3828'),
('country_Tunisia_214', 'state_____________________________3829'),
('country_Tunisia_214', 'state___________________________3830'),
('country_Tunisia_214', 'state_______________________3831'),
('country_Tunisia_214', 'state_____________________3832'),
('country_Tunisia_214', 'state_____________________3833'),
('country_Tunisia_214', 'state_____________________3834'),
('country_Tunisia_214', 'state_____________________3835'),
('country_Tunisia_214', 'state_______________________3836'),
('country_Tunisia_214', 'state_________________________3837'),
('country_Turkey_215', 'state_Adana_3838'),
('country_Turkey_215', 'state_Ad__yaman_3839'),
('country_Turkey_215', 'state_Afyonkarahisar_3840'),
('country_Turkey_215', 'state_A__r___3841'),
('country_Turkey_215', 'state_Amasya_3842'),
('country_Turkey_215', 'state_Ankara_3843'),
('country_Turkey_215', 'state_Antalya_3844'),
('country_Turkey_215', 'state_Artvin_3845'),
('country_Turkey_215', 'state_Ayd__n_3846'),
('country_Turkey_215', 'state_Bal__kesir_3847'),
('country_Turkey_215', 'state_Bilecik_3848'),
('country_Turkey_215', 'state_Bing__l_3849'),
('country_Turkey_215', 'state_Bitlis_3850'),
('country_Turkey_215', 'state_Bolu_3851'),
('country_Turkey_215', 'state_Burdur_3852'),
('country_Turkey_215', 'state_Bursa_3853'),
('country_Turkey_215', 'state___anakkale_3854'),
('country_Turkey_215', 'state___ank__r___3855'),
('country_Turkey_215', 'state___orum_3856'),
('country_Turkey_215', 'state_Denizli_3857'),
('country_Turkey_215', 'state_Diyarbak__r_3858'),
('country_Turkey_215', 'state_Edirne_3859'),
('country_Turkey_215', 'state_Elaz_____3860'),
('country_Turkey_215', 'state_Erzincan_3861'),
('country_Turkey_215', 'state_Erzurum_3862'),
('country_Turkey_215', 'state_Eski__ehir_3863'),
('country_Turkey_215', 'state_Gaziantep_3864'),
('country_Turkey_215', 'state_Giresun_3865'),
('country_Turkey_215', 'state_G__m____hane_3866'),
('country_Turkey_215', 'state_Hakkari_3867'),
('country_Turkey_215', 'state_Hatay_3868'),
('country_Turkey_215', 'state_Isparta_3869'),
('country_Turkey_215', 'state_Mersin_3870'),
('country_Turkey_215', 'state___stanbul_3871'),
('country_Turkey_215', 'state___zmir_3872'),
('country_Turkey_215', 'state_Kars_3873'),
('country_Turkey_215', 'state_Kastamonu_3874'),
('country_Turkey_215', 'state_Kayseri_3875'),
('country_Turkey_215', 'state_K__rklareli_3876'),
('country_Turkey_215', 'state_K__r__ehir_3877'),
('country_Turkey_215', 'state_Kocaeli_3878'),
('country_Turkey_215', 'state_Konya_3879'),
('country_Turkey_215', 'state_K__tahya_3880'),
('country_Turkey_215', 'state_Malatya_3881'),
('country_Turkey_215', 'state_Manisa_3882'),
('country_Turkey_215', 'state_Kahramanmara___3883'),
('country_Turkey_215', 'state_Mardin_3884'),
('country_Turkey_215', 'state_Mu__la_3885'),
('country_Turkey_215', 'state_Mu___3886'),
('country_Turkey_215', 'state_Nev__ehir_3887'),
('country_Turkey_215', 'state_Ni__de_3888'),
('country_Turkey_215', 'state_Ordu_3889'),
('country_Turkey_215', 'state_Rize_3890'),
('country_Turkey_215', 'state_Sakarya_3891'),
('country_Turkey_215', 'state_Samsun_3892'),
('country_Turkey_215', 'state_Siirt_3893'),
('country_Turkey_215', 'state_Sinop_3894'),
('country_Turkey_215', 'state_Sivas_3895'),
('country_Turkey_215', 'state_Tekirda___3896'),
('country_Turkey_215', 'state_Tokat_3897'),
('country_Turkey_215', 'state_Trabzon_3898'),
('country_Turkey_215', 'state_Tunceli_3899'),
('country_Turkey_215', 'state___anl__urfa_3900'),
('country_Turkey_215', 'state_U__ak_3901'),
('country_Turkey_215', 'state_Van_3902'),
('country_Turkey_215', 'state_Yozgat_3903'),
('country_Turkey_215', 'state_Zonguldak_3904'),
('country_Turkey_215', 'state_Aksaray_3905'),
('country_Turkey_215', 'state_Bayburt_3906'),
('country_Turkey_215', 'state_Karaman_3907'),
('country_Turkey_215', 'state_K__r__kkale_3908'),
('country_Turkey_215', 'state_Batman_3909'),
('country_Turkey_215', 'state_____rnak_3910'),
('country_Turkey_215', 'state_Bart__n_3911'),
('country_Turkey_215', 'state_Ardahan_3912'),
('country_Turkey_215', 'state_I__d__r_3913'),
('country_Turkey_215', 'state_Yalova_3914'),
('country_Turkey_215', 'state_Karab__k_3915'),
('country_Turkey_215', 'state_Kilis_3916'),
('country_Turkey_215', 'state_Osmaniye_3917'),
('country_Turkey_215', 'state_D__zce_3918'),
('country_Turkmenistan_216', 'state_Ahal_wela__aty_3919'),
('country_Turkmenistan_216', 'state_Balkan_wela__aty_3920'),
('country_Turkmenistan_216', 'state_Da__oguz_wela__aty_3921'),
('country_Turkmenistan_216', 'state_Lebap_wela__aty_3922'),
('country_Turkmenistan_216', 'state_Mary_wela__aty_3923'),
('country_Turks_and_Caicos_Islands_217', 'state_Ambergris_Cays_3924'),
('country_Turks_and_Caicos_Islands_217', 'state_Dellis_Cay_3925'),
('country_Turks_and_Caicos_Islands_217', 'state_French_Cay_3926'),
('country_Turks_and_Caicos_Islands_217', 'state_Little_Water_Cay_3927'),
('country_Turks_and_Caicos_Islands_217', 'state_Parrot_Cay_3928'),
('country_Turks_and_Caicos_Islands_217', 'state_Pine_Cay_3929'),
('country_Turks_and_Caicos_Islands_217', 'state_Salt_Cay_3930'),
('country_Turks_and_Caicos_Islands_217', 'state_Grand_Turk_3931'),
('country_Turks_and_Caicos_Islands_217', 'state_South_Caicos_3932'),
('country_Turks_and_Caicos_Islands_217', 'state_East_Caicos_3933'),
('country_Turks_and_Caicos_Islands_217', 'state_Middle_Caicos_3934'),
('country_Turks_and_Caicos_Islands_217', 'state_North_Caicos_3935'),
('country_Turks_and_Caicos_Islands_217', 'state_Providenciales_3936'),
('country_Turks_and_Caicos_Islands_217', 'state_West_Caicos_3937'),
('country_Tuvalu_218', 'state_Funafuti_3938'),
('country_Tuvalu_218', 'state_Nanumea_3939'),
('country_Tuvalu_218', 'state_Nanumanga_3940'),
('country_Tuvalu_218', 'state_Niutao_3941'),
('country_Tuvalu_218', 'state_Nui_3942'),
('country_Tuvalu_218', 'state_Nukufetau_3943'),
('country_Tuvalu_218', 'state_Nukulaelae_3944'),
('country_Tuvalu_218', 'state_Vaitupu_3945'),
('country_Uganda_219', 'state_Kalangala_3946'),
('country_Uganda_219', 'state_Kampala_3947'),
('country_Uganda_219', 'state_Kiboga_3948'),
('country_Uganda_219', 'state_Luwero_3949'),
('country_Uganda_219', 'state_Masaka_3950'),
('country_Uganda_219', 'state_Mpigi_3951'),
('country_Uganda_219', 'state_Mubende_3952'),
('country_Uganda_219', 'state_Mukono_3953'),
('country_Uganda_219', 'state_Nakasongola_3954'),
('country_Uganda_219', 'state_Rakai_3955'),
('country_Uganda_219', 'state_Sembabule_3956'),
('country_Uganda_219', 'state_Kayunga_3957'),
('country_Uganda_219', 'state_Wakiso_3958'),
('country_Uganda_219', 'state_Bugiri_3959'),
('country_Uganda_219', 'state_Busia_3960'),
('country_Uganda_219', 'state_Iganga_3961'),
('country_Uganda_219', 'state_Jinja_3962'),
('country_Uganda_219', 'state_Kamuli_3963'),
('country_Uganda_219', 'state_Kapchorwa_3964'),
('country_Uganda_219', 'state_Katakwi_3965'),
('country_Uganda_219', 'state_Kumi_3966'),
('country_Uganda_219', 'state_Mbale_3967'),
('country_Uganda_219', 'state_Pallisa_3968'),
('country_Uganda_219', 'state_Soroti_3969'),
('country_Uganda_219', 'state_Tororo_3970'),
('country_Uganda_219', 'state_Kaberamaido_3971'),
('country_Uganda_219', 'state_Mayuge_3972'),
('country_Uganda_219', 'state_Sironko_3973'),
('country_Uganda_219', 'state_Adjumani_3974'),
('country_Uganda_219', 'state_Apac_3975'),
('country_Uganda_219', 'state_Arua_3976'),
('country_Uganda_219', 'state_Gulu_3977'),
('country_Uganda_219', 'state_Kitgum_3978'),
('country_Uganda_219', 'state_Kotido_3979'),
('country_Uganda_219', 'state_Lira_3980'),
('country_Uganda_219', 'state_Moroto_3981'),
('country_Uganda_219', 'state_Moyo_3982'),
('country_Uganda_219', 'state_Nebbi_3983'),
('country_Uganda_219', 'state_Nakapiripirit_3984'),
('country_Uganda_219', 'state_Pader_3985'),
('country_Uganda_219', 'state_Yumbe_3986'),
('country_Uganda_219', 'state_Bundibugyo_3987'),
('country_Uganda_219', 'state_Bushenyi_3988'),
('country_Uganda_219', 'state_Hoima_3989'),
('country_Uganda_219', 'state_Kabale_3990'),
('country_Uganda_219', 'state_Kabarole_3991'),
('country_Uganda_219', 'state_Kasese_3992'),
('country_Uganda_219', 'state_Kibale_3993'),
('country_Uganda_219', 'state_Kisoro_3994'),
('country_Uganda_219', 'state_Masindi_3995'),
('country_Uganda_219', 'state_Mbarara_3996'),
('country_Uganda_219', 'state_Ntungamo_3997'),
('country_Uganda_219', 'state_Rukungiri_3998'),
('country_Uganda_219', 'state_Kamwenge_3999'),
('country_Uganda_219', 'state_Kanungu_4000'),
('country_Uganda_219', 'state_Kyenjojo_4001'),
('country_Ukraine_220', 'state___________________________________4002'),
('country_Ukraine_220', 'state___________________________________4003'),
('country_Ukraine_220', 'state___________________________________4004'),
('country_Ukraine_220', 'state_________________________________________________4005'),
('country_Ukraine_220', 'state_________________________________4006'),
('country_Ukraine_220', 'state_______________________________________4007'),
('country_Ukraine_220', 'state_____________________________________4008'),
('country_Ukraine_220', 'state_________________________________________4009'),
('country_Ukraine_220', 'state_____________________________________4010'),
('country_Ukraine_220', 'state__________________________________________________4011'),
('country_Ukraine_220', 'state__________4012'),
('country_Ukraine_220', 'state_________________________________4013'),
('country_Ukraine_220', 'state_____________________________________________4014'),
('country_Ukraine_220', 'state________________________4015'),
('country_Ukraine_220', 'state____________________________________________________4016'),
('country_Ukraine_220', 'state___________________________________4017'),
('country_Ukraine_220', 'state_________________________________________4018'),
('country_Ukraine_220', 'state_______________________________4019'),
('country_Ukraine_220', 'state_____________________________________4020'),
('country_Ukraine_220', 'state_______________________________4021'),
('country_Ukraine_220', 'state___________________________________________4022'),
('country_Ukraine_220', 'state_____________________________________4023'),
('country_Ukraine_220', 'state_____________________________________4024'),
('country_Ukraine_220', 'state_______________________________________4025'),
('country_Ukraine_220', 'state___________________________________4026'),
('country_Ukraine_220', 'state_________________________________________4027'),
('country_Ukraine_220', 'state_______________________________________4028'),
('country_United_Kingdom_222', 'state_Argyll_and_Bute_4031'),
('country_United_Kingdom_222', 'state_Bath_and_North_East_Somerset_4037'),
('country_United_Kingdom_222', 'state_Bedfordshire_4039'),
('country_United_Kingdom_222', 'state_Berkshire_4040'),
('country_United_Kingdom_222', 'state_Blaenau_Gwent_4045'),
('country_United_Kingdom_222', 'state_Borders_4055'),
('country_United_Kingdom_222', 'state_Bristol_4060'),
('country_United_Kingdom_222', 'state_Buckinghamshire_4061'),
('country_United_Kingdom_222', 'state_Cambridgeshire_4062'),
('country_United_Kingdom_222', 'state_Carmarthenshire_4074'),
('country_United_Kingdom_222', 'state_Ceredigion_4064'),
('country_United_Kingdom_222', 'state_Cheshire_4066'),
('country_United_Kingdom_222', 'state_Conwy_4080'),
('country_United_Kingdom_222', 'state_Cornwall_4075'),
('country_United_Kingdom_222', 'state_Antrim_4034'),
('country_United_Kingdom_222', 'state_Down_4091'),
('country_United_Kingdom_222', 'state_Durham_4094'),
('country_United_Kingdom_222', 'state_Fermanagh_4107'),
('country_United_Kingdom_222', 'state_Londonderry_4063'),
('country_United_Kingdom_222', 'state_Tyrone_4065'),
('country_United_Kingdom_222', 'state_Cumbria_4072'),
('country_United_Kingdom_222', 'state_Denbighshire_4083'),
('country_United_Kingdom_222', 'state_Derbyshire_4082'),
('country_United_Kingdom_222', 'state_Devon_4085'),
('country_United_Kingdom_222', 'state_Dorset_4090'),
('country_United_Kingdom_222', 'state_Dumbarton_4065'),
('country_United_Kingdom_222', 'state_Dumfries_and_Galloway_4087'),
('country_United_Kingdom_222', 'state_Dyfed_4093'),
('country_United_Kingdom_222', 'state_East_Ayrshire_4096'),
('country_United_Kingdom_222', 'state_East_Dunbartonshire_4098'),
('country_United_Kingdom_222', 'state_East_Renfrewshire_4102'),
('country_United_Kingdom_222', 'state_East_Riding_of_Yorkshire_4103'),
('country_United_Kingdom_222', 'state_East_Sussex_4105'),
('country_United_Kingdom_222', 'state_Edinburgh_4097'),
('country_United_Kingdom_222', 'state_Essex_4104'),
('country_United_Kingdom_222', 'state_Fife_4108'),
('country_United_Kingdom_222', 'state_Flintshire_4109'),
('country_United_Kingdom_222', 'state_Glamorgan_4068'),
('country_United_Kingdom_222', 'state_Glasgow_4111'),
('country_United_Kingdom_222', 'state_Gloucestershire_4112'),
('country_United_Kingdom_222', 'state_Grampian_4110'),
('country_United_Kingdom_222', 'state_Greater_Manchester_4113'),
('country_United_Kingdom_222', 'state_Gwent_4114'),
('country_United_Kingdom_222', 'state_Gwynedd_4115'),
('country_United_Kingdom_222', 'state_Hampshire_4117'),
('country_United_Kingdom_222', 'state_Herefordshire_4120'),
('country_United_Kingdom_222', 'state_Hertfordshire_4126'),
('country_United_Kingdom_222', 'state_Inverclyde_4132'),
('country_United_Kingdom_222', 'state_Isle_of_Wight_4130'),
('country_United_Kingdom_222', 'state_Kent_4135'),
('country_United_Kingdom_222', 'state_Lancashire_4140'),
('country_United_Kingdom_222', 'state_Leicestershire_4144'),
('country_United_Kingdom_222', 'state_Lincolnshire_4146'),
('country_United_Kingdom_222', 'state_London_4149'),
('country_United_Kingdom_222', 'state_Manchester_4153'),
('country_United_Kingdom_222', 'state_Middlesex_4069'),
('country_United_Kingdom_222', 'state_Merseyside_4070'),
('country_United_Kingdom_222', 'state_Norfolk_4169'),
('country_United_Kingdom_222', 'state_North_Ayrshire_4164'),
('country_United_Kingdom_222', 'state_North_Lanarkshire_4171'),
('country_United_Kingdom_222', 'state_North_West_Highlands_4071'),
('country_United_Kingdom_222', 'state_North_Yorkshire_4181'),
('country_United_Kingdom_222', 'state_Northamptonshire_4175'),
('country_United_Kingdom_222', 'state_Northumberland_4165'),
('country_United_Kingdom_222', 'state_Nottinghamshire_4177'),
('country_United_Kingdom_222', 'state_Oxfordshire_4186'),
('country_United_Kingdom_222', 'state_Pembrokeshire_4187'),
('country_United_Kingdom_222', 'state_Powys_4192'),
('country_United_Kingdom_222', 'state_Renfrewshire_4199'),
('country_United_Kingdom_222', 'state_Rhondda_Cynon_Taf_4196'),
('country_United_Kingdom_222', 'state_Shropshire_4211'),
('country_United_Kingdom_222', 'state_Somerset_4218'),
('country_United_Kingdom_222', 'state_South_Ayrshire_4204'),
('country_United_Kingdom_222', 'state_South_Gloucestershire_4208'),
('country_United_Kingdom_222', 'state_South_Lanarkshire_4215'),
('country_United_Kingdom_222', 'state_South_Yorkshire_4228'),
('country_United_Kingdom_222', 'state_Staffordshire_4226'),
('country_United_Kingdom_222', 'state_Suffolk_4206'),
('country_United_Kingdom_222', 'state_Surrey_4220'),
('country_United_Kingdom_222', 'state_Tayside_4235'),
('country_United_Kingdom_222', 'state_Torfaen_4236'),
('country_United_Kingdom_222', 'state_Tyne_and_Wear_4237'),
('country_United_Kingdom_222', 'state_Warwickshire_4240'),
('country_United_Kingdom_222', 'state_West_Lothian_4248'),
('country_United_Kingdom_222', 'state_West_Midlands_4073'),
('country_United_Kingdom_222', 'state_West_Sussex_4257'),
('country_United_Kingdom_222', 'state_West_Yorkshire_4076'),
('country_United_Kingdom_222', 'state_Wiltshire_4245'),
('country_United_Kingdom_222', 'state_Worcestershire_4252'),
('country_United_Kingdom_222', 'state_Aberdeenshire_4554'),
('country_United_Kingdom_222', 'state_Anglesey_4555'),
('country_United_Kingdom_222', 'state_Angus_4506'),
('country_United_Kingdom_222', 'state_Argyllshire_4507'),
('country_United_Kingdom_222', 'state_Ayrshire_4508'),
('country_United_Kingdom_222', 'state_Banffshire_4509'),
('country_United_Kingdom_222', 'state_Berwickshire_4510'),
('country_United_Kingdom_222', 'state_Brecknockshire_4511'),
('country_United_Kingdom_222', 'state_Buteshire_4512'),
('country_United_Kingdom_222', 'state_Caernarfonshire_4513'),
('country_United_Kingdom_222', 'state_Caithness_4514'),
('country_United_Kingdom_222', 'state_Cardiganshire_4515'),
('country_United_Kingdom_222', 'state_Channel_Isles_4516'),
('country_United_Kingdom_222', 'state_Clackmannanshire_4517'),
('country_United_Kingdom_222', 'state_County_Armagh_4518'),
('country_United_Kingdom_222', 'state_Cumberland_4519'),
('country_United_Kingdom_222', 'state_Dumfriesshire_4520'),
('country_United_Kingdom_222', 'state_Dunbartonshire_4521'),
('country_United_Kingdom_222', 'state_East_Lothian_4522'),
('country_United_Kingdom_222', 'state_Huntingdonshire_4523'),
('country_United_Kingdom_222', 'state_Inverness-shire_4524'),
('country_United_Kingdom_222', 'state_Isle_ of_Islay_4525'),
('country_United_Kingdom_222', 'state_Isle_of_Lewis_4526'),
('country_United_Kingdom_222', 'state_Isle_of_Man_4527'),
('country_United_Kingdom_222', 'state_Isle_of_Skye_4528'),
('country_United_Kingdom_222', 'state_Isles_of_Scilly_4529'),
('country_United_Kingdom_222', 'state_Kincardineshire_4530'),
('country_United_Kingdom_222', 'state_Kinross-Shire_4531'),
('country_United_Kingdom_222', 'state_Kirkcudbrightshire_4532'),
('country_United_Kingdom_222', 'state_Lanarkshire_4533'),
('country_United_Kingdom_222', 'state_Merioneth_4534'),
('country_United_Kingdom_222', 'state_Midlothian_4535'),
('country_United_Kingdom_222', 'state_Monmouthshire_4536'),
('country_United_Kingdom_222', 'state_Montgomeryshire_4537'),
('country_United_Kingdom_222', 'state_Morayshire_4538'),
('country_United_Kingdom_222', 'state_Nairnshire_4539'),
('country_United_Kingdom_222', 'state_Orkney_4540'),
('country_United_Kingdom_222', 'state_Peeblesshire_4541'),
('country_United_Kingdom_222', 'state_Perthshire_4542'),
('country_United_Kingdom_222', 'state_Radnorshire_4543'),
('country_United_Kingdom_222', 'state_Ross-shire_4544'),
('country_United_Kingdom_222', 'state_Roxburghshire_4545'),
('country_United_Kingdom_222', 'state_Rutland_4546'),
('country_United_Kingdom_222', 'state_Selkirkshire_4547'),
('country_United_Kingdom_222', 'state_Shetland_4548'),
('country_United_Kingdom_222', 'state_Stirlingshire_4549'),
('country_United_Kingdom_222', 'state_Sussex_4550'),
('country_United_Kingdom_222', 'state_Sutherland_4551'),
('country_United_Kingdom_222', 'state_Westmorland_4552'),
('country_United_Kingdom_222', 'state_Wigtownshire_4553')

INSERT IGNORE INTO `#__hikashop_zone_link` (`zone_parent_namekey`, `zone_child_namekey`) VALUES
('country_United_States_of_America_223', 'state_Alaska_4260'),
('country_United_States_of_America_223', 'state_Alabama_4261'),
('country_United_States_of_America_223', 'state_American_Samoa_4262'),
('country_United_States_of_America_223', 'state_Arkansas_4263'),
('country_United_States_of_America_223', 'state_Arizona_4264'),
('country_United_States_of_America_223', 'state_California_4265'),
('country_United_States_of_America_223', 'state_Colorado_4266'),
('country_United_States_of_America_223', 'state_Connecticut_4267'),
('country_United_States_of_America_223', 'state_District_of_Columbia_4268'),
('country_United_States_of_America_223', 'state_Delaware_4269'),
('country_United_States_of_America_223', 'state_Florida_4270'),
('country_United_States_of_America_223', 'state_Georgia_4271'),
('country_United_States_of_America_223', 'state_Guam_4272'),
('country_United_States_of_America_223', 'state_Hawaii_4273'),
('country_United_States_of_America_223', 'state_Iowa_4274'),
('country_United_States_of_America_223', 'state_Idaho_4275'),
('country_United_States_of_America_223', 'state_Illinois_4276'),
('country_United_States_of_America_223', 'state_Indiana_4277'),
('country_United_States_of_America_223', 'state_Kansas_4278'),
('country_United_States_of_America_223', 'state_Kentucky_4279'),
('country_United_States_of_America_223', 'state_Louisiana_4280'),
('country_United_States_of_America_223', 'state_Massachusetts_4281'),
('country_United_States_of_America_223', 'state_Maryland_4282'),
('country_United_States_of_America_223', 'state_Maine_4283'),
('country_United_States_of_America_223', 'state_Michigan_4284'),
('country_United_States_of_America_223', 'state_Minnesota_4285'),
('country_United_States_of_America_223', 'state_Missouri_4286'),
('country_United_States_of_America_223', 'state_Mississippi_4287'),
('country_United_States_of_America_223', 'state_Montana_4288'),
('country_United_States_of_America_223', 'state_North_Carolina_4289'),
('country_United_States_of_America_223', 'state_North_Dakota_4290'),
('country_United_States_of_America_223', 'state_Nebraska_4291'),
('country_United_States_of_America_223', 'state_New_Hampshire_4292'),
('country_United_States_of_America_223', 'state_New_Jersey_4293'),
('country_United_States_of_America_223', 'state_New_Mexico_4294'),
('country_United_States_of_America_223', 'state_Nevada_4295'),
('country_United_States_of_America_223', 'state_New_York_4296'),
('country_United_States_of_America_223', 'state_Northern_Mariana_Islands_4297'),
('country_United_States_of_America_223', 'state_Ohio_4298'),
('country_United_States_of_America_223', 'state_Oklahoma_4299'),
('country_United_States_of_America_223', 'state_Oregon_4300'),
('country_United_States_of_America_223', 'state_Pennsylvania_4301'),
('country_United_States_of_America_223', 'state_Puerto_Rico_4302'),
('country_United_States_of_America_223', 'state_Rhode_Island_4303'),
('country_United_States_of_America_223', 'state_South_Carolina_4304'),
('country_United_States_of_America_223', 'state_South_Dakota_4305'),
('country_United_States_of_America_223', 'state_Tennessee_4306'),
('country_United_States_of_America_223', 'state_Texas_4307'),
('country_United_States_of_America_223', 'state_U_S__Minor_Outlying_Islands_4308'),
('country_United_States_of_America_223', 'state_Utah_4309'),
('country_United_States_of_America_223', 'state_Virginia_4310'),
('country_United_States_of_America_223', 'state_Virgin_Islands_of_the_U_S__4311'),
('country_United_States_of_America_223', 'state_Vermont_4312'),
('country_United_States_of_America_223', 'state_Washington_4313'),
('country_United_States_of_America_223', 'state_Wisconsin_4314'),
('country_United_States_of_America_223', 'state_West_Virginia_4315'),
('country_United_States_of_America_223', 'state_Wyoming_4316'),
('country_United_States_of_America_223', 'state_Armed_Forces_Americas_4557'),
('country_United_States_of_America_223', 'state_Armed_Forces_Europe_4558'),
('country_United_States_of_America_223', 'state_Armed_Forces_Pacific_4559'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Baker_Island_4317'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Howland_Island_4318'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Jarvis_Island_4319'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Johnston_Atoll_4320'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Kingman_Reef_4321'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Midway_Atoll_4322'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Navassa_Island_4323'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Palmyra_Atoll_4324'),
('country_United_States_Minor_Outlying_Islands_224', 'state_Wake_Island_4325'),
('country_Uruguay_225', 'state_Artigas_4326'),
('country_Uruguay_225', 'state_Canelones_4327'),
('country_Uruguay_225', 'state_Cerro_Largo_4328'),
('country_Uruguay_225', 'state_Colonia_4329'),
('country_Uruguay_225', 'state_Durazno_4330'),
('country_Uruguay_225', 'state_Florida_4331'),
('country_Uruguay_225', 'state_Flores_4332'),
('country_Uruguay_225', 'state_Lavalleja_4333'),
('country_Uruguay_225', 'state_Maldonado_4334'),
('country_Uruguay_225', 'state_Montevideo_4335'),
('country_Uruguay_225', 'state_Paysandu_4336'),
('country_Uruguay_225', 'state_R__o_Negro_4337'),
('country_Uruguay_225', 'state_Rocha_4338'),
('country_Uruguay_225', 'state_Rivera_4339'),
('country_Uruguay_225', 'state_Salto_4340'),
('country_Uruguay_225', 'state_Soriano_4342'),
('country_Uruguay_225', 'state_Tacuaremb___4343'),
('country_Uruguay_225', 'state_Treinta_y_Tres_4344'),
('country_Uzbekistan_226', 'state_Andijon_viloyati_4345'),
('country_Uzbekistan_226', 'state_Buxoro_viloyati_4346'),
('country_Uzbekistan_226', 'state_Farg_ona_viloyati_4347'),
('country_Uzbekistan_226', 'state_Jizzax_viloyati_4348'),
('country_Uzbekistan_226', 'state_Namangan_viloyati_4349'),
('country_Uzbekistan_226', 'state_Navoiy_viloyati_4350'),
('country_Uzbekistan_226', 'state_Qashqadaryo_viloyati_4351'),
('country_Uzbekistan_226', 'state_Qoraqalpog_iston_Respublikasi_4352'),
('country_Uzbekistan_226', 'state_Samarqand_viloyati_4353'),
('country_Uzbekistan_226', 'state_Sirdaryo_viloyati_4354'),
('country_Uzbekistan_226', 'state_Surxondaryo_viloyati_4355'),
('country_Uzbekistan_226', 'state_Toshkent_4356'),
('country_Uzbekistan_226', 'state_Toshkent_viloyati_4357'),
('country_Uzbekistan_226', 'state_Xorazm_viloyati_4358'),
('country_Vanuatu_227', 'state_Malampa_4359'),
('country_Vanuatu_227', 'state_P__nama_4360'),
('country_Vanuatu_227', 'state_Sanma_4361'),
('country_Vanuatu_227', 'state_Sh__fa_4362'),
('country_Vanuatu_227', 'state_Taf__a_4363'),
('country_Vanuatu_227', 'state_Torba_4364'),
('country_Venezuela_229', 'state_Distrito_Capital_4365'),
('country_Venezuela_229', 'state_Anzo__tegui_4366'),
('country_Venezuela_229', 'state_Apure_4367'),
('country_Venezuela_229', 'state_Aragua_4368'),
('country_Venezuela_229', 'state_Barinas_4369'),
('country_Venezuela_229', 'state_Bol__var_4370'),
('country_Venezuela_229', 'state_Carabobo_4371'),
('country_Venezuela_229', 'state_Cojedes_4372'),
('country_Venezuela_229', 'state_Falc__n_4373'),
('country_Venezuela_229', 'state_Gu__rico_4374'),
('country_Venezuela_229', 'state_Lara_4375'),
('country_Venezuela_229', 'state_M__rida_4376'),
('country_Venezuela_229', 'state_Miranda_4377'),
('country_Venezuela_229', 'state_Monagas_4378'),
('country_Venezuela_229', 'state_Nueva_Esparta_4379'),
('country_Venezuela_229', 'state_Portuguesa_4380'),
('country_Venezuela_229', 'state_Sucre_4381'),
('country_Venezuela_229', 'state_Tachira_4382'),
('country_Venezuela_229', 'state_Trujillo_4383'),
('country_Venezuela_229', 'state_Yaracuy_4384'),
('country_Venezuela_229', 'state_Zulia_4385'),
('country_Venezuela_229', 'state_Capital_Dependencia_4386'),
('country_Venezuela_229', 'state_Vargas_4387'),
('country_Venezuela_229', 'state_Delta_Amacuro_4388'),
('country_Venezuela_229', 'state_Amazonas_4389'),
('country_Vietnam_230', 'state_Lai_Ch__u_4390'),
('country_Vietnam_230', 'state_L__o_Cai_4391'),
('country_Vietnam_230', 'state_H___Giang_4392'),
('country_Vietnam_230', 'state_Cao_B___ng_4393'),
('country_Vietnam_230', 'state_S__n_La_4394'),
('country_Vietnam_230', 'state_Y__n_B__i_4395'),
('country_Vietnam_230', 'state_Tuy__n_Quang_4396'),
('country_Vietnam_230', 'state_L___ng_S__n_4397'),
('country_Vietnam_230', 'state_Qu___ng_Ninh_4398'),
('country_Vietnam_230', 'state_H__a_B__nh_4399'),
('country_Vietnam_230', 'state_H___T__y_4400'),
('country_Vietnam_230', 'state_Ninh_B__nh_4401'),
('country_Vietnam_230', 'state_Th__i_B__nh_4402'),
('country_Vietnam_230', 'state_Thanh_H__a_4403'),
('country_Vietnam_230', 'state_Ngh____An_4404'),
('country_Vietnam_230', 'state_H___T__nh_4405'),
('country_Vietnam_230', 'state_Qu___ng_B__nh_4406'),
('country_Vietnam_230', 'state_Qu___ng_Tr____4407'),
('country_Vietnam_230', 'state_Th___a_Thi__n_Hu____4408'),
('country_Vietnam_230', 'state_Qu___ng_Nam_4409'),
('country_Vietnam_230', 'state_Kon_Tum_4410'),
('country_Vietnam_230', 'state_Qu___ng_Ng__i_4411'),
('country_Vietnam_230', 'state_Gia_Lai_4412'),
('country_Vietnam_230', 'state_B__nh______nh_4413'),
('country_Vietnam_230', 'state_Ph___Y__n_4414'),
('country_Vietnam_230', 'state______k_L___k_4415'),
('country_Vietnam_230', 'state_Kh__nh_H__a_4416'),
('country_Vietnam_230', 'state_L__m______ng_4417'),
('country_Vietnam_230', 'state_Ninh_Thu___n_4418'),
('country_Vietnam_230', 'state_T__y_Ninh_4419'),
('country_Vietnam_230', 'state______ng_Nai_4420'),
('country_Vietnam_230', 'state_B__nh_Thu___n_4421'),
('country_Vietnam_230', 'state_Long_An_4422'),
('country_Vietnam_230', 'state_B___R___a_V__ng_T__u_4423'),
('country_Vietnam_230', 'state_An_Giang_4424'),
('country_Vietnam_230', 'state______ng_Th__p_4425'),
('country_Vietnam_230', 'state_Ti___n_Giang_4426'),
('country_Vietnam_230', 'state_Ki__n_Giang_4427'),
('country_Vietnam_230', 'state_C___n_Th___4428'),
('country_Vietnam_230', 'state_V__nh_Long_4429'),
('country_Vietnam_230', 'state_B___n_Tre_4430'),
('country_Vietnam_230', 'state_Tr___Vinh_4431'),
('country_Vietnam_230', 'state_S__c_Tr__ng_4432'),
('country_Vietnam_230', 'state_B___c_K___n_4433'),
('country_Vietnam_230', 'state_B___c_Giang_4434'),
('country_Vietnam_230', 'state_B___c_Li__u_4435'),
('country_Vietnam_230', 'state_B___c_Ninh_4436'),
('country_Vietnam_230', 'state_B__nh_D____ng_4437'),
('country_Vietnam_230', 'state_B__nh_Ph_____c_4438'),
('country_Vietnam_230', 'state_C___Mau_4439'),
('country_Vietnam_230', 'state______N___ng_4440'),
('country_Vietnam_230', 'state_H___i_D____ng_4441'),
('country_Vietnam_230', 'state_H___i_Ph__ng_4442'),
('country_Vietnam_230', 'state_H___Nam_4443'),
('country_Vietnam_230', 'state_H___N___i_4444'),
('country_Vietnam_230', 'state_S__i_G__n_4445'),
('country_Vietnam_230', 'state_H__ng_Y__n_4446'),
('country_Vietnam_230', 'state_Nam______nh_4447'),
('country_Vietnam_230', 'state_Ph___Th____4448'),
('country_Vietnam_230', 'state_Th__i_Nguy__n_4449'),
('country_Vietnam_230', 'state_V__nh_Ph__c_4450'),
('country_Vietnam_230', 'state___i___n_Bi__n_4451'),
('country_Vietnam_230', 'state______k_N__ng_4452'),
('country_Vietnam_230', 'state_H___u_Giang_4453'),
('country_Virgin_Islands__U_S___232', 'state_Saint_Croix_4454'),
('country_Wallis_and_Futuna_Islands_233', 'state_Alo_4457'),
('country_Wallis_and_Futuna_Islands_233', 'state_Sigave_4458'),
('country_Wallis_and_Futuna_Islands_233', 'state_Wallis_4459'),
('country_Yemen_235', 'state_____________4460'),
('country_Yemen_235', 'state________4461'),
('country_Yemen_235', 'state____________4462'),
('country_Yemen_235', 'state________________4463'),
('country_Yemen_235', 'state______________4464'),
('country_Yemen_235', 'state__________4465'),
('country_Yemen_235', 'state______________4466'),
('country_Yemen_235', 'state________4467'),
('country_Yemen_235', 'state________________4468'),
('country_Yemen_235', 'state______4469'),
('country_Yemen_235', 'state____________4470'),
('country_Yemen_235', 'state________4471'),
('country_Yemen_235', 'state__________4472'),
('country_Yemen_235', 'state______________4473'),
('country_Yemen_235', 'state________________4474'),
('country_Yemen_235', 'state__________4475'),
('country_Yemen_235', 'state____________4476'),
('country_Yemen_235', 'state__________4477'),
('country_Yemen_235', 'state________4478'),
('country_Zambia_238', 'state_Western_4479'),
('country_Zambia_238', 'state_Central_4480'),
('country_Zambia_238', 'state_Eastern_4481'),
('country_Zambia_238', 'state_Luapula_4482'),
('country_Zambia_238', 'state_Northern_4483'),
('country_Zambia_238', 'state_North_Western_4484'),
('country_Zambia_238', 'state_Southern_4485'),
('country_Zambia_238', 'state_Copperbelt_4486'),
('country_Zambia_238', 'state_Lusaka_4487'),
('country_Zimbabwe_239', 'state_Manicaland_4488'),
('country_Zimbabwe_239', 'state_Mashonaland_Central_4489'),
('country_Zimbabwe_239', 'state_Mashonaland_East_4490'),
('country_Zimbabwe_239', 'state_Midlands_4491'),
('country_Zimbabwe_239', 'state_Matabeleland_North_4492'),
('country_Zimbabwe_239', 'state_Matabeleland_South_4493'),
('country_Zimbabwe_239', 'state_Masvingo_4494'),
('country_Zimbabwe_239', 'state_Mashonaland_West_4495'),
('country_Afghanistan_', '1977'),
('country_Afghanistan_', '1978'),
('country_Japan_107', 'state___________1977'),
('tax_europe_9728', 'country_Germany_81'),
('tax_europe_9728', 'country_Austria_14'),
('tax_europe_9728', 'country_Belgium_21'),
('tax_europe_9728', 'country_Bulgaria_33'),
('tax_europe_9728', 'country_Croatia_53'),
('tax_europe_9728', 'country_Cyprus_55'),
('tax_europe_9728', 'country_Denmark_57'),
('tax_europe_9728', 'country_Spain_195'),
('tax_europe_9728', 'country_Estonia_67'),
('tax_europe_9728', 'country_Finland_72'),
('tax_europe_9728', 'country_France_73'),
('tax_europe_9728', 'country_France__Metropolitan_74'),
('tax_europe_9728', 'country_Greece_84'),
('tax_europe_9728', 'country_Hungary_97'),
('tax_europe_9728', 'country_Ireland_103'),
('tax_europe_9728', 'country_Italy_105'),
('tax_europe_9728', 'country_Latvia_117'),
('tax_europe_9728', 'country_Lithuania_123'),
('tax_europe_9728', 'country_Luxembourg_124'),
('tax_europe_9728', 'country_Malta_132'),
('tax_europe_9728', 'country_Netherlands_150'),
('tax_europe_9728', 'country_Poland_170'),
('tax_europe_9728', 'country_Portugal_171'),
('tax_europe_9728', 'country_Czech_Republic_56'),
('tax_europe_9728', 'country_Romania_175'),
('tax_europe_9728', 'country_Slovakia_189'),
('tax_europe_9728', 'country_Slovenia_190'),
('tax_europe_9728', 'country_Sweden_203'),
('country_South_Sudan_4577', 'state_Northern_Bahr_el_Ghazal_4578'),
('country_South_Sudan_4577', 'state_Western_Bahr_el_Ghazal_4579'),
('country_South_Sudan_4577', 'state_Lakes_4580'),
('country_South_Sudan_4577', 'state_Warrap_4581'),
('country_South_Sudan_4577', 'state_Western_Equatoria_4582'),
('country_South_Sudan_4577', 'state_Central_Equatoria_4583'),
('country_South_Sudan_4577', 'state_Eastern_Equatoria_4584'),
('country_South_Sudan_4577', 'state_Jonglei_4585'),
('country_South_Sudan_4577', 'state_Unity_4586'),
('country_South_Sudan_4577', 'state_Upper_Nile_4587'),
('country_South_Sudan_4577', 'state_Pibor_Administrative_Area_4588'),
('country_South_Sudan_4577', 'state_Ruweng_Administrative_Area_4589'),
('country_South_Sudan_4577', 'state_Abyei_Special_Administrative_Area_4590');