--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


--
-- Dumping data for table `<<prefix>>subadmin1`
--

INSERT INTO `<<prefix>>subadmin1` VALUES (1914,'MA.01','MA','Tanger-Tetouan-Al Hoceima','Tanger-Tetouan-Al Hoceima',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1915,'MA.02','MA','Oriental','Oriental',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1916,'MA.03','MA','Fès-Meknès','Fes-Meknes',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1917,'MA.04','MA','Rabat-Salé-Kénitra','Rabat-Sale-Kenitra',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1918,'MA.05','MA','Béni Mellal-Khénifra','Beni Mellal-Khenifra',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1919,'MA.06','MA','Casablanca-Settat','Casablanca-Settat',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1920,'MA.07','MA','Marrakesh-Safi','Marrakesh-Safi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1921,'MA.08','MA','Drâa-Tafilalet','Draa-Tafilalet',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1922,'MA.09','MA','Souss-Massa','Souss-Massa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1923,'MA.10','MA','Guelmim-Oued Noun','Guelmim-Oued Noun',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1924,'MA.11','MA','Laâyoune-Sakia El Hamra','Laayoune-Sakia El Hamra',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1925,'MA.12','MA','Dakhla-Oued Ed-Dahab','Dakhla-Oued Ed-Dahab',1);

--
-- Dumping data for table `<<prefix>>subadmin2`
--

