REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug) VALUES 
('DZ', 'Algeria', 'algeria');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782614, 'dz', 'Adrar', 1, 'adrar');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(499856, 782614, 'dz', 'Adrar', 1, 'adrar'),
(499857, 782614, 'dz', 'Tamest', 1, 'tamest'),
(499858, 782614, 'dz', 'Charouine', 1, 'charouine'),
(499859, 782614, 'dz', 'Reggane', 1, 'reggane'),
(499860, 782614, 'dz', 'In Zghmir', 1, 'in-zghmir'),
(499861, 782614, 'dz', 'Tit', 1, 'tit'),
(499862, 782614, 'dz', 'Ksar Kaddou', 1, 'ksar-kaddou'),
(499863, 782614, 'dz', 'Tsabit', 1, 'tsabit'),
(499864, 782614, 'dz', 'Timimoun', 1, 'timimoun'),
(499865, 782614, 'dz', 'Ouled Saïd', 1, 'ouled-said'),
(499866, 782614, 'dz', 'Zaouiet Kounta', 1, 'zaouiet-kounta'),
(499867, 782614, 'dz', 'Aoulef', 1, 'aoulef'),
(499868, 782614, 'dz', 'Tamekten', 1, 'tamekten'),
(499869, 782614, 'dz', 'Tamantit', 1, 'tamantit'),
(499870, 782614, 'dz', 'Fenoughil', 1, 'fenoughil'),
(499871, 782614, 'dz', 'Tinerkouk', 1, 'tinerkouk'),
(499872, 782614, 'dz', 'Deldoul', 1, 'deldoul'),
(499873, 782614, 'dz', 'Sali', 1, 'sali'),
(499874, 782614, 'dz', 'Akabli', 1, 'akabli'),
(499875, 782614, 'dz', 'Metarfa', 1, 'metarfa'),
(499876, 782614, 'dz', 'Ouled Ahmed Tammi', 1, 'ouled-ahmed-tammi'),
(499877, 782614, 'dz', 'Bouda', 1, 'bouda'),
(499878, 782614, 'dz', 'Aougrout', 1, 'aougrout'),
(499879, 782614, 'dz', 'Talmine', 1, 'talmine'),
(499880, 782614, 'dz', 'Bordj Badji Mokhtar', 1, 'bordj-badji-mokhtar'),
(499881, 782614, 'dz', 'Sebaa', 1, 'sebaa'),
(499882, 782614, 'dz', 'Ouled Aïssa', 1, 'ouled-aissa'),
(499883, 782614, 'dz', 'Timiaouine', 1, 'timiaouine');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782615, 'dz', 'Chlef', 1, 'chlef');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(499884, 782615, 'dz', 'Abou El Hassan', 1, 'abou-el-hassan'),
(499885, 782615, 'dz', 'Aïn Merane', 1, 'ain-merane'),
(499886, 782615, 'dz', 'Bénairia', 1, 'benairia'),
(499887, 782615, 'dz', 'Beni Bouateb', 1, 'beni-bouateb'),
(499888, 782615, 'dz', 'Beni Haoua', 1, 'beni-haoua'),
(499889, 782615, 'dz', 'Beni Rached', 1, 'beni-rached'),
(499890, 782615, 'dz', 'Boukadir', 1, 'boukadir'),
(499891, 782615, 'dz', 'Bouzeghaia', 1, 'bouzeghaia'),
(499892, 782615, 'dz', 'Breira', 1, 'breira'),
(499893, 782615, 'dz', 'Chettia', 1, 'chettia'),
(499894, 782615, 'dz', 'Chlef', 1, 'chlef'),
(499895, 782615, 'dz', 'Dahra', 1, 'dahra'),
(499896, 782615, 'dz', 'El Hadjadj', 1, 'el-hadjadj'),
(499897, 782615, 'dz', 'El Karimia', 1, 'el-karimia'),
(499898, 782615, 'dz', 'El Marsa', 1, 'el-marsa'),
(499899, 782615, 'dz', 'Harchoun', 1, 'harchoun'),
(499900, 782615, 'dz', 'Harenfa', 1, 'harenfa'),
(499901, 782615, 'dz', 'Labiod Medjadja', 1, 'labiod-medjadja'),
(499902, 782615, 'dz', 'Moussadek', 1, 'moussadek'),
(499903, 782615, 'dz', 'Oued Fodda', 1, 'oued-fodda'),
(499904, 782615, 'dz', 'Oued Goussine', 1, 'oued-goussine'),
(499905, 782615, 'dz', 'Oued Sly', 1, 'oued-sly'),
(499906, 782615, 'dz', 'Ouled Abbes', 1, 'ouled-abbes'),
(499907, 782615, 'dz', 'Ouled Ben Abdelkader', 1, 'ouled-ben-abdelkader'),
(499908, 782615, 'dz', 'Ouled Fares', 1, 'ouled-fares'),
(499909, 782615, 'dz', 'Oum Drou', 1, 'oum-drou'),
(499910, 782615, 'dz', 'Sendjas', 1, 'sendjas'),
(499911, 782615, 'dz', 'Sidi Abderrahmane', 1, 'sidi-abderrahmane'),
(499912, 782615, 'dz', 'Sidi Akkacha', 1, 'sidi-akkacha'),
(499913, 782615, 'dz', 'Sobha', 1, 'sobha'),
(499914, 782615, 'dz', 'Tadjena', 1, 'tadjena'),
(499915, 782615, 'dz', 'Talassa', 1, 'talassa'),
(499916, 782615, 'dz', 'Taougrite', 1, 'taougrite'),
(499917, 782615, 'dz', 'Ténès', 1, 'tenes'),
(499918, 782615, 'dz', 'Zeboudja', 1, 'zeboudja');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782616, 'dz', 'Laghouat', 1, 'laghouat');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(499919, 782616, 'dz', 'Laghouat', 1, 'laghouat'),
(499920, 782616, 'dz', 'Ksar El Hirane', 1, 'ksar-el-hirane'),
(499921, 782616, 'dz', 'Bennasser Benchohra', 1, 'bennasser-benchohra'),
(499922, 782616, 'dz', 'Sidi Makhlouf', 1, 'sidi-makhlouf'),
(499923, 782616, 'dz', 'Hassi Delaa', 1, 'hassi-delaa'),
(499924, 782616, 'dz', 'Hassi R\'Mel', 1, 'hassi-rmel'),
(499925, 782616, 'dz', 'Aïn Madhi', 1, 'ain-madhi'),
(499926, 782616, 'dz', 'Tadjemout', 1, 'tadjemout'),
(499927, 782616, 'dz', 'Kheneg', 1, 'kheneg'),
(499928, 782616, 'dz', 'Gueltat Sidi Saad', 1, 'gueltat-sidi-saad'),
(499929, 782616, 'dz', 'Aïn Sidi Ali', 1, 'ain-sidi-ali'),
(499930, 782616, 'dz', 'Beidha', 1, 'beidha'),
(499931, 782616, 'dz', 'Brida', 1, 'brida'),
(499932, 782616, 'dz', 'El Ghicha', 1, 'el-ghicha'),
(499933, 782616, 'dz', 'Hadj Mechri', 1, 'hadj-mechri'),
(499934, 782616, 'dz', 'Sebgag', 1, 'sebgag'),
(499935, 782616, 'dz', 'Taouila', 1, 'taouila'),
(499936, 782616, 'dz', 'Tadjrouna', 1, 'tadjrouna'),
(499937, 782616, 'dz', 'Aflou', 1, 'aflou'),
(499938, 782616, 'dz', 'El Assafia', 1, 'el-assafia'),
(499939, 782616, 'dz', 'Oued Morra', 1, 'oued-morra'),
(499940, 782616, 'dz', 'Oued M\'Zi', 1, 'oued-mzi'),
(499941, 782616, 'dz', 'El Houaita', 1, 'el-houaita'),
(499942, 782616, 'dz', 'Sidi Bouzid', 1, 'sidi-bouzid');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782617, 'dz', 'Oum El-Bouaghi', 1, 'oum-el-bouaghi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(499943, 782617, 'dz', 'Oum el Bouaghi', 1, 'oum-el-bouaghi'),
(499944, 782617, 'dz', 'Aïn Béïda', 1, 'ain-beida'),
(499945, 782617, 'dz', 'Aïn M\'lila', 1, 'ain-mlila'),
(499946, 782617, 'dz', 'Behir Chergui', 1, 'behir-chergui'),
(499947, 782617, 'dz', 'El Amiria', 1, 'el-amiria'),
(499948, 782617, 'dz', 'Sigus', 1, 'sigus'),
(499949, 782617, 'dz', 'El Belala', 1, 'el-belala'),
(499950, 782617, 'dz', 'Aïn Babouche', 1, 'ain-babouche'),
(499951, 782617, 'dz', 'Berriche', 1, 'berriche'),
(499952, 782617, 'dz', 'Ouled Hamla', 1, 'ouled-hamla'),
(499953, 782617, 'dz', 'Dhalaa', 1, 'dhalaa'),
(499954, 782617, 'dz', 'Aïn Kercha', 1, 'ain-kercha'),
(499955, 782617, 'dz', 'Hanchir Toumghani', 1, 'hanchir-toumghani'),
(499956, 782617, 'dz', 'El Djazia', 1, 'el-djazia'),
(499957, 782617, 'dz', 'Aïn Diss', 1, 'ain-diss'),
(499958, 782617, 'dz', 'Fkirina', 1, 'fkirina'),
(499959, 782617, 'dz', 'Souk Naamane', 1, 'souk-naamane'),
(499960, 782617, 'dz', 'Zorg', 1, 'zorg'),
(499961, 782617, 'dz', 'El Fedjouz Boughrara Saoudi', 1, 'el-fedjouz-boughrara-saoudi'),
(499962, 782617, 'dz', 'Ouled Zouaï', 1, 'ouled-zouai'),
(499963, 782617, 'dz', 'Bir Chouhada', 1, 'bir-chouhada'),
(499964, 782617, 'dz', 'Ksar Sbahi', 1, 'ksar-sbahi'),
(499965, 782617, 'dz', 'Oued Nini', 1, 'oued-nini'),
(499966, 782617, 'dz', 'Meskiana', 1, 'meskiana'),
(499967, 782617, 'dz', 'Aïn Fakroun', 1, 'ain-fakroun'),
(499968, 782617, 'dz', 'Rahia', 1, 'rahia'),
(499969, 782617, 'dz', 'Aïn Zitoun', 1, 'ain-zitoun'),
(499970, 782617, 'dz', 'Ouled Gacem', 1, 'ouled-gacem'),
(499971, 782617, 'dz', 'El Harmilia', 1, 'el-harmilia');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782618, 'dz', 'Batna', 1, 'batna');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(499972, 782618, 'dz', 'Batna', 1, 'batna'),
(499973, 782618, 'dz', 'Ghassira', 1, 'ghassira'),
(499974, 782618, 'dz', 'Maafa', 1, 'maafa'),
(499975, 782618, 'dz', 'Merouana', 1, 'merouana'),
(499976, 782618, 'dz', 'Seriana', 1, 'seriana'),
(499977, 782618, 'dz', 'Menaa', 1, 'menaa'),
(499978, 782618, 'dz', 'El Madher', 1, 'el-madher'),
(499979, 782618, 'dz', 'Tazoult', 1, 'tazoult'),
(499980, 782618, 'dz', 'N\'Gaous', 1, 'ngaous'),
(499981, 782618, 'dz', 'Guigba', 1, 'guigba'),
(499982, 782618, 'dz', 'Inoughissen', 1, 'inoughissen'),
(499983, 782618, 'dz', 'Ouyoun El Assafir', 1, 'ouyoun-el-assafir'),
(499984, 782618, 'dz', 'Djerma', 1, 'djerma'),
(499985, 782618, 'dz', 'Bitam', 1, 'bitam'),
(499986, 782618, 'dz', 'Abdelkader Azil', 1, 'abdelkader-azil'),
(499987, 782618, 'dz', 'Arris', 1, 'arris'),
(499988, 782618, 'dz', 'Kimmel', 1, 'kimmel'),
(499989, 782618, 'dz', 'Tilatou', 1, 'tilatou'),
(499990, 782618, 'dz', 'Aïn Djasser', 1, 'ain-djasser'),
(499991, 782618, 'dz', 'Ouled Sellam', 1, 'ouled-sellam'),
(499992, 782618, 'dz', 'Tigherghar', 1, 'tigherghar'),
(499993, 782618, 'dz', 'Aïn Yagout', 1, 'ain-yagout'),
(499994, 782618, 'dz', 'Sefiane', 1, 'sefiane'),
(499995, 782618, 'dz', 'Fesdis', 1, 'fesdis'),
(499996, 782618, 'dz', 'Rahbat', 1, 'rahbat'),
(499997, 782618, 'dz', 'Tighanimine', 1, 'tighanimine'),
(499998, 782618, 'dz', 'Lemsane', 1, 'lemsane'),
(499999, 782618, 'dz', 'Ksar Bellezma', 1, 'ksar-bellezma'),
(500000, 782618, 'dz', 'Seggana', 1, 'seggana'),
(500001, 782618, 'dz', 'Ichmoul', 1, 'ichmoul'),
(500002, 782618, 'dz', 'Foum Toub', 1, 'foum-toub'),
(500003, 782618, 'dz', 'Ben Foudhala El Hakania', 1, 'ben-foudhala-el-hakania'),
(500004, 782618, 'dz', 'Oued El Ma', 1, 'oued-el-ma'),
(500005, 782618, 'dz', 'Talkhamt', 1, 'talkhamt'),
(500006, 782618, 'dz', 'Bouzina', 1, 'bouzina'),
(500007, 782618, 'dz', 'Chemora', 1, 'chemora'),
(500008, 782618, 'dz', 'Oued Chaaba', 1, 'oued-chaaba'),
(500009, 782618, 'dz', 'Taxlent', 1, 'taxlent'),
(500010, 782618, 'dz', 'Gosbat', 1, 'gosbat'),
(500011, 782618, 'dz', 'Ouled Aouf', 1, 'ouled-aouf'),
(500012, 782618, 'dz', 'Boumaguer', 1, 'boumaguer'),
(500013, 782618, 'dz', 'Barika', 1, 'barika'),
(500014, 782618, 'dz', 'Djezar', 1, 'djezar'),
(500015, 782618, 'dz', 'T\'Kout', 1, 'tkout'),
(500016, 782618, 'dz', 'Aïn Touta', 1, 'ain-touta'),
(500017, 782618, 'dz', 'Hidoussa', 1, 'hidoussa'),
(500018, 782618, 'dz', 'Teniet El Abed', 1, 'teniet-el-abed'),
(500019, 782618, 'dz', 'Oued Taga', 1, 'oued-taga'),
(500020, 782618, 'dz', 'Ouled Fadel', 1, 'ouled-fadel'),
(500021, 782618, 'dz', 'Timgad', 1, 'timgad'),
(500022, 782618, 'dz', 'Ras El Aioun', 1, 'ras-el-aioun'),
(500023, 782618, 'dz', 'Chir', 1, 'chir'),
(500024, 782618, 'dz', 'Ouled Si Slimane', 1, 'ouled-si-slimane'),
(500025, 782618, 'dz', 'Zanat El Beida', 1, 'zanat-el-beida'),
(500026, 782618, 'dz', 'M\'doukel', 1, 'mdoukel'),
(500027, 782618, 'dz', 'Ouled Ammar', 1, 'ouled-ammar'),
(500028, 782618, 'dz', 'El Hassi', 1, 'el-hassi'),
(500029, 782618, 'dz', 'Lazrou', 1, 'lazrou'),
(500030, 782618, 'dz', 'Boumia', 1, 'boumia'),
(500031, 782618, 'dz', 'Boulhilat', 1, 'boulhilat'),
(500032, 782618, 'dz', 'Larbaâ', 1, 'larbaa');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782619, 'dz', 'Béjaïa', 1, 'bejaia');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500033, 782619, 'dz', 'Béjaïa', 1, 'bejaia'),
(500034, 782619, 'dz', 'Amizour', 1, 'amizour'),
(500035, 782619, 'dz', 'Ferraoun', 1, 'ferraoun'),
(500036, 782619, 'dz', 'Taourirt', 1, 'taourirt'),
(500037, 782619, 'dz', 'Chellata', 1, 'chellata'),
(500038, 782619, 'dz', 'Tamokra', 1, 'tamokra'),
(500039, 782619, 'dz', 'Timezrit', 1, 'timezrit'),
(500040, 782619, 'dz', 'Souk El Ténine', 1, 'souk-el-tenine'),
(500041, 782619, 'dz', 'M\'cisna', 1, 'mcisna'),
(500042, 782619, 'dz', 'Tinabdher', 1, 'tinabdher'),
(500043, 782619, 'dz', 'Tichy', 1, 'tichy'),
(500044, 782619, 'dz', 'Semaoun', 1, 'semaoun'),
(500045, 782619, 'dz', 'Kendira', 1, 'kendira'),
(500046, 782619, 'dz', 'Tifra', 1, 'tifra'),
(500047, 782619, 'dz', 'Ighram', 1, 'ighram'),
(500048, 782619, 'dz', 'Amalou', 1, 'amalou'),
(500049, 782619, 'dz', 'Ighil Ali', 1, 'ighil-ali'),
(500050, 782619, 'dz', 'Fenaïa Ilmaten', 1, 'fenaia-ilmaten'),
(500051, 782619, 'dz', 'Toudja', 1, 'toudja'),
(500052, 782619, 'dz', 'Darguina', 1, 'darguina'),
(500053, 782619, 'dz', 'Sidi-Ayad', 1, 'sidi-ayad'),
(500054, 782619, 'dz', 'Aokas', 1, 'aokas'),
(500055, 782619, 'dz', 'Beni Djellil', 1, 'beni-djellil'),
(500056, 782619, 'dz', 'Adekar', 1, 'adekar'),
(500057, 782619, 'dz', 'Akbou', 1, 'akbou'),
(500058, 782619, 'dz', 'Seddouk', 1, 'seddouk'),
(500059, 782619, 'dz', 'Tazmalt', 1, 'tazmalt'),
(500060, 782619, 'dz', 'Aït-R\'zine', 1, 'ait-rzine'),
(500061, 782619, 'dz', 'Chemini', 1, 'chemini'),
(500062, 782619, 'dz', 'Souk-Oufella', 1, 'souk-oufella'),
(500063, 782619, 'dz', 'Taskriout', 1, 'taskriout'),
(500064, 782619, 'dz', 'Tibane', 1, 'tibane'),
(500065, 782619, 'dz', 'Tala Hamza', 1, 'tala-hamza'),
(500066, 782619, 'dz', 'Barbacha', 1, 'barbacha'),
(500067, 782619, 'dz', 'Beni Ksila', 1, 'beni-ksila'),
(500068, 782619, 'dz', 'Ouzellaguen', 1, 'ouzellaguen'),
(500069, 782619, 'dz', 'Bouhamza', 1, 'bouhamza'),
(500070, 782619, 'dz', 'Beni Mellikeche', 1, 'beni-mellikeche'),
(500071, 782619, 'dz', 'Sidi-Aïch', 1, 'sidi-aich'),
(500072, 782619, 'dz', 'El Kseur', 1, 'el-kseur'),
(500073, 782619, 'dz', 'Melbou', 1, 'melbou'),
(500074, 782619, 'dz', 'Akfadou', 1, 'akfadou'),
(500075, 782619, 'dz', 'Leflaye', 1, 'leflaye'),
(500076, 782619, 'dz', 'Kherrata', 1, 'kherrata'),
(500077, 782619, 'dz', 'Draâ El-Kaïd', 1, 'draa-el-kaid'),
(500078, 782619, 'dz', 'Tamridjet', 1, 'tamridjet'),
(500079, 782619, 'dz', 'Aït-Smail', 1, 'ait-smail'),
(500080, 782619, 'dz', 'Boukhelifa', 1, 'boukhelifa'),
(500081, 782619, 'dz', 'Tizi N\'Berber', 1, 'tizi-nberber'),
(500082, 782619, 'dz', 'Beni Maouche', 1, 'beni-maouche'),
(500083, 782619, 'dz', 'Oued Ghir', 1, 'oued-ghir'),
(500084, 782619, 'dz', 'Boudjellil', 1, 'boudjellil');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782620, 'dz', 'Biskra', 1, 'biskra');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500085, 782620, 'dz', 'Aïn Naga', 1, 'ain-naga'),
(500086, 782620, 'dz', 'Aïn Zaatout', 1, 'ain-zaatout'),
(500087, 782620, 'dz', 'Besbes', 1, 'besbes'),
(500088, 782620, 'dz', 'Biskra', 1, 'biskra'),
(500089, 782620, 'dz', 'Bordj Ben Azzouz', 1, 'bordj-ben-azzouz'),
(500090, 782620, 'dz', 'Bouchagroune', 1, 'bouchagroune'),
(500091, 782620, 'dz', 'Branis', 1, 'branis'),
(500092, 782620, 'dz', 'Chetma', 1, 'chetma'),
(500093, 782620, 'dz', 'Djemorah', 1, 'djemorah'),
(500094, 782620, 'dz', 'Doucen', 1, 'doucen'),
(500095, 782620, 'dz', 'Ech Chaïba', 1, 'ech-chaiba'),
(500096, 782620, 'dz', 'El Feidh', 1, 'el-feidh'),
(500097, 782620, 'dz', 'El Ghrous', 1, 'el-ghrous'),
(500098, 782620, 'dz', 'El Hadjeb', 1, 'el-hadjeb'),
(500099, 782620, 'dz', 'El Haouch', 1, 'el-haouch'),
(500100, 782620, 'dz', 'El Kantara', 1, 'el-kantara'),
(500101, 782620, 'dz', 'El Mizaraa', 1, 'el-mizaraa'),
(500102, 782620, 'dz', 'El Outaya', 1, 'el-outaya'),
(500103, 782620, 'dz', 'Foughala', 1, 'foughala'),
(500104, 782620, 'dz', 'Khenguet Sidi Nadji', 1, 'khenguet-sidi-nadji'),
(500105, 782620, 'dz', 'Lichana', 1, 'lichana'),
(500106, 782620, 'dz', 'Lioua', 1, 'lioua'),
(500107, 782620, 'dz', 'M\'Chouneche', 1, 'mchouneche'),
(500108, 782620, 'dz', 'Mekhadma', 1, 'mekhadma'),
(500109, 782620, 'dz', 'M\'Lili', 1, 'mlili'),
(500110, 782620, 'dz', 'Ouled Djellal', 1, 'ouled-djellal'),
(500111, 782620, 'dz', 'Oumache', 1, 'oumache'),
(500112, 782620, 'dz', 'Ourlal', 1, 'ourlal'),
(500113, 782620, 'dz', 'Ras El Miaad', 1, 'ras-el-miaad'),
(500114, 782620, 'dz', 'Sidi Khaled', 1, 'sidi-khaled'),
(500115, 782620, 'dz', 'Sidi Okba', 1, 'sidi-okba'),
(500116, 782620, 'dz', 'Tolga', 1, 'tolga'),
(500117, 782620, 'dz', 'Zeribet El Oued', 1, 'zeribet-el-oued');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782621, 'dz', 'Béchar', 1, 'bechar');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500118, 782621, 'dz', 'Béchar', 1, 'bechar'),
(500119, 782621, 'dz', 'Erg Ferradj', 1, 'erg-ferradj'),
(500120, 782621, 'dz', 'Ouled Khoudir', 1, 'ouled-khoudir'),
(500121, 782621, 'dz', 'Meridja', 1, 'meridja'),
(500122, 782621, 'dz', 'Timoudi', 1, 'timoudi'),
(500123, 782621, 'dz', 'Lahmar', 1, 'lahmar'),
(500124, 782621, 'dz', 'Béni Abbès', 1, 'beni-abbes'),
(500125, 782621, 'dz', 'Beni Ikhlef', 1, 'beni-ikhlef'),
(500126, 782621, 'dz', 'Mechraa Houari Boumedienne', 1, 'mechraa-houari-boumedienne'),
(500127, 782621, 'dz', 'Kenadsa', 1, 'kenadsa'),
(500128, 782621, 'dz', 'Igli', 1, 'igli'),
(500129, 782621, 'dz', 'Tabelbala', 1, 'tabelbala'),
(500130, 782621, 'dz', 'Taghit', 1, 'taghit'),
(500131, 782621, 'dz', 'El Ouata', 1, 'el-ouata'),
(500132, 782621, 'dz', 'Boukais', 1, 'boukais'),
(500133, 782621, 'dz', 'Mougheul', 1, 'mougheul'),
(500134, 782621, 'dz', 'Abadla', 1, 'abadla'),
(500135, 782621, 'dz', 'Ksabi', 1, 'ksabi'),
(500136, 782621, 'dz', 'Tamtert', 1, 'tamtert'),
(500137, 782621, 'dz', 'Beni Ounif', 1, 'beni-ounif');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782622, 'dz', 'Blida', 1, 'blida');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500138, 782622, 'dz', 'Blida', 1, 'blida'),
(500139, 782622, 'dz', 'Chebli', 1, 'chebli'),
(500140, 782622, 'dz', 'Bouinan', 1, 'bouinan'),
(500141, 782622, 'dz', 'Oued Alleug', 1, 'oued-alleug'),
(500142, 782622, 'dz', 'Ouled Yaïch', 1, 'ouled-yaich'),
(500143, 782622, 'dz', 'Chréa', 1, 'chrea'),
(500144, 782622, 'dz', 'El Affroun', 1, 'el-affroun'),
(500145, 782622, 'dz', 'Chiffa', 1, 'chiffa'),
(500146, 782622, 'dz', 'Hammam Melouane', 1, 'hammam-melouane'),
(500147, 782622, 'dz', 'Benkhelil', 1, 'benkhelil'),
(500148, 782622, 'dz', 'Soumaa', 1, 'soumaa'),
(500149, 782622, 'dz', 'Mouzaia', 1, 'mouzaia'),
(500150, 782622, 'dz', 'Souhane', 1, 'souhane'),
(500151, 782622, 'dz', 'Meftah', 1, 'meftah'),
(500152, 782622, 'dz', 'Ouled Slama', 1, 'ouled-slama'),
(500153, 782622, 'dz', 'Boufarik', 1, 'boufarik'),
(500154, 782622, 'dz', 'Larbaa', 1, 'larbaa'),
(500155, 782622, 'dz', 'Oued Djer', 1, 'oued-djer'),
(500156, 782622, 'dz', 'Beni Tamou', 1, 'beni-tamou'),
(500157, 782622, 'dz', 'Bouarfa', 1, 'bouarfa'),
(500158, 782622, 'dz', 'Beni Mered', 1, 'beni-mered'),
(500159, 782622, 'dz', 'Bougara', 1, 'bougara'),
(500160, 782622, 'dz', 'Guerouaou', 1, 'guerouaou'),
(500161, 782622, 'dz', 'Aïn Romana', 1, 'ain-romana'),
(500162, 782622, 'dz', 'Djebabra', 1, 'djebabra');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782623, 'dz', 'Bouira', 1, 'bouira');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500163, 782623, 'dz', 'Ain Bessam', 1, 'ain-bessam'),
(500164, 782623, 'dz', 'Hanif', 1, 'hanif'),
(500165, 782623, 'dz', 'Aghbalou', 1, 'aghbalou'),
(500166, 782623, 'dz', 'Aïn El Hadjar', 1, 'ain-el-hadjar'),
(500167, 782623, 'dz', 'Ahl El Ksar', 1, 'ahl-el-ksar'),
(500168, 782623, 'dz', 'Aïn Laloui', 1, 'ain-laloui'),
(500169, 782623, 'dz', 'Ath Mansour', 1, 'ath-mansour'),
(500170, 782623, 'dz', 'Aomar', 1, 'aomar'),
(500171, 782623, 'dz', 'Aïn El Turc', 1, 'ain-el-turc'),
(500172, 782623, 'dz', 'Aït Laziz', 1, 'ait-laziz'),
(500173, 782623, 'dz', 'Bouderbala', 1, 'bouderbala'),
(500174, 782623, 'dz', 'Bechloul', 1, 'bechloul'),
(500175, 782623, 'dz', 'Bir Ghbalou', 1, 'bir-ghbalou'),
(500176, 782623, 'dz', 'Bouiche', 1, 'bouiche'),
(500177, 782623, 'dz', 'Boukram', 1, 'boukram'),
(500178, 782623, 'dz', 'Bordj Okhriss', 1, 'bordj-okhriss'),
(500179, 782623, 'dz', 'Bouira', 1, 'bouira'),
(500180, 782623, 'dz', 'Chorfa', 1, 'chorfa'),
(500181, 782623, 'dz', 'Dechmia', 1, 'dechmia'),
(500182, 782623, 'dz', 'Dirrah', 1, 'dirrah'),
(500183, 782623, 'dz', 'Djebahia', 1, 'djebahia'),
(500184, 782623, 'dz', 'El Hakimia', 1, 'el-hakimia'),
(500185, 782623, 'dz', 'El Hachimia', 1, 'el-hachimia'),
(500186, 782623, 'dz', 'El Adjiba', 1, 'el-adjiba'),
(500187, 782623, 'dz', 'El Khabouzia', 1, 'el-khabouzia'),
(500188, 782623, 'dz', 'El Mokrani', 1, 'el-mokrani'),
(500189, 782623, 'dz', 'El Asnam', 1, 'el-asnam'),
(500190, 782623, 'dz', 'Guerrouma', 1, 'guerrouma'),
(500191, 782623, 'dz', 'Haizer', 1, 'haizer'),
(500192, 782623, 'dz', 'Hadjera Zerga', 1, 'hadjera-zerga'),
(500193, 782623, 'dz', 'Kadiria', 1, 'kadiria'),
(500194, 782623, 'dz', 'Lakhdaria', 1, 'lakhdaria'),
(500195, 782623, 'dz', 'M\'Chedallah', 1, 'mchedallah'),
(500196, 782623, 'dz', 'Mezdour )', 1, 'mezdour'),
(500197, 782623, 'dz', 'Maala', 1, 'maala'),
(500198, 782623, 'dz', 'Maamora', 1, 'maamora'),
(500199, 782623, 'dz', 'Oued El Berdi', 1, 'oued-el-berdi'),
(500200, 782623, 'dz', 'Ouled Rached', 1, 'ouled-rached'),
(500201, 782623, 'dz', 'Raouraoua', 1, 'raouraoua'),
(500202, 782623, 'dz', 'Ridane', 1, 'ridane'),
(500203, 782623, 'dz', 'Saharidj', 1, 'saharidj'),
(500204, 782623, 'dz', 'Sour El Ghouzlane', 1, 'sour-el-ghouzlane'),
(500205, 782623, 'dz', 'Souk El Khemis', 1, 'souk-el-khemis'),
(500206, 782623, 'dz', 'Taguedit', 1, 'taguedit'),
(500207, 782623, 'dz', 'Taghzout', 1, 'taghzout'),
(500208, 782623, 'dz', 'Zbarbar', 1, 'zbarbar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782624, 'dz', 'Tamanrasset', 1, 'tamanrasset');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500209, 782624, 'dz', 'Tamanrasset', 1, 'tamanrasset'),
(500210, 782624, 'dz', 'Abalessa', 1, 'abalessa'),
(500211, 782624, 'dz', 'In Ghar', 1, 'in-ghar'),
(500212, 782624, 'dz', 'In Guezzam', 1, 'in-guezzam'),
(500213, 782624, 'dz', 'Idles', 1, 'idles'),
(500214, 782624, 'dz', 'Tazrouk', 1, 'tazrouk'),
(500215, 782624, 'dz', 'Tin Zaouatine', 1, 'tin-zaouatine'),
(500216, 782624, 'dz', 'In Salah', 1, 'in-salah'),
(500217, 782624, 'dz', 'In Amguel', 1, 'in-amguel'),
(500218, 782624, 'dz', 'Foggaret Ezzaouia', 1, 'foggaret-ezzaouia');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782625, 'dz', 'Tébessa', 1, 'tebessa');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500219, 782625, 'dz', 'Tébessa', 1, 'tebessa'),
(500220, 782625, 'dz', 'Bir el-Ater', 1, 'bir-el-ater'),
(500221, 782625, 'dz', 'Cheria', 1, 'cheria'),
(500222, 782625, 'dz', 'Stah Guentis', 1, 'stah-guentis'),
(500223, 782625, 'dz', 'El Aouinet', 1, 'el-aouinet'),
(500224, 782625, 'dz', 'El Houidjbet', 1, 'el-houidjbet'),
(500225, 782625, 'dz', 'Safsaf El Ouesra', 1, 'safsaf-el-ouesra'),
(500226, 782625, 'dz', 'Hammamet', 1, 'hammamet'),
(500227, 782625, 'dz', 'Negrine', 1, 'negrine'),
(500228, 782625, 'dz', 'Bir Mokkadem', 1, 'bir-mokkadem'),
(500229, 782625, 'dz', 'El Kouif', 1, 'el-kouif'),
(500230, 782625, 'dz', 'Morsott', 1, 'morsott'),
(500231, 782625, 'dz', 'El Ogla', 1, 'el-ogla'),
(500232, 782625, 'dz', 'Bir Dheb', 1, 'bir-dheb'),
(500233, 782625, 'dz', 'Ogla Melha', 1, 'ogla-melha'),
(500234, 782625, 'dz', 'Guorriguer', 1, 'guorriguer'),
(500235, 782625, 'dz', 'Bekkaria', 1, 'bekkaria'),
(500236, 782625, 'dz', 'Boukhadra', 1, 'boukhadra'),
(500237, 782625, 'dz', 'Ouenza', 1, 'ouenza'),
(500238, 782625, 'dz', 'El Ma Labiodh', 1, 'el-ma-labiodh'),
(500239, 782625, 'dz', 'Oum Ali', 1, 'oum-ali'),
(500240, 782625, 'dz', 'Tlidjene', 1, 'tlidjene'),
(500241, 782625, 'dz', 'Aïn Zerga', 1, 'ain-zerga'),
(500242, 782625, 'dz', 'El Meridj', 1, 'el-meridj'),
(500243, 782625, 'dz', 'Boulhaf Dir', 1, 'boulhaf-dir'),
(500244, 782625, 'dz', 'Bedjene', 1, 'bedjene'),
(500245, 782625, 'dz', 'El Mezeraa', 1, 'el-mezeraa'),
(500246, 782625, 'dz', 'Ferkane', 1, 'ferkane');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782626, 'dz', 'Tlemcen', 1, 'tlemcen');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500247, 782626, 'dz', 'Tlemcen', 1, 'tlemcen'),
(500248, 782626, 'dz', 'Beni Mester', 1, 'beni-mester'),
(500249, 782626, 'dz', 'Aïn Tallout', 1, 'ain-tallout'),
(500250, 782626, 'dz', 'Remchi', 1, 'remchi'),
(500251, 782626, 'dz', 'El Fehoul', 1, 'el-fehoul'),
(500252, 782626, 'dz', 'Sabra', 1, 'sabra'),
(500253, 782626, 'dz', 'Ghazaouet', 1, 'ghazaouet'),
(500254, 782626, 'dz', 'Souani', 1, 'souani'),
(500255, 782626, 'dz', 'Djebala', 1, 'djebala'),
(500256, 782626, 'dz', 'El Gor', 1, 'el-gor'),
(500257, 782626, 'dz', 'Oued Lakhdar', 1, 'oued-lakhdar'),
(500258, 782626, 'dz', 'Aïn Fezza', 1, 'ain-fezza'),
(500259, 782626, 'dz', 'Ouled Mimoun', 1, 'ouled-mimoun'),
(500260, 782626, 'dz', 'Amieur', 1, 'amieur'),
(500261, 782626, 'dz', 'Aïn Youcef', 1, 'ain-youcef'),
(500262, 782626, 'dz', 'Zenata', 1, 'zenata'),
(500263, 782626, 'dz', 'Beni Snous', 1, 'beni-snous'),
(500264, 782626, 'dz', 'Bab El Assa', 1, 'bab-el-assa'),
(500265, 782626, 'dz', 'Dar Yaghmouracene', 1, 'dar-yaghmouracene'),
(500266, 782626, 'dz', 'Fellaoucene', 1, 'fellaoucene'),
(500267, 782626, 'dz', 'Azails', 1, 'azails'),
(500268, 782626, 'dz', 'Sebaa Chioukh', 1, 'sebaa-chioukh'),
(500269, 782626, 'dz', 'Terny Beni Hdiel', 1, 'terny-beni-hdiel'),
(500270, 782626, 'dz', 'Bensekrane', 1, 'bensekrane'),
(500271, 782626, 'dz', 'Aïn Nehala', 1, 'ain-nehala'),
(500272, 782626, 'dz', 'Hennaya', 1, 'hennaya'),
(500273, 782626, 'dz', 'Maghnia', 1, 'maghnia'),
(500274, 782626, 'dz', 'Hammam Boughrara', 1, 'hammam-boughrara'),
(500275, 782626, 'dz', 'Souahlia', 1, 'souahlia'),
(500276, 782626, 'dz', 'MSirda Fouaga', 1, 'msirda-fouaga'),
(500277, 782626, 'dz', 'Aïn Fetah', 1, 'ain-fetah'),
(500278, 782626, 'dz', 'El Aricha', 1, 'el-aricha'),
(500279, 782626, 'dz', 'Souk Tlata', 1, 'souk-tlata'),
(500280, 782626, 'dz', 'Sidi Abdelli', 1, 'sidi-abdelli'),
(500281, 782626, 'dz', 'Sebdou', 1, 'sebdou'),
(500282, 782626, 'dz', 'Beni Ouarsous', 1, 'beni-ouarsous'),
(500283, 782626, 'dz', 'Sidi Medjahed', 1, 'sidi-medjahed'),
(500284, 782626, 'dz', 'Beni Boussaid', 1, 'beni-boussaid'),
(500285, 782626, 'dz', 'Marsa Ben M\'Hidi', 1, 'marsa-ben-mhidi'),
(500286, 782626, 'dz', 'Nedroma', 1, 'nedroma'),
(500287, 782626, 'dz', 'Sidi Djillali', 1, 'sidi-djillali'),
(500288, 782626, 'dz', 'Beni Bahdel', 1, 'beni-bahdel'),
(500289, 782626, 'dz', 'El Bouihi', 1, 'el-bouihi'),
(500290, 782626, 'dz', 'Honaïne	5 408', 1, 'honaine-5-408'),
(500291, 782626, 'dz', 'Tienet	4 493', 1, 'tienet-4-493'),
(500292, 782626, 'dz', 'Ouled Riyah', 1, 'ouled-riyah'),
(500293, 782626, 'dz', 'Bouhlou	6 347', 1, 'bouhlou-6-347'),
(500294, 782626, 'dz', 'Beni Khellad', 1, 'beni-khellad'),
(500295, 782626, 'dz', 'Aïn Ghoraba', 1, 'ain-ghoraba'),
(500296, 782626, 'dz', 'Chetouane', 1, 'chetouane'),
(500297, 782626, 'dz', 'Mansourah', 1, 'mansourah'),
(500298, 782626, 'dz', 'Beni Semiel', 1, 'beni-semiel'),
(500299, 782626, 'dz', 'Aïn Kebira', 1, 'ain-kebira');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782627, 'dz', 'Tiaret', 1, 'tiaret');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500300, 782627, 'dz', 'Aïn Bouchekif', 1, 'ain-bouchekif'),
(500301, 782627, 'dz', 'Aïn Deheb', 1, 'ain-deheb'),
(500302, 782627, 'dz', 'Aïn El Hadid', 1, 'ain-el-hadid'),
(500303, 782627, 'dz', 'Aïn Kermes', 1, 'ain-kermes'),
(500304, 782627, 'dz', 'Aïn Zarit', 1, 'ain-zarit'),
(500305, 782627, 'dz', 'Bougara', 1, 'bougara'),
(500306, 782627, 'dz', 'Chehaima', 1, 'chehaima'),
(500307, 782627, 'dz', 'Dahmouni', 1, 'dahmouni'),
(500308, 782627, 'dz', 'Djebilet Rosfa', 1, 'djebilet-rosfa'),
(500309, 782627, 'dz', 'Djillali Ben Amar', 1, 'djillali-ben-amar'),
(500310, 782627, 'dz', 'Faidja', 1, 'faidja'),
(500311, 782627, 'dz', 'Frenda', 1, 'frenda'),
(500312, 782627, 'dz', 'Guertoufa', 1, 'guertoufa'),
(500313, 782627, 'dz', 'Hamadia', 1, 'hamadia'),
(500314, 782627, 'dz', 'Ksar Chellala', 1, 'ksar-chellala'),
(500315, 782627, 'dz', 'Madna', 1, 'madna'),
(500316, 782627, 'dz', 'Mahdia', 1, 'mahdia'),
(500317, 782627, 'dz', 'Mechraa Safa', 1, 'mechraa-safa'),
(500318, 782627, 'dz', 'Medrissa', 1, 'medrissa'),
(500319, 782627, 'dz', 'Medroussa', 1, 'medroussa'),
(500320, 782627, 'dz', 'Meghila', 1, 'meghila'),
(500321, 782627, 'dz', 'Mellakou', 1, 'mellakou'),
(500322, 782627, 'dz', 'Nadorah', 1, 'nadorah'),
(500323, 782627, 'dz', 'Naima', 1, 'naima'),
(500324, 782627, 'dz', 'Oued Lilli', 1, 'oued-lilli'),
(500325, 782627, 'dz', 'Rahouia', 1, 'rahouia'),
(500326, 782627, 'dz', 'Rechaiga', 1, 'rechaiga'),
(500327, 782627, 'dz', 'Sebaine', 1, 'sebaine'),
(500328, 782627, 'dz', 'Sebt', 1, 'sebt'),
(500329, 782627, 'dz', 'Serghine', 1, 'serghine'),
(500330, 782627, 'dz', 'Si Abdelghani', 1, 'si-abdelghani'),
(500331, 782627, 'dz', 'Sidi Abderahmane', 1, 'sidi-abderahmane'),
(500332, 782627, 'dz', 'Sidi Ali Mellal', 1, 'sidi-ali-mellal'),
(500333, 782627, 'dz', 'Sidi Bakhti', 1, 'sidi-bakhti'),
(500334, 782627, 'dz', 'Sidi Hosni', 1, 'sidi-hosni'),
(500335, 782627, 'dz', 'Sougueur', 1, 'sougueur'),
(500336, 782627, 'dz', 'Tagdemt', 1, 'tagdemt'),
(500337, 782627, 'dz', 'Takhemaret', 1, 'takhemaret'),
(500338, 782627, 'dz', 'Tiaret', 1, 'tiaret'),
(500339, 782627, 'dz', 'Tidda', 1, 'tidda'),
(500340, 782627, 'dz', 'Tousnina', 1, 'tousnina'),
(500341, 782627, 'dz', 'Zmalet El Emir Abdelkader', 1, 'zmalet-el-emir-abdelkader');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782628, 'dz', 'Tizi Ouzou', 1, 'tizi-ouzou');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500342, 782628, 'dz', 'Tizi Ouzou', 1, 'tizi-ouzou'),
(500343, 782628, 'dz', 'Ain El Hammam', 1, 'ain-el-hammam'),
(500344, 782628, 'dz', 'Akbil', 1, 'akbil'),
(500345, 782628, 'dz', 'Freha', 1, 'freha'),
(500346, 782628, 'dz', 'Souamaâ', 1, 'souamaa'),
(500347, 782628, 'dz', 'Mechtras', 1, 'mechtras'),
(500348, 782628, 'dz', 'Irdjen', 1, 'irdjen'),
(500349, 782628, 'dz', 'Timizart', 1, 'timizart'),
(500350, 782628, 'dz', 'Makouda', 1, 'makouda'),
(500351, 782628, 'dz', 'Draâ El Mizan', 1, 'draa-el-mizan'),
(500352, 782628, 'dz', 'Tizi Gheniff', 1, 'tizi-gheniff'),
(500353, 782628, 'dz', 'Bounouh', 1, 'bounouh'),
(500354, 782628, 'dz', 'Aït Chafâa', 1, 'ait-chafaa'),
(500355, 782628, 'dz', 'Frikat', 1, 'frikat'),
(500356, 782628, 'dz', 'Beni Aïssi', 1, 'beni-aissi'),
(500357, 782628, 'dz', 'Beni Zmenzer', 1, 'beni-zmenzer'),
(500358, 782628, 'dz', 'Iferhounène', 1, 'iferhounene'),
(500359, 782628, 'dz', 'Azazga', 1, 'azazga'),
(500360, 782628, 'dz', 'Illoula Oumalou', 1, 'illoula-oumalou'),
(500361, 782628, 'dz', 'Yakouren', 1, 'yakouren'),
(500362, 782628, 'dz', 'Larbaâ Nath Irathen', 1, 'larbaa-nath-irathen'),
(500363, 782628, 'dz', 'Tizi Rached', 1, 'tizi-rached'),
(500364, 782628, 'dz', 'Zekri	3 286', 1, 'zekri-3-286'),
(500365, 782628, 'dz', 'Ouaguenoun', 1, 'ouaguenoun'),
(500366, 782628, 'dz', 'Aïn Zaouia', 1, 'ain-zaouia'),
(500367, 782628, 'dz', 'M\'Kira', 1, 'mkira'),
(500368, 782628, 'dz', 'Aït Yahia', 1, 'ait-yahia'),
(500369, 782628, 'dz', 'Aït Mahmoud', 1, 'ait-mahmoud'),
(500370, 782628, 'dz', 'Mâatkas	32 121', 1, 'maatkas-32-121'),
(500371, 782628, 'dz', 'Aït Boumahdi', 1, 'ait-boumahdi'),
(500372, 782628, 'dz', 'Abi Youcef', 1, 'abi-youcef'),
(500373, 782628, 'dz', 'Beni Douala', 1, 'beni-douala'),
(500374, 782628, 'dz', 'Illilten', 1, 'illilten'),
(500375, 782628, 'dz', 'Bouzguen', 1, 'bouzguen'),
(500376, 782628, 'dz', 'Aït Aggouacha', 1, 'ait-aggouacha'),
(500377, 782628, 'dz', 'Ouadhia	15 771', 1, 'ouadhia-15-771'),
(500378, 782628, 'dz', 'Azeffoun', 1, 'azeffoun'),
(500379, 782628, 'dz', 'Tigzirt', 1, 'tigzirt'),
(500380, 782628, 'dz', 'Djebel Aissa Mimoun', 1, 'djebel-aissa-mimoun'),
(500381, 782628, 'dz', 'Boghni', 1, 'boghni'),
(500382, 782628, 'dz', 'Ifigha', 1, 'ifigha'),
(500383, 782628, 'dz', 'Aït Oumalou', 1, 'ait-oumalou'),
(500384, 782628, 'dz', 'Tirmitine', 1, 'tirmitine'),
(500385, 782628, 'dz', 'Akerrou', 1, 'akerrou'),
(500386, 782628, 'dz', 'Yatafen', 1, 'yatafen'),
(500387, 782628, 'dz', 'Beni Ziki', 1, 'beni-ziki'),
(500388, 782628, 'dz', 'Draâ Ben Khedda', 1, 'draa-ben-khedda'),
(500389, 782628, 'dz', 'Ouacif', 1, 'ouacif'),
(500390, 782628, 'dz', 'Idjeur', 1, 'idjeur'),
(500391, 782628, 'dz', 'Mekla', 1, 'mekla'),
(500392, 782628, 'dz', 'Tizi N\'Tleta', 1, 'tizi-ntleta'),
(500393, 782628, 'dz', 'Beni Yenni', 1, 'beni-yenni'),
(500394, 782628, 'dz', 'Aghribs', 1, 'aghribs'),
(500395, 782628, 'dz', 'Iflissen', 1, 'iflissen'),
(500396, 782628, 'dz', 'Boudjima', 1, 'boudjima'),
(500397, 782628, 'dz', 'Aït Yahia Moussa', 1, 'ait-yahia-moussa'),
(500398, 782628, 'dz', 'Souk El Thenine', 1, 'souk-el-thenine'),
(500399, 782628, 'dz', 'Aït Khellili', 1, 'ait-khellili'),
(500400, 782628, 'dz', 'Sidi Namane', 1, 'sidi-namane'),
(500401, 782628, 'dz', 'Iboudraren', 1, 'iboudraren'),
(500402, 782628, 'dz', 'Agouni Gueghrane', 1, 'agouni-gueghrane'),
(500403, 782628, 'dz', 'Mizrana', 1, 'mizrana'),
(500404, 782628, 'dz', 'Imsouhel', 1, 'imsouhel'),
(500405, 782628, 'dz', 'Tadmaït', 1, 'tadmait'),
(500406, 782628, 'dz', 'Aït Bouadou', 1, 'ait-bouadou'),
(500407, 782628, 'dz', 'Assi Youcef', 1, 'assi-youcef'),
(500408, 782628, 'dz', 'Aït Toudert', 1, 'ait-toudert');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782629, 'dz', 'Alger', 1, 'alger');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500409, 782629, 'dz', 'Alger-Centre', 1, 'alger-centre'),
(500410, 782629, 'dz', 'Sidi M\'Hamed', 1, 'sidi-mhamed'),
(500411, 782629, 'dz', 'El Madania', 1, 'el-madania'),
(500412, 782629, 'dz', 'Belouizdad', 1, 'belouizdad'),
(500413, 782629, 'dz', 'Bab El Oued', 1, 'bab-el-oued'),
(500414, 782629, 'dz', 'Bologhine', 1, 'bologhine'),
(500415, 782629, 'dz', 'Casbah', 1, 'casbah'),
(500416, 782629, 'dz', 'Oued Koriche', 1, 'oued-koriche'),
(500417, 782629, 'dz', 'Bir Mourad Raïs', 1, 'bir-mourad-rais'),
(500418, 782629, 'dz', 'El Biar', 1, 'el-biar'),
(500419, 782629, 'dz', 'Bouzareah', 1, 'bouzareah'),
(500420, 782629, 'dz', 'Birkhadem', 1, 'birkhadem'),
(500421, 782629, 'dz', 'El Harrach', 1, 'el-harrach'),
(500422, 782629, 'dz', 'Baraki', 1, 'baraki'),
(500423, 782629, 'dz', 'Oued Smar', 1, 'oued-smar'),
(500424, 782629, 'dz', 'Bourouba', 1, 'bourouba'),
(500425, 782629, 'dz', 'Hussein Dey', 1, 'hussein-dey'),
(500426, 782629, 'dz', 'Kouba	7', 1, 'kouba-7'),
(500427, 782629, 'dz', 'Bachdjerrah', 1, 'bachdjerrah'),
(500428, 782629, 'dz', 'Dar El Beïda', 1, 'dar-el-beida'),
(500429, 782629, 'dz', 'Bab Ezzouar', 1, 'bab-ezzouar'),
(500430, 782629, 'dz', 'Ben Aknoun', 1, 'ben-aknoun'),
(500431, 782629, 'dz', 'Dely Ibrahim', 1, 'dely-ibrahim'),
(500432, 782629, 'dz', 'El Hammamet', 1, 'el-hammamet'),
(500433, 782629, 'dz', 'Raïs Hamidou', 1, 'rais-hamidou'),
(500434, 782629, 'dz', 'Djasr Kasentina', 1, 'djasr-kasentina'),
(500435, 782629, 'dz', 'El Mouradia', 1, 'el-mouradia'),
(500436, 782629, 'dz', 'Hydra', 1, 'hydra'),
(500437, 782629, 'dz', 'Mohammadia', 1, 'mohammadia'),
(500438, 782629, 'dz', 'Bordj El Kiffan', 1, 'bordj-el-kiffan'),
(500439, 782629, 'dz', 'El Magharia', 1, 'el-magharia'),
(500440, 782629, 'dz', 'Beni Messous', 1, 'beni-messous'),
(500441, 782629, 'dz', 'Les Eucalyptus', 1, 'les-eucalyptus'),
(500442, 782629, 'dz', 'Birtouta', 1, 'birtouta'),
(500443, 782629, 'dz', 'Tessala El Merdja', 1, 'tessala-el-merdja'),
(500444, 782629, 'dz', 'Ouled Chebel', 1, 'ouled-chebel'),
(500445, 782629, 'dz', 'Sidi Moussa', 1, 'sidi-moussa'),
(500446, 782629, 'dz', 'Aïn Taya', 1, 'ain-taya'),
(500447, 782629, 'dz', 'Bordj El Bahri', 1, 'bordj-el-bahri'),
(500448, 782629, 'dz', 'El Marsa', 1, 'el-marsa'),
(500449, 782629, 'dz', 'H\'raoua', 1, 'hraoua'),
(500450, 782629, 'dz', 'Rouïba', 1, 'rouiba'),
(500451, 782629, 'dz', 'Reghaïa', 1, 'reghaia'),
(500452, 782629, 'dz', 'Aïn Benian', 1, 'ain-benian'),
(500453, 782629, 'dz', 'Staoueli', 1, 'staoueli'),
(500454, 782629, 'dz', 'Zeralda', 1, 'zeralda'),
(500455, 782629, 'dz', 'Mahelma', 1, 'mahelma'),
(500456, 782629, 'dz', 'Rahmania', 1, 'rahmania'),
(500457, 782629, 'dz', 'Souidania', 1, 'souidania'),
(500458, 782629, 'dz', 'Cheraga', 1, 'cheraga'),
(500459, 782629, 'dz', 'Ouled Fayet', 1, 'ouled-fayet'),
(500460, 782629, 'dz', 'El Achour', 1, 'el-achour'),
(500461, 782629, 'dz', 'Draria', 1, 'draria'),
(500462, 782629, 'dz', 'Douera', 1, 'douera'),
(500463, 782629, 'dz', 'Baba Hassen', 1, 'baba-hassen'),
(500464, 782629, 'dz', 'Khraicia', 1, 'khraicia'),
(500465, 782629, 'dz', 'Saoula', 1, 'saoula');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782630, 'dz', 'Djelfa', 1, 'djelfa');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500466, 782630, 'dz', 'Aïn Chouhada', 1, 'ain-chouhada'),
(500467, 782630, 'dz', 'Aïn El Ibel', 1, 'ain-el-ibel'),
(500468, 782630, 'dz', 'Aïn Feka', 1, 'ain-feka'),
(500469, 782630, 'dz', 'Aïn Maabed', 1, 'ain-maabed'),
(500470, 782630, 'dz', 'Aïn Oussara', 1, 'ain-oussara'),
(500471, 782630, 'dz', 'Amourah', 1, 'amourah'),
(500472, 782630, 'dz', 'Benhar', 1, 'benhar'),
(500473, 782630, 'dz', 'Beni Yagoub', 1, 'beni-yagoub'),
(500474, 782630, 'dz', 'Birine', 1, 'birine'),
(500475, 782630, 'dz', 'Bouira Lahdab', 1, 'bouira-lahdab'),
(500476, 782630, 'dz', 'Charef', 1, 'charef'),
(500477, 782630, 'dz', 'Dar Chioukh', 1, 'dar-chioukh'),
(500478, 782630, 'dz', 'Deldoul', 1, 'deldoul'),
(500479, 782630, 'dz', 'Djelfa', 1, 'djelfa'),
(500480, 782630, 'dz', 'Douis', 1, 'douis'),
(500481, 782630, 'dz', 'El Guedid', 1, 'el-guedid'),
(500482, 782630, 'dz', 'El Idrissia', 1, 'el-idrissia'),
(500483, 782630, 'dz', 'El Khemis', 1, 'el-khemis'),
(500484, 782630, 'dz', 'Faidh El Botma', 1, 'faidh-el-botma'),
(500485, 782630, 'dz', 'Guernini', 1, 'guernini'),
(500486, 782630, 'dz', 'Guettara', 1, 'guettara'),
(500487, 782630, 'dz', 'Had-Sahary', 1, 'had-sahary'),
(500488, 782630, 'dz', 'Hassi Bahbah', 1, 'hassi-bahbah'),
(500489, 782630, 'dz', 'Hassi El Euch', 1, 'hassi-el-euch'),
(500490, 782630, 'dz', 'Hassi Fedoul', 1, 'hassi-fedoul'),
(500491, 782630, 'dz', 'Messaad', 1, 'messaad'),
(500492, 782630, 'dz', 'M\'Liliha', 1, 'mliliha'),
(500493, 782630, 'dz', 'Moudjebara', 1, 'moudjebara'),
(500494, 782630, 'dz', 'Oum Laadham', 1, 'oum-laadham'),
(500495, 782630, 'dz', 'Sed Rahal', 1, 'sed-rahal'),
(500496, 782630, 'dz', 'Selmana', 1, 'selmana'),
(500497, 782630, 'dz', 'Sidi Baizid', 1, 'sidi-baizid'),
(500498, 782630, 'dz', 'Sidi Ladjel', 1, 'sidi-ladjel'),
(500499, 782630, 'dz', 'Tadmit', 1, 'tadmit'),
(500500, 782630, 'dz', 'Zaafrane', 1, 'zaafrane'),
(500501, 782630, 'dz', 'Zaccar', 1, 'zaccar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782631, 'dz', 'Jijel', 1, 'jijel');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500502, 782631, 'dz', 'Jijel', 1, 'jijel'),
(500503, 782631, 'dz', 'Eraguene', 1, 'eraguene'),
(500504, 782631, 'dz', 'El Aouana', 1, 'el-aouana'),
(500505, 782631, 'dz', 'Ziama Mansouriah', 1, 'ziama-mansouriah'),
(500506, 782631, 'dz', 'Taher', 1, 'taher'),
(500507, 782631, 'dz', 'Emir Abdelkader', 1, 'emir-abdelkader'),
(500508, 782631, 'dz', 'Chekfa', 1, 'chekfa'),
(500509, 782631, 'dz', 'Chahna', 1, 'chahna'),
(500510, 782631, 'dz', 'El Milia', 1, 'el-milia'),
(500511, 782631, 'dz', 'Sidi Maarouf', 1, 'sidi-maarouf'),
(500512, 782631, 'dz', 'Settara', 1, 'settara'),
(500513, 782631, 'dz', 'El Ancer', 1, 'el-ancer'),
(500514, 782631, 'dz', 'Sidi Abdelaziz', 1, 'sidi-abdelaziz'),
(500515, 782631, 'dz', 'Kaous', 1, 'kaous'),
(500516, 782631, 'dz', 'Ghebala', 1, 'ghebala'),
(500517, 782631, 'dz', 'Bouraoui Belhadef', 1, 'bouraoui-belhadef'),
(500518, 782631, 'dz', 'Djimla', 1, 'djimla'),
(500519, 782631, 'dz', 'Selma Benziada', 1, 'selma-benziada'),
(500520, 782631, 'dz', 'Boucif Ouled Askeur', 1, 'boucif-ouled-askeur'),
(500521, 782631, 'dz', 'El Kennar Nouchfi', 1, 'el-kennar-nouchfi'),
(500522, 782631, 'dz', 'Ouled Yahia Khedrouche', 1, 'ouled-yahia-khedrouche'),
(500523, 782631, 'dz', 'Boudriaa Ben Yadjis', 1, 'boudriaa-ben-yadjis'),
(500524, 782631, 'dz', 'Kheïri Oued Adjoul', 1, 'kheiri-oued-adjoul'),
(500525, 782631, 'dz', 'Texenna	15 682', 1, 'texenna-15-682'),
(500526, 782631, 'dz', 'Djemaa Beni Habibi', 1, 'djemaa-beni-habibi'),
(500527, 782631, 'dz', 'Bordj Tahar', 1, 'bordj-tahar'),
(500528, 782631, 'dz', 'Ouled Rabah', 1, 'ouled-rabah'),
(500529, 782631, 'dz', 'Ouadjana', 1, 'ouadjana');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782632, 'dz', 'Sétif', 1, 'setif');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500530, 782632, 'dz', 'Aïn Abessa', 1, 'ain-abessa'),
(500531, 782632, 'dz', 'Aïn Arnat', 1, 'ain-arnat'),
(500532, 782632, 'dz', 'Aïn Azel', 1, 'ain-azel'),
(500533, 782632, 'dz', 'Aïn El Kebira', 1, 'ain-el-kebira'),
(500534, 782632, 'dz', 'Aïn Lahdjar', 1, 'ain-lahdjar'),
(500535, 782632, 'dz', 'Aïn Legraj', 1, 'ain-legraj'),
(500536, 782632, 'dz', 'Aïn Oulmene', 1, 'ain-oulmene'),
(500537, 782632, 'dz', 'Aïn Roua', 1, 'ain-roua'),
(500538, 782632, 'dz', 'Aïn Sebt', 1, 'ain-sebt'),
(500539, 782632, 'dz', 'Aït Naoual Mezada', 1, 'ait-naoual-mezada'),
(500540, 782632, 'dz', 'Aït Tizi', 1, 'ait-tizi'),
(500541, 782632, 'dz', 'Amoucha', 1, 'amoucha'),
(500542, 782632, 'dz', 'Babor', 1, 'babor'),
(500543, 782632, 'dz', 'Bazer Sakhra', 1, 'bazer-sakhra'),
(500544, 782632, 'dz', 'Beidha Bordj', 1, 'beidha-bordj'),
(500545, 782632, 'dz', 'Belaa', 1, 'belaa'),
(500546, 782632, 'dz', 'Beni Aziz', 1, 'beni-aziz'),
(500547, 782632, 'dz', 'Beni Chebana', 1, 'beni-chebana'),
(500548, 782632, 'dz', 'Beni Fouda', 1, 'beni-fouda'),
(500549, 782632, 'dz', 'Beni Hocine', 1, 'beni-hocine'),
(500550, 782632, 'dz', 'Beni Mouhli', 1, 'beni-mouhli'),
(500551, 782632, 'dz', 'Beni Ouartilene', 1, 'beni-ouartilene'),
(500552, 782632, 'dz', 'Bir El Arch', 1, 'bir-el-arch'),
(500553, 782632, 'dz', 'Bir Haddada', 1, 'bir-haddada'),
(500554, 782632, 'dz', 'Bouandas', 1, 'bouandas'),
(500555, 782632, 'dz', 'Bougaa', 1, 'bougaa'),
(500556, 782632, 'dz', 'Bousselam', 1, 'bousselam'),
(500557, 782632, 'dz', 'Boutaleb', 1, 'boutaleb'),
(500558, 782632, 'dz', 'Dehamcha', 1, 'dehamcha'),
(500559, 782632, 'dz', 'Djemila', 1, 'djemila'),
(500560, 782632, 'dz', 'Draa Kebila', 1, 'draa-kebila'),
(500561, 782632, 'dz', 'El Eulma', 1, 'el-eulma'),
(500562, 782632, 'dz', 'El Ouldja', 1, 'el-ouldja'),
(500563, 782632, 'dz', 'El Ouricia', 1, 'el-ouricia'),
(500564, 782632, 'dz', 'Guellal', 1, 'guellal'),
(500565, 782632, 'dz', 'Guelta Zerka', 1, 'guelta-zerka'),
(500566, 782632, 'dz', 'Guenzet', 1, 'guenzet'),
(500567, 782632, 'dz', 'Guidjel', 1, 'guidjel'),
(500568, 782632, 'dz', 'Hamma', 1, 'hamma'),
(500569, 782632, 'dz', 'Hammam Guergour', 1, 'hammam-guergour'),
(500570, 782632, 'dz', 'Hammam Soukhna', 1, 'hammam-soukhna'),
(500571, 782632, 'dz', 'Harbil', 1, 'harbil'),
(500572, 782632, 'dz', 'Ksar El Abtal', 1, 'ksar-el-abtal'),
(500573, 782632, 'dz', 'Maaouia', 1, 'maaouia'),
(500574, 782632, 'dz', 'Maoklane', 1, 'maoklane'),
(500575, 782632, 'dz', 'Mezloug', 1, 'mezloug'),
(500576, 782632, 'dz', 'Oued El Barad', 1, 'oued-el-barad'),
(500577, 782632, 'dz', 'Ouled Addouane', 1, 'ouled-addouane'),
(500578, 782632, 'dz', 'Ouled Sabor', 1, 'ouled-sabor'),
(500579, 782632, 'dz', 'Ouled Si Ahmed', 1, 'ouled-si-ahmed'),
(500580, 782632, 'dz', 'Ouled Tebben', 1, 'ouled-tebben'),
(500581, 782632, 'dz', 'Rasfa', 1, 'rasfa'),
(500582, 782632, 'dz', 'Salah Bey', 1, 'salah-bey'),
(500583, 782632, 'dz', 'Serdj El Ghoul', 1, 'serdj-el-ghoul'),
(500584, 782632, 'dz', 'Sétif', 1, 'setif'),
(500585, 782632, 'dz', 'Tachouda', 1, 'tachouda'),
(500586, 782632, 'dz', 'Talaifacene', 1, 'talaifacene'),
(500587, 782632, 'dz', 'Taya', 1, 'taya'),
(500588, 782632, 'dz', 'Tella', 1, 'tella'),
(500589, 782632, 'dz', 'Tizi N\'Bechar', 1, 'tizi-nbechar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782633, 'dz', 'Saïda', 1, 'saida');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500590, 782633, 'dz', 'Aïn El Hadjar', 1, 'ain-el-hadjar'),
(500591, 782633, 'dz', 'Aïn Sekhouna', 1, 'ain-sekhouna'),
(500592, 782633, 'dz', 'Aïn Soltane', 1, 'ain-soltane'),
(500593, 782633, 'dz', 'Doui Thabet', 1, 'doui-thabet'),
(500594, 782633, 'dz', 'El Hassasna', 1, 'el-hassasna'),
(500595, 782633, 'dz', 'Hounet', 1, 'hounet'),
(500596, 782633, 'dz', 'Maamora', 1, 'maamora'),
(500597, 782633, 'dz', 'Moulay Larbi', 1, 'moulay-larbi'),
(500598, 782633, 'dz', 'Ouled Brahim', 1, 'ouled-brahim'),
(500599, 782633, 'dz', 'Ouled Khaled', 1, 'ouled-khaled'),
(500600, 782633, 'dz', 'Saïda', 1, 'saida'),
(500601, 782633, 'dz', 'Sidi Ahmed', 1, 'sidi-ahmed'),
(500602, 782633, 'dz', 'Sidi Amar', 1, 'sidi-amar'),
(500603, 782633, 'dz', 'Sidi Boubekeur', 1, 'sidi-boubekeur'),
(500604, 782633, 'dz', 'Tircine', 1, 'tircine'),
(500605, 782633, 'dz', 'Youb', 1, 'youb');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782634, 'dz', 'Skikda', 1, 'skikda');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500606, 782634, 'dz', 'Aïn Bouziane', 1, 'ain-bouziane'),
(500607, 782634, 'dz', 'Aïn Charchar', 1, 'ain-charchar'),
(500608, 782634, 'dz', 'Aïn Kechra', 1, 'ain-kechra'),
(500609, 782634, 'dz', 'Aïn Zouit', 1, 'ain-zouit'),
(500610, 782634, 'dz', 'Azzaba', 1, 'azzaba'),
(500611, 782634, 'dz', 'Bekkouche Lakhdar', 1, 'bekkouche-lakhdar'),
(500612, 782634, 'dz', 'Bin El Ouiden', 1, 'bin-el-ouiden'),
(500613, 782634, 'dz', 'Ben Azzouz', 1, 'ben-azzouz'),
(500614, 782634, 'dz', 'Beni Bechir', 1, 'beni-bechir'),
(500615, 782634, 'dz', 'Beni Oulbane', 1, 'beni-oulbane'),
(500616, 782634, 'dz', 'Beni Zid', 1, 'beni-zid'),
(500617, 782634, 'dz', 'Bouchtata', 1, 'bouchtata'),
(500618, 782634, 'dz', 'Cheraia', 1, 'cheraia'),
(500619, 782634, 'dz', 'Collo', 1, 'collo'),
(500620, 782634, 'dz', 'Djendel Saadi Mohamed', 1, 'djendel-saadi-mohamed'),
(500621, 782634, 'dz', 'El Ghedir', 1, 'el-ghedir'),
(500622, 782634, 'dz', 'El Hadaiek', 1, 'el-hadaiek'),
(500623, 782634, 'dz', 'El Harrouch', 1, 'el-harrouch'),
(500624, 782634, 'dz', 'El Marsa', 1, 'el-marsa'),
(500625, 782634, 'dz', 'Emdjez Edchich', 1, 'emdjez-edchich'),
(500626, 782634, 'dz', 'Es Sebt', 1, 'es-sebt'),
(500627, 782634, 'dz', 'Filfila', 1, 'filfila'),
(500628, 782634, 'dz', 'Hamadi Krouma', 1, 'hamadi-krouma'),
(500629, 782634, 'dz', 'Kanoua', 1, 'kanoua'),
(500630, 782634, 'dz', 'Kerkera', 1, 'kerkera'),
(500631, 782634, 'dz', 'Kheneg Mayoum', 1, 'kheneg-mayoum'),
(500632, 782634, 'dz', 'Oued Zehour', 1, 'oued-zehour'),
(500633, 782634, 'dz', 'Ouldja Boulballout', 1, 'ouldja-boulballout'),
(500634, 782634, 'dz', 'Ouled Attia', 1, 'ouled-attia'),
(500635, 782634, 'dz', 'Ouled Hbaba', 1, 'ouled-hbaba'),
(500636, 782634, 'dz', 'Oum Toub', 1, 'oum-toub'),
(500637, 782634, 'dz', 'Ramdane Djamel', 1, 'ramdane-djamel'),
(500638, 782634, 'dz', 'Salah Bouchaour', 1, 'salah-bouchaour'),
(500639, 782634, 'dz', 'Sidi Mezghiche', 1, 'sidi-mezghiche'),
(500640, 782634, 'dz', 'Skikda', 1, 'skikda'),
(500641, 782634, 'dz', 'Tamalous', 1, 'tamalous'),
(500642, 782634, 'dz', 'Zerdaza', 1, 'zerdaza'),
(500643, 782634, 'dz', 'Zitouna', 1, 'zitouna');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782635, 'dz', 'Sidi Bel Abbes', 1, 'sidi-bel-abbes');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500644, 782635, 'dz', 'Aïn Adden', 1, 'ain-adden'),
(500645, 782635, 'dz', 'Aïn El Berd', 1, 'ain-el-berd'),
(500646, 782635, 'dz', 'Aïn Kada', 1, 'ain-kada'),
(500647, 782635, 'dz', 'Aïn Thrid', 1, 'ain-thrid'),
(500648, 782635, 'dz', 'Aïn Tindamine', 1, 'ain-tindamine'),
(500649, 782635, 'dz', 'Amarnas', 1, 'amarnas'),
(500650, 782635, 'dz', 'Badredine El Mokrani', 1, 'badredine-el-mokrani'),
(500651, 782635, 'dz', 'Belarbi	22255', 1, 'belarbi-22255'),
(500652, 782635, 'dz', 'Ben Badis', 1, 'ben-badis'),
(500653, 782635, 'dz', 'Benachiba Chelia', 1, 'benachiba-chelia'),
(500654, 782635, 'dz', 'Bir El Hammam', 1, 'bir-el-hammam'),
(500655, 782635, 'dz', 'Boudjebaa El Bordj', 1, 'boudjebaa-el-bordj'),
(500656, 782635, 'dz', 'Boukhanafis', 1, 'boukhanafis'),
(500657, 782635, 'dz', 'Chettouane Belaila', 1, 'chettouane-belaila'),
(500658, 782635, 'dz', 'Dhaya', 1, 'dhaya'),
(500659, 782635, 'dz', 'El Haçaiba', 1, 'el-hacaiba'),
(500660, 782635, 'dz', 'Hassi Dahou', 1, 'hassi-dahou'),
(500661, 782635, 'dz', 'Hassi Zehana', 1, 'hassi-zehana'),
(500662, 782635, 'dz', 'Lamtar', 1, 'lamtar'),
(500663, 782635, 'dz', 'Makedra', 1, 'makedra'),
(500664, 782635, 'dz', 'Marhoum', 1, 'marhoum'),
(500665, 782635, 'dz', 'M\'Cid', 1, 'mcid'),
(500666, 782635, 'dz', 'Merine', 1, 'merine'),
(500667, 782635, 'dz', 'Mezaourou', 1, 'mezaourou'),
(500668, 782635, 'dz', 'Mostefa Ben Brahim', 1, 'mostefa-ben-brahim'),
(500669, 782635, 'dz', 'Moulay Slissen', 1, 'moulay-slissen'),
(500670, 782635, 'dz', 'Oued Sebaa', 1, 'oued-sebaa'),
(500671, 782635, 'dz', 'Oued Sefioun', 1, 'oued-sefioun'),
(500672, 782635, 'dz', 'Oued Taourira', 1, 'oued-taourira'),
(500673, 782635, 'dz', 'Ras El Ma', 1, 'ras-el-ma'),
(500674, 782635, 'dz', 'Redjem Demouche', 1, 'redjem-demouche'),
(500675, 782635, 'dz', 'Sehala Thaoura', 1, 'sehala-thaoura'),
(500676, 782635, 'dz', 'Sfisef', 1, 'sfisef'),
(500677, 782635, 'dz', 'Sidi Ali Benyoub', 1, 'sidi-ali-benyoub'),
(500678, 782635, 'dz', 'Sidi Ali Boussidi', 1, 'sidi-ali-boussidi'),
(500679, 782635, 'dz', 'Sidi Bel Abbes', 1, 'sidi-bel-abbes'),
(500680, 782635, 'dz', 'Sidi Brahim', 1, 'sidi-brahim'),
(500681, 782635, 'dz', 'Sidi Chaib', 1, 'sidi-chaib'),
(500682, 782635, 'dz', 'Sidi Dahou de Zairs', 1, 'sidi-dahou-de-zairs'),
(500683, 782635, 'dz', 'Sidi Hamadouche', 1, 'sidi-hamadouche'),
(500684, 782635, 'dz', 'Sidi Khaled', 1, 'sidi-khaled'),
(500685, 782635, 'dz', 'Sidi Lahcene', 1, 'sidi-lahcene'),
(500686, 782635, 'dz', 'Sidi Yacoub', 1, 'sidi-yacoub'),
(500687, 782635, 'dz', 'Tabia', 1, 'tabia'),
(500688, 782635, 'dz', 'Tafissour', 1, 'tafissour'),
(500689, 782635, 'dz', 'Taoudmout', 1, 'taoudmout'),
(500690, 782635, 'dz', 'Teghalimet', 1, 'teghalimet'),
(500691, 782635, 'dz', 'Telagh', 1, 'telagh'),
(500692, 782635, 'dz', 'Tenira', 1, 'tenira'),
(500693, 782635, 'dz', 'Tessala', 1, 'tessala'),
(500694, 782635, 'dz', 'Tilmouni', 1, 'tilmouni'),
(500695, 782635, 'dz', 'Zerouala', 1, 'zerouala');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782636, 'dz', 'Annaba', 1, 'annaba');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500696, 782636, 'dz', 'Annaba', 1, 'annaba'),
(500697, 782636, 'dz', 'Barrahel', 1, 'barrahel'),
(500698, 782636, 'dz', 'El Hadjar', 1, 'el-hadjar'),
(500699, 782636, 'dz', 'Eulma', 1, 'eulma'),
(500700, 782636, 'dz', 'El Bouni', 1, 'el-bouni'),
(500701, 782636, 'dz', 'Oued El Aneb', 1, 'oued-el-aneb'),
(500702, 782636, 'dz', 'Cheurfa', 1, 'cheurfa'),
(500703, 782636, 'dz', 'Seraïdi', 1, 'seraidi'),
(500704, 782636, 'dz', 'Aïn Berda', 1, 'ain-berda'),
(500705, 782636, 'dz', 'Chetaïbi', 1, 'chetaibi'),
(500706, 782636, 'dz', 'Sidi Amar', 1, 'sidi-amar'),
(500707, 782636, 'dz', 'Treat', 1, 'treat');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782637, 'dz', 'Guelma', 1, 'guelma');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500708, 782637, 'dz', 'Aïn Ben Beida', 1, 'ain-ben-beida'),
(500709, 782637, 'dz', 'Aïn Larbi', 1, 'ain-larbi'),
(500710, 782637, 'dz', 'Aïn Makhlouf', 1, 'ain-makhlouf'),
(500711, 782637, 'dz', 'Aïn Reggada', 1, 'ain-reggada'),
(500712, 782637, 'dz', 'Aïn Sandel', 1, 'ain-sandel'),
(500713, 782637, 'dz', 'Belkheir', 1, 'belkheir'),
(500714, 782637, 'dz', 'Ben Djerrah', 1, 'ben-djerrah'),
(500715, 782637, 'dz', 'Beni Mezline', 1, 'beni-mezline'),
(500716, 782637, 'dz', 'Bordj Sabat', 1, 'bordj-sabat'),
(500717, 782637, 'dz', 'Bouhachana', 1, 'bouhachana'),
(500718, 782637, 'dz', 'Bouhamdane', 1, 'bouhamdane'),
(500719, 782637, 'dz', 'Bouati Mahmoud', 1, 'bouati-mahmoud'),
(500720, 782637, 'dz', 'Bouchegouf', 1, 'bouchegouf'),
(500721, 782637, 'dz', 'Boumahra Ahmed', 1, 'boumahra-ahmed'),
(500722, 782637, 'dz', 'Dahouara', 1, 'dahouara'),
(500723, 782637, 'dz', 'Djeballah Khemissi', 1, 'djeballah-khemissi'),
(500724, 782637, 'dz', 'El Fedjoudj', 1, 'el-fedjoudj'),
(500725, 782637, 'dz', 'Guellat Bou Sbaa', 1, 'guellat-bou-sbaa'),
(500726, 782637, 'dz', 'Guelma', 1, 'guelma'),
(500727, 782637, 'dz', 'Hammam Debagh', 1, 'hammam-debagh'),
(500728, 782637, 'dz', 'Hammam N\'Bail', 1, 'hammam-nbail'),
(500729, 782637, 'dz', 'Héliopolis', 1, 'heliopolis'),
(500730, 782637, 'dz', 'Houari Boumédiène', 1, 'houari-boumediene'),
(500731, 782637, 'dz', 'Khezarra', 1, 'khezarra'),
(500732, 782637, 'dz', 'Medjez Amar', 1, 'medjez-amar'),
(500733, 782637, 'dz', 'Medjez Sfa', 1, 'medjez-sfa'),
(500734, 782637, 'dz', 'Nechmaya', 1, 'nechmaya'),
(500735, 782637, 'dz', 'Oued Cheham', 1, 'oued-cheham'),
(500736, 782637, 'dz', 'Oued Fragha', 1, 'oued-fragha'),
(500737, 782637, 'dz', 'Oued Zenati', 1, 'oued-zenati'),
(500738, 782637, 'dz', 'Ras El Agba', 1, 'ras-el-agba'),
(500739, 782637, 'dz', 'Roknia', 1, 'roknia'),
(500740, 782637, 'dz', 'Sellaoua Announa', 1, 'sellaoua-announa'),
(500741, 782637, 'dz', 'Tamlouka', 1, 'tamlouka');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782638, 'dz', 'Constantine', 1, 'constantine');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500742, 782638, 'dz', 'Aïn Abid', 1, 'ain-abid'),
(500743, 782638, 'dz', 'Aïn Smara', 1, 'ain-smara'),
(500744, 782638, 'dz', 'Beni Hamiden', 1, 'beni-hamiden'),
(500745, 782638, 'dz', 'Constantine', 1, 'constantine'),
(500746, 782638, 'dz', 'Didouche Mourad', 1, 'didouche-mourad'),
(500747, 782638, 'dz', 'El Khroub', 1, 'el-khroub'),
(500748, 782638, 'dz', 'Hamma Bouziane', 1, 'hamma-bouziane'),
(500749, 782638, 'dz', 'Ibn Badis', 1, 'ibn-badis'),
(500750, 782638, 'dz', 'Ibn Ziad', 1, 'ibn-ziad'),
(500751, 782638, 'dz', 'Messaoud Boudjriou', 1, 'messaoud-boudjriou'),
(500752, 782638, 'dz', 'Ouled Rahmoune', 1, 'ouled-rahmoune'),
(500753, 782638, 'dz', 'Zighoud Youcef', 1, 'zighoud-youcef');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782639, 'dz', 'Médéa', 1, 'medea');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500754, 782639, 'dz', 'Aïn Boucif', 1, 'ain-boucif'),
(500755, 782639, 'dz', 'Aïn Ouksir', 1, 'ain-ouksir'),
(500756, 782639, 'dz', 'Aissaouia', 1, 'aissaouia'),
(500757, 782639, 'dz', 'Aziz', 1, 'aziz'),
(500758, 782639, 'dz', 'Baata', 1, 'baata'),
(500759, 782639, 'dz', 'Benchicao', 1, 'benchicao'),
(500760, 782639, 'dz', 'Beni Slimane', 1, 'beni-slimane'),
(500761, 782639, 'dz', 'Berrouaghia', 1, 'berrouaghia'),
(500762, 782639, 'dz', 'Bir Ben Laabed', 1, 'bir-ben-laabed'),
(500763, 782639, 'dz', 'Boghar', 1, 'boghar'),
(500764, 782639, 'dz', 'Bou Aiche', 1, 'bou-aiche'),
(500765, 782639, 'dz', 'Bouaichoune', 1, 'bouaichoune'),
(500766, 782639, 'dz', 'Bouchrahil', 1, 'bouchrahil'),
(500767, 782639, 'dz', 'Boughezoul', 1, 'boughezoul'),
(500768, 782639, 'dz', 'Bouskene', 1, 'bouskene'),
(500769, 782639, 'dz', 'Chahbounia', 1, 'chahbounia'),
(500770, 782639, 'dz', 'Chellalet El Adhaoura', 1, 'chellalet-el-adhaoura'),
(500771, 782639, 'dz', 'Cheniguel', 1, 'cheniguel'),
(500772, 782639, 'dz', 'Derrag', 1, 'derrag'),
(500773, 782639, 'dz', 'Deux Bassins', 1, 'deux-bassins'),
(500774, 782639, 'dz', 'Djouab', 1, 'djouab'),
(500775, 782639, 'dz', 'Draa Essamar', 1, 'draa-essamar'),
(500776, 782639, 'dz', 'El Azizia', 1, 'el-azizia'),
(500777, 782639, 'dz', 'El Guelb El Kebir', 1, 'el-guelb-el-kebir'),
(500778, 782639, 'dz', 'El Hamdania', 1, 'el-hamdania'),
(500779, 782639, 'dz', 'El Omaria', 1, 'el-omaria'),
(500780, 782639, 'dz', 'El Ouinet', 1, 'el-ouinet'),
(500781, 782639, 'dz', 'Hannacha', 1, 'hannacha'),
(500782, 782639, 'dz', 'Kef Lakhdar', 1, 'kef-lakhdar'),
(500783, 782639, 'dz', 'Khams Djouamaa', 1, 'khams-djouamaa'),
(500784, 782639, 'dz', 'Ksar Boukhari', 1, 'ksar-boukhari'),
(500785, 782639, 'dz', 'Meghraoua', 1, 'meghraoua'),
(500786, 782639, 'dz', 'Médéa', 1, 'medea'),
(500787, 782639, 'dz', 'Moudjbar', 1, 'moudjbar'),
(500788, 782639, 'dz', 'Meftaha', 1, 'meftaha'),
(500789, 782639, 'dz', 'Mezerana', 1, 'mezerana'),
(500790, 782639, 'dz', 'Mihoub', 1, 'mihoub'),
(500791, 782639, 'dz', 'Ouamri', 1, 'ouamri'),
(500792, 782639, 'dz', 'Oued Harbil', 1, 'oued-harbil'),
(500793, 782639, 'dz', 'Ouled Antar', 1, 'ouled-antar'),
(500794, 782639, 'dz', 'Ouled Bouachra', 1, 'ouled-bouachra'),
(500795, 782639, 'dz', 'Ouled Brahim', 1, 'ouled-brahim'),
(500796, 782639, 'dz', 'Ouled Deide', 1, 'ouled-deide'),
(500797, 782639, 'dz', 'Ouled Hellal', 1, 'ouled-hellal'),
(500798, 782639, 'dz', 'Ouled Maaref', 1, 'ouled-maaref'),
(500799, 782639, 'dz', 'Oum El Djalil', 1, 'oum-el-djalil'),
(500800, 782639, 'dz', 'Ouzera', 1, 'ouzera'),
(500801, 782639, 'dz', 'Rebaia', 1, 'rebaia'),
(500802, 782639, 'dz', 'Saneg', 1, 'saneg'),
(500803, 782639, 'dz', 'Sedraia', 1, 'sedraia'),
(500804, 782639, 'dz', 'Seghouane', 1, 'seghouane'),
(500805, 782639, 'dz', 'Si Mahdjoub', 1, 'si-mahdjoub'),
(500806, 782639, 'dz', 'Sidi Damed', 1, 'sidi-damed'),
(500807, 782639, 'dz', 'Sidi Errabia', 1, 'sidi-errabia'),
(500808, 782639, 'dz', 'Sidi Naamane', 1, 'sidi-naamane'),
(500809, 782639, 'dz', 'Sidi Zahar', 1, 'sidi-zahar'),
(500810, 782639, 'dz', 'Sidi Ziane', 1, 'sidi-ziane'),
(500811, 782639, 'dz', 'Souagui', 1, 'souagui'),
(500812, 782639, 'dz', 'Tablat', 1, 'tablat'),
(500813, 782639, 'dz', 'Tafraout', 1, 'tafraout'),
(500814, 782639, 'dz', 'Tamesguida', 1, 'tamesguida'),
(500815, 782639, 'dz', 'Tizi Mahdi', 1, 'tizi-mahdi'),
(500816, 782639, 'dz', 'Tlatet Eddouar', 1, 'tlatet-eddouar'),
(500817, 782639, 'dz', 'Zoubiria', 1, 'zoubiria');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782640, 'dz', 'Mostaganem', 1, 'mostaganem');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500818, 782640, 'dz', 'Abdelmalek Ramdane', 1, 'abdelmalek-ramdane'),
(500819, 782640, 'dz', 'Achaacha', 1, 'achaacha'),
(500820, 782640, 'dz', 'Aïn Boudinar', 1, 'ain-boudinar'),
(500821, 782640, 'dz', 'Aïn Nouïssy', 1, 'ain-nouissy'),
(500822, 782640, 'dz', 'Aïn Sidi Cherif', 1, 'ain-sidi-cherif'),
(500823, 782640, 'dz', 'Aïn Tedles', 1, 'ain-tedles'),
(500824, 782640, 'dz', 'Blad Touahria', 1, 'blad-touahria'),
(500825, 782640, 'dz', 'Bouguirat', 1, 'bouguirat'),
(500826, 782640, 'dz', 'El Hassaine', 1, 'el-hassaine'),
(500827, 782640, 'dz', 'Fornaka', 1, 'fornaka'),
(500828, 782640, 'dz', 'Hadjadj', 1, 'hadjadj'),
(500829, 782640, 'dz', 'Hassi Mameche', 1, 'hassi-mameche'),
(500830, 782640, 'dz', 'Khadra', 1, 'khadra'),
(500831, 782640, 'dz', 'Kheireddine', 1, 'kheireddine'),
(500832, 782640, 'dz', 'Mansourah', 1, 'mansourah'),
(500833, 782640, 'dz', 'Mesra', 1, 'mesra'),
(500834, 782640, 'dz', 'Mazagran', 1, 'mazagran'),
(500835, 782640, 'dz', 'Mostaganem', 1, 'mostaganem'),
(500836, 782640, 'dz', 'Nekmaria', 1, 'nekmaria'),
(500837, 782640, 'dz', 'Oued El Kheir', 1, 'oued-el-kheir'),
(500838, 782640, 'dz', 'Ouled Boughalem', 1, 'ouled-boughalem'),
(500839, 782640, 'dz', 'Ouled Maallah', 1, 'ouled-maallah'),
(500840, 782640, 'dz', 'Safsaf', 1, 'safsaf'),
(500841, 782640, 'dz', 'Sayada', 1, 'sayada'),
(500842, 782640, 'dz', 'Sidi Ali', 1, 'sidi-ali'),
(500843, 782640, 'dz', 'Sidi Belattar', 1, 'sidi-belattar'),
(500844, 782640, 'dz', 'Sidi Lakhdar', 1, 'sidi-lakhdar'),
(500845, 782640, 'dz', 'Sirat', 1, 'sirat'),
(500846, 782640, 'dz', 'Souaflia', 1, 'souaflia'),
(500847, 782640, 'dz', 'Sour', 1, 'sour'),
(500848, 782640, 'dz', 'Stidia', 1, 'stidia'),
(500849, 782640, 'dz', 'Tazgait', 1, 'tazgait');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782641, 'dz', 'M\'Sila', 1, 'msila');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500850, 782641, 'dz', 'Aïn El Hadjel', 1, 'ain-el-hadjel'),
(500851, 782641, 'dz', 'Aïn El Melh', 1, 'ain-el-melh'),
(500852, 782641, 'dz', 'Aïn Errich', 1, 'ain-errich'),
(500853, 782641, 'dz', 'Aïn Fares', 1, 'ain-fares'),
(500854, 782641, 'dz', 'Aïn Khadra', 1, 'ain-khadra'),
(500855, 782641, 'dz', 'Belaiba', 1, 'belaiba'),
(500856, 782641, 'dz', 'Ben Srour', 1, 'ben-srour'),
(500857, 782641, 'dz', 'Beni Ilmane', 1, 'beni-ilmane'),
(500858, 782641, 'dz', 'Benzouh', 1, 'benzouh'),
(500859, 782641, 'dz', 'Berhoum', 1, 'berhoum'),
(500860, 782641, 'dz', 'Bir Foda', 1, 'bir-foda'),
(500861, 782641, 'dz', 'Bou-Saâda', 1, 'bou-saada'),
(500862, 782641, 'dz', 'Bouti Sayah', 1, 'bouti-sayah'),
(500863, 782641, 'dz', 'Chellal', 1, 'chellal'),
(500864, 782641, 'dz', 'Dehahna', 1, 'dehahna'),
(500865, 782641, 'dz', 'Djebel Messaad', 1, 'djebel-messaad'),
(500866, 782641, 'dz', 'El Hamel', 1, 'el-hamel'),
(500867, 782641, 'dz', 'El Houamed', 1, 'el-houamed'),
(500868, 782641, 'dz', 'Hammam Dhalaa', 1, 'hammam-dhalaa'),
(500869, 782641, 'dz', 'Khettouti Sed El Djir', 1, 'khettouti-sed-el-djir'),
(500870, 782641, 'dz', 'Khoubana', 1, 'khoubana'),
(500871, 782641, 'dz', 'Maadid', 1, 'maadid'),
(500872, 782641, 'dz', 'Maarif', 1, 'maarif'),
(500873, 782641, 'dz', 'Magra', 1, 'magra'),
(500874, 782641, 'dz', 'M\'Cif', 1, 'mcif'),
(500875, 782641, 'dz', 'Medjedel', 1, 'medjedel'),
(500876, 782641, 'dz', 'M\'Sila', 1, 'msila'),
(500877, 782641, 'dz', 'M\'Tarfa', 1, 'mtarfa'),
(500878, 782641, 'dz', 'Ouanougha', 1, 'ouanougha'),
(500879, 782641, 'dz', 'Ouled Addi Guebala', 1, 'ouled-addi-guebala'),
(500880, 782641, 'dz', 'Ouled Atia', 1, 'ouled-atia'),
(500881, 782641, 'dz', 'Oued Chair', 1, 'oued-chair'),
(500882, 782641, 'dz', 'Ouled Derradj', 1, 'ouled-derradj'),
(500883, 782641, 'dz', 'Ouled Madhi', 1, 'ouled-madhi'),
(500884, 782641, 'dz', 'Ouled Mansour', 1, 'ouled-mansour'),
(500885, 782641, 'dz', 'Ouled Sidi Brahim', 1, 'ouled-sidi-brahim'),
(500886, 782641, 'dz', 'Ouled Slimane', 1, 'ouled-slimane'),
(500887, 782641, 'dz', 'Oultem', 1, 'oultem'),
(500888, 782641, 'dz', 'Sidi Aïssa', 1, 'sidi-aissa'),
(500889, 782641, 'dz', 'Sidi Ameur', 1, 'sidi-ameur'),
(500890, 782641, 'dz', 'Sidi Hadjeres', 1, 'sidi-hadjeres'),
(500891, 782641, 'dz', 'Sidi M\'Hamed', 1, 'sidi-mhamed'),
(500892, 782641, 'dz', 'Slim', 1, 'slim'),
(500893, 782641, 'dz', 'Souamaa', 1, 'souamaa'),
(500894, 782641, 'dz', 'Tamsa', 1, 'tamsa'),
(500895, 782641, 'dz', 'Tarmount', 1, 'tarmount'),
(500896, 782641, 'dz', 'Zarzour', 1, 'zarzour');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782642, 'dz', 'Mascara', 1, 'mascara');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500897, 782642, 'dz', 'Aïn Fares', 1, 'ain-fares'),
(500898, 782642, 'dz', 'Aïn Fekan', 1, 'ain-fekan'),
(500899, 782642, 'dz', 'Aïn Ferah', 1, 'ain-ferah'),
(500900, 782642, 'dz', 'Aïn Fras', 1, 'ain-fras'),
(500901, 782642, 'dz', 'Alaimia', 1, 'alaimia'),
(500902, 782642, 'dz', 'Aouf', 1, 'aouf'),
(500903, 782642, 'dz', 'Beniane', 1, 'beniane'),
(500904, 782642, 'dz', 'Bou Hanifia', 1, 'bou-hanifia'),
(500905, 782642, 'dz', 'Bou Henni', 1, 'bou-henni'),
(500906, 782642, 'dz', 'Chorfa', 1, 'chorfa'),
(500907, 782642, 'dz', 'El Bordj', 1, 'el-bordj'),
(500908, 782642, 'dz', 'El Gaada', 1, 'el-gaada'),
(500909, 782642, 'dz', 'El Ghomri', 1, 'el-ghomri'),
(500910, 782642, 'dz', 'El Guettana', 1, 'el-guettana'),
(500911, 782642, 'dz', 'El Keurt', 1, 'el-keurt'),
(500912, 782642, 'dz', 'El Menaouer', 1, 'el-menaouer'),
(500913, 782642, 'dz', 'Ferraguig', 1, 'ferraguig'),
(500914, 782642, 'dz', 'Froha', 1, 'froha'),
(500915, 782642, 'dz', 'Gharrous', 1, 'gharrous'),
(500916, 782642, 'dz', 'Guerdjoum', 1, 'guerdjoum'),
(500917, 782642, 'dz', 'Ghriss', 1, 'ghriss'),
(500918, 782642, 'dz', 'Hachem', 1, 'hachem'),
(500919, 782642, 'dz', 'Hacine', 1, 'hacine'),
(500920, 782642, 'dz', 'Khalouia', 1, 'khalouia'),
(500921, 782642, 'dz', 'Makdha', 1, 'makdha'),
(500922, 782642, 'dz', 'Mamounia', 1, 'mamounia'),
(500923, 782642, 'dz', 'Maoussa', 1, 'maoussa'),
(500924, 782642, 'dz', 'Mascara', 1, 'mascara'),
(500925, 782642, 'dz', 'Matemore', 1, 'matemore'),
(500926, 782642, 'dz', 'Mocta Douz', 1, 'mocta-douz'),
(500927, 782642, 'dz', 'Mohammadia', 1, 'mohammadia'),
(500928, 782642, 'dz', 'Nesmoth', 1, 'nesmoth'),
(500929, 782642, 'dz', 'Oggaz', 1, 'oggaz'),
(500930, 782642, 'dz', 'Oued El Abtal', 1, 'oued-el-abtal'),
(500931, 782642, 'dz', 'Oued Taria', 1, 'oued-taria'),
(500932, 782642, 'dz', 'Ras Ain Amirouche', 1, 'ras-ain-amirouche'),
(500933, 782642, 'dz', 'Sedjerara', 1, 'sedjerara'),
(500934, 782642, 'dz', 'Sehailia', 1, 'sehailia'),
(500935, 782642, 'dz', 'Sidi Abdeldjebar', 1, 'sidi-abdeldjebar'),
(500936, 782642, 'dz', 'Sidi Abdelmoumen', 1, 'sidi-abdelmoumen'),
(500937, 782642, 'dz', 'Sidi Kada', 1, 'sidi-kada'),
(500938, 782642, 'dz', 'Sidi Boussaid', 1, 'sidi-boussaid'),
(500939, 782642, 'dz', 'Sig', 1, 'sig'),
(500940, 782642, 'dz', 'Tighennif', 1, 'tighennif'),
(500941, 782642, 'dz', 'Tizi', 1, 'tizi'),
(500942, 782642, 'dz', 'Zahana', 1, 'zahana'),
(500943, 782642, 'dz', 'Zelmata', 1, 'zelmata');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782643, 'dz', 'Ouargla', 1, 'ouargla');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500944, 782643, 'dz', 'Aïn Beida', 1, 'ain-beida'),
(500945, 782643, 'dz', 'Benaceur', 1, 'benaceur'),
(500946, 782643, 'dz', 'Blidet Amor', 1, 'blidet-amor'),
(500947, 782643, 'dz', 'El Allia', 1, 'el-allia'),
(500948, 782643, 'dz', 'El Borma', 1, 'el-borma'),
(500949, 782643, 'dz', 'El Hadjira', 1, 'el-hadjira'),
(500950, 782643, 'dz', 'Hassi Ben Abdellah', 1, 'hassi-ben-abdellah'),
(500951, 782643, 'dz', 'Hassi Messaoud', 1, 'hassi-messaoud'),
(500952, 782643, 'dz', 'Megarine', 1, 'megarine'),
(500953, 782643, 'dz', 'M\'Naguer', 1, 'mnaguer'),
(500954, 782643, 'dz', 'Nezla', 1, 'nezla'),
(500955, 782643, 'dz', 'N\'Goussa', 1, 'ngoussa'),
(500956, 782643, 'dz', 'Ouargla', 1, 'ouargla'),
(500957, 782643, 'dz', 'Rouissat', 1, 'rouissat'),
(500958, 782643, 'dz', 'Sidi Khouiled', 1, 'sidi-khouiled'),
(500959, 782643, 'dz', 'Sidi Slimane', 1, 'sidi-slimane'),
(500960, 782643, 'dz', 'Taibet', 1, 'taibet'),
(500961, 782643, 'dz', 'Tamacine', 1, 'tamacine'),
(500962, 782643, 'dz', 'Tebesbest', 1, 'tebesbest'),
(500963, 782643, 'dz', 'Touggourt', 1, 'touggourt'),
(500964, 782643, 'dz', 'Zaouia El Abidia', 1, 'zaouia-el-abidia');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782644, 'dz', 'Oran', 1, 'oran');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500965, 782644, 'dz', 'Oran', 1, 'oran'),
(500966, 782644, 'dz', 'Gdyel', 1, 'gdyel'),
(500967, 782644, 'dz', 'Bir El Djir', 1, 'bir-el-djir'),
(500968, 782644, 'dz', 'Hassi Bounif', 1, 'hassi-bounif'),
(500969, 782644, 'dz', 'Es Senia', 1, 'es-senia'),
(500970, 782644, 'dz', 'Arzew', 1, 'arzew'),
(500971, 782644, 'dz', 'Bethioua', 1, 'bethioua'),
(500972, 782644, 'dz', 'Marsat El Hadjadj', 1, 'marsat-el-hadjadj'),
(500973, 782644, 'dz', 'Aïn El Turk', 1, 'ain-el-turk'),
(500974, 782644, 'dz', 'El Ançor', 1, 'el-ancor'),
(500975, 782644, 'dz', 'Oued Tlelat', 1, 'oued-tlelat'),
(500976, 782644, 'dz', 'Tafraoui', 1, 'tafraoui'),
(500977, 782644, 'dz', 'Sidi Chami', 1, 'sidi-chami'),
(500978, 782644, 'dz', 'Boufatis', 1, 'boufatis'),
(500979, 782644, 'dz', 'Mers El Kébir', 1, 'mers-el-kebir'),
(500980, 782644, 'dz', 'Bou-Sfer', 1, 'bou-sfer'),
(500981, 782644, 'dz', 'El Kerma', 1, 'el-kerma'),
(500982, 782644, 'dz', 'El Braya', 1, 'el-braya'),
(500983, 782644, 'dz', 'Hassi Ben Okba', 1, 'hassi-ben-okba'),
(500984, 782644, 'dz', 'Ben Freha', 1, 'ben-freha'),
(500985, 782644, 'dz', 'Hassi Mefsoukh', 1, 'hassi-mefsoukh'),
(500986, 782644, 'dz', 'Sidi Benyebka', 1, 'sidi-benyebka'),
(500987, 782644, 'dz', 'Misserghin', 1, 'misserghin'),
(500988, 782644, 'dz', 'Boutlelis', 1, 'boutlelis'),
(500989, 782644, 'dz', 'Aïn El Kerma', 1, 'ain-el-kerma'),
(500990, 782644, 'dz', 'Aïn El Bia', 1, 'ain-el-bia');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782645, 'dz', 'El Bayadh', 1, 'el-bayadh');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(500991, 782645, 'dz', 'El Bayadh', 1, 'el-bayadh'),
(500992, 782645, 'dz', 'Rogassa', 1, 'rogassa'),
(500993, 782645, 'dz', 'Stitten', 1, 'stitten'),
(500994, 782645, 'dz', 'Brezina', 1, 'brezina'),
(500995, 782645, 'dz', 'Ghassoul', 1, 'ghassoul'),
(500996, 782645, 'dz', 'Boualem', 1, 'boualem'),
(500997, 782645, 'dz', 'El Abiodh Sidi Cheikh', 1, 'el-abiodh-sidi-cheikh'),
(500998, 782645, 'dz', 'Aïn El Orak', 1, 'ain-el-orak'),
(500999, 782645, 'dz', 'Arbaouat', 1, 'arbaouat'),
(501000, 782645, 'dz', 'Bougtoub', 1, 'bougtoub'),
(501001, 782645, 'dz', 'El Kheiter', 1, 'el-kheiter'),
(501002, 782645, 'dz', 'Kef El Ahmar', 1, 'kef-el-ahmar'),
(501003, 782645, 'dz', 'Boussemghoun', 1, 'boussemghoun'),
(501004, 782645, 'dz', 'Chellala', 1, 'chellala'),
(501005, 782645, 'dz', 'Kraakda', 1, 'kraakda'),
(501006, 782645, 'dz', 'El Bnoud', 1, 'el-bnoud'),
(501007, 782645, 'dz', 'Cheguig', 1, 'cheguig'),
(501008, 782645, 'dz', 'Sidi Ameur', 1, 'sidi-ameur'),
(501009, 782645, 'dz', 'El Mehara', 1, 'el-mehara'),
(501010, 782645, 'dz', 'Tousmouline', 1, 'tousmouline'),
(501011, 782645, 'dz', 'Sidi Slimane', 1, 'sidi-slimane'),
(501012, 782645, 'dz', 'Sidi Tifour', 1, 'sidi-tifour');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782646, 'dz', 'Illizi', 1, 'illizi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501013, 782646, 'dz', 'Illizi', 1, 'illizi'),
(501014, 782646, 'dz', 'Djanet', 1, 'djanet'),
(501015, 782646, 'dz', 'Debdeb', 1, 'debdeb'),
(501016, 782646, 'dz', 'Bordj Omar Driss', 1, 'bordj-omar-driss'),
(501017, 782646, 'dz', 'Bordj El Haouas', 1, 'bordj-el-haouas'),
(501018, 782646, 'dz', 'In Amenas', 1, 'in-amenas');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782647, 'dz', 'Bordj Bou Arreridj', 1, 'bordj-bou-arreridj');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501019, 782647, 'dz', 'Aïn Taghrout', 1, 'ain-taghrout'),
(501020, 782647, 'dz', 'Aïn Tesra', 1, 'ain-tesra'),
(501021, 782647, 'dz', 'Belimour', 1, 'belimour'),
(501022, 782647, 'dz', 'Ben Daoud', 1, 'ben-daoud'),
(501023, 782647, 'dz', 'Bir Kasdali', 1, 'bir-kasdali'),
(501024, 782647, 'dz', 'Bordj Bou Arreridj', 1, 'bordj-bou-arreridj'),
(501025, 782647, 'dz', 'Bordj Ghédir', 1, 'bordj-ghedir'),
(501026, 782647, 'dz', 'Bordj Zemoura', 1, 'bordj-zemoura'),
(501027, 782647, 'dz', 'Colla', 1, 'colla'),
(501028, 782647, 'dz', 'Djaafra', 1, 'djaafra'),
(501029, 782647, 'dz', 'El Ach', 1, 'el-ach'),
(501030, 782647, 'dz', 'El Achir', 1, 'el-achir'),
(501031, 782647, 'dz', 'El Anseur', 1, 'el-anseur'),
(501032, 782647, 'dz', 'El Hamadia', 1, 'el-hamadia'),
(501033, 782647, 'dz', 'El Main', 1, 'el-main'),
(501034, 782647, 'dz', 'El M\'hir', 1, 'el-mhir'),
(501035, 782647, 'dz', 'Ghilassa', 1, 'ghilassa'),
(501036, 782647, 'dz', 'Haraza', 1, 'haraza'),
(501037, 782647, 'dz', 'Hasnaoua', 1, 'hasnaoua'),
(501038, 782647, 'dz', 'Khelil', 1, 'khelil'),
(501039, 782647, 'dz', 'Ksour', 1, 'ksour'),
(501040, 782647, 'dz', 'Mansoura', 1, 'mansoura'),
(501041, 782647, 'dz', 'Medjana', 1, 'medjana'),
(501042, 782647, 'dz', 'Ouled Brahem', 1, 'ouled-brahem'),
(501043, 782647, 'dz', 'Ouled Dahmane', 1, 'ouled-dahmane'),
(501044, 782647, 'dz', 'Ouled Sidi Brahim', 1, 'ouled-sidi-brahim'),
(501045, 782647, 'dz', 'Rabta', 1, 'rabta'),
(501046, 782647, 'dz', 'Ras El Oued', 1, 'ras-el-oued'),
(501047, 782647, 'dz', 'Sidi Embarek', 1, 'sidi-embarek'),
(501048, 782647, 'dz', 'Tefreg', 1, 'tefreg'),
(501049, 782647, 'dz', 'Taglait', 1, 'taglait'),
(501050, 782647, 'dz', 'Teniet En Nasr', 1, 'teniet-en-nasr'),
(501051, 782647, 'dz', 'Tassameurt', 1, 'tassameurt'),
(501052, 782647, 'dz', 'Tixter', 1, 'tixter');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782648, 'dz', 'Boumerdes', 1, 'boumerdes');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501053, 782648, 'dz', 'Afir', 1, 'afir'),
(501054, 782648, 'dz', 'Ammal', 1, 'ammal'),
(501055, 782648, 'dz', 'Baghlia', 1, 'baghlia'),
(501056, 782648, 'dz', 'Ben Choud', 1, 'ben-choud'),
(501057, 782648, 'dz', 'Beni Amrane', 1, 'beni-amrane'),
(501058, 782648, 'dz', 'Bordj Menaiel', 1, 'bordj-menaiel'),
(501059, 782648, 'dz', 'Boudouaou', 1, 'boudouaou'),
(501060, 782648, 'dz', 'Boudouaou-El-Bahri', 1, 'boudouaou-el-bahri'),
(501061, 782648, 'dz', 'Boumerdes', 1, 'boumerdes'),
(501062, 782648, 'dz', 'Bouzegza Keddara', 1, 'bouzegza-keddara'),
(501063, 782648, 'dz', 'Chabet el Ameur', 1, 'chabet-el-ameur'),
(501064, 782648, 'dz', 'Corso', 1, 'corso'),
(501065, 782648, 'dz', 'Dellys', 1, 'dellys'),
(501066, 782648, 'dz', 'Djinet', 1, 'djinet'),
(501067, 782648, 'dz', 'El Kharrouba', 1, 'el-kharrouba'),
(501068, 782648, 'dz', 'Hammedi', 1, 'hammedi'),
(501069, 782648, 'dz', 'Issers', 1, 'issers'),
(501070, 782648, 'dz', 'Khemis El-Khechna', 1, 'khemis-el-khechna'),
(501071, 782648, 'dz', 'Larbatache', 1, 'larbatache'),
(501072, 782648, 'dz', 'Leghata', 1, 'leghata'),
(501073, 782648, 'dz', 'Naciria', 1, 'naciria'),
(501074, 782648, 'dz', 'Ouled Aissa', 1, 'ouled-aissa'),
(501075, 782648, 'dz', 'Ouled Hedadj', 1, 'ouled-hedadj'),
(501076, 782648, 'dz', 'Ouled Moussa', 1, 'ouled-moussa'),
(501077, 782648, 'dz', 'Si Mustapha', 1, 'si-mustapha'),
(501078, 782648, 'dz', 'Sidi Daoud', 1, 'sidi-daoud'),
(501079, 782648, 'dz', 'Souk El Had', 1, 'souk-el-had'),
(501080, 782648, 'dz', 'Taourga', 1, 'taourga'),
(501081, 782648, 'dz', 'Thenia', 1, 'thenia'),
(501082, 782648, 'dz', 'Tidjelabine', 1, 'tidjelabine'),
(501083, 782648, 'dz', 'Timezrit', 1, 'timezrit'),
(501084, 782648, 'dz', 'Zemmouri', 1, 'zemmouri');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782649, 'dz', 'El Tarf', 1, 'el-tarf');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501085, 782649, 'dz', 'Aïn El Assel', 1, 'ain-el-assel'),
(501086, 782649, 'dz', 'Aïn Kerma', 1, 'ain-kerma'),
(501087, 782649, 'dz', 'Asfour', 1, 'asfour'),
(501088, 782649, 'dz', 'Ben Mehidi', 1, 'ben-mehidi'),
(501089, 782649, 'dz', 'Berrihane', 1, 'berrihane'),
(501090, 782649, 'dz', 'Besbes', 1, 'besbes'),
(501091, 782649, 'dz', 'Bougous', 1, 'bougous'),
(501092, 782649, 'dz', 'Bouhadjar', 1, 'bouhadjar'),
(501093, 782649, 'dz', 'Bouteldja', 1, 'bouteldja'),
(501094, 782649, 'dz', 'Chebaita Mokhtar', 1, 'chebaita-mokhtar'),
(501095, 782649, 'dz', 'Chefia', 1, 'chefia'),
(501096, 782649, 'dz', 'Chihani', 1, 'chihani'),
(501097, 782649, 'dz', 'Dréan', 1, 'drean'),
(501098, 782649, 'dz', 'Echatt', 1, 'echatt'),
(501099, 782649, 'dz', 'El Aioun', 1, 'el-aioun'),
(501100, 782649, 'dz', 'El Kala', 1, 'el-kala'),
(501101, 782649, 'dz', 'El Tarf', 1, 'el-tarf'),
(501102, 782649, 'dz', 'Hammam Beni Salah', 1, 'hammam-beni-salah'),
(501103, 782649, 'dz', 'Lac des Oiseaux', 1, 'lac-des-oiseaux'),
(501104, 782649, 'dz', 'Oued Zitoun', 1, 'oued-zitoun'),
(501105, 782649, 'dz', 'Raml Souk', 1, 'raml-souk'),
(501106, 782649, 'dz', 'Souarekh', 1, 'souarekh'),
(501107, 782649, 'dz', 'Zerizer', 1, 'zerizer'),
(501108, 782649, 'dz', 'Zitouna', 1, 'zitouna');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782650, 'dz', 'Tindouf', 1, 'tindouf');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501109, 782650, 'dz', 'Oum el Assel', 1, 'oum-el-assel'),
(501110, 782650, 'dz', 'Tindouf', 1, 'tindouf');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782651, 'dz', 'Tissemsilt', 1, 'tissemsilt');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501111, 782651, 'dz', 'Ammari', 1, 'ammari'),
(501112, 782651, 'dz', 'Beni Chaib', 1, 'beni-chaib'),
(501113, 782651, 'dz', 'Beni Lahcene', 1, 'beni-lahcene'),
(501114, 782651, 'dz', 'Boucaid', 1, 'boucaid'),
(501115, 782651, 'dz', 'Bordj Bou Naama', 1, 'bordj-bou-naama'),
(501116, 782651, 'dz', 'Bordj El Emir Abdelkader', 1, 'bordj-el-emir-abdelkader'),
(501117, 782651, 'dz', 'Khemisti', 1, 'khemisti'),
(501118, 782651, 'dz', 'Larbaa', 1, 'larbaa'),
(501119, 782651, 'dz', 'Lardjem', 1, 'lardjem'),
(501120, 782651, 'dz', 'Layoune', 1, 'layoune'),
(501121, 782651, 'dz', 'Lazharia', 1, 'lazharia'),
(501122, 782651, 'dz', 'Maacem', 1, 'maacem'),
(501123, 782651, 'dz', 'Melaab', 1, 'melaab'),
(501124, 782651, 'dz', 'Ouled Bessem', 1, 'ouled-bessem'),
(501125, 782651, 'dz', 'Sidi Abed', 1, 'sidi-abed'),
(501126, 782651, 'dz', 'Sidi Boutouchent', 1, 'sidi-boutouchent'),
(501127, 782651, 'dz', 'Sidi Lantri', 1, 'sidi-lantri'),
(501128, 782651, 'dz', 'Sidi Slimane', 1, 'sidi-slimane'),
(501129, 782651, 'dz', 'Tamalaht', 1, 'tamalaht'),
(501130, 782651, 'dz', 'Theniet El Had', 1, 'theniet-el-had'),
(501131, 782651, 'dz', 'Tissemsilt', 1, 'tissemsilt'),
(501132, 782651, 'dz', 'Youssoufia', 1, 'youssoufia');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782652, 'dz', 'El Oued', 1, 'el-oued');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501133, 782652, 'dz', 'El Oued', 1, 'el-oued'),
(501134, 782652, 'dz', 'Robbah', 1, 'robbah'),
(501135, 782652, 'dz', 'Oued El Alenda', 1, 'oued-el-alenda'),
(501136, 782652, 'dz', 'Bayadha', 1, 'bayadha'),
(501137, 782652, 'dz', 'Nakhla', 1, 'nakhla'),
(501138, 782652, 'dz', 'Guemar', 1, 'guemar'),
(501139, 782652, 'dz', 'Kouinine', 1, 'kouinine'),
(501140, 782652, 'dz', 'Reguiba', 1, 'reguiba'),
(501141, 782652, 'dz', 'Hamraia', 1, 'hamraia'),
(501142, 782652, 'dz', 'Taghzout', 1, 'taghzout'),
(501143, 782652, 'dz', 'Debila', 1, 'debila'),
(501144, 782652, 'dz', 'Hassani Abdelkrim', 1, 'hassani-abdelkrim'),
(501145, 782652, 'dz', 'Hassi Khalifa', 1, 'hassi-khalifa'),
(501146, 782652, 'dz', 'Taleb Larbi', 1, 'taleb-larbi'),
(501147, 782652, 'dz', 'Douar El Ma', 1, 'douar-el-ma'),
(501148, 782652, 'dz', 'Sidi Aoun', 1, 'sidi-aoun'),
(501149, 782652, 'dz', 'Trifaoui', 1, 'trifaoui'),
(501150, 782652, 'dz', 'Magrane', 1, 'magrane'),
(501151, 782652, 'dz', 'Beni Guecha', 1, 'beni-guecha'),
(501152, 782652, 'dz', 'Ourmas', 1, 'ourmas'),
(501153, 782652, 'dz', 'Still', 1, 'still'),
(501154, 782652, 'dz', 'M\'Rara', 1, 'mrara'),
(501155, 782652, 'dz', 'Sidi Khellil', 1, 'sidi-khellil'),
(501156, 782652, 'dz', 'Tendla', 1, 'tendla'),
(501157, 782652, 'dz', 'El Ogla', 1, 'el-ogla'),
(501158, 782652, 'dz', 'Mih Ouansa', 1, 'mih-ouansa'),
(501159, 782652, 'dz', 'El M\'Ghair', 1, 'el-mghair'),
(501160, 782652, 'dz', 'Djamaa', 1, 'djamaa'),
(501161, 782652, 'dz', 'Oum Touyour', 1, 'oum-touyour'),
(501162, 782652, 'dz', 'Sidi Amrane', 1, 'sidi-amrane');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782653, 'dz', 'Khenchela', 1, 'khenchela');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501163, 782653, 'dz', 'Aïn Touila', 1, 'ain-touila'),
(501164, 782653, 'dz', 'Babar', 1, 'babar'),
(501165, 782653, 'dz', 'Baghai', 1, 'baghai'),
(501166, 782653, 'dz', 'Bouhmama', 1, 'bouhmama'),
(501167, 782653, 'dz', 'Chechar', 1, 'chechar'),
(501168, 782653, 'dz', 'Chelia', 1, 'chelia'),
(501169, 782653, 'dz', 'Djellal', 1, 'djellal'),
(501170, 782653, 'dz', 'El Hamma', 1, 'el-hamma'),
(501171, 782653, 'dz', 'El Mahmal', 1, 'el-mahmal'),
(501172, 782653, 'dz', 'El Oueldja', 1, 'el-oueldja'),
(501173, 782653, 'dz', 'Ensigha', 1, 'ensigha'),
(501174, 782653, 'dz', 'Kais', 1, 'kais'),
(501175, 782653, 'dz', 'Khenchela', 1, 'khenchela'),
(501176, 782653, 'dz', 'Khirane', 1, 'khirane'),
(501177, 782653, 'dz', 'M\'Sara', 1, 'msara'),
(501178, 782653, 'dz', 'M\'Toussa', 1, 'mtoussa'),
(501179, 782653, 'dz', 'Ouled Rechache', 1, 'ouled-rechache'),
(501180, 782653, 'dz', 'Remila', 1, 'remila'),
(501181, 782653, 'dz', 'Tamza', 1, 'tamza'),
(501182, 782653, 'dz', 'Taouzient', 1, 'taouzient'),
(501183, 782653, 'dz', 'Yabous', 1, 'yabous');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782654, 'dz', 'Souk Ahras', 1, 'souk-ahras');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501184, 782654, 'dz', 'Souk Ahras', 1, 'souk-ahras'),
(501185, 782654, 'dz', 'Sedrata', 1, 'sedrata'),
(501186, 782654, 'dz', 'Hanancha', 1, 'hanancha'),
(501187, 782654, 'dz', 'Mechroha', 1, 'mechroha'),
(501188, 782654, 'dz', 'Ouled Driss', 1, 'ouled-driss'),
(501189, 782654, 'dz', 'Tiffech', 1, 'tiffech'),
(501190, 782654, 'dz', 'Zaarouria', 1, 'zaarouria'),
(501191, 782654, 'dz', 'Taoura', 1, 'taoura'),
(501192, 782654, 'dz', 'Drea', 1, 'drea'),
(501193, 782654, 'dz', 'Heddada', 1, 'heddada'),
(501194, 782654, 'dz', 'Khedara', 1, 'khedara'),
(501195, 782654, 'dz', 'Merahna', 1, 'merahna'),
(501196, 782654, 'dz', 'Ouled Moumene', 1, 'ouled-moumene'),
(501197, 782654, 'dz', 'Bir Bou Haouch', 1, 'bir-bou-haouch'),
(501198, 782654, 'dz', 'M\'daourouch', 1, 'mdaourouch'),
(501199, 782654, 'dz', 'Oum El Adhaim', 1, 'oum-el-adhaim'),
(501200, 782654, 'dz', 'Aïn Zana', 1, 'ain-zana'),
(501201, 782654, 'dz', 'Aïn Soltane', 1, 'ain-soltane'),
(501202, 782654, 'dz', 'Ouillen', 1, 'ouillen'),
(501203, 782654, 'dz', 'Sidi Fredj', 1, 'sidi-fredj'),
(501204, 782654, 'dz', 'Safel El Ouiden', 1, 'safel-el-ouiden'),
(501205, 782654, 'dz', 'Ragouba', 1, 'ragouba'),
(501206, 782654, 'dz', 'Khemissa', 1, 'khemissa'),
(501207, 782654, 'dz', 'Oued Keberit', 1, 'oued-keberit'),
(501208, 782654, 'dz', 'Terraguelt', 1, 'terraguelt'),
(501209, 782654, 'dz', 'Zouabi', 1, 'zouabi');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782655, 'dz', 'Tipaza', 1, 'tipaza');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501210, 782655, 'dz', 'Tipaza', 1, 'tipaza'),
(501211, 782655, 'dz', 'Menaceur', 1, 'menaceur'),
(501212, 782655, 'dz', 'Larhat', 1, 'larhat'),
(501213, 782655, 'dz', 'Douaouda', 1, 'douaouda'),
(501214, 782655, 'dz', 'Bourkika', 1, 'bourkika'),
(501215, 782655, 'dz', 'Khemisti', 1, 'khemisti'),
(501216, 782655, 'dz', 'Aghbal', 1, 'aghbal'),
(501217, 782655, 'dz', 'Hadjout', 1, 'hadjout'),
(501218, 782655, 'dz', 'Sidi Amar', 1, 'sidi-amar'),
(501219, 782655, 'dz', 'Gouraya', 1, 'gouraya'),
(501220, 782655, 'dz', 'Nador', 1, 'nador'),
(501221, 782655, 'dz', 'Chaiba', 1, 'chaiba'),
(501222, 782655, 'dz', 'Aïn Tagourait', 1, 'ain-tagourait'),
(501223, 782655, 'dz', 'Cherchell', 1, 'cherchell'),
(501224, 782655, 'dz', 'Damous', 1, 'damous'),
(501225, 782655, 'dz', 'Merad', 1, 'merad'),
(501226, 782655, 'dz', 'Fouka', 1, 'fouka'),
(501227, 782655, 'dz', 'Bou Ismaïl', 1, 'bou-ismail'),
(501228, 782655, 'dz', 'Ahmar El Aïn', 1, 'ahmar-el-ain'),
(501229, 782655, 'dz', 'Bouharoun', 1, 'bouharoun'),
(501230, 782655, 'dz', 'Sidi Ghiles', 1, 'sidi-ghiles'),
(501231, 782655, 'dz', 'Messelmoun', 1, 'messelmoun'),
(501232, 782655, 'dz', 'Sidi Rached', 1, 'sidi-rached'),
(501233, 782655, 'dz', 'Koléa', 1, 'kolea'),
(501234, 782655, 'dz', 'Attatba', 1, 'attatba'),
(501235, 782655, 'dz', 'Sidi Semiane', 1, 'sidi-semiane'),
(501236, 782655, 'dz', 'Beni Milleuk', 1, 'beni-milleuk'),
(501237, 782655, 'dz', 'Hadjeret Ennous', 1, 'hadjeret-ennous');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782656, 'dz', 'Mila', 1, 'mila');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501238, 782656, 'dz', 'Ahmed Rachedi', 1, 'ahmed-rachedi'),
(501239, 782656, 'dz', 'Aïn Beida Harriche', 1, 'ain-beida-harriche'),
(501240, 782656, 'dz', 'Aïn Mellouk', 1, 'ain-mellouk'),
(501241, 782656, 'dz', 'Aïn Tine', 1, 'ain-tine'),
(501242, 782656, 'dz', 'Amira Arrès', 1, 'amira-arres'),
(501243, 782656, 'dz', 'Benyahia Abderrahmane', 1, 'benyahia-abderrahmane'),
(501244, 782656, 'dz', 'Bouhatem', 1, 'bouhatem'),
(501245, 782656, 'dz', 'Chelghoum Laid', 1, 'chelghoum-laid'),
(501246, 782656, 'dz', 'Chigara', 1, 'chigara'),
(501247, 782656, 'dz', 'Derradji Bousselah', 1, 'derradji-bousselah'),
(501248, 782656, 'dz', 'El Mechira', 1, 'el-mechira'),
(501249, 782656, 'dz', 'Elayadi Barbes', 1, 'elayadi-barbes'),
(501250, 782656, 'dz', 'Ferdjioua', 1, 'ferdjioua'),
(501251, 782656, 'dz', 'Grarem Gouga', 1, 'grarem-gouga'),
(501252, 782656, 'dz', 'Hamala', 1, 'hamala'),
(501253, 782656, 'dz', 'Mila', 1, 'mila'),
(501254, 782656, 'dz', 'Minar Zarza', 1, 'minar-zarza'),
(501255, 782656, 'dz', 'Oued Athmania', 1, 'oued-athmania'),
(501256, 782656, 'dz', 'Oued Endja', 1, 'oued-endja'),
(501257, 782656, 'dz', 'Oued Seguen', 1, 'oued-seguen'),
(501258, 782656, 'dz', 'Ouled Khalouf', 1, 'ouled-khalouf'),
(501259, 782656, 'dz', 'Rouached', 1, 'rouached'),
(501260, 782656, 'dz', 'Sidi Khelifa', 1, 'sidi-khelifa'),
(501261, 782656, 'dz', 'Sidi Merouane', 1, 'sidi-merouane'),
(501262, 782656, 'dz', 'Tadjenanet', 1, 'tadjenanet'),
(501263, 782656, 'dz', 'Tassadane Haddada', 1, 'tassadane-haddada'),
(501264, 782656, 'dz', 'Teleghma', 1, 'teleghma'),
(501265, 782656, 'dz', 'Terrai Bainen', 1, 'terrai-bainen'),
(501266, 782656, 'dz', 'Tessala Lemtaï', 1, 'tessala-lemtai'),
(501267, 782656, 'dz', 'Tiberguent', 1, 'tiberguent'),
(501268, 782656, 'dz', 'Yahia Beni Guecha', 1, 'yahia-beni-guecha'),
(501269, 782656, 'dz', 'Zeghaia', 1, 'zeghaia');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782657, 'dz', 'Aïn Defla', 1, 'ain-defla');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501270, 782657, 'dz', 'Aïn Benian', 1, 'ain-benian'),
(501271, 782657, 'dz', 'Aïn Bouyahia', 1, 'ain-bouyahia'),
(501272, 782657, 'dz', 'Aïn Defla', 1, 'ain-defla'),
(501273, 782657, 'dz', 'Aïn Lechiekh', 1, 'ain-lechiekh'),
(501274, 782657, 'dz', 'Aïn Soltane', 1, 'ain-soltane'),
(501275, 782657, 'dz', 'Aïn Torki', 1, 'ain-torki'),
(501276, 782657, 'dz', 'Arib', 1, 'arib'),
(501277, 782657, 'dz', 'Bathia', 1, 'bathia'),
(501278, 782657, 'dz', 'Belaas', 1, 'belaas'),
(501279, 782657, 'dz', 'Ben Allal', 1, 'ben-allal'),
(501280, 782657, 'dz', 'Birbouche', 1, 'birbouche'),
(501281, 782657, 'dz', 'Bir Ould Khelifa', 1, 'bir-ould-khelifa'),
(501282, 782657, 'dz', 'Bordj Emir Khaled', 1, 'bordj-emir-khaled'),
(501283, 782657, 'dz', 'Boumedfaa', 1, 'boumedfaa'),
(501284, 782657, 'dz', 'Bourached', 1, 'bourached'),
(501285, 782657, 'dz', 'Djelida', 1, 'djelida'),
(501286, 782657, 'dz', 'Djemaa Ouled Cheikh', 1, 'djemaa-ouled-cheikh'),
(501287, 782657, 'dz', 'Djendel', 1, 'djendel'),
(501288, 782657, 'dz', 'El Abadia', 1, 'el-abadia'),
(501289, 782657, 'dz', 'El Amra', 1, 'el-amra'),
(501290, 782657, 'dz', 'El Attaf', 1, 'el-attaf'),
(501291, 782657, 'dz', 'El Hassania', 1, 'el-hassania'),
(501292, 782657, 'dz', 'El Maine', 1, 'el-maine'),
(501293, 782657, 'dz', 'Hammam Righa', 1, 'hammam-righa'),
(501294, 782657, 'dz', 'Hoceinia', 1, 'hoceinia'),
(501295, 782657, 'dz', 'Khemis Miliana', 1, 'khemis-miliana'),
(501296, 782657, 'dz', 'Mekhatria', 1, 'mekhatria'),
(501297, 782657, 'dz', 'Miliana', 1, 'miliana'),
(501298, 782657, 'dz', 'Oued Chorfa', 1, 'oued-chorfa'),
(501299, 782657, 'dz', 'Oued Djemaa', 1, 'oued-djemaa'),
(501300, 782657, 'dz', 'Rouina', 1, 'rouina'),
(501301, 782657, 'dz', 'Sidi Lakhdar', 1, 'sidi-lakhdar'),
(501302, 782657, 'dz', 'Tacheta Zougagha', 1, 'tacheta-zougagha'),
(501303, 782657, 'dz', 'Tarik Ibn Ziad', 1, 'tarik-ibn-ziad'),
(501304, 782657, 'dz', 'Tiberkanine', 1, 'tiberkanine'),
(501305, 782657, 'dz', 'Zeddine', 1, 'zeddine');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782658, 'dz', 'Naâma', 1, 'naama');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501306, 782658, 'dz', 'Aïn Ben Khelil', 1, 'ain-ben-khelil'),
(501307, 782658, 'dz', 'Aïn Sefra', 1, 'ain-sefra'),
(501308, 782658, 'dz', 'Assela', 1, 'assela'),
(501309, 782658, 'dz', 'Djeniene Bourezg', 1, 'djeniene-bourezg'),
(501310, 782658, 'dz', 'El Biod', 1, 'el-biod'),
(501311, 782658, 'dz', 'Kasdir', 1, 'kasdir'),
(501312, 782658, 'dz', 'Makman Ben Amer', 1, 'makman-ben-amer'),
(501313, 782658, 'dz', 'Mecheria', 1, 'mecheria'),
(501314, 782658, 'dz', 'Moghrar', 1, 'moghrar'),
(501315, 782658, 'dz', 'Naâma', 1, 'naama'),
(501316, 782658, 'dz', 'Sfissifa', 1, 'sfissifa'),
(501317, 782658, 'dz', 'Tiout', 1, 'tiout');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782659, 'dz', 'Aïn Témouchent', 1, 'ain-temouchent');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501318, 782659, 'dz', 'Aghlal', 1, 'aghlal'),
(501319, 782659, 'dz', 'Aïn El Arbaa', 1, 'ain-el-arbaa'),
(501320, 782659, 'dz', 'Aïn Kihal', 1, 'ain-kihal'),
(501321, 782659, 'dz', 'Aïn Témouchent', 1, 'ain-temouchent'),
(501322, 782659, 'dz', 'Aïn Tolba', 1, 'ain-tolba'),
(501323, 782659, 'dz', 'Aoubellil', 1, 'aoubellil'),
(501324, 782659, 'dz', 'Beni Saf', 1, 'beni-saf'),
(501325, 782659, 'dz', 'Bouzedjar', 1, 'bouzedjar'),
(501326, 782659, 'dz', 'Chaabat El Leham', 1, 'chaabat-el-leham'),
(501327, 782659, 'dz', 'Chentouf', 1, 'chentouf'),
(501328, 782659, 'dz', 'El Amria', 1, 'el-amria'),
(501329, 782659, 'dz', 'El Emir Abdelkader', 1, 'el-emir-abdelkader'),
(501330, 782659, 'dz', 'El Malah', 1, 'el-malah'),
(501331, 782659, 'dz', 'El Messaid', 1, 'el-messaid'),
(501332, 782659, 'dz', 'Hammam Bouhadjar', 1, 'hammam-bouhadjar'),
(501333, 782659, 'dz', 'Hassasna', 1, 'hassasna'),
(501334, 782659, 'dz', 'Hassi El Ghella', 1, 'hassi-el-ghella'),
(501335, 782659, 'dz', 'Oued Berkeche', 1, 'oued-berkeche'),
(501336, 782659, 'dz', 'Oued Sabah', 1, 'oued-sabah'),
(501337, 782659, 'dz', 'Ouled Boudjemaa', 1, 'ouled-boudjemaa'),
(501338, 782659, 'dz', 'Ouled Kihal', 1, 'ouled-kihal'),
(501339, 782659, 'dz', 'Oulhaça El Gheraba', 1, 'oulhaca-el-gheraba'),
(501340, 782659, 'dz', 'Sidi Ben Adda', 1, 'sidi-ben-adda'),
(501341, 782659, 'dz', 'Sidi Boumedienne', 1, 'sidi-boumedienne'),
(501342, 782659, 'dz', 'Sidi Ouriache (Tadmaya)', 1, 'sidi-ouriache-tadmaya'),
(501343, 782659, 'dz', 'Sidi Safi', 1, 'sidi-safi'),
(501344, 782659, 'dz', 'Tamzoura', 1, 'tamzoura'),
(501345, 782659, 'dz', 'Terga', 1, 'terga');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782660, 'dz', 'Ghardaïa', 1, 'ghardaia');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501346, 782660, 'dz', 'Berriane', 1, 'berriane'),
(501347, 782660, 'dz', 'Bounoura', 1, 'bounoura'),
(501348, 782660, 'dz', 'Dhayet Bendhahoua', 1, 'dhayet-bendhahoua'),
(501349, 782660, 'dz', 'El Atteuf', 1, 'el-atteuf'),
(501350, 782660, 'dz', 'El Guerrara', 1, 'el-guerrara'),
(501351, 782660, 'dz', 'El Golea', 1, 'el-golea'),
(501352, 782660, 'dz', 'Ghardaïa', 1, 'ghardaia'),
(501353, 782660, 'dz', 'Hassi Fehal', 1, 'hassi-fehal'),
(501354, 782660, 'dz', 'Hassi Gara', 1, 'hassi-gara'),
(501355, 782660, 'dz', 'Mansoura', 1, 'mansoura'),
(501356, 782660, 'dz', 'Metlili', 1, 'metlili'),
(501357, 782660, 'dz', 'Sebseb', 1, 'sebseb'),
(501358, 782660, 'dz', 'Zelfana', 1, 'zelfana');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782661, 'dz', 'Relizane', 1, 'relizane');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(501359, 782661, 'dz', 'Aïn Rahma', 1, 'ain-rahma'),
(501360, 782661, 'dz', 'Aïn Tarek', 1, 'ain-tarek'),
(501361, 782661, 'dz', 'Ammi Moussa', 1, 'ammi-moussa'),
(501362, 782661, 'dz', 'Belassel Bouzegza', 1, 'belassel-bouzegza'),
(501363, 782661, 'dz', 'Bendaoud', 1, 'bendaoud'),
(501364, 782661, 'dz', 'Beni Dergoun', 1, 'beni-dergoun'),
(501365, 782661, 'dz', 'Beni Zentis', 1, 'beni-zentis'),
(501366, 782661, 'dz', 'Dar Ben Abdellah', 1, 'dar-ben-abdellah'),
(501367, 782661, 'dz', 'Djidioua', 1, 'djidioua'),
(501368, 782661, 'dz', 'El Guettar', 1, 'el-guettar'),
(501369, 782661, 'dz', 'El Hamadna', 1, 'el-hamadna'),
(501370, 782661, 'dz', 'El Hassi', 1, 'el-hassi'),
(501371, 782661, 'dz', 'El Matmar', 1, 'el-matmar'),
(501372, 782661, 'dz', 'El Ouldja', 1, 'el-ouldja'),
(501373, 782661, 'dz', 'Had Echkalla', 1, 'had-echkalla'),
(501374, 782661, 'dz', 'Hamri', 1, 'hamri'),
(501375, 782661, 'dz', 'Kalaa', 1, 'kalaa'),
(501376, 782661, 'dz', 'Lahlef', 1, 'lahlef'),
(501377, 782661, 'dz', 'Mazouna', 1, 'mazouna'),
(501378, 782661, 'dz', 'Mediouna', 1, 'mediouna'),
(501379, 782661, 'dz', 'Mendes', 1, 'mendes'),
(501380, 782661, 'dz', 'Merdja Sidi Abed', 1, 'merdja-sidi-abed'),
(501381, 782661, 'dz', 'Ouarizane', 1, 'ouarizane'),
(501382, 782661, 'dz', 'Oued Essalem', 1, 'oued-essalem'),
(501383, 782661, 'dz', 'Oued Rhiou', 1, 'oued-rhiou'),
(501384, 782661, 'dz', 'Ouled Aiche', 1, 'ouled-aiche'),
(501385, 782661, 'dz', 'Oued El Djemaa', 1, 'oued-el-djemaa'),
(501386, 782661, 'dz', 'Ouled Sidi Mihoub', 1, 'ouled-sidi-mihoub'),
(501387, 782661, 'dz', 'Ramka', 1, 'ramka'),
(501388, 782661, 'dz', 'Relizane', 1, 'relizane'),
(501389, 782661, 'dz', 'Sidi Khettab', 1, 'sidi-khettab'),
(501390, 782661, 'dz', 'Sidi Lazreg', 1, 'sidi-lazreg'),
(501391, 782661, 'dz', 'Sidi M\'Hamed Ben Ali', 1, 'sidi-mhamed-ben-ali'),
(501392, 782661, 'dz', 'Sidi M\'Hamed Benaouda', 1, 'sidi-mhamed-benaouda'),
(501393, 782661, 'dz', 'Sidi Saada', 1, 'sidi-saada'),
(501394, 782661, 'dz', 'Souk El Had', 1, 'souk-el-had'),
(501395, 782661, 'dz', 'Yellel', 1, 'yellel'),
(501396, 782661, 'dz', 'Zemmora', 1, 'zemmora');

