REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('QA', 'Qatar', 'قطر', 'qatar', '974', 'QAR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3389462, 'QA', 'Madīnat ash Shamāl', 1, 'madinat-ash-shamal'),
(3389465, 'QA', 'Al Khor', 1, 'al-khor'),
(3389467, 'QA', 'Baladīyat Umm Şalāl', 1, 'baladiyat-umm-salal'),
(3389469, 'QA', 'Baladīyat ar Rayyān', 1, 'baladiyat-ar-rayyan'),
(3389470, 'QA', 'Baladīyat ad Dawḩah', 1, 'baladiyat-ad-dawhah'),
(3389472, 'QA', 'Al Wakrah', 1, 'al-wakrah'),
(11030540, 'QA', 'Baladīyat az̧ Z̧a‘āyin', 1, 'baladiyat-az-za-ayin'),
(14777514, 'QA', 'Al-Shahaniya', 1, 'al-shahaniya');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(3289488, 14777514, 'QA', '‘Ayn az Zughayn', 1, 'ayn-az-zughayn', 25.31374, 50.88844),
(3289490, 14777514, 'QA', 'Bi’r Zikrīt', 1, 'bi-r-zikrit', 25.48533, 50.84768),
(3289516, 3389467, 'QA', 'Umm ‘Ubayrīyah', 1, 'umm-ubayriyah', 25.49366, 51.37544),
(3289520, 14777514, 'QA', 'Rawḑat Shamīm', 1, 'rawdat-shamim', 25.22661, 51.17608),
(3289523, 3389467, 'QA', 'Umm Şalāl Muḩammad', 1, 'umm-salal-muhammad', 25.41524, 51.40647),
(3289525, 3389472, 'QA', 'Musay‘īd', 1, 'musay-id', 24.99226, 51.55067),
(3289530, 3389465, 'QA', 'Umm Qayn', 1, 'umm-qayn', 25.71291, 51.49887),
(3289532, 11030540, 'QA', 'Umm Qarn', 1, 'umm-qarn', 25.55267, 51.431),
(3289539, 3389465, 'QA', 'Umm Juway‘id', 1, 'umm-juway-id', 25.83211, 51.06775),
(3289545, 14777514, 'QA', 'Umm Ghuwaylīnah', 1, 'umm-ghuwaylinah', 25.58716, 51.14986),
(3289548, 3389469, 'QA', 'Umm Bāb', 1, 'umm-bab', 25.21417, 50.80722),
(3289550, 14777514, 'QA', 'Umm az Zubār ash Sharqīyah', 1, 'umm-az-zubar-ash-sharqiyah', 25.17493, 51.27824),
(3289558, 11030540, 'QA', 'Umm Suwayyah', 1, 'umm-suwayyah', 25.64803, 51.44936),
(3289559, 3389469, 'QA', 'Umm aş Şuwab', 1, 'umm-as-suwab', 25.06864, 51.07817),
(3289565, 14777514, 'QA', 'Umm ash Shubrum', 1, 'umm-ash-shubrum', 25.16386, 51.22132),
(3289567, 3389465, 'QA', 'Umm al Quhāb', 1, 'umm-al-quhab', 25.76695, 51.47134),
(3289568, 14777514, 'QA', 'Aş Şunay‘', 1, 'as-sunay', 25.4927, 50.9648),
(3289569, 14777514, 'QA', 'Umm al Quhāb', 1, 'umm-al-quhab', 25.37411, 51.29333),
(3289571, 3389467, 'QA', 'Umm al Qubūr', 1, 'umm-al-qubur', 25.3653, 51.43691),
(3289592, 14777514, 'QA', 'Umm al ‘Iz̧ām', 1, 'umm-al-izam', 25.31271, 51.00451),
(3289603, 3389467, 'QA', 'Umm al ‘Amad', 1, 'umm-al-amad', 25.49065, 51.3977),
(3289604, 3389469, 'QA', 'Umm al Afā‘ī', 1, 'umm-al-afa-i', 25.35879, 51.33357),
(3289606, 3389467, 'QA', 'Umm al Abāriq', 1, 'umm-al-abariq', 25.47748, 51.36071),
(3289625, 11030540, 'QA', 'Sumaysimah', 1, 'sumaysimah', 25.57823, 51.48319),
(3289682, 3389470, 'QA', 'Ra’s Abū Finţās', 1, 'ra-s-abu-fintas', 25.20401, 51.61764),
(3289698, 3389470, 'QA', 'Nu‘ayjah', 1, 'nu-ayjah', 25.24617, 51.53227),
(3289704, 3389472, 'QA', 'Nabāt al Uşayl', 1, 'nabat-al-usayl', 25.10966, 51.5339),
(3289709, 3389462, 'QA', 'Musaykah', 1, 'musaykah', 25.95911, 51.09753),
(3289716, 3389469, 'QA', 'Mu‘aydhir Rawḑat Rāshid', 1, 'mu-aydhir-rawdat-rashid', 25.2617, 51.39684),
(3289724, 3389472, 'QA', 'Turaynah', 1, 'turaynah', 24.75809, 51.2107),
(3289739, 3389462, 'QA', 'Madīnat ash Shamāl', 1, 'madinat-ash-shamal', 26.12933, 51.2009),
(3289740, 3389465, 'QA', 'Madīnat al Ka‘bān', 1, 'madinat-al-ka-ban', 25.87339, 51.35265),
(3289741, 3389462, 'QA', 'Lishā', 1, 'lisha', 25.95784, 51.07163),
(3289749, 14777514, 'QA', 'Al Kharsa‘ah', 1, 'al-kharsa-ah', 25.26738, 50.96794),
(3289813, 14777514, 'QA', 'Dukhān', 1, 'dukhan', 25.42485, 50.78227),
(3289832, 14777514, 'QA', 'Bi’r al Ḩusayn', 1, 'bi-r-al-husayn', 25.56974, 50.9509),
(3289848, 3389462, 'QA', '‘Ayn Sinān', 1, 'ayn-sinan', 26.0083, 51.3294),
(3289857, 3389462, 'QA', 'Ath Thaqab', 1, 'ath-thaqab', 26.03153, 51.11512),
(3289859, 14777514, 'QA', 'As Suwayḩilīyah', 1, 'as-suwayhiliyah', 25.76673, 51.01828),
(3289860, 14777514, 'QA', 'Mazra‘at aş Şin‘', 1, 'mazra-at-as-sin', 25.5601, 51.16059),
(3289862, 3389465, 'QA', 'As Sulaymī Suḩaym Bin Ḩamad', 1, 'as-sulaymi-suhaym-bin-hamad', 25.88112, 51.17918),
(3289863, 3389465, 'QA', 'As Sulaymī al Gharbī', 1, 'as-sulaymi-al-gharbi', 25.86801, 51.20263),
(3289864, 3389465, 'QA', 'Al Jatlāwīyah', 1, 'al-jatlawiyah', 25.90572, 51.20244),
(3289869, 3389462, 'QA', 'Makīn al Fatīyah', 1, 'makin-al-fatiyah', 26.03293, 51.1647),
(3289873, 14777514, 'QA', 'As Samrīyah', 1, 'as-samriyah', 25.36464, 51.2807),
(3289874, 14777514, 'QA', 'As Sulaymīyah', 1, 'as-sulaymiyah', 25.35373, 50.96052),
(3289876, 3389472, 'QA', 'Ash Shaqrā’', 1, 'ash-shaqra', 24.82671, 51.3934),
(3289877, 14777514, 'QA', 'Ash Shīḩānīyah', 1, 'ash-shihaniyah', 25.37088, 51.22264),
(3289879, 3389465, 'QA', 'Ash Shafallaḩīyah', 1, 'ash-shafallahiyah', 25.64923, 51.36953),
(3289884, 3389462, 'QA', 'Ar Ruways', 1, 'ar-ruways', 26.13978, 51.21493),
(3289886, 14777514, 'QA', 'Qaryat ar Rufayq', 1, 'qaryat-ar-rufayq', 25.52951, 50.97406),
(3289888, 3389469, 'QA', 'Ar Rayyān', 1, 'ar-rayyan', 25.29194, 51.42444),
(3289899, 3389462, 'QA', '‘Ayn an Nu‘mān', 1, 'ayn-an-nu-man', 25.85959, 51.08388),
(3289913, 3389472, 'QA', 'Al Wukayr', 1, 'al-wukayr', 25.15107, 51.53718),
(3289915, 3389472, 'QA', 'Al Wakrah', 1, 'al-wakrah', 25.17151, 51.60337),
(3289916, 3389469, 'QA', 'Al Waqbah', 1, 'al-waqbah', 25.30498, 51.40142),
(3289917, 14777514, 'QA', 'Al Wabrah', 1, 'al-wabrah', 25.33905, 51.17333),
(3289919, 3389465, 'QA', 'Al Wa‘b', 1, 'al-wa-b', 25.84084, 51.46319),
(3289922, 14777514, 'QA', 'Jaww al ‘Uwaynah', 1, 'jaww-al-uwaynah', 25.44662, 50.95815),
(3289934, 3389462, 'QA', 'Al Muraydah', 1, 'al-muraydah', 25.93951, 51.30957),
(3289936, 3389465, 'QA', 'Al Mashrab', 1, 'al-mashrab', 25.89459, 51.38631),
(3289948, 3389469, 'QA', 'Al Kir‘ānah', 1, 'al-kir-anah', 25.01108, 51.04324),
(3289951, 3389467, 'QA', 'Al Khurayţīyāt', 1, 'al-khuraytiyat', 25.38838, 51.42515),
(3289955, 14777514, 'QA', 'Al Khurayb', 1, 'al-khurayb', 25.43568, 51.22019),
(3289958, 3389462, 'QA', 'Al Khīsah', 1, 'al-khisah', 25.92442, 51.33994),
(3289959, 11030540, 'QA', 'Al Khīsah', 1, 'al-khisah', 25.41644, 51.45905),
(3289962, 3389465, 'QA', 'Al Khawr', 1, 'al-khawr', 25.68389, 51.50583),
(3289963, 14777514, 'QA', 'Al Khaţţīyah', 1, 'al-khattiyah', 25.41867, 50.78758),
(3289968, 3389472, 'QA', 'Al Kharrārah', 1, 'al-kharrarah', 24.90325, 51.17582),
(3289973, 3389462, 'QA', 'Al Qa‘ābīyah', 1, 'al-qa-abiyah', 26.06968, 51.24531),
(3289975, 14777514, 'QA', 'Al Jumaylīyah', 1, 'al-jumayliyah', 25.61068, 51.09108),
(3289977, 3389462, 'QA', 'Al Judhay‘', 1, 'al-judhay', 25.95149, 51.34767),
(3289978, 3389465, 'QA', 'Al Jubayl', 1, 'al-jubayl', 25.70133, 51.58541),
(3289985, 14777514, 'QA', 'Al Ḩasanīyah', 1, 'al-hasaniyah', 25.33984, 51.29582),
(3289993, 3389465, 'QA', 'Al Ghuwayrīyah', 1, 'al-ghuwayriyah', 25.82882, 51.24567),
(3289995, 3389462, 'QA', 'Al Ghashshāmīyah', 1, 'al-ghashshamiyah', 25.98513, 51.3283),
(3289997, 3389462, 'QA', 'Al Ghārīyah', 1, 'al-ghariyah', 26.07996, 51.35745),
(3290006, 14777514, 'QA', 'Al Buşayyir', 1, 'al-busayyir', 25.71651, 51.05597),
(3290009, 14777514, 'QA', 'Al Buraythāt', 1, 'al-buraythat', 25.45894, 50.95678),
(3290014, 3389462, 'QA', 'Al ‘Arīsh', 1, 'al-arish', 26.05102, 51.05689),
(3290020, 3389462, 'QA', '‘Adhbah', 1, 'adhbah', 26.05151, 51.31874),
(3290022, 3389467, 'QA', 'Rawḑat al ‘Ajūz', 1, 'rawdat-al-ajuz', 25.54622, 51.37221),
(3290025, 3389465, 'QA', 'Adh Dhakhīrah', 1, 'adh-dhakhirah', 25.73201, 51.54377),
(3290030, 3389470, 'QA', 'Doha', 1, 'doha', 25.28545, 51.53096),
(3290039, 14777514, 'QA', 'Abū Sidrah', 1, 'abu-sidrah', 25.7251, 51.00192),
(3290056, 3389462, 'QA', 'Abū Z̧ulūf', 1, 'abu-zuluf', 26.12403, 51.18151),
(3393291, 3389469, 'QA', 'Zar‘ al ‘Atīyah', 1, 'zar-al-atiyah', 25.32565, 51.34905),
(3393294, 3389469, 'QA', 'As Saylīyah', 1, 'as-sayliyah', 25.21363, 51.37314),
(3393295, 3389469, 'QA', 'Umm Qurūn', 1, 'umm-qurun', 25.23358, 51.33043),
(3393296, 3389472, 'QA', 'Wādī Jallāl', 1, 'wadi-jallal', 25.0306, 51.27611),
(3398806, 3389469, 'QA', 'Abū Samrah', 1, 'abu-samrah', 24.7437, 50.83174),
(3406674, 3389462, 'QA', 'Al Wa‘b', 1, 'al-wa-b', 26.11561, 51.22603),
(3406682, 3389462, 'QA', 'Umm Şabbāḩ', 1, 'umm-sabbah', 26.11094, 51.18966),
(3406683, 3389462, 'QA', 'Az Zighāb', 1, 'az-zighab', 26.10778, 51.23965),
(3406686, 3389462, 'QA', 'Al ‘Aşmīyah', 1, 'al-asmiyah', 26.07644, 51.16564),
(3406687, 3389462, 'QA', 'Umm aş Şūf', 1, 'umm-as-suf', 26.07146, 51.21083),
(3406721, 3389462, 'QA', 'Ar Rakīyāt', 1, 'ar-rakiyat', 26.05023, 51.13041),
(3406733, 3389462, 'QA', 'Sidrīyat Makīn', 1, 'sidriyat-makin', 26.03361, 51.16389),
(3406753, 3389462, 'QA', 'Umm al Qubūr', 1, 'umm-al-qubur', 26.0084, 51.08769),
(3406756, 3389462, 'QA', 'Umm al Kilāb', 1, 'umm-al-kilab', 26.04787, 51.20931),
(3406783, 3389462, 'QA', 'Umm al Ghaylam', 1, 'umm-al-ghaylam', 25.99983, 51.29953),
(3406787, 3389462, 'QA', 'Fuwayriţ', 1, 'fuwayrit', 26.02565, 51.36971),
(3442521, 3389465, 'QA', 'As Sulaymī ash Sharqī', 1, 'as-sulaymi-ash-sharqi', 25.88315, 51.21974),
(3442522, 3389465, 'QA', 'As Sulaymī ‘Abd al ‘Azīz Bin Khalīfah', 1, 'as-sulaymi-abd-al-aziz-bin-khalifah', 25.84778, 51.20583),
(3442523, 3389465, 'QA', 'Umm al ‘Iz̧ām', 1, 'umm-al-izam', 25.82241, 51.15614),
(3442524, 3389465, 'QA', 'Muḩayriqat Janūb aş Şu‘lūkīyah', 1, 'muhayriqat-janub-as-su-lukiyah', 25.8094, 51.05608),
(3442525, 3389465, 'QA', 'Al Ghāfah', 1, 'al-ghafah', 25.77977, 51.0209),
(3442527, 3389462, 'QA', 'Al Ḩuwaylah', 1, 'al-huwaylah', 25.94889, 51.46511),
(3442528, 3389465, 'QA', 'Al Khurayş', 1, 'al-khurays', 25.85694, 51.43583),
(3442529, 3389465, 'QA', 'Mazra‘at al Mājidah', 1, 'mazra-at-al-majidah', 25.87267, 51.2578),
(3442531, 3389465, 'QA', 'Simsimah', 1, 'simsimah', 25.79508, 51.40479),
(3442533, 3389465, 'QA', 'Umm Birkah', 1, 'umm-birkah', 25.7472, 51.45082),
(3442535, 14777514, 'QA', 'Al Qā‘īyah', 1, 'al-qa-iyah', 25.66834, 51.17245),
(3442536, 14777514, 'QA', 'As Sāmirīyah', 1, 'as-samiriyah', 25.49131, 51.22239),
(3442537, 14777514, 'QA', 'Abū Şuwayy', 1, 'abu-suwayy', 25.697, 51.25975),
(3442539, 3389465, 'QA', 'Al ‘Uqdah', 1, 'al-uqdah', 25.68545, 51.46711),
(3442540, 11030540, 'QA', 'Al Ghāf', 1, 'al-ghaf', 25.62731, 51.45508),
(3442541, 11030540, 'QA', 'Tinbak ash Sharqīyah al Qadīmah', 1, 'tinbak-ash-sharqiyah-al-qadimah', 25.61119, 51.47233),
(3442542, 3389467, 'QA', 'Abū Thaylah', 1, 'abu-thaylah', 25.53383, 51.30479),
(3442547, 14777514, 'QA', 'An Naşrānīyah', 1, 'an-nasraniyah', 25.407, 51.07694),
(3442550, 14777514, 'QA', 'Rawḑat Rāshid', 1, 'rawdat-rashid', 25.23306, 51.20467),
(3442551, 14777514, 'QA', 'Umm Wishāḩ', 1, 'umm-wishah', 25.17009, 51.09012),
(3442552, 14777514, 'QA', 'Sahlat al Markh', 1, 'sahlat-al-markh', 25.1618, 51.16457),
(3442553, 3389469, 'QA', 'Mukaynis', 1, 'mukaynis', 25.12243, 51.21775),
(3443223, 3389467, 'QA', 'Aş Şanī‘', 1, 'as-sani', 25.54273, 51.40815),
(3443240, 3389465, 'QA', 'Abū Kharāb', 1, 'abu-kharab', 25.7098, 51.58971),
(3443253, 14777514, 'QA', 'Umm aḑ Ḑa‘ah Khawzān', 1, 'umm-ad-da-ah-khawzan', 25.48031, 50.94052),
(3443255, 14777514, 'QA', 'Umm Qarn', 1, 'umm-qarn', 25.29899, 51.00536),
(3443259, 14777514, 'QA', 'Umm al Quhāb al Qadīmah', 1, 'umm-al-quhab-al-qadimah', 25.5006, 50.97955),
(13371855, 14777514, 'QA', 'Al ‘Uţūrīyah', 1, 'al-uturiyah', 25.51294, 51.21138),
(14205933, 14777514, 'QA', 'As Sahlah ash Shamālīyah', 1, 'as-sahlah-ash-shamaliyah', 25.17778, 51.16204),
(14205936, 14777514, 'QA', 'Ash Shabhānah', 1, 'ash-shabhanah', 25.21264, 50.93687),
(14205982, 14777514, 'QA', 'Umm al Maqārīn', 1, 'umm-al-maqarin', 25.17021, 51.18551),
(14206141, 14777514, 'QA', 'Wādī al Jamāl ash Shamālī', 1, 'wadi-al-jamal-ash-shamali', 25.1906, 51.10868),
(14206237, 3389469, 'QA', 'Umm Ḩawţah', 1, 'umm-hawtah', 24.89011, 51.06698),
(14206340, 3389469, 'QA', 'Al ‘Āmirīyah', 1, 'al-amiriyah', 24.82163, 51.07673),
(14206491, 3389469, 'QA', 'Al Wusayl', 1, 'al-wusayl', 24.97221, 50.98623),
(14206506, 3389469, 'QA', 'Umm Qarn', 1, 'umm-qarn', 25.09297, 51.13321),
(14206523, 3389469, 'QA', 'Jarayān al Baţnah', 1, 'jarayan-al-batnah', 25.1078, 51.15298),
(14206632, 14777514, 'QA', 'Jumaylīyat ash Shahwān', 1, 'jumayliyat-ash-shahwan', 25.62016, 51.0827),
(14206633, 14777514, 'QA', 'Jumaylīyat an Na‘īm', 1, 'jumayliyat-an-na-im', 25.63413, 51.08078),
(14207111, 3389462, 'QA', 'Al Marrūnah', 1, 'al-marrunah', 25.99483, 51.39892),
(14207267, 11030540, 'QA', 'Ar Ruḩayyah', 1, 'ar-ruhayyah', 25.64063, 51.46313),
(14207302, 3389465, 'QA', 'Al Masākir ‘Uraydah', 1, 'al-masakir-uraydah', 25.73221, 51.58859),
(14207338, 3389465, 'QA', 'Umm ‘Anīq', 1, 'umm-aniq', 25.7139, 51.53157),
(14207529, 11030540, 'QA', 'Al Ḩammāmah', 1, 'al-hammamah', 25.44623, 51.47328),
(14207583, 3389467, 'QA', 'Burj Barzān', 1, 'burj-barzan', 25.52469, 51.30365),
(14207584, 3389467, 'QA', 'Thu‘aylib', 1, 'thu-aylib', 25.4184, 51.4137),
(14207590, 3389467, 'QA', 'Jarī Ibn ‘Abd al Wahhāb', 1, 'jari-ibn-abd-al-wahhab', 25.438, 51.26977),
(14207662, 3389469, 'QA', 'Şin‘ al Ḩumaydī', 1, 'sin-al-humaydi', 25.3697, 51.33689),
(14207754, 14777514, 'QA', 'Abū Nakhlah', 1, 'abu-nakhlah', 25.17386, 51.31733),
(14207760, 3389472, 'QA', 'Al Bāhiyah', 1, 'al-bahiyah', 25.12829, 51.41859),
(14207802, 3389472, 'QA', 'Al Mashāf', 1, 'al-mashaf', 25.17528, 51.56902),
(14207816, 14777514, 'QA', 'Umm az Zubār al Qiblīyah', 1, 'umm-az-zubar-al-qibliyah', 25.17644, 51.25202),
(14207868, 14777514, 'QA', '‘Ayn ar Rukhayşah', 1, 'ayn-ar-rukhaysah', 25.33097, 51.24923),
(14207875, 14777514, 'QA', 'Gharāfat ar Rayyān', 1, 'gharafat-ar-rayyan', 25.23835, 51.24617),
(14207887, 14777514, 'QA', 'Laqţah', 1, 'laqtah', 25.3413, 51.3099),
(14208370, 3389462, 'QA', 'Umm Jāsim', 1, 'umm-jasim', 26.06693, 51.15312),
(14208399, 3389462, 'QA', '‘Adhbah ash Shamālīyah', 1, 'adhbah-ash-shamaliyah', 26.07098, 51.30453),
(14208412, 3389462, 'QA', 'Fuwayriţ al Qadīm', 1, 'fuwayrit-al-qadim', 26.03447, 51.36717),
(15219679, 3389467, 'QA', 'Abā an Najm', 1, 'aba-an-najm', 25.53404, 51.36992),
(15219681, 3389467, 'QA', 'Jarī Khabāb', 1, 'jari-khabab', 25.50619, 51.38365),
(15219687, 3389467, 'QA', 'Abū Qarn', 1, 'abu-qarn', 25.43079, 51.34598),
(15219690, 14777514, 'QA', 'Umm Aqdīr', 1, 'umm-aqdir', 25.3257, 51.27801),
(15219691, 3389469, 'QA', 'Jarī az̧ Z̧abī', 1, 'jari-az-zabi', 25.34751, 51.34642),
(15219692, 3389469, 'QA', 'Jarīyān as Sahm', 1, 'jariyan-as-sahm', 25.36849, 51.3545),
(15219693, 3389469, 'QA', 'Ath Thamīd', 1, 'ath-thamid', 25.35658, 51.3792),
(15219790, 14777514, 'QA', 'Mu‘aydhir al Mashāf', 1, 'mu-aydhir-al-mashaf', 25.41804, 51.26399),
(15219791, 14777514, 'QA', 'Mu‘aydhir ad Dasm', 1, 'mu-aydhir-ad-dasm', 25.39162, 51.26836),
(15219792, 3389467, 'QA', 'Abū Aqlīlah', 1, 'abu-aqlilah', 25.45617, 51.27556),
(15219795, 3389467, 'QA', 'Umm Asharīn', 1, 'umm-asharin', 25.3974, 51.34386),
(15219824, 3389465, 'QA', 'Umm Qarīn', 1, 'umm-qarin', 25.60925, 51.39032),
(15242650, 3389472, 'QA', 'Mu‘aydhar al Wakīr', 1, 'mu-aydharalwakir', 25.1251, 51.54224);