INSERT INTO `<<prefix>>subadmin2` VALUES (22052,'MA.09.581','MA','MA.09','Tiznit','Tiznit',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22053,'MA.01.571','MA','MA.01','Tetouan','Tetouan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22054,'MA.03.561','MA','MA.03','Taza','Taza',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22055,'MA.09.551','MA','MA.09','Tata','Tata',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22056,'MA.09.541','MA','MA.09','Taroudannt','Taroudannt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22057,'MA.03.531','MA','MA.03','Taounate','Taounate',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22058,'MA.10.521','MA','MA.10','Tan-Tan','Tan-Tan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22059,'MA.01.511','MA','MA.01','Tanger-Assilah','Tanger-Assilah',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22060,'MA.04.481','MA','MA.04','Sidi-Kacem','Sidi-Kacem',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22061,'MA.06.461','MA','MA.06','Settat Province','Settat Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22062,'MA.04.441','MA','MA.04','Sale','Sale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22063,'MA.07.431','MA','MA.07','Safi','Safi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22064,'MA.04.421','MA','MA.04','Rabat','Rabat',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22065,'MA.02.411','MA','MA.02','Oujda-Angad','Oujda-Angad',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22066,'MA.08.401','MA','MA.08','Ouarzazate','Ouarzazate',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22067,'MA.02.381','MA','MA.02','Nador','Nador',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22068,'MA.01.331','MA','MA.01','Larache','Larache',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22069,'MA.11.321','MA','MA.11','Laayoune','Laayoune',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22070,'MA.05.311','MA','MA.05','Khouribga Province','Khouribga Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22071,'MA.05.301','MA','MA.05','Khenifra','Khenifra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22072,'MA.04.291','MA','MA.04','Khemisset','Khemisset',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22073,'MA.04.281','MA','MA.04','Kenitra Province','Kenitra Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22074,'MA.09.273','MA','MA.09','Inezgane-Ait Mellou','Inezgane-Ait Mellou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22075,'MA.03.271','MA','MA.03','Ifrane','Ifrane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22076,'MA.10.261','MA','MA.10','Guelmim','Guelmim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22077,'MA.02.251','MA','MA.02','Figuig','Figuig',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22078,'MA.07.211','MA','MA.07','Essaouira','Essaouira',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22079,'MA.08.201','MA','MA.08','Errachidia','Errachidia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22080,'MA.07.191','MA','MA.07','Kelaa-Des-Sraghna','Kelaa-Des-Sraghna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22081,'MA.06.181','MA','MA.06','El-Jadida','El-Jadida',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22082,'MA.01.151','MA','MA.01','Chefchaouen Province','Chefchaouen Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22083,'MA.03.131','MA','MA.03','Boulemane','Boulemane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22084,'MA.06.111','MA','MA.06','Benslimane','Benslimane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22085,'MA.05.091','MA','MA.05','Beni-Mellal','Beni-Mellal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22086,'MA.05.081','MA','MA.05','Azilal Province','Azilal Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22087,'MA.01.051','MA','MA.01','Al-Hoceima','Al-Hoceima',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22088,'MA.09.001','MA','MA.09','Agadir-Ida-ou-Tnan','Agadir-Ida-ou-Tnan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22089,'MA.04.501','MA','MA.04','Skhirate-Temara','Skhirate-Temara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22090,'MA.10.071','MA','MA.10','Assa-Zag','Assa-Zag',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22091,'MA.11.221','MA','MA.11','Es-Semara','Es-Semara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22092,'MA.03.061','MA','MA.03','Meknes','Meknes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22093,'MA.07.161','MA','MA.07','Chichaoua','Chichaoua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22094,'MA.07.351','MA','MA.07','Marrakech','Marrakech',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22095,'MA.03.451','MA','MA.03','Sefrou','Sefrou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22096,'MA.02.113','MA','MA.02','Berkane','Berkane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22097,'MA.02.275','MA','MA.02','Jerada','Jerada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22098,'MA.02.533','MA','MA.02','Taourirt','Taourirt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22099,'MA.11.121','MA','MA.11','Boujdour','Boujdour',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22100,'MA.09.163','MA','MA.09','Chtouka-Ait-Baha','Chtouka-Ait-Baha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22101,'MA.07.041','MA','MA.07','Al-Haouz','Al-Haouz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22102,'MA.01.227','MA','MA.01','Fahs-Anjra','Fahs-Anjra',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22103,'MA.06.141','MA','MA.06','Casablanca','Casablanca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22104,'MA.03.591','MA','MA.03','Moulay-Yacoub','Moulay-Yacoub',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22105,'MA.03.171','MA','MA.03','El-Hajeb','El-Hajeb',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22106,'MA.12.066','MA','MA.12','Aousserd','Aousserd',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22107,'MA.12.391','MA','MA.12','Oued-Ed-Dahab','Oued-Ed-Dahab',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22108,'MA.06.385','MA','MA.06','Nouaceur','Nouaceur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22109,'MA.03.231','MA','MA.03','Fes','Fes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22110,'MA.06.371','MA','MA.06','Mohammedia','Mohammedia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22111,'MA.08.587','MA','MA.08','Zagora','Zagora',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22112,'MA.06.355','MA','MA.06','Mediouna','Mediouna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22113,'MA.02.265','MA','MA.02','Guercif Province','Guercif Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22114,'MA.06.117','MA','MA.06','Berrechid Province','Berrechid Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22115,'MA.02.167','MA','MA.02','Driouch Province','Driouch Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22116,'MA.08.577','MA','MA.08','Tinghir Province','Tinghir Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22117,'MA.01.405','MA','MA.01','Ouezzane Province','Ouezzane Province',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22118,'MA.01.573','MA','MA.01','M\'Diq-Fnideq','M\'Diq-Fnideq',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22119,'MA.04.491','MA','MA.04','Sidi Slimane','Sidi Slimane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22120,'MA.06.467','MA','MA.06','Sidi Bennour','Sidi Bennour',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22121,'MA.07.585','MA','MA.07','Youssoufia','Youssoufia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22122,'MA.08.363','MA','MA.08','Midelt','Midelt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22123,'MA.07.427','MA','MA.07','Rehamna','Rehamna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22124,'MA.11.537','MA','MA.11','Tarfaya','Tarfaya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22125,'MA.10.473','MA','MA.10','Sidi Ifni','Sidi Ifni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22126,'MA.05.255','MA','MA.05','Fquih Ben Salah Province','Fquih Ben Salah Province',1);

--
-- Dumping data for table `<<prefix>>cities`
--

INSERT INTO `<<prefix>>cities` VALUES (2461874,'MA','Smara','Smara',26.7384,-11.6719,'P','PPL','MA.11','MA.11.221',42056,'Africa/Casablanca',1,'2017-07-07 23:00:00','2017-07-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2526435,'MA','Zaïo','Zaio',34.9428,-2.7329,'P','PPLA3','MA.02','MA.02.381',30008,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2526452,'MA','Zagora','Zagora',30.3324,-5.8384,'P','PPLA3','MA.08','MA.08.587',35154,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2526488,'MA','Youssoufia','Youssoufia',32.2463,-8.52941,'P','PPLA3','MA.07','MA.07.431',64910,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2527089,'MA','Tiznit','Tiznit',29.6974,-9.73162,'P','PPLA3','MA.09','MA.09.581',55092,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2527645,'MA','Tirhanimîne','Tirhanimine',35.2362,-3.95453,'P','PPL','MA.01','MA.01.051',55827,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2527915,'MA','Tinghir','Tinghir',31.5147,-5.53278,'P','PPLA2','MA.08','MA.08.577',36795,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2528659,'MA','Tiflet','Tiflet',33.8947,-6.30649,'P','PPLA3','MA.04','MA.04.291',70010,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2528910,'MA','Tétouan','Tetouan',35.5784,-5.36837,'P','PPLA2','MA.01','MA.01.571',326261,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2529013,'MA','Temara','Temara',33.9287,-6.90656,'P','PPLA3','MA.04','MA.04.501',313510,'Africa/Casablanca',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2529317,'MA','Taza','Taza',34.21,-4.01,'P','PPLA2','MA.03','MA.03.561',141890,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2529649,'MA','Taroudant','Taroudant',30.4703,-8.87695,'P','PPLA3','MA.09','MA.09.541',71133,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2529923,'MA','Tarfaya','Tarfaya',27.9392,-12.926,'P','PPL','MA.59',NULL,5615,'Africa/Casablanca',1,'2014-10-15 23:00:00','2014-10-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2530048,'MA','Taourirt','Taourirt',34.4073,-2.89732,'P','PPLA3','MA.02','MA.02.533',82518,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2530155,'MA','Taounate','Taounate',34.5366,-4.64009,'P','PPLA3','MA.03','MA.03.531',32802,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2530241,'MA','Tan-Tan','Tan-Tan',28.438,-11.1032,'P','PPLA2','MA.10','MA.10.521',61924,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2530335,'MA','Tangier','Tangier',35.7673,-5.79975,'P','PPLA','MA.01','MA.01.511',688356,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2531480,'MA','Tahla','Tahla',34.0496,-4.42162,'P','PPLA3','MA.03','MA.03.561',25761,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2532394,'MA','Souq Larb’a al Gharb','Souq Larb\'a al Gharb',34.6866,-6.00272,'P','PPLA3','MA.04','MA.04.281',44059,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2532822,'MA','Sidi Yahia El Gharb','Sidi Yahia El Gharb',34.3049,-6.30404,'P','PPLA3','MA.04','MA.04.491',32202,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2532945,'MA','Sidi Slimane','Sidi Slimane',34.2648,-5.92598,'P','PPLA3','MA.04','MA.04.281',79437,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2533191,'MA','Sidi Qacem','Sidi Qacem',34.2215,-5.70775,'P','PPL','MA.04','MA.04.481',74755,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2534515,'MA','Sidi Ifni','Sidi Ifni',29.3797,-10.173,'P','PPLA3','MA.09','MA.09.581',20000,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2536074,'MA','Sidi Bennour','Sidi Bennour',32.6524,-8.42769,'P','PPLA3','MA.06','MA.06.181',40044,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2537406,'MA','Settat','Settat',33.001,-7.61662,'P','PPLA2','MA.06','MA.06.461',119082,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2537545,'MA','Sefrou','Sefrou',33.8319,-4.828,'P','PPLA3','MA.03','MA.03.451',65150,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2537763,'MA','Sale','Sale',34.0531,-6.79846,'P','PPL','MA.04','MA.04.441',903485,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2537881,'MA','Safi','Safi',32.2994,-9.23718,'P','PPLA2','MA.07','MA.07.431',288163,'Africa/Casablanca',1,'2017-05-01 23:00:00','2017-05-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2538475,'MA','Rabat','Rabat',34.0132,-6.83255,'P','PPLC','MA.04','MA.04.421',1655753,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2539134,'MA','Oulad Teïma','Oulad Teima',30.3947,-9.20897,'P','PPL','MA.09','MA.09.541',66832,'Africa/Casablanca',1,'2016-11-09 23:00:00','2016-11-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2540483,'MA','Oujda-Angad','Oujda-Angad',34.6814,-1.90858,'P','PPLA','MA.02','MA.02.411',405253,'Africa/Casablanca',1,'2016-12-04 23:00:00','2016-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2540689,'MA','Oued Zem','Oued Zem',32.8627,-6.57359,'P','PPLA3','MA.05','MA.05.311',84910,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2540810,'MA','Ouezzane','Ouezzane',34.7958,-5.57849,'P','PPLA2','MA.01','MA.01.405',58684,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2540850,'MA','Ouarzazat','Ouarzazat',30.9189,-6.89341,'P','PPLA2','MA.08','MA.08.401',57245,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2541210,'MA','Zawyat an Nwaçer','Zawyat an Nwacer',33.3798,-7.61932,'P','PPL','MA.06',NULL,12696,'Africa/Casablanca',1,'2017-08-01 23:00:00','2017-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2541479,'MA','Nador','Nador',35.1681,-2.93352,'P','PPLA3','MA.02','MA.02.381',129260,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542013,'MA','Al Aaroui','Al Aaroui',35.0109,-3.00938,'P','PPL','MA.02',NULL,36021,'Africa/Casablanca',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542051,'MA','Mohammedia','Mohammedia',33.6861,-7.38298,'P','PPLA3','MA.06','MA.06.371',187708,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542227,'MA','Midelt','Midelt',32.6852,-4.74512,'P','PPLA3','MA.05','MA.05.301',45159,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542715,'MA','Meknès','Meknes',33.8935,-5.54727,'P','PPLA2','MA.03','MA.03.061',545705,'Africa/Casablanca',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542866,'MA','Mechraa Bel Ksiri','Mechraa Bel Ksiri',34.5737,-5.95585,'P','PPLA3','MA.04','MA.04.481',27802,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542987,'MA','Martil','Martil',35.6166,-5.27522,'P','PPLA3','MA.01','MA.01.571',39738,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2542997,'MA','Marrakesh','Marrakesh',31.6342,-7.99994,'P','PPLA','MA.07','MA.07.351',839296,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2543394,'MA','Ifrane','Ifrane',31.7022,-6.3494,'P','PPL','MA.05',NULL,13000,'Africa/Casablanca',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2543549,'MA','Larache','Larache',35.1932,-6.15572,'P','PPLA3','MA.01','MA.01.331',109294,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2544001,'MA','Ksar El Kebir','Ksar El Kebir',35.0004,-5.90378,'P','PPL','MA.01','MA.01.331',108753,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2544248,'MA','Khouribga','Khouribga',32.8811,-6.9063,'P','PPLA3','MA.05','MA.05.311',167673,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2544333,'MA','Khenifra','Khenifra',32.9349,-5.66167,'P','PPLA3','MA.05','MA.05.301',73906,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2544571,'MA','Kenitra','Kenitra',34.261,-6.5802,'P','PPLA','MA.04','MA.04.281',366570,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2544720,'MA','Kasba Tadla','Kasba Tadla',32.5977,-6.26844,'P','PPLA3','MA.05','MA.05.091',41199,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2545017,'MA','Jerada','Jerada',34.31,-2.16,'P','PPLA3','MA.02','MA.02.275',43696,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2548489,'MA','Guercif','Guercif',34.2257,-3.35361,'P','PPLA3','MA.03','MA.03.561',57544,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2548526,'MA','Guelmim','Guelmim',28.987,-10.0574,'P','PPLA','MA.10','MA.10.261',98229,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2548830,'MA','Al Fqih Ben Çalah','Al Fqih Ben Calah',32.5021,-6.68771,'P','PPL','MA.05','MA.05.255',84072,'Africa/Casablanca',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2548851,'MA','Figuig (Centre)','Figuig (Centre)',32.1089,-1.22855,'P','PPL','MA.54',NULL,12516,'Africa/Casablanca',1,'2009-06-19 23:00:00','2009-06-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2548880,'MA','Fès al Bali','Fes al Bali',34.0701,-4.95473,'P','PPLX','MA.03','MA.03.231',156000,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2548885,'MA','Fès','Fes',34.0331,-5.00028,'P','PPLA','MA.03','MA.03.231',964891,'Africa/Casablanca',1,'2016-12-04 23:00:00','2016-12-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2549263,'MA','Essaouira','Essaouira',31.5125,-9.77,'P','PPLA3','MA.07','MA.07.211',70634,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2550078,'MA','El Jadid','El Jadid',33.2568,-8.50882,'P','PPL','MA.06','MA.06.181',147549,'Africa/Casablanca',1,'2017-03-04 23:00:00','2017-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2550252,'MA','El Hajeb','El Hajeb',33.6879,-5.371,'P','PPLA3','MA.03','MA.03.171',28126,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2550806,'MA','El Aïoun','El Aioun',34.5832,-2.50612,'P','PPL','MA.02',NULL,35196,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2550898,'MA','Imzouren','Imzouren',35.1464,-3.85063,'P','PPLA3','MA.01','MA.01.051',40000,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2553455,'MA','Chefchaouene','Chefchaouene',35.1688,-5.2636,'P','PPLA2','MA.01','MA.01.151',36280,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2553604,'MA','Casablanca','Casablanca',33.5883,-7.61138,'P','PPLA','MA.06','MA.06.141',3144909,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2553751,'MA','Bouznika','Bouznika',33.7894,-7.15968,'P','PPLA3','MA.06','MA.06.111',27283,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2555467,'MA','Berkane','Berkane',34.92,-2.32,'P','PPLA3','MA.02','MA.02.113',80721,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2555745,'MA','Beni Mellal','Beni Mellal',32.3372,-6.34983,'P','PPLA','MA.05','MA.05.091',166399,'Africa/Casablanca',1,'2017-02-02 23:00:00','2017-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2556272,'MA','Berrechid','Berrechid',33.2655,-7.58754,'P','PPLA3','MA.06','MA.06.461',93954,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2556464,'MA','Azrou','Azrou',33.4344,-5.22126,'P','PPLA3','MA.03','MA.03.271',48249,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2556657,'MA','Azemmour','Azemmour',33.2895,-8.3425,'P','PPLA3','MA.06','MA.06.181',37140,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2557055,'MA','Asilah','Asilah',35.4652,-6.03415,'P','PPL','MA.01','MA.01.511',28861,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2558470,'MA','Khemisset','Khemisset',33.824,-6.06627,'P','PPLA3','MA.04','MA.04.291',106991,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2558545,'MA','Al Hoceïma','Al Hoceima',35.2517,-3.93723,'P','PPLA2','MA.01','MA.01.051',395644,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2561124,'MA','Ahfir','Ahfir',34.9537,-2.10027,'P','PPLA3','MA.02','MA.02.113',19611,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2561668,'MA','Agadir','Agadir',30.4202,-9.59815,'P','PPLA','MA.09','MA.09.001',698310,'Africa/Casablanca',1,'2017-07-16 23:00:00','2017-07-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2562055,'MA','Skhirate','Skhirate',33.8527,-7.03171,'P','PPLA3','MA.04','MA.04.501',44850,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2565267,'MA','Mhamid','Mhamid',29.82,-5.72,'P','PPL','MA.08',NULL,10000,'Africa/Casablanca',1,'2017-10-03 23:00:00','2017-10-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6546693,'MA','Boujniba','Boujniba',32.9005,-6.77464,'P','PPL','MA.05','MA.05.311',15041,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7280528,'MA','Errachidia','Errachidia',31.9314,-4.42663,'P','PPLA3','MA.08','MA.08.201',92374,'Africa/Casablanca',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8542188,'MA','Dakhla','Dakhla',30.4107,-9.55572,'P','PPLX','MA.EH',NULL,55618,'Africa/Casablanca',1,'2016-03-17 23:00:00','2016-03-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9645313,'MA','Gueltat Zemmour','Gueltat Zemmour',25.1428,-12.3717,'P','PPL','MA.11','MA.11.121',6740,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 23:00:00');


