(148943,194,'As Sayl al Kabir',NULL,2850,'active',NULL,NULL,NULL),(148944,194,'As Sayl as Saghir',NULL,2850,'active',NULL,NULL,NULL),(148945,194,'As Sifyani',NULL,2850,'active',NULL,NULL,NULL),(148946,194,'As Sudayrah, Makkah',NULL,2850,'active',NULL,NULL,NULL),(148947,194,'As Suwadah',NULL,2850,'active',NULL,NULL,NULL),(148948,194,'Ash Shajwah',NULL,2850,'active',NULL,NULL,NULL),(148949,194,'Ash Shamiyah',NULL,2850,'active',NULL,NULL,NULL),(148950,194,'Ash Shara\'i`',NULL,2850,'active',NULL,NULL,NULL),(148951,194,'Ash Shaybi',NULL,2850,'active',NULL,NULL,NULL),(148952,194,'Ash Shi`b',NULL,2850,'active',NULL,NULL,NULL),(148953,194,'Ash Shishah',NULL,2850,'active',NULL,NULL,NULL),(148954,194,'Ash Shumaysi',NULL,2850,'active',NULL,NULL,NULL),(148955,194,'Ash Shuwaybit',NULL,2850,'active',NULL,NULL,NULL),(148956,194,'At Tan`im',NULL,2850,'active',NULL,NULL,NULL),(148957,194,'At Tarfa\'',NULL,2850,'active',NULL,NULL,NULL),(148958,194,'At Turqi',NULL,2850,'active',NULL,NULL,NULL),(148959,194,'Az Zaymah',NULL,2850,'active',NULL,NULL,NULL),(148960,194,'Az Zilal',NULL,2850,'active',NULL,NULL,NULL),(148961,194,'Az Zughbah',NULL,2850,'active',NULL,NULL,NULL),(148962,194,'Az Zurra`',NULL,2850,'active',NULL,NULL,NULL),(148963,194,'Az Zuwayb',NULL,2850,'active',NULL,NULL,NULL),(148964,194,'Bahrat al Qadimah',NULL,2850,'active',NULL,NULL,NULL),(148965,194,'Bahwil',NULL,2850,'active',NULL,NULL,NULL),(148966,194,'Baranah',NULL,2850,'active',NULL,NULL,NULL),(148967,194,'Barzah',NULL,2850,'active',NULL,NULL,NULL),(148968,194,'Bashm',NULL,2850,'active',NULL,NULL,NULL),(148969,194,'Buraykah',NULL,2850,'active',NULL,NULL,NULL),(148970,194,'Burayman',NULL,2850,'active',NULL,NULL,NULL),(148971,194,'CITY GHRAN',NULL,2850,'active',NULL,NULL,NULL),(148972,194,'Dabyah',NULL,2850,'active',NULL,NULL,NULL),(148973,194,'Dahaban',NULL,2850,'active',NULL,NULL,NULL),(148974,194,'Dughaybjah',NULL,2850,'active',NULL,NULL,NULL),(148975,194,'Fayd',NULL,2850,'active',NULL,NULL,NULL),(148976,194,'Hadda\'',NULL,2850,'active',NULL,NULL,NULL),(148977,194,'Haddat ash Sham',NULL,2850,'active',NULL,NULL,NULL),(148978,194,'Hadhah',NULL,2850,'active',NULL,NULL,NULL),(148979,194,'Hajur',NULL,2850,'active',NULL,NULL,NULL),(148980,194,'Halamah',NULL,2850,'active',NULL,NULL,NULL),(148981,194,'Husnah',NULL,2850,'active',NULL,NULL,NULL),(148982,194,'Jarwal',NULL,2850,'active',NULL,NULL,NULL),(148983,194,'Julayyil',NULL,2850,'active',NULL,NULL,NULL),(148984,194,'Khamis Mushait',NULL,2850,'active',NULL,NULL,NULL),(148985,194,'Khumrah',NULL,2850,'active',NULL,NULL,NULL),(148986,194,'Kulakh',NULL,2850,'active',NULL,NULL,NULL),(148987,194,'Ma`riyah',NULL,2850,'active',NULL,NULL,NULL),(148988,194,'Madrakah',NULL,2850,'active',NULL,NULL,NULL),(148989,194,'Mafruq',NULL,2850,'active',NULL,NULL,NULL),(148990,194,'Malakan',NULL,2850,'active',NULL,NULL,NULL),(148991,194,'Mashajji',NULL,2850,'active',NULL,NULL,NULL),(148992,194,'Masihat Mahd al Hayl',NULL,2850,'active',NULL,NULL,NULL),(148993,194,'Maskar',NULL,2850,'active',NULL,NULL,NULL),(148994,194,'Matiyah',NULL,2850,'active',NULL,NULL,NULL),(148995,194,'Mifa',NULL,2850,'active',NULL,NULL,NULL),(148996,194,'Mina',NULL,2850,'active',NULL,NULL,NULL),(148997,194,'Munayzir',NULL,2850,'active',NULL,NULL,NULL),(148998,194,'Murshidiyah',NULL,2850,'active',NULL,NULL,NULL),(148999,194,'Mushrif',NULL,2850,'active',NULL,NULL,NULL),(149000,194,'Nughayshiyah',NULL,2850,'active',NULL,NULL,NULL),(149001,194,'Nuzlat al Faqin',NULL,2850,'active',NULL,NULL,NULL),(149002,194,'Qiya',NULL,2850,'active',NULL,NULL,NULL),(149003,194,'Quwayzah',NULL,2850,'active',NULL,NULL,NULL),(149004,194,'Rabwah Ghran',NULL,2850,'active',NULL,NULL,NULL),(149005,194,'Raqiyah',NULL,2850,'active',NULL,NULL,NULL),(149006,194,'Sabuhah',NULL,2850,'active',NULL,NULL,NULL),(149007,194,'Shi`b `amir',NULL,2850,'active',NULL,NULL,NULL),(149008,194,'Shira`ayn',NULL,2850,'active',NULL,NULL,NULL),(149009,194,'Sulaym',NULL,2850,'active',NULL,NULL,NULL),(149010,194,'Sumaymah',NULL,2850,'active',NULL,NULL,NULL),(149011,194,'Suways',NULL,2850,'active',NULL,NULL,NULL),(149012,194,'Tabalah',NULL,2850,'active',NULL,NULL,NULL),(149013,194,'Tharwah',NULL,2850,'active',NULL,NULL,NULL),(149014,194,'Thuwal',NULL,2850,'active',NULL,NULL,NULL),(149015,194,'Usfan',NULL,2850,'active',NULL,NULL,NULL),(149016,194,'Wadi al Jalil',NULL,2850,'active',NULL,NULL,NULL),(149017,194,'Al Bir',NULL,2849,'active',NULL,NULL,NULL),(149018,194,'Al Hair',NULL,2849,'active',NULL,NULL,NULL),(149019,194,'Al Jurayfah',NULL,2849,'active',NULL,NULL,NULL),(149020,194,'Ar Rayn',NULL,2849,'active',NULL,NULL,NULL),(149021,194,'As Salamiyah',NULL,2849,'active',NULL,NULL,NULL),(149022,194,'Dawadmi',NULL,2849,'active',NULL,NULL,NULL),(149023,194,'Diriyah',NULL,2849,'active',NULL,NULL,NULL),(149024,194,'Harmah',NULL,2849,'active',NULL,NULL,NULL),(149025,194,'Jalajil',NULL,2849,'active',NULL,NULL,NULL),(149026,194,'Layla',NULL,2849,'active',NULL,NULL,NULL),(149027,194,'Manfuha',NULL,2849,'active',NULL,NULL,NULL),(149028,194,'Najan',NULL,2849,'active',NULL,NULL,NULL),(149029,194,'Najran',NULL,2849,'active',NULL,NULL,NULL),(149030,218,'Chimala',NULL,4955,'active',NULL,NULL,NULL),(149031,218,'Hedaru',NULL,4955,'active',NULL,NULL,NULL),(149032,218,'Ibaba',NULL,4955,'active',NULL,NULL,NULL),(149033,218,'Ikama',NULL,4955,'active',NULL,NULL,NULL),(149034,218,'Ikinga',NULL,4955,'active',NULL,NULL,NULL),(149035,218,'Ikolo',NULL,4955,'active',NULL,NULL,NULL),(149036,218,'Ikuti',NULL,4955,'active',NULL,NULL,NULL),(149037,218,'Ilembo',NULL,4955,'active',NULL,NULL,NULL),(149038,218,'Ipinda',NULL,4955,'active',NULL,NULL,NULL),(149039,218,'Kabula',NULL,4955,'active',NULL,NULL,NULL),(149040,218,'Kahe, Tanzania',NULL,4955,'active',NULL,NULL,NULL),(149041,218,'Kandete',NULL,4955,'active',NULL,NULL,NULL),(149042,218,'Katumba',NULL,4955,'active',NULL,NULL,NULL),(149043,218,'Kihurio',NULL,4955,'active',NULL,NULL,NULL),(149044,218,'Kisiwani',NULL,4955,'active',NULL,NULL,NULL),(149045,218,'Kiwira',NULL,4955,'active',NULL,NULL,NULL),(149046,218,'Kwakoa',NULL,4955,'active',NULL,NULL,NULL),(149047,218,'Lembeni',NULL,4955,'active',NULL,NULL,NULL),(149048,218,'Lupata',NULL,4955,'active',NULL,NULL,NULL),(149049,218,'Lusungo',NULL,4955,'active',NULL,NULL,NULL),(149050,218,'Machame',NULL,4955,'active',NULL,NULL,NULL),(149051,218,'Makanya',NULL,4955,'active',NULL,NULL,NULL),(149052,218,'Marangu',NULL,4955,'active',NULL,NULL,NULL),(149053,218,'Masukulu',NULL,4955,'active',NULL,NULL,NULL),(149054,218,'Mbeya',NULL,4955,'active',NULL,NULL,NULL),(149055,218,'Mlowo',NULL,4955,'active',NULL,NULL,NULL),(149056,218,'Moshi',NULL,4955,'active',NULL,NULL,NULL),(149057,218,'Mpuguso',NULL,4955,'active',NULL,NULL,NULL),(149058,218,'Mwansanga',NULL,4955,'active',NULL,NULL,NULL),(149059,218,'Mwaya',NULL,4955,'active',NULL,NULL,NULL),(149060,218,'Mwembe',NULL,4955,'active',NULL,NULL,NULL),(149061,218,'Same',NULL,4955,'active',NULL,NULL,NULL),(149062,218,'Tukuyu',NULL,4955,'active',NULL,NULL,NULL),(149063,218,'Tunduma',NULL,4955,'active',NULL,NULL,NULL),(149064,218,'Ugweno',NULL,4955,'active',NULL,NULL,NULL),(149065,218,'Ulanga',NULL,4955,'active',NULL,NULL,NULL),(149066,161,'Gboko',NULL,291,'active',NULL,NULL,NULL),(149067,233,'Mantua Township',NULL,1417,'active',NULL,NULL,NULL),(149068,83,'Tano South',NULL,53,'active',NULL,NULL,NULL),(149069,83,'Tano North',NULL,53,'active',NULL,NULL,NULL),(149070,83,'Asunafo North',NULL,53,'active',NULL,NULL,NULL),(149071,83,'Asunafo South',NULL,53,'active',NULL,NULL,NULL),(149072,83,'Asutifi North',NULL,53,'active',NULL,NULL,NULL),(149073,83,'Asutifi South',NULL,53,'active',NULL,NULL,NULL),(149074,83,'Techiman',NULL,4958,'active',NULL,NULL,NULL),(149075,83,'Techiman North',NULL,4958,'active',NULL,NULL,NULL),(149076,83,'Atebubu-Amantin',NULL,4958,'active',NULL,NULL,NULL),(149077,83,'Kintampo North',NULL,4958,'active',NULL,NULL,NULL),(149078,83,'Kintampo South',NULL,4958,'active',NULL,NULL,NULL),(149079,83,'Nkoranza North',NULL,4958,'active',NULL,NULL,NULL),(149080,83,'Nkoranza South',NULL,4958,'active',NULL,NULL,NULL),(149081,83,'Pru West',NULL,4958,'active',NULL,NULL,NULL),(149082,83,'Pru East',NULL,4958,'active',NULL,NULL,NULL),(149083,83,'Sene East',NULL,4958,'active',NULL,NULL,NULL),(149084,83,'Sene West',NULL,4958,'active',NULL,NULL,NULL),(149086,83,'Banda',NULL,4959,'active',NULL,NULL,NULL),(149087,83,'Berekum East',NULL,4959,'active',NULL,NULL,NULL),(149088,83,'Berekum West',NULL,4959,'active',NULL,NULL,NULL),(149089,83,'Dormaa Central',NULL,4959,'active',NULL,NULL,NULL),(149090,83,'Dormaa East',NULL,4959,'active',NULL,NULL,NULL),(149091,83,'Dormaa West',NULL,4959,'active',NULL,NULL,NULL),(149092,83,'Jaman North',NULL,4959,'active',NULL,NULL,NULL),(149093,83,'Jaman South',NULL,4959,'active',NULL,NULL,NULL),(149094,83,'Sunyani',NULL,4959,'active',NULL,NULL,NULL),(149095,83,'Sunyani West',NULL,4959,'active',NULL,NULL,NULL),(149096,83,'Tain',NULL,4959,'active',NULL,NULL,NULL),(149097,83,'Wenchi',NULL,4959,'active',NULL,NULL,NULL),(149098,83,'Bunkpurugu-Nyakpanduri',NULL,4960,'active',NULL,NULL,NULL),(149099,83,'Chereponi',NULL,4960,'active',NULL,NULL,NULL),(149100,83,'East Mamprusi',NULL,4960,'active',NULL,NULL,NULL),(149101,83,'Mamprugu-Moagduri',NULL,4960,'active',NULL,NULL,NULL),(149102,83,'West Mamprusi',NULL,4960,'active',NULL,NULL,NULL),(149103,83,'Yunyoo-Nasuan',NULL,4960,'active',NULL,NULL,NULL),(149104,83,'Biakoye',NULL,4961,'active',NULL,NULL,NULL),(149105,83,'Jasikan',NULL,4961,'active',NULL,NULL,NULL),(149106,83,'Kadjebi',NULL,4961,'active',NULL,NULL,NULL),(149107,83,'Krachi East',NULL,4961,'active',NULL,NULL,NULL),(149108,83,'Krachi Nchumuru',NULL,4961,'active',NULL,NULL,NULL),(149109,83,'Krachi West',NULL,4961,'active',NULL,NULL,NULL),(149110,83,'Nkwanta North',NULL,4961,'active',NULL,NULL,NULL),(149111,83,'Nkwanta South',NULL,4961,'active',NULL,NULL,NULL),(149112,83,'Bole',NULL,4962,'active',NULL,NULL,NULL),(149113,83,'Central Gonja',NULL,4962,'active',NULL,NULL,NULL),(149114,83,'North Gonja',NULL,4962,'active',NULL,NULL,NULL),(149115,83,'East Gonja',NULL,4962,'active',NULL,NULL,NULL),(149116,83,'North East Gonja',NULL,4962,'active',NULL,NULL,NULL),(149117,83,'Sawla-Tuna-Kalba',NULL,4962,'active',NULL,NULL,NULL),(149118,83,'West Gonja',NULL,4962,'active',NULL,NULL,NULL),(149119,83,'Aowin',NULL,4963,'active',NULL,NULL,NULL),(149120,83,'Bia East',NULL,4963,'active',NULL,NULL,NULL),(149121,83,'Bia West',NULL,4963,'active',NULL,NULL,NULL),(149122,83,'Bibiani-Anhwiaso-Bekwai',NULL,4963,'active',NULL,NULL,NULL),(149123,83,'Bodi',NULL,4963,'active',NULL,NULL,NULL),(149124,83,'Juaboso',NULL,4963,'active',NULL,NULL,NULL),(149125,83,'Sefwi-Akontombra',NULL,4963,'active',NULL,NULL,NULL),(149126,83,'Sefwi-Wiawso',NULL,4963,'active',NULL,NULL,NULL),(149127,83,'Suaman',NULL,4963,'active',NULL,NULL,NULL),(149129,214,'Basel',NULL,4957,'active',NULL,NULL,NULL),(149130,214,'Bettingen',NULL,4957,'active',NULL,NULL,NULL),(149131,214,'Riehen',NULL,4957,'active',NULL,NULL,NULL),(149132,159,'Ciudad Antigua',NULL,4964,'active',NULL,NULL,NULL),(149133,159,'Dipilto',NULL,4964,'active',NULL,NULL,NULL),(149134,159,'El Jicaro',NULL,4964,'active',NULL,NULL,NULL),(149135,159,'Jalapa',NULL,4964,'active',NULL,NULL,NULL),(149136,159,'Macuelizo',NULL,4964,'active',NULL,NULL,NULL),(149137,159,'Mozonte',NULL,4964,'active',NULL,NULL,NULL),(149138,159,'Murra',NULL,4964,'active',NULL,NULL,NULL),(149139,159,'Ocotal',NULL,4964,'active',NULL,NULL,NULL),(149140,159,'Quilali',NULL,4964,'active',NULL,NULL,NULL),(149141,159,'San Fernando',NULL,4964,'active',NULL,NULL,NULL),(149142,159,'Santa Maria',NULL,4964,'active',NULL,NULL,NULL),(149143,159,'Wiwili',NULL,4964,'active',NULL,NULL,NULL),(149144,14,'Rosebery',NULL,3909,'active',NULL,NULL,NULL),(149145,14,'Yallah',NULL,3909,'active',NULL,NULL,NULL),(149146,45,'Badaogu',NULL,2276,'active',NULL,NULL,NULL),(149147,45,'Baijian',NULL,2276,'active',NULL,NULL,NULL),(149148,45,'Bamencheng',NULL,2276,'active',NULL,NULL,NULL),(149149,45,'Bangjun',NULL,2276,'active',NULL,NULL,NULL),(149150,45,'Beicang',NULL,2276,'active',NULL,NULL,NULL),(149151,45,'Beihuaidian',NULL,2276,'active',NULL,NULL,NULL),(149152,45,'Beilizigu',NULL,2276,'active',NULL,NULL,NULL),(149153,45,'Biaokou',NULL,2276,'active',NULL,NULL,NULL),(149154,45,'Binhai New Area',NULL,2276,'active',NULL,NULL,NULL),(149155,45,'Caijiapu',NULL,2276,'active',NULL,NULL,NULL),(149156,45,'Caodian',NULL,2276,'active',NULL,NULL,NULL),(149157,45,'Chabaihu',NULL,2276,'active',NULL,NULL,NULL),(149158,45,'Changtun',NULL,2276,'active',NULL,NULL,NULL),(149159,45,'Chengtougu',NULL,2276,'active',NULL,NULL,NULL),(149160,45,'Chitu',NULL,2276,'active',NULL,NULL,NULL),(149161,45,'Cuijiamatou',NULL,2276,'active',NULL,NULL,NULL),(149162,45,'Dadunqiu',NULL,2276,'active',NULL,NULL,NULL),(149163,45,'Dakoutun',NULL,2276,'active',NULL,NULL,NULL),(149164,45,'Dashentang',NULL,2276,'active',NULL,NULL,NULL),(149165,45,'Dawangtai',NULL,2276,'active',NULL,NULL,NULL),(149166,45,'Daxinzhuang',NULL,2276,'active',NULL,NULL,NULL),(149167,45,'Dazhongzhuang',NULL,2276,'active',NULL,NULL,NULL),(149168,45,'Dongditou',NULL,2276,'active',NULL,NULL,NULL),(149169,45,'Dongshigu',NULL,2276,'active',NULL,NULL,NULL),(149170,45,'Erwangzhuang',NULL,2276,'active',NULL,NULL,NULL),(149171,45,'Fanzhuang',NULL,2276,'active',NULL,NULL,NULL),(149172,45,'Fengtai (Ninghe)',NULL,2276,'active',NULL,NULL,NULL),(149173,45,'Fuzhuang',NULL,2276,'active',NULL,NULL,NULL),(149174,45,'Gaojingzhuang',NULL,2276,'active',NULL,NULL,NULL),(149175,45,'Hanjiashu',NULL,2276,'active',NULL,NULL,NULL),(149176,45,'Hebeitun',NULL,2276,'active',NULL,NULL,NULL),(149177,45,'Hexiwu',NULL,2276,'active',NULL,NULL,NULL),(149178,45,'Huangcaotuo',NULL,2276,'active',NULL,NULL,NULL),(149179,45,'Huantuo',NULL,2276,'active',NULL,NULL,NULL),(149180,45,'Huogezhuang',NULL,2276,'active',NULL,NULL,NULL),(149181,45,'Jiangwakou',NULL,2276,'active',NULL,NULL,NULL),(149182,45,'Zhangjiawo',NULL,2276,'active',NULL,NULL,NULL),(149183,45,'Lianzhuang',NULL,2276,'active',NULL,NULL,NULL),(149184,45,'Lintingkou',NULL,2276,'active',NULL,NULL,NULL),(149185,45,'Liujiading',NULL,2276,'active',NULL,NULL,NULL),(149186,45,'Liukuaizhuang',NULL,2276,'active',NULL,NULL,NULL),(149187,45,'Liuzikou',NULL,2276,'active',NULL,NULL,NULL),(149188,45,'Luotuofangzi',NULL,2276,'active',NULL,NULL,NULL),(149189,45,'Meichang',NULL,2276,'active',NULL,NULL,NULL),(149190,45,'Mengquan',NULL,2276,'active',NULL,NULL,NULL),(149191,45,'Panzhuang',NULL,2276,'active',NULL,NULL,NULL),(149192,45,'Qingguang',NULL,2276,'active',NULL,NULL,NULL),(149193,45,'Sangzi',NULL,2276,'active',NULL,NULL,NULL),(149194,45,'Shangcang',NULL,2276,'active',NULL,NULL,NULL),(149195,45,'Shimianzhuang',NULL,2276,'active',NULL,NULL,NULL),(149196,45,'Shuangjiang',NULL,2276,'active',NULL,NULL,NULL),(149197,45,'Sigaozhuang',NULL,2276,'active',NULL,NULL,NULL),(149198,45,'Tianjin',NULL,2276,'active',NULL,NULL,NULL),(149199,45,'Touying',NULL,2276,'active',NULL,NULL,NULL),(149200,45,'Wangqinzhuang',NULL,2276,'active',NULL,NULL,NULL),(149201,45,'Weiwangzhuang',NULL,2276,'active',NULL,NULL,NULL),(149202,45,'Xiawuqi',NULL,2276,'active',NULL,NULL,NULL),(149203,45,'Xiditou',NULL,2276,'active',NULL,NULL,NULL),(149204,45,'Xinkaikou',NULL,2276,'active',NULL,NULL,NULL),(149205,45,'Xitazhuang',NULL,2276,'active',NULL,NULL,NULL),(149206,45,'Yangjinzhuang',NULL,2276,'active',NULL,NULL,NULL),(149207,45,'Yangliuqing',NULL,2276,'active',NULL,NULL,NULL),(149208,45,'Yinliu',NULL,2276,'active',NULL,NULL,NULL),(149209,45,'Yixingfu',NULL,2276,'active',NULL,NULL,NULL),(149210,45,'Youguzhuang',NULL,2276,'active',NULL,NULL,NULL),(149211,45,'Yuelongzhuang',NULL,2276,'active',NULL,NULL,NULL),(149212,45,'Yuguzhuang',NULL,2276,'active',NULL,NULL,NULL),(149213,45,'Zaojiacheng',NULL,2276,'active',NULL,NULL,NULL),(149214,45,'Zhaoguli',NULL,2276,'active',NULL,NULL,NULL),(149215,14,'Banksmeadow',NULL,3909,'active',NULL,NULL,NULL),(149216,14,'Whale Beach',NULL,3909,'active',NULL,NULL,NULL),(149220,65,'10th of Ramadan',NULL,5067,'active',NULL,NULL,NULL),(149221,65,'Markaz Abu Hammad',NULL,5067,'active',NULL,NULL,NULL),(149223,65,'Awlad Saqr',NULL,5067,'active',NULL,NULL,NULL),(149224,65,'Bilbeis',NULL,5067,'active',NULL,NULL,NULL),(149225,65,'Diyarb Negm',NULL,5067,'active',NULL,NULL,NULL),(149226,65,'El Husseiniya',NULL,5067,'active',NULL,NULL,NULL),(149228,65,'Al Qurein',NULL,5067,'active',NULL,NULL,NULL),(149229,65,'Faqous',NULL,5067,'active',NULL,NULL,NULL),(149230,65,'Hihya',NULL,5067,'active',NULL,NULL,NULL),(149231,65,'Kafr Saqr',NULL,5067,'active',NULL,NULL,NULL),(149232,65,'Mashtoul El Souk',NULL,5067,'active',NULL,NULL,NULL),(149233,65,'Minya El Qamh',NULL,5067,'active',NULL,NULL,NULL),(149234,65,'New Salhia',NULL,5067,'active',NULL,NULL,NULL),(149235,65,'Zagazig',NULL,5067,'active',NULL,NULL,NULL),(149237,48,'Bogota D.C.',NULL,4921,'active',NULL,NULL,NULL),(149238,48,'Bosconia',NULL,2899,'active',NULL,NULL,NULL),(149239,48,'Buenavista',NULL,2902,'active',NULL,NULL,NULL),(149240,48,'El Dorado',NULL,2878,'active',NULL,NULL,NULL),(149241,48,'Guachene',NULL,2884,'active',NULL,NULL,NULL),(149242,48,'La Argentina',NULL,4871,'active',NULL,NULL,NULL),(149243,48,'La Salina',NULL,2892,'active',NULL,NULL,NULL),(149244,48,'Paz de Ariporo',NULL,2892,'active',NULL,NULL,NULL),(149245,48,'Piamonte',NULL,2884,'active',NULL,NULL,NULL),(149246,48,'Providencia',NULL,2897,'active',NULL,NULL,NULL),(149247,48,'Pueblo Bello',NULL,2899,'active',NULL,NULL,NULL),(149248,48,'Puerto Caicedo',NULL,2896,'active',NULL,NULL,NULL),(149249,48,'Santa Helena Del Opon',NULL,2901,'active',NULL,NULL,NULL),(149250,48,'Santa Rosa',NULL,2884,'active',NULL,NULL,NULL),(149251,48,'San Jose de Ure',NULL,2898,'active',NULL,NULL,NULL),(149252,48,'San Juanito',NULL,2878,'active',NULL,NULL,NULL),(149253,48,'San Luis',NULL,2890,'active',NULL,NULL,NULL),(149254,48,'San Vicente del Caguan',NULL,2891,'active',NULL,NULL,NULL),(149255,48,'Solita',NULL,2891,'active',NULL,NULL,NULL),(149256,48,'Teorama',NULL,2877,'active',NULL,NULL,NULL),(149257,48,'Timbio',NULL,2884,'active',NULL,NULL,NULL),(149258,48,'Tuchin',NULL,2898,'active',NULL,NULL,NULL),(149259,48,'Uribe',NULL,2878,'active',NULL,NULL,NULL),(149260,48,'Villa Caro',NULL,2877,'active',NULL,NULL,NULL),(149261,239,'Caracas',NULL,4855,'active',NULL,NULL,NULL),(149262,64,'Loja',NULL,5068,'active',NULL,NULL,NULL),(149263,45,'NanJing',NULL,2250,'active',NULL,NULL,NULL),(149264,45,'WuXi',NULL,2250,'active',NULL,NULL,NULL),(149265,45,'XuZhou',NULL,2250,'active',NULL,NULL,NULL),(149266,45,'ChangZhou',NULL,2250,'active',NULL,NULL,NULL),(149267,45,'SuZhou',NULL,2250,'active',NULL,NULL,NULL),(149268,45,'NanTong',NULL,2250,'active',NULL,NULL,NULL),(149269,45,'LianYunGang',NULL,2250,'active',NULL,NULL,NULL),(149270,45,'HuaiAn',NULL,2250,'active',NULL,NULL,NULL),(149271,45,'YanCheng',NULL,2250,'active',NULL,NULL,NULL),(149272,45,'YangZhou',NULL,2250,'active',NULL,NULL,NULL),(149273,45,'ZhenJiang',NULL,2250,'active',NULL,NULL,NULL),(149274,45,'TaiZhou',NULL,2250,'active',NULL,NULL,NULL),(149275,45,'SuQian',NULL,2250,'active',NULL,NULL,NULL),(149276,235,'Bella Vista',NULL,3218,'active',NULL,NULL,NULL),(149277,235,'Belvedere',NULL,3218,'active',NULL,NULL,NULL),(149278,235,'Buceo',NULL,3218,'active',NULL,NULL,NULL),(149279,235,'Capurro (Montevideo)',NULL,3218,'active',NULL,NULL,NULL),(149280,235,'Carrasco',NULL,3218,'active',NULL,NULL,NULL),(149281,235,'Casabo',NULL,3218,'active',NULL,NULL,NULL),(149282,235,'Centro',NULL,3218,'active',NULL,NULL,NULL),(149283,235,'Cerrito, Montevideo',NULL,3218,'active',NULL,NULL,NULL),(149284,235,'Colon Centro y Noroeste',NULL,3218,'active',NULL,NULL,NULL),(149285,235,'Colon Sudeste',NULL,3218,'active',NULL,NULL,NULL),(149286,235,'Conciliacion',NULL,3218,'active',NULL,NULL,NULL),(149287,235,'Cordon',NULL,3218,'active',NULL,NULL,NULL),(149288,235,'Flor de Maronas',NULL,3218,'active',NULL,NULL,NULL),(149289,235,'Ituzaingo',NULL,3218,'active',NULL,NULL,NULL),(149290,235,'La Union',NULL,3218,'active',NULL,NULL,NULL),(149291,235,'Malvin',NULL,3218,'active',NULL,NULL,NULL),(149292,235,'Manga',NULL,3218,'active',NULL,NULL,NULL),(149293,235,'Maronas',NULL,3218,'active',NULL,NULL,NULL),(149294,235,'Nuevo Paris',NULL,3218,'active',NULL,NULL,NULL),(149295,235,'Paso del Molino',NULL,3218,'active',NULL,NULL,NULL),(149296,235,'Penarol',NULL,3218,'active',NULL,NULL,NULL),(149297,235,'Piedras Blancas',NULL,3218,'active',NULL,NULL,NULL),(149298,235,'Pocitos',NULL,3218,'active',NULL,NULL,NULL),(149299,235,'Punta Carretas',NULL,3218,'active',NULL,NULL,NULL),(149300,235,'Punta Gorda',NULL,3218,'active',NULL,NULL,NULL),(149301,235,'Reducto',NULL,3218,'active',NULL,NULL,NULL),(149302,235,'Sayage',NULL,3218,'active',NULL,NULL,NULL),(149303,235,'Tres Cruces',NULL,3218,'active',NULL,NULL,NULL),(149304,235,'Villa Espanola',NULL,3218,'active',NULL,NULL,NULL),(149305,235,'Villa Garcia',NULL,3218,'active',NULL,NULL,NULL),(149306,235,'Villa Munoz',NULL,3218,'active',NULL,NULL,NULL),(149307,235,'Villa del Cerro',NULL,3218,'active',NULL,NULL,NULL),(149308,14,'Huntingwood',NULL,3909,'active',NULL,NULL,NULL),(149309,14,'Eagle Farm',NULL,3905,'active',NULL,NULL,NULL),(149310,233,'Dartmouth',NULL,1433,'active',NULL,NULL,NULL),(149311,230,'Abramok',NULL,5071,'active',NULL,NULL,NULL),(149312,230,'Adamivka',NULL,5071,'active',NULL,NULL,NULL),(149313,230,'Adamove',NULL,5071,'active',NULL,NULL,NULL),(149314,230,'Agativka',NULL,5071,'active',NULL,NULL,NULL),(149315,230,'Andriyivka',NULL,5071,'active',NULL,NULL,NULL),(149316,230,'Andrushivka',NULL,5071,'active',NULL,NULL,NULL),(149317,230,'Autozavodskoy Raion',NULL,5071,'active',NULL,NULL,NULL),(149318,230,'Avratin',NULL,5071,'active',NULL,NULL,NULL),(149319,230,'Bairak',NULL,5071,'active',NULL,NULL,NULL),(149320,230,'Baliasne',NULL,5071,'active',NULL,NULL,NULL),(149321,230,'Baranivka',NULL,5071,'active',NULL,NULL,NULL),(149323,230,'Barashi',NULL,5071,'active',NULL,NULL,NULL),(149324,230,'Bazar',NULL,5071,'active',NULL,NULL,NULL),(149325,230,'Bekhi',NULL,5071,'active',NULL,NULL,NULL),(149326,230,'Berdychiv',NULL,5071,'active',NULL,NULL,NULL),(149327,230,'Berestivka',NULL,5071,'active',NULL,NULL,NULL),(149328,230,'Berestovets',NULL,5071,'active',NULL,NULL,NULL),(149329,230,'Berezianka',NULL,5071,'active',NULL,NULL,NULL),(149330,230,'Berezovii Grud',NULL,5071,'active',NULL,NULL,NULL),(149331,230,'Bereztsi',NULL,5071,'active',NULL,NULL,NULL),(149332,230,'Bicheva',NULL,5071,'active',NULL,NULL,NULL),(149333,230,'Bigun',NULL,5071,'active',NULL,NULL,NULL),(149334,230,'Bikiv',NULL,5071,'active',NULL,NULL,NULL),(149335,230,'Bila Krynytsia',NULL,5071,'active',NULL,NULL,NULL),(149336,230,'Bilii Bereg',NULL,5071,'active',NULL,NULL,NULL),(149337,230,'Bilka',NULL,5071,'active',NULL,NULL,NULL),(149338,230,'Bilylivka',NULL,5071,'active',NULL,NULL,NULL),(149339,230,'Bistrik',NULL,5071,'active',NULL,NULL,NULL),(149340,230,'Bistriyivka',NULL,5071,'active',NULL,NULL,NULL),(149341,230,'Borisivka',NULL,5071,'active',NULL,NULL,NULL),(149342,230,'Broniki',NULL,5071,'active',NULL,NULL,NULL),(149343,230,'Bronitska Guta',NULL,5071,'active',NULL,NULL,NULL),(149344,230,'Bronitsia',NULL,5071,'active',NULL,NULL,NULL),(149345,230,'Brovki Pershi',NULL,5071,'active',NULL,NULL,NULL),(149346,230,'Brusyliv',NULL,5071,'active',NULL,NULL,NULL),(149347,230,'Buchmany',NULL,5071,'active',NULL,NULL,NULL),(149348,230,'Buki',NULL,5071,'active',NULL,NULL,NULL),(149349,230,'Buldichiv',NULL,5071,'active',NULL,NULL,NULL),(149350,230,'Buriaki',NULL,5071,'active',NULL,NULL,NULL),(149351,230,'Burkivtsi',NULL,5071,'active',NULL,NULL,NULL),(149352,230,'Bykivka',NULL,5071,'active',NULL,NULL,NULL),(149353,230,'Chernechii Iar',NULL,5071,'active',NULL,NULL,NULL),(149354,230,'Cherniakhiv',NULL,5071,'active',NULL,NULL,NULL),(149355,230,'Chervone',NULL,5071,'active',NULL,NULL,NULL),(149356,230,'Chopovychi',NULL,5071,'active',NULL,NULL,NULL),(149357,230,'Chornukhy',NULL,5071,'active',NULL,NULL,NULL),(149358,230,'Chudniv',NULL,5071,'active',NULL,NULL,NULL),(149359,230,'Chutove',NULL,5071,'active',NULL,NULL,NULL),(149360,230,'Dashynka',NULL,5071,'active',NULL,NULL,NULL),(149361,230,'Davidivka',NULL,5071,'active',NULL,NULL,NULL),(149362,230,'Davydky',NULL,5071,'active',NULL,NULL,NULL),(149363,230,'Denyshi',NULL,5071,'active',NULL,NULL,NULL),(149364,230,'Derhanivka',NULL,5071,'active',NULL,NULL,NULL),(149365,230,'Dibrova',NULL,5071,'active',NULL,NULL,NULL),(149366,230,'Didkovichi',NULL,5071,'active',NULL,NULL,NULL),(149367,230,'Didovichi',NULL,5071,'active',NULL,NULL,NULL),(149368,230,'Divochki',NULL,5071,'active',NULL,NULL,NULL),(149369,230,'Dovbysh',NULL,5071,'active',NULL,NULL,NULL),(149370,230,'Druzhba',NULL,5071,'active',NULL,NULL,NULL),(149371,230,'Dubivka',NULL,5071,'active',NULL,NULL,NULL),(149372,230,'Dubnyki',NULL,5071,'active',NULL,NULL,NULL),(149373,230,'Dubrivka',NULL,5071,'active',NULL,NULL,NULL),(149374,230,'Dvorishche',NULL,5071,'active',NULL,NULL,NULL),(149375,230,'Dykanka',NULL,5071,'active',NULL,NULL,NULL),(149376,230,'Elivka',NULL,5071,'active',NULL,NULL,NULL),(149377,230,'Fedorivka',NULL,5071,'active',NULL,NULL,NULL),(149378,230,'Filenkove',NULL,5071,'active',NULL,NULL,NULL),(149379,230,'Glinivtsi',NULL,5071,'active',NULL,NULL,NULL),(149380,230,'Godikha',NULL,5071,'active',NULL,NULL,NULL),(149381,230,'Golovenka',NULL,5071,'active',NULL,NULL,NULL),(149382,230,'Golovki',NULL,5071,'active',NULL,NULL,NULL),(149383,230,'Golubyatin',NULL,5071,'active',NULL,NULL,NULL),(149384,230,'Gorbuliv',NULL,5071,'active',NULL,NULL,NULL),(149385,230,'Gordiyivka',NULL,5071,'active',NULL,NULL,NULL),(149386,230,'Gorianshchina',NULL,5071,'active',NULL,NULL,NULL),(149387,230,'Gorodkivka',NULL,5071,'active',NULL,NULL,NULL),(149388,230,'Gorodok',NULL,5071,'active',NULL,NULL,NULL),(149389,230,'Gorodske',NULL,5071,'active',NULL,NULL,NULL),(149390,230,'Goropayi',NULL,5071,'active',NULL,NULL,NULL),(149391,230,'Goshiv',NULL,5071,'active',NULL,NULL,NULL),(149392,230,'Gromada',NULL,5071,'active',NULL,NULL,NULL),(149393,230,'Grozyne',NULL,5071,'active',NULL,NULL,NULL),(149394,230,'Grushki',NULL,5071,'active',NULL,NULL,NULL),(149395,230,'Gubske',NULL,5071,'active',NULL,NULL,NULL),(149396,230,'Gulsk',NULL,5071,'active',NULL,NULL,NULL),(149397,230,'Gumenniki',NULL,5071,'active',NULL,NULL,NULL),(149398,230,'Guta-Potiyivka',NULL,5071,'active',NULL,NULL,NULL),(149399,230,'Guto-Mariatin',NULL,5071,'active',NULL,NULL,NULL),(149400,230,'Hadiach',NULL,5071,'active',NULL,NULL,NULL),(149401,230,'Hlobyne',NULL,5071,'active',NULL,NULL,NULL),(149402,230,'Holovyne',NULL,5071,'active',NULL,NULL,NULL),(149403,230,'Holubivka',NULL,5071,'active',NULL,NULL,NULL),(149404,230,'Horishni Plavni',NULL,5071,'active',NULL,NULL,NULL),(149405,230,'Horodets',NULL,5071,'active',NULL,NULL,NULL),(149406,230,'Horodnytsia',NULL,5071,'active',NULL,NULL,NULL),(149407,230,'Hradyzk',NULL,5071,'active',NULL,NULL,NULL),(149408,230,'Hranitne',NULL,5071,'active',NULL,NULL,NULL),(149409,230,'Hrebinka',NULL,5071,'active',NULL,NULL,NULL),(149410,230,'Hryshkivtsi',NULL,5071,'active',NULL,NULL,NULL),(149411,230,'Iemilivka',NULL,5071,'active',NULL,NULL,NULL),(149412,230,'Ievgenivka',NULL,5071,'active',NULL,NULL,NULL),(149413,230,'Irshansk',NULL,5071,'active',NULL,NULL,NULL),(149414,230,'Ivanivka',NULL,5071,'active',NULL,NULL,NULL),(149415,230,'Ivankiv',NULL,5071,'active',NULL,NULL,NULL),(149416,230,'Ivanopil',NULL,5071,'active',NULL,NULL,NULL),(149417,230,'Kamiani Potoky',NULL,5071,'active',NULL,NULL,NULL),(149418,230,'Kardashivka',NULL,5071,'active',NULL,NULL,NULL),(149419,230,'Karlivka',NULL,5071,'active',NULL,NULL,NULL),(149420,230,'Khodaky',NULL,5071,'active',NULL,NULL,NULL),(149421,230,'Khorol',NULL,5071,'active',NULL,NULL,NULL),(149422,230,'Khoroshiv',NULL,5071,'active',NULL,NULL,NULL),(149423,230,'Kobeliaky',NULL,5071,'active',NULL,NULL,NULL),(149424,230,'Kononenki',NULL,5071,'active',NULL,NULL,NULL),(149425,230,'Korchak',NULL,5071,'active',NULL,NULL,NULL),(149426,230,'Kornyn',NULL,5071,'active',NULL,NULL,NULL),(149427,230,'Korosten',NULL,5071,'active',NULL,NULL,NULL),(149428,230,'Korostyshiv',NULL,5071,'active',NULL,NULL,NULL),(149429,230,'Kotelva',NULL,5071,'active',NULL,NULL,NULL),(149430,230,'Kozelshchyna',NULL,5071,'active',NULL,NULL,NULL),(149431,230,'Kratova Govtva',NULL,5071,'active',NULL,NULL,NULL),(149432,230,'Kremenchuk',NULL,5071,'active',NULL,NULL,NULL),(149433,230,'Krukovskiy Raion',NULL,5071,'active',NULL,NULL,NULL),(149434,230,'Kucherivka',NULL,5071,'active',NULL,NULL,NULL),(149435,230,'Kupech',NULL,5071,'active',NULL,NULL,NULL),(149436,230,'Kvitneve',NULL,5071,'active',NULL,NULL,NULL),(149437,230,'Landari',NULL,5071,'active',NULL,NULL,NULL),(149438,230,'Lani',NULL,5071,'active',NULL,NULL,NULL),(149439,230,'Lasky',NULL,5071,'active',NULL,NULL,NULL),(149440,230,'Lazarivka',NULL,5071,'active',NULL,NULL,NULL),(149441,230,'Lisogirka',NULL,5071,'active',NULL,NULL,NULL),(149442,230,'Liubar',NULL,5071,'active',NULL,NULL,NULL),(149443,230,'Lokhvytsia',NULL,5071,'active',NULL,NULL,NULL),(149444,230,'Lubny',NULL,5071,'active',NULL,NULL,NULL),(149445,230,'Luhyny',NULL,5071,'active',NULL,NULL,NULL),(149446,230,'Lutovynivka',NULL,5071,'active',NULL,NULL,NULL),(149447,230,'Mala Rudka',NULL,5071,'active',NULL,NULL,NULL),(149448,230,'Malyn',NULL,5071,'active',NULL,NULL,NULL),(149449,230,'Marchenki',NULL,5071,'active',NULL,NULL,NULL),(149450,230,'Markivka',NULL,5071,'active',NULL,NULL,NULL),(149451,230,'Maschiwka',NULL,5071,'active',NULL,NULL,NULL),(149452,230,'Morozivka',NULL,5071,'active',NULL,NULL,NULL),(149453,230,'Myrhorod',NULL,5071,'active',NULL,NULL,NULL),(149454,230,'Myropil',NULL,5071,'active',NULL,NULL,NULL),(149455,230,'Narodychi',NULL,5071,'active',NULL,NULL,NULL),(149456,230,'Nedoharky',NULL,5071,'active',NULL,NULL,NULL),(149457,230,'Nemyryntsi',NULL,5071,'active',NULL,NULL,NULL),(149458,230,'Nova Borova',NULL,5071,'active',NULL,NULL,NULL),(149459,230,'Nova Chortoriia',NULL,5071,'active',NULL,NULL,NULL),(149460,230,'Novi Bilokorovychi',NULL,5071,'active',NULL,NULL,NULL),(149461,230,'Novi Sanzhary',NULL,5071,'active',NULL,NULL,NULL),(149462,230,'Novi Vorobyi',NULL,5071,'active',NULL,NULL,NULL),(149463,230,'Novohrad-Volynskyi',NULL,5071,'active',NULL,NULL,NULL),(149464,230,'Novoozerianka',NULL,5071,'active',NULL,NULL,NULL),(149465,230,'Nyvky',NULL,5071,'active',NULL,NULL,NULL),(149466,230,'Odariukivka',NULL,5071,'active',NULL,NULL,NULL),(149467,230,'Olefirshchina',NULL,5071,'active',NULL,NULL,NULL),(149468,230,'Olevsk',NULL,5071,'active',NULL,NULL,NULL),(149469,230,'Onatski',NULL,5071,'active',NULL,NULL,NULL),(149470,230,'Opishnia',NULL,5071,'active',NULL,NULL,NULL),(149471,230,'Orzhytsia',NULL,5071,'active',NULL,NULL,NULL),(149472,230,'Ovruch',NULL,5071,'active',NULL,NULL,NULL),(149473,230,'Ozerne',NULL,5071,'active',NULL,NULL,NULL),(149474,230,'Pavoloch',NULL,5071,'active',NULL,NULL,NULL),(149475,230,'Pershotravensk',NULL,5071,'active',NULL,NULL,NULL),(149476,230,'Pershotravneve',NULL,5071,'active',NULL,NULL,NULL),(149477,230,'Petrenki',NULL,5071,'active',NULL,NULL,NULL),(149478,230,'Pisarivshchina',NULL,5071,'active',NULL,NULL,NULL),(149479,230,'Pishchiv',NULL,5071,'active',NULL,NULL,NULL),(149480,230,'Polianka',NULL,5071,'active',NULL,NULL,NULL),(149481,230,'Poltava',NULL,5071,'active',NULL,NULL,NULL),(149482,230,'Popilnia',NULL,5071,'active',NULL,NULL,NULL),(149483,230,'Popivka',NULL,5071,'active',NULL,NULL,NULL),(149484,230,'Potiivka',NULL,5071,'active',NULL,NULL,NULL),(149485,230,'Proni',NULL,5071,'active',NULL,NULL,NULL),(149486,230,'Pyriatyn',NULL,5071,'active',NULL,NULL,NULL),(149487,230,'Radomyshl',NULL,5071,'active',NULL,NULL,NULL),(149488,230,'Reshetylivka',NULL,5071,'active',NULL,NULL,NULL),(149489,230,'Rohachi',NULL,5071,'active',NULL,NULL,NULL),(149490,230,'Romaniv',NULL,5071,'active',NULL,NULL,NULL),(149491,230,'Romodan',NULL,5071,'active',NULL,NULL,NULL),(149492,230,'Ruzhyn (settlement)',NULL,5071,'active',NULL,NULL,NULL),(149493,230,'Schyschaky',NULL,5071,'active',NULL,NULL,NULL),(149494,230,'Semenivka',NULL,5071,'active',NULL,NULL,NULL),(149495,230,'Sencha',NULL,5071,'active',NULL,NULL,NULL),(149496,230,'Shumsk',NULL,5071,'active',NULL,NULL,NULL),(149497,230,'Slovechne',NULL,5071,'active',NULL,NULL,NULL),(149498,230,'Smolovivshchina',NULL,5071,'active',NULL,NULL,NULL),(149499,230,'Sokhatska Balka',NULL,5071,'active',NULL,NULL,NULL),(149500,230,'Stepanivka',NULL,5071,'active',NULL,NULL,NULL),(149501,230,'Sudivka',NULL,5071,'active',NULL,NULL,NULL),(149502,230,'Tabory',NULL,5071,'active',NULL,NULL,NULL),(149503,230,'Taraschanka',NULL,5071,'active',NULL,NULL,NULL),(149504,230,'Topory',NULL,5071,'active',NULL,NULL,NULL),(149505,230,'Travneve',NULL,5071,'active',NULL,NULL,NULL),(149506,230,'Troiany',NULL,5071,'active',NULL,NULL,NULL),(149507,230,'Vasilivka',NULL,5071,'active',NULL,NULL,NULL),(149508,230,'Velika Rudka',NULL,5071,'active',NULL,NULL,NULL),(149509,230,'Veliki Budishcha',NULL,5071,'active',NULL,NULL,NULL),(149510,230,'Velyka Bahachka',NULL,5071,'active',NULL,NULL,NULL),(149511,230,'Velyki Korovyntsi',NULL,5071,'active',NULL,NULL,NULL),(149512,230,'Velyki Sorochyntsi',NULL,5071,'active',NULL,NULL,NULL),(149513,230,'Veresna',NULL,5071,'active',NULL,NULL,NULL),(149514,230,'Veselivka',NULL,5071,'active',NULL,NULL,NULL),(149515,230,'Virlya',NULL,5071,'active',NULL,NULL,NULL),(149516,230,'Vodiana Balka',NULL,5071,'active',NULL,NULL,NULL),(149517,230,'Yablunets',NULL,5071,'active',NULL,NULL,NULL),(149518,230,'Yarun',NULL,5071,'active',NULL,NULL,NULL),(149519,230,'Yemilchyne',NULL,5071,'active',NULL,NULL,NULL),(149520,230,'Zabaro-Davidivka',NULL,5071,'active',NULL,NULL,NULL),(149521,230,'Zadovga',NULL,5071,'active',NULL,NULL,NULL),(149522,230,'Zakrinichchia',NULL,5071,'active',NULL,NULL,NULL),(149523,230,'Zalissia',NULL,5071,'active',NULL,NULL,NULL),(149524,230,'Zaliznia',NULL,5071,'active',NULL,NULL,NULL),(149525,230,'Zaluzhne',NULL,5071,'active',NULL,NULL,NULL),(149526,230,'Zapadnia',NULL,5071,'active',NULL,NULL,NULL),(149527,230,'Zarichchia',NULL,5071,'active',NULL,NULL,NULL),(149528,230,'Zarudintsi',NULL,5071,'active',NULL,NULL,NULL),(149529,230,'Zavodske',NULL,5071,'active',NULL,NULL,NULL),(149530,230,'Zbranki',NULL,5071,'active',NULL,NULL,NULL),(149531,230,'Zdorovets',NULL,5071,'active',NULL,NULL,NULL),(149532,230,'Zherdeli',NULL,5071,'active',NULL,NULL,NULL),(149533,230,'Zhitintsi',NULL,5071,'active',NULL,NULL,NULL),(149534,230,'Zhovte',NULL,5071,'active',NULL,NULL,NULL),(149535,230,'Zhovtii Brid',NULL,5071,'active',NULL,NULL,NULL),(149536,230,'Zhupanivka',NULL,5071,'active',NULL,NULL,NULL),(149537,230,'Zhurbintsi',NULL,5071,'active',NULL,NULL,NULL),(149538,230,'Zhytomyr',NULL,5071,'active',NULL,NULL,NULL),(149539,230,'Zinkiv',NULL,5071,'active',NULL,NULL,NULL),(149540,230,'Zlobichi',NULL,5071,'active',NULL,NULL,NULL),(149541,230,'Zoriane',NULL,5071,'active',NULL,NULL,NULL),(149542,230,'Zorokiv',NULL,5071,'active',NULL,NULL,NULL),(149543,230,'Zosimivka',NULL,5071,'active',NULL,NULL,NULL),(149544,230,'Zubivshchina',NULL,5071,'active',NULL,NULL,NULL),(149545,230,'Zvizdal',NULL,5071,'active',NULL,NULL,NULL),(149546,233,'Hazlet Township',NULL,1417,'active',NULL,NULL,NULL),(149547,233,'Morningside',NULL,1422,'active',NULL,NULL,NULL),(149548,101,'Ranipet',NULL,4035,'active',NULL,NULL,NULL),(149549,14,'Malaga',NULL,3906,'active',NULL,NULL,NULL),(149550,14,'Badgingarra',NULL,3906,'active',NULL,NULL,NULL),(149551,14,'Muchea',NULL,3906,'active',NULL,NULL,NULL),(149552,14,'Cervantes',NULL,3906,'active',NULL,NULL,NULL),(149553,14,'Woodridge',NULL,3906,'active',NULL,NULL,NULL),(149554,14,'Leeman',NULL,3906,'active',NULL,NULL,NULL),(149555,14,'Lancelin',NULL,3906,'active',NULL,NULL,NULL),(149556,14,'Green Head',NULL,3906,'active',NULL,NULL,NULL),(149557,14,'Cataby',NULL,3906,'active',NULL,NULL,NULL),(149558,14,'Regans Ford',NULL,3906,'active',NULL,NULL,NULL),(149559,14,'Hill River',NULL,3906,'active',NULL,NULL,NULL),(149561,242,'Charlotte Amalie',NULL,5072,'active',NULL,NULL,NULL),(149562,242,'East End',NULL,5072,'active',NULL,NULL,NULL),(149563,242,'Northside',NULL,5072,'active',NULL,NULL,NULL),(149564,242,'Southside',NULL,5072,'active',NULL,NULL,NULL),(149565,242,'Tutu',NULL,5072,'active',NULL,NULL,NULL),(149566,242,'Water Island',NULL,5072,'active',NULL,NULL,NULL),(149567,242,'West End',NULL,5072,'active',NULL,NULL,NULL),(149568,242,'Central',NULL,5073,'active',NULL,NULL,NULL),(149569,242,'Coral Bay',NULL,5073,'active',NULL,NULL,NULL),(149570,242,'Cruz Bay',NULL,5073,'active',NULL,NULL,NULL),(149571,242,'East End',NULL,5073,'active',NULL,NULL,NULL),(149572,242,'Good Hope',NULL,5074,'active',NULL,NULL,NULL),(149573,242,'Christiansted',NULL,5074,'active',NULL,NULL,NULL),(149574,242,'East End',NULL,5074,'active',NULL,NULL,NULL),(149575,242,'Frederiksted',NULL,5074,'active',NULL,NULL,NULL),(149576,242,'Northcentral',NULL,5074,'active',NULL,NULL,NULL),(149577,242,'Northwest',NULL,5074,'active',NULL,NULL,NULL),(149578,242,'Sion Farm',NULL,5074,'active',NULL,NULL,NULL),(149579,242,'Southcentral',NULL,5074,'active',NULL,NULL,NULL),(149580,242,'Southwest',NULL,5074,'active',NULL,NULL,NULL),(149581,39,'Thornhill',NULL,866,'active',NULL,NULL,NULL),(149582,65,'Badr',NULL,3223,'active',NULL,NULL,NULL),(149583,65,'Bulaq',NULL,3223,'active',NULL,NULL,NULL),(149584,65,'El Mataria',NULL,3223,'active',NULL,NULL,NULL),(149585,65,'Fustat',NULL,3223,'active',NULL,NULL,NULL),(149586,65,'Hadayek El Kobba',NULL,3223,'active',NULL,NULL,NULL),(149587,65,'Heliopolis',NULL,3223,'active',NULL,NULL,NULL),(149588,65,'Helwan',NULL,3223,'active',NULL,NULL,NULL),(149589,65,'Maadi',NULL,3223,'active',NULL,NULL,NULL),(149590,65,'Musturud',NULL,3223,'active',NULL,NULL,NULL),(149591,65,'New Administrative Capital of Egypt',NULL,3223,'active',NULL,NULL,NULL),(149592,65,'Shubra',NULL,3223,'active',NULL,NULL,NULL),(149593,65,'Tura',NULL,3223,'active',NULL,NULL,NULL),(149594,65,'Abu Qir',NULL,3235,'active',NULL,NULL,NULL),(149595,65,'Agami',NULL,3235,'active',NULL,NULL,NULL),(149596,65,'Ar-Raml',NULL,3235,'active',NULL,NULL,NULL),(149597,65,'Borg El Arab',NULL,3235,'active',NULL,NULL,NULL),(149598,65,'Montaza',NULL,3235,'active',NULL,NULL,NULL),(149599,65,'New Borg El Arab',NULL,3235,'active',NULL,NULL,NULL),(149600,65,'Sidi Bishr',NULL,3235,'active',NULL,NULL,NULL),(149601,99,'Aka',NULL,5085,'active',NULL,NULL,NULL),(149602,99,'Almasfuzito',NULL,5085,'active',NULL,NULL,NULL),(149603,99,'Bajot',NULL,5085,'active',NULL,NULL,NULL),(149604,99,'Bakonybank',NULL,5085,'active',NULL,NULL,NULL),(149605,99,'Bakonyszombathely',NULL,5085,'active',NULL,NULL,NULL),(149606,99,'Bakonysarkany',NULL,5085,'active',NULL,NULL,NULL),(149607,99,'Bana',NULL,5085,'active',NULL,NULL,NULL),(149608,99,'Babolna',NULL,5085,'active',NULL,NULL,NULL),(149609,99,'Banhida',NULL,5085,'active',NULL,NULL,NULL),(149610,99,'Barsonyos',NULL,5085,'active',NULL,NULL,NULL),(149611,99,'Csatka',NULL,5085,'active',NULL,NULL,NULL),(149612,99,'Csolnok',NULL,5085,'active',NULL,NULL,NULL),(149613,99,'Csaszar',NULL,5085,'active',NULL,NULL,NULL),(149614,99,'Csem',NULL,5085,'active',NULL,NULL,NULL),(149615,99,'Csep',NULL,5085,'active',NULL,NULL,NULL),(149616,99,'Dad',NULL,5085,'active',NULL,NULL,NULL),(149617,99,'Dorog',NULL,5085,'active',NULL,NULL,NULL),(149618,99,'Dunaalmas',NULL,5085,'active',NULL,NULL,NULL),(149619,99,'Dunaszentmiklos',NULL,5085,'active',NULL,NULL,NULL),(149620,99,'Dag',NULL,5085,'active',NULL,NULL,NULL),(149621,99,'Domos',NULL,5085,'active',NULL,NULL,NULL),(149622,99,'Epol',NULL,5085,'active',NULL,NULL,NULL),(149623,99,'Esztergom',NULL,5085,'active',NULL,NULL,NULL),(149624,99,'Ete',NULL,5085,'active',NULL,NULL,NULL),(149625,99,'Gyermely',NULL,5085,'active',NULL,NULL,NULL),(149626,99,'Hereg',NULL,5085,'active',NULL,NULL,NULL),(149627,99,'Kecsked',NULL,5085,'active',NULL,NULL,NULL),(149628,99,'Kerekteleki',NULL,5085,'active',NULL,NULL,NULL),(149629,99,'Kesztolc',NULL,5085,'active',NULL,NULL,NULL),(149630,99,'Kisber',NULL,5085,'active',NULL,NULL,NULL),(149631,99,'Kisigmand',NULL,5085,'active',NULL,NULL,NULL),(149632,99,'Kocs',NULL,5085,'active',NULL,NULL,NULL),(149633,99,'Komarom',NULL,5085,'active',NULL,NULL,NULL),(149634,99,'Komlod',NULL,5085,'active',NULL,NULL,NULL),(149635,99,'Kornye',NULL,5085,'active',NULL,NULL,NULL),(149636,99,'Leanyvar',NULL,5085,'active',NULL,NULL,NULL),(149637,99,'Labatlan',NULL,5085,'active',NULL,NULL,NULL),(149638,99,'Mocsa',NULL,5085,'active',NULL,NULL,NULL),(149639,99,'Mogyorosbanya',NULL,5085,'active',NULL,NULL,NULL),(149640,99,'Mariahalom',NULL,5085,'active',NULL,NULL,NULL),(149641,99,'Nagyigmand',NULL,5085,'active',NULL,NULL,NULL),(149642,99,'Nagysap',NULL,5085,'active',NULL,NULL,NULL),(149643,99,'Naszaly',NULL,5085,'active',NULL,NULL,NULL),(149644,99,'Neszmely',NULL,5085,'active',NULL,NULL,NULL),(149645,99,'Nyergesujfalu',NULL,5085,'active',NULL,NULL,NULL),(149646,99,'Oroszlany',NULL,5085,'active',NULL,NULL,NULL),(149647,99,'Piliscsev',NULL,5085,'active',NULL,NULL,NULL),(149648,99,'Pilismarot',NULL,5085,'active',NULL,NULL,NULL),(149649,99,'Rede',NULL,5085,'active',NULL,NULL,NULL),(149650,99,'Szomor',NULL,5085,'active',NULL,NULL,NULL),(149651,99,'Szomod',NULL,5085,'active',NULL,NULL,NULL),(149652,99,'Szakszend',NULL,5085,'active',NULL,NULL,NULL),(149653,99,'Szony',NULL,5085,'active',NULL,NULL,NULL),(149654,99,'Sarisap',NULL,5085,'active',NULL,NULL,NULL),(149655,99,'Sur',NULL,5085,'active',NULL,NULL,NULL),(149656,99,'Sutto',NULL,5085,'active',NULL,NULL,NULL),(149657,99,'Tardos',NULL,5085,'active',NULL,NULL,NULL),(149658,99,'Tarjan',NULL,5085,'active',NULL,NULL,NULL),(149659,99,'Tatabanya',NULL,5085,'active',NULL,NULL,NULL),(149660,99,'Tokodaltaro',NULL,5085,'active',NULL,NULL,NULL),(149661,99,'Tarkany',NULL,5085,'active',NULL,NULL,NULL),(149662,99,'Vargesztes',NULL,5085,'active',NULL,NULL,NULL),(149663,99,'Verteskethely',NULL,5085,'active',NULL,NULL,NULL),(149664,99,'Vertessomlo',NULL,5085,'active',NULL,NULL,NULL),(149665,99,'Vertesszolos',NULL,5085,'active',NULL,NULL,NULL),(149666,99,'Vertestolna',NULL,5085,'active',NULL,NULL,NULL),(149667,99,'Acs',NULL,5085,'active',NULL,NULL,NULL),(149668,99,'Aszar',NULL,5085,'active',NULL,NULL,NULL),(149669,99,'Uny',NULL,5085,'active',NULL,NULL,NULL),(149670,142,'Agualeguas, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149671,142,'Alberto Villarreal',NULL,3452,'active',NULL,NULL,NULL),(149672,142,'Aldama Estacion',NULL,3452,'active',NULL,NULL,NULL),(149673,142,'Alfonso Reyes',NULL,3452,'active',NULL,NULL,NULL),(149674,142,'Allende',NULL,3452,'active',NULL,NULL,NULL),(149675,142,'Altamira',NULL,3452,'active',NULL,NULL,NULL),(149676,142,'Ampliacion de la Laguna',NULL,3452,'active',NULL,NULL,NULL),(149677,142,'Apodaca',NULL,3452,'active',NULL,NULL,NULL),(149678,142,'Aquiles Serdan',NULL,3452,'active',NULL,NULL,NULL),(149679,142,'Armando Fernandez Garza',NULL,3452,'active',NULL,NULL,NULL),(149680,142,'Barrio Aldamas',NULL,3452,'active',NULL,NULL,NULL),(149681,142,'Barrio de Jalisco',NULL,3452,'active',NULL,NULL,NULL),(149682,142,'Bello Amanecer',NULL,3452,'active',NULL,NULL,NULL),(149683,142,'Caja Pinta',NULL,3452,'active',NULL,NULL,NULL),(149684,142,'Campestre el Montesito',NULL,3452,'active',NULL,NULL,NULL),(149685,142,'Cantu',NULL,3452,'active',NULL,NULL,NULL),(149686,142,'Carboneras',NULL,3452,'active',NULL,NULL,NULL),(149687,142,'Casa Rosa',NULL,3452,'active',NULL,NULL,NULL),(149688,142,'Canon de Vacas',NULL,3452,'active',NULL,NULL,NULL),(149689,142,'Centro Habitacional Burocratas de Guadalupe',NULL,3452,'active',NULL,NULL,NULL),(149690,142,'Charco Redondo',NULL,3452,'active',NULL,NULL,NULL),(149691,142,'Cinco Senores',NULL,3452,'active',NULL,NULL,NULL),(149692,142,'Ciudad Anahuac',NULL,3452,'active',NULL,NULL,NULL),(149693,142,'Colinas del Rio, Juarez',NULL,3452,'active',NULL,NULL,NULL),(149694,142,'Colombia',NULL,3452,'active',NULL,NULL,NULL),(149695,142,'Colonia Independencia (Monterrey)',NULL,3452,'active',NULL,NULL,NULL),(149696,142,'Colonia la Mesa',NULL,3452,'active',NULL,NULL,NULL),(149697,142,'Conferin Arizpe',NULL,3452,'active',NULL,NULL,NULL),(149698,142,'Constitucion',NULL,3452,'active',NULL,NULL,NULL),(149699,142,'Dieciocho de Marzo',NULL,3452,'active',NULL,NULL,NULL),(149700,142,'Dieciseis de Septiembre',NULL,3452,'active',NULL,NULL,NULL),(149701,142,'Doce de Octubre',NULL,3452,'active',NULL,NULL,NULL),(149702,142,'Doctor Coss, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149703,142,'Dolores',NULL,3452,'active',NULL,NULL,NULL),(149704,142,'El Bajio',NULL,3452,'active',NULL,NULL,NULL),(149705,142,'El Barco',NULL,3452,'active',NULL,NULL,NULL),(149706,142,'El Bosque',NULL,3452,'active',NULL,NULL,NULL),(149707,142,'El Brasil',NULL,3452,'active',NULL,NULL,NULL),(149708,142,'El Carmen de los Elizondo',NULL,3452,'active',NULL,NULL,NULL),(149709,142,'El Carmen, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149710,142,'El Cedral',NULL,3452,'active',NULL,NULL,NULL),(149711,142,'El Cerrito',NULL,3452,'active',NULL,NULL,NULL),(149712,142,'El Chamizal',NULL,3452,'active',NULL,NULL,NULL),(149713,142,'El Dieciseis',NULL,3452,'active',NULL,NULL,NULL),(149714,142,'El Diez',NULL,3452,'active',NULL,NULL,NULL),(149715,142,'El Fraile',NULL,3452,'active',NULL,NULL,NULL),(149716,142,'El Leal',NULL,3452,'active',NULL,NULL,NULL),(149717,142,'El Maguey',NULL,3452,'active',NULL,NULL,NULL),(149718,142,'El Mosquito, Linares',NULL,3452,'active',NULL,NULL,NULL),(149719,142,'El Nogalito',NULL,3452,'active',NULL,NULL,NULL),(149720,142,'El Palmital',NULL,3452,'active',NULL,NULL,NULL),(149721,142,'El Pastor',NULL,3452,'active',NULL,NULL,NULL),(149722,142,'El Ranchito Numero Uno',NULL,3452,'active',NULL,NULL,NULL),(149723,142,'El Realito',NULL,3452,'active',NULL,NULL,NULL),(149724,142,'El Refugio',NULL,3452,'active',NULL,NULL,NULL),(149725,142,'El Refugio y el Reparo',NULL,3452,'active',NULL,NULL,NULL),(149726,142,'El Rucio',NULL,3452,'active',NULL,NULL,NULL),(149727,142,'El Saladito',NULL,3452,'active',NULL,NULL,NULL),(149728,142,'El Salitre',NULL,3452,'active',NULL,NULL,NULL),(149729,142,'Estados Unidos',NULL,3452,'active',NULL,NULL,NULL),(149730,142,'Fraccionamiento del Valle',NULL,3452,'active',NULL,NULL,NULL),(149731,142,'Francisco I. Madero',NULL,3452,'active',NULL,NULL,NULL),(149732,142,'Francisco Villa',NULL,3452,'active',NULL,NULL,NULL),(149733,142,'Garza Garcia',NULL,3452,'active',NULL,NULL,NULL),(149734,142,'Garza Gonzalez',NULL,3452,'active',NULL,NULL,NULL),(149735,142,'General Escobedo',NULL,3452,'active',NULL,NULL,NULL),(149736,142,'General Tapia',NULL,3452,'active',NULL,NULL,NULL),(149737,142,'General Teran, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149738,142,'General Trevino',NULL,3452,'active',NULL,NULL,NULL),(149739,142,'Graciano Bortoni',NULL,3452,'active',NULL,NULL,NULL),(149740,142,'Hacienda San Juan',NULL,3452,'active',NULL,NULL,NULL),(149741,142,'Hacienda de Enmedio',NULL,3452,'active',NULL,NULL,NULL),(149742,142,'Hidalgo',NULL,3452,'active',NULL,NULL,NULL),(149743,142,'Higueras, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149744,142,'Huertas Estacion',NULL,3452,'active',NULL,NULL,NULL),(149745,142,'Ibarrilla',NULL,3452,'active',NULL,NULL,NULL),(149746,142,'Ismael Flores',NULL,3452,'active',NULL,NULL,NULL),(149747,142,'Iturbide, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149748,142,'Jardines de la Silla',NULL,3452,'active',NULL,NULL,NULL),(149749,142,'Jesus Maria Aguirre, Galeana',NULL,3452,'active',NULL,NULL,NULL),(149750,142,'Jesus Maria de Berrones',NULL,3452,'active',NULL,NULL,NULL),(149751,142,'Jesus Maria del Terrero',NULL,3452,'active',NULL,NULL,NULL),(149752,142,'Juan Salazar',NULL,3452,'active',NULL,NULL,NULL),(149753,142,'Juarez, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149754,142,'Jauregui',NULL,3452,'active',NULL,NULL,NULL),(149755,142,'Kilometro Dieciseis',NULL,3452,'active',NULL,NULL,NULL),(149756,142,'La Aguita',NULL,3452,'active',NULL,NULL,NULL),(149757,142,'La Aldea',NULL,3452,'active',NULL,NULL,NULL),(149758,142,'La Arena',NULL,3452,'active',NULL,NULL,NULL),(149759,142,'La Barreta',NULL,3452,'active',NULL,NULL,NULL),(149760,142,'La Baticolla',NULL,3452,'active',NULL,NULL,NULL),(149761,142,'La Boquilla',NULL,3452,'active',NULL,NULL,NULL),(149762,142,'La Campana',NULL,3452,'active',NULL,NULL,NULL),(149763,142,'La Candelaria',NULL,3452,'active',NULL,NULL,NULL),(149764,142,'La Cardona',NULL,3452,'active',NULL,NULL,NULL),(149765,142,'La Chiripa',NULL,3452,'active',NULL,NULL,NULL),(149766,142,'La Chueca, Cadereyta Jimenez',NULL,3452,'active',NULL,NULL,NULL),(149767,142,'La Colmena de Arriba',NULL,3452,'active',NULL,NULL,NULL),(149768,142,'La Escuadra',NULL,3452,'active',NULL,NULL,NULL),(149769,142,'La Esperanza',NULL,3452,'active',NULL,NULL,NULL),(149770,142,'La Estrella',NULL,3452,'active',NULL,NULL,NULL),(149771,142,'La Fama',NULL,3452,'active',NULL,NULL,NULL),(149772,142,'La Florida',NULL,3452,'active',NULL,NULL,NULL),(149773,142,'La Gloria',NULL,3452,'active',NULL,NULL,NULL),(149774,142,'La Haciendita',NULL,3452,'active',NULL,NULL,NULL),(149775,142,'La Joya de Alardin',NULL,3452,'active',NULL,NULL,NULL),(149776,142,'La Lagunita',NULL,3452,'active',NULL,NULL,NULL),(149777,142,'La Lobera de Portillo',NULL,3452,'active',NULL,NULL,NULL),(149778,142,'La Maestranza',NULL,3452,'active',NULL,NULL,NULL),(149779,142,'La Mesa de Berrones',NULL,3452,'active',NULL,NULL,NULL),(149780,142,'La Palmita, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149781,142,'La Presita de Berlanga',NULL,3452,'active',NULL,NULL,NULL),(149782,142,'La Providencia',NULL,3452,'active',NULL,NULL,NULL),(149783,142,'La Purisima',NULL,3452,'active',NULL,NULL,NULL),(149784,142,'La Reforma',NULL,3452,'active',NULL,NULL,NULL),(149785,142,'La Soledad',NULL,3452,'active',NULL,NULL,NULL),(149786,142,'La Tinaja',NULL,3452,'active',NULL,NULL,NULL),(149787,142,'La Trinidad',NULL,3452,'active',NULL,NULL,NULL),(149788,142,'La Union y el Cardonal',NULL,3452,'active',NULL,NULL,NULL),(149789,142,'La Ventana',NULL,3452,'active',NULL,NULL,NULL),(149790,142,'Ladrillera',NULL,3452,'active',NULL,NULL,NULL),(149791,142,'Las Barretas',NULL,3452,'active',NULL,NULL,NULL),(149792,142,'Las Brisas',NULL,3452,'active',NULL,NULL,NULL),(149793,142,'Las Mesas de San Juan',NULL,3452,'active',NULL,NULL,NULL),(149794,142,'Las Palomas',NULL,3452,'active',NULL,NULL,NULL),(149795,142,'Linares, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149796,142,'Lomas de San Francisco',NULL,3452,'active',NULL,NULL,NULL),(149797,142,'Los Aldamas',NULL,3452,'active',NULL,NULL,NULL),(149798,142,'Los Dos Rios',NULL,3452,'active',NULL,NULL,NULL),(149799,142,'Los Herreras',NULL,3452,'active',NULL,NULL,NULL),(149800,142,'Los Pocitos',NULL,3452,'active',NULL,NULL,NULL),(149801,142,'Los Alamos',NULL,3452,'active',NULL,NULL,NULL),(149802,142,'Los Angeles, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149803,142,'Maria Aurora',NULL,3452,'active',NULL,NULL,NULL),(149804,142,'Maria Auxiliadora',NULL,3452,'active',NULL,NULL,NULL),(149805,142,'Melchor Ocampo, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149806,142,'Mexiquito',NULL,3452,'active',NULL,NULL,NULL),(149807,142,'Mier y Noriega',NULL,3452,'active',NULL,NULL,NULL),(149808,142,'Mina, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149809,142,'Nanez Gonzalez',NULL,3452,'active',NULL,NULL,NULL),(149810,142,'Paras, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149811,142,'Pedro Ibarra Hernandez',NULL,3452,'active',NULL,NULL,NULL),(149812,142,'Puerto Genovevo, Santiago',NULL,3452,'active',NULL,NULL,NULL),(149813,142,'Ruben Carlos Gallegos Reyes, Villaldama',NULL,3452,'active',NULL,NULL,NULL),(149814,142,'Sabinas Hidalgo',NULL,3452,'active',NULL,NULL,NULL),(149815,142,'San Antonio de Alamitos',NULL,3452,'active',NULL,NULL,NULL),(149816,142,'San Bernardo, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149817,142,'San Jose de Cuatro Caminos',NULL,3452,'active',NULL,NULL,NULL),(149818,142,'San Jose de Medina',NULL,3452,'active',NULL,NULL,NULL),(149819,142,'San Jose, Linares',NULL,3452,'active',NULL,NULL,NULL),(149820,142,'San Mateo, Doctor Arroyo',NULL,3452,'active',NULL,NULL,NULL),(149821,142,'Santa Catarina',NULL,3452,'active',NULL,NULL,NULL),(149822,142,'Santa Teresita',NULL,3452,'active',NULL,NULL,NULL),(149823,142,'Santa Veronica',NULL,3452,'active',NULL,NULL,NULL),(149824,142,'Valle Alto',NULL,3452,'active',NULL,NULL,NULL),(149825,142,'Villaldama, Nuevo Leon',NULL,3452,'active',NULL,NULL,NULL),(149826,156,'\'s-Graveland',NULL,2612,'active',NULL,NULL,NULL),(149827,156,'\'t Horntje',NULL,2612,'active',NULL,NULL,NULL),(149828,156,'\'t Kabel',NULL,2612,'active',NULL,NULL,NULL),(149829,156,'\'t Nopeind',NULL,2612,'active',NULL,NULL,NULL),(149830,156,'\'t Veld',NULL,2612,'active',NULL,NULL,NULL),(149831,156,'Aagtdorp',NULL,2612,'active',NULL,NULL,NULL),(149832,156,'Aalsmeerderbrug',NULL,2612,'active',NULL,NULL,NULL),(149833,156,'Aartswoud',NULL,2612,'active',NULL,NULL,NULL),(149834,156,'Abbenes',NULL,2612,'active',NULL,NULL,NULL),(149835,156,'Akersloot',NULL,2612,'active',NULL,NULL,NULL),(149836,156,'Andijk',NULL,2612,'active',NULL,NULL,NULL),(149837,156,'Ankeveen',NULL,2612,'active',NULL,NULL,NULL),(149838,156,'Assendelft',NULL,2612,'active',NULL,NULL,NULL),(149839,156,'Badhoevedorp',NULL,2612,'active',NULL,NULL,NULL),(149840,156,'Bakkum',NULL,2612,'active',NULL,NULL,NULL),(149841,156,'Bargen',NULL,2612,'active',NULL,NULL,NULL),(149842,156,'Barsingerhorn',NULL,2612,'active',NULL,NULL,NULL),(149843,156,'Beemster',NULL,2612,'active',NULL,NULL,NULL),(149844,156,'Beets',NULL,2612,'active',NULL,NULL,NULL),(149845,156,'Beinsdorp',NULL,2612,'active',NULL,NULL,NULL),(149846,156,'Belt',NULL,2612,'active',NULL,NULL,NULL),(149847,156,'Benningbroek',NULL,2612,'active',NULL,NULL,NULL),(149848,156,'Bentveld',NULL,2612,'active',NULL,NULL,NULL),(149849,156,'Bergen',NULL,2612,'active',NULL,NULL,NULL),(149850,156,'Berkmeer',NULL,2612,'active',NULL,NULL,NULL),(149851,156,'Bijlmermeer',NULL,2612,'active',NULL,NULL,NULL),(149852,156,'Binnenstad',NULL,2612,'active',NULL,NULL,NULL),(149853,156,'Blauwe Keet',NULL,2612,'active',NULL,NULL,NULL),(149854,156,'Bobeldijk',NULL,2612,'active',NULL,NULL,NULL),(149855,156,'Boekel',NULL,2612,'active',NULL,NULL,NULL),(149856,156,'Boesingheliede',NULL,2612,'active',NULL,NULL,NULL),(149857,156,'Bos en Lommer',NULL,2612,'active',NULL,NULL,NULL),(149858,156,'Bovenkarspel',NULL,2612,'active',NULL,NULL,NULL),(149859,156,'Bregtdorp',NULL,2612,'active',NULL,NULL,NULL),(149860,156,'Breukeleveen',NULL,2612,'active',NULL,NULL,NULL),(149861,156,'Buiksloot',NULL,2612,'active',NULL,NULL,NULL),(149862,156,'Buikslotermeer',NULL,2612,'active',NULL,NULL,NULL),(149863,156,'Buitenkaag',NULL,2612,'active',NULL,NULL,NULL),(149864,156,'Buitenveldert',NULL,2612,'active',NULL,NULL,NULL),(149865,156,'Burgerbrug',NULL,2612,'active',NULL,NULL,NULL),(149866,156,'Burgerveen',NULL,2612,'active',NULL,NULL,NULL),(149867,156,'Burgervlotbrug',NULL,2612,'active',NULL,NULL,NULL),(149868,156,'Butterhuizen',NULL,2612,'active',NULL,NULL,NULL),(149869,156,'Calslagen',NULL,2612,'active',NULL,NULL,NULL),(149870,156,'Camperduin',NULL,2612,'active',NULL,NULL,NULL),(149871,156,'Catrijp',NULL,2612,'active',NULL,NULL,NULL),(149872,156,'Cruquius',NULL,2612,'active',NULL,NULL,NULL),(149873,156,'De Aker',NULL,2612,'active',NULL,NULL,NULL),(149874,156,'De Cocksdorp',NULL,2612,'active',NULL,NULL,NULL),(149875,156,'De Haukes',NULL,2612,'active',NULL,NULL,NULL),(149876,156,'De Hulk',NULL,2612,'active',NULL,NULL,NULL),(149877,156,'De Kooy',NULL,2612,'active',NULL,NULL,NULL),(149878,156,'De Kwakel',NULL,2612,'active',NULL,NULL,NULL),(149879,156,'De Pijp',NULL,2612,'active',NULL,NULL,NULL),(149880,156,'De Stolpen',NULL,2612,'active',NULL,NULL,NULL),(149881,156,'De Waal',NULL,2612,'active',NULL,NULL,NULL),(149882,156,'De Wallen',NULL,2612,'active',NULL,NULL,NULL),(149883,156,'De Weere',NULL,2612,'active',NULL,NULL,NULL),(149885,156,'De Woude',NULL,2612,'active',NULL,NULL,NULL),(149886,156,'Den Hoorn',NULL,2612,'active',NULL,NULL,NULL),(149887,156,'Den Ilp',NULL,2612,'active',NULL,NULL,NULL),(149888,156,'Drechterland',NULL,2612,'active',NULL,NULL,NULL),(149889,156,'Driehuis',NULL,2612,'active',NULL,NULL,NULL),(149890,156,'Driehuizen',NULL,2612,'active',NULL,NULL,NULL),(149892,156,'Durgerdam',NULL,2612,'active',NULL,NULL,NULL),(149893,156,'Edam-Volendam',NULL,2612,'active',NULL,NULL,NULL),(149894,156,'Eenigenburg',NULL,2612,'active',NULL,NULL,NULL),(149895,156,'Egmond aan den Hoef',NULL,2612,'active',NULL,NULL,NULL),(149896,156,'Etersheim',NULL,2612,'active',NULL,NULL,NULL),(149897,156,'Friese Buurt',NULL,2612,'active',NULL,NULL,NULL),(149898,156,'Geuzenveld',NULL,2612,'active',NULL,NULL,NULL),(149899,156,'Gouwe',NULL,2612,'active',NULL,NULL,NULL),(149900,156,'Graft',NULL,2612,'active',NULL,NULL,NULL),(149901,156,'Grootebroek',NULL,2612,'active',NULL,NULL,NULL),(149902,156,'Grootschermer',NULL,2612,'active',NULL,NULL,NULL),(149903,156,'Grosthuizen',NULL,2612,'active',NULL,NULL,NULL),(149904,156,'Haarlemmerliede',NULL,2612,'active',NULL,NULL,NULL),(149905,156,'Haarlemmermeer',NULL,2612,'active',NULL,NULL,NULL),(149906,156,'Hakkelaarsbrug',NULL,2612,'active',NULL,NULL,NULL),(149907,156,'Harderwijk',NULL,2612,'active',NULL,NULL,NULL),(149908,156,'Hargen',NULL,2612,'active',NULL,NULL,NULL),(149909,156,'Haringhuizen',NULL,2612,'active',NULL,NULL,NULL),(149910,156,'Hauwert',NULL,2612,'active',NULL,NULL,NULL),(149911,156,'Hinderdam',NULL,2612,'active',NULL,NULL,NULL),(149912,156,'Hobrede',NULL,2612,'active',NULL,NULL,NULL),(149913,156,'Hollands Kroon',NULL,2612,'active',NULL,NULL,NULL),(149914,156,'Holysloot',NULL,2612,'active',NULL,NULL,NULL),(149915,156,'Hoogkarspel',NULL,2612,'active',NULL,NULL,NULL),(149916,156,'Horstermeer',NULL,2612,'active',NULL,NULL,NULL),(149917,156,'Huigsloot',NULL,2612,'active',NULL,NULL,NULL),(149918,156,'Huisduinen',NULL,2612,'active',NULL,NULL,NULL),(149919,156,'IJburg',NULL,2612,'active',NULL,NULL,NULL),(149920,156,'IJmuiden',NULL,2612,'active',NULL,NULL,NULL),(149921,156,'Jisp',NULL,2612,'active',NULL,NULL,NULL),(149922,156,'Jordaan',NULL,2612,'active',NULL,NULL,NULL),(149923,156,'Julianadorp',NULL,2612,'active',NULL,NULL,NULL),(149924,156,'Kalverdijk',NULL,2612,'active',NULL,NULL,NULL),(149925,156,'Kapel',NULL,2612,'active',NULL,NULL,NULL),(149926,156,'Katwoude',NULL,2612,'active',NULL,NULL,NULL),(149927,156,'Kerkbuurt',NULL,2612,'active',NULL,NULL,NULL),(149928,156,'Koedijk',NULL,2612,'active',NULL,NULL,NULL),(149929,156,'Koggenland',NULL,2612,'active',NULL,NULL,NULL),(149930,156,'Kolhorn',NULL,2612,'active',NULL,NULL,NULL),(149931,156,'Koog aan de Zaan',NULL,2612,'active',NULL,NULL,NULL),(149932,156,'Krabbendam',NULL,2612,'active',NULL,NULL,NULL),(149933,156,'Kreileroord',NULL,2612,'active',NULL,NULL,NULL),(149934,156,'Krommenie',NULL,2612,'active',NULL,NULL,NULL),(149935,156,'Kwadijk',NULL,2612,'active',NULL,NULL,NULL),(149936,156,'Lambertschaag',NULL,2612,'active',NULL,NULL,NULL),(149937,156,'Langedijk',NULL,2612,'active',NULL,NULL,NULL),(149938,156,'Langereis',NULL,2612,'active',NULL,NULL,NULL),(149939,156,'Leimuiderbrug',NULL,2612,'active',NULL,NULL,NULL),(149940,156,'Lijnden',NULL,2612,'active',NULL,NULL,NULL),(149941,156,'Loosdrecht',NULL,2612,'active',NULL,NULL,NULL),(149942,156,'Lutjewinkel',NULL,2612,'active',NULL,NULL,NULL),(149943,156,'Markenbinnen',NULL,2612,'active',NULL,NULL,NULL),(149944,156,'Middelie',NULL,2612,'active',NULL,NULL,NULL),(149945,156,'Moerbeek',NULL,2612,'active',NULL,NULL,NULL),(149946,156,'Muyeveld',NULL,2612,'active',NULL,NULL,NULL),(149947,156,'Neck',NULL,2612,'active',NULL,NULL,NULL),(149948,156,'Nederhorst den Berg',NULL,2612,'active',NULL,NULL,NULL),(149949,156,'Nes aan de Amstel',NULL,2612,'active',NULL,NULL,NULL),(149950,156,'Nibbixwoud',NULL,2612,'active',NULL,NULL,NULL),(149951,156,'Nieuw-Vennep',NULL,2612,'active',NULL,NULL,NULL),(149952,156,'Nieuwe Meer',NULL,2612,'active',NULL,NULL,NULL),(149953,156,'Nieuwebrug',NULL,2612,'active',NULL,NULL,NULL),(149954,156,'Nieuwendam',NULL,2612,'active',NULL,NULL,NULL),(149955,156,'Nieuwesluis',NULL,2612,'active',NULL,NULL,NULL),(149956,156,'Noordbeemster',NULL,2612,'active',NULL,NULL,NULL),(149957,156,'Noordburen',NULL,2612,'active',NULL,NULL,NULL),(149958,156,'Noorddijk',NULL,2612,'active',NULL,NULL,NULL),(149959,156,'Noordeinde',NULL,2612,'active',NULL,NULL,NULL),(149960,156,'Omval',NULL,2612,'active',NULL,NULL,NULL),(149961,156,'Oost-Graftdijk',NULL,2612,'active',NULL,NULL,NULL),(149962,156,'Oosterdijk',NULL,2612,'active',NULL,NULL,NULL),(149963,156,'Oosterend',NULL,2612,'active',NULL,NULL,NULL),(149964,156,'Oosterland',NULL,2612,'active',NULL,NULL,NULL),(149965,156,'Oosterleek',NULL,2612,'active',NULL,NULL,NULL),(149966,156,'Oostknollendam',NULL,2612,'active',NULL,NULL,NULL),(149967,156,'Oostwoud',NULL,2612,'active',NULL,NULL,NULL),(149968,156,'Oostzaan',NULL,2612,'active',NULL,NULL,NULL),(149969,156,'Osdorp',NULL,2612,'active',NULL,NULL,NULL),(149970,156,'Oterleek',NULL,2612,'active',NULL,NULL,NULL),(149971,156,'Oude Meer',NULL,2612,'active',NULL,NULL,NULL),(149972,156,'Oude Niedorp',NULL,2612,'active',NULL,NULL,NULL),(149973,156,'Oudendijk',NULL,2612,'active',NULL,NULL,NULL),(149974,156,'Ouder-Amstel',NULL,2612,'active',NULL,NULL,NULL),(149975,156,'Oudesluis',NULL,2612,'active',NULL,NULL,NULL),(149976,156,'Oudorp',NULL,2612,'active',NULL,NULL,NULL),(149977,156,'Overleek',NULL,2612,'active',NULL,NULL,NULL),(149978,156,'Overmeer',NULL,2612,'active',NULL,NULL,NULL),(149979,156,'Penningsveer',NULL,2612,'active',NULL,NULL,NULL),(149980,156,'Purmerland',NULL,2612,'active',NULL,NULL,NULL),(149981,156,'Ransdorp',NULL,2612,'active',NULL,NULL,NULL),(149982,156,'Rijsenhout',NULL,2612,'active',NULL,NULL,NULL),(149983,156,'Risdam',NULL,2612,'active',NULL,NULL,NULL),(149984,156,'Ruigoord',NULL,2612,'active',NULL,NULL,NULL),(149985,156,'Rustenburg',NULL,2612,'active',NULL,NULL,NULL),(149986,156,'Santpoort',NULL,2612,'active',NULL,NULL,NULL),(149987,156,'Schalkwijk',NULL,2612,'active',NULL,NULL,NULL),(149988,156,'Schardam',NULL,2612,'active',NULL,NULL,NULL),(149989,156,'Scharwoude',NULL,2612,'active',NULL,NULL,NULL),(149990,156,'Schellingwoude',NULL,2612,'active',NULL,NULL,NULL),(149991,156,'Schellinkhout',NULL,2612,'active',NULL,NULL,NULL),(149992,156,'Schiphol-Rijk',NULL,2612,'active',NULL,NULL,NULL),(149993,156,'Schoorl',NULL,2612,'active',NULL,NULL,NULL),(149994,156,'Schoorldam',NULL,2612,'active',NULL,NULL,NULL),(149995,156,'Sijbekarspel',NULL,2612,'active',NULL,NULL,NULL),(149996,156,'Sint Maartenszee',NULL,2612,'active',NULL,NULL,NULL),(149997,156,'Sloten',NULL,2612,'active',NULL,NULL,NULL),(149998,156,'Sloterdijk',NULL,2612,'active',NULL,NULL,NULL),(149999,156,'Slotermeer',NULL,2612,'active',NULL,NULL,NULL),(150000,156,'Slotervaart (former borough)',NULL,2612,'active',NULL,NULL,NULL),(150001,156,'Spaarndam-Oost',NULL,2612,'active',NULL,NULL,NULL),(150002,156,'Spaarndam-West',NULL,2612,'active',NULL,NULL,NULL),(150003,156,'Spaarnwoude',NULL,2612,'active',NULL,NULL,NULL),(150004,156,'Spanbroek',NULL,2612,'active',NULL,NULL,NULL),(150005,156,'Spijkerboor',NULL,2612,'active',NULL,NULL,NULL),(150006,156,'Starnmeer',NULL,2612,'active',NULL,NULL,NULL),(150007,156,'Stede Broec',NULL,2612,'active',NULL,NULL,NULL),(150008,156,'Stierop',NULL,2612,'active',NULL,NULL,NULL),(150009,156,'Stroe',NULL,2612,'active',NULL,NULL,NULL),(150010,156,'Stroet',NULL,2612,'active',NULL,NULL,NULL),(150011,156,'Terdiek',NULL,2612,'active',NULL,NULL,NULL),(150012,156,'Texel',NULL,2612,'active',NULL,NULL,NULL),(150013,156,'Tuindorp Oostzaan',NULL,2612,'active',NULL,NULL,NULL),(150014,156,'Tuitjenhorn',NULL,2612,'active',NULL,NULL,NULL),(150015,156,'Uitdam',NULL,2612,'active',NULL,NULL,NULL),(150016,156,'Ursem',NULL,2612,'active',NULL,NULL,NULL),(150017,156,'Valkkoog',NULL,2612,'active',NULL,NULL,NULL),(150018,156,'Van Ewijcksluis',NULL,2612,'active',NULL,NULL,NULL),(150019,156,'Vatrop',NULL,2612,'active',NULL,NULL,NULL),(150020,156,'Veenhuizen',NULL,2612,'active',NULL,NULL,NULL),(150021,156,'Velsen',NULL,2612,'active',NULL,NULL,NULL),(150022,156,'Velserbroek',NULL,2612,'active',NULL,NULL,NULL),(150023,156,'Venhuizen',NULL,2612,'active',NULL,NULL,NULL),(150024,156,'Vinkebrug',NULL,2612,'active',NULL,NULL,NULL),(150025,156,'Wadway',NULL,2612,'active',NULL,NULL,NULL),(150026,156,'Warder',NULL,2612,'active',NULL,NULL,NULL),(150027,156,'Warmenhuizen',NULL,2612,'active',NULL,NULL,NULL),(150028,156,'Watergang',NULL,2612,'active',NULL,NULL,NULL),(150029,156,'Watergraafsmeer',NULL,2612,'active',NULL,NULL,NULL),(150030,156,'Wateringskant',NULL,2612,'active',NULL,NULL,NULL),(150031,156,'Waterland',NULL,2612,'active',NULL,NULL,NULL),(150032,156,'Waver',NULL,2612,'active',NULL,NULL,NULL),(150033,156,'Weidevenne',NULL,2612,'active',NULL,NULL,NULL),(150034,156,'Wervershoof',NULL,2612,'active',NULL,NULL,NULL),(150035,156,'West-Graftdijk',NULL,2612,'active',NULL,NULL,NULL),(150036,156,'West-Knollendam',NULL,2612,'active',NULL,NULL,NULL),(150037,156,'Westbeemster',NULL,2612,'active',NULL,NULL,NULL),(150038,156,'Westerland',NULL,2612,'active',NULL,NULL,NULL),(150039,156,'Westzaan',NULL,2612,'active',NULL,NULL,NULL),(150040,156,'Weteringbrug',NULL,2612,'active',NULL,NULL,NULL),(150041,156,'Wijdemeren',NULL,2612,'active',NULL,NULL,NULL),(150042,156,'Wijdewormer',NULL,2612,'active',NULL,NULL,NULL),(150043,156,'Wimmenum',NULL,2612,'active',NULL,NULL,NULL),(150044,156,'Wognum',NULL,2612,'active',NULL,NULL,NULL),(150045,156,'Wormerland',NULL,2612,'active',NULL,NULL,NULL),(150046,156,'Wormerveer',NULL,2612,'active',NULL,NULL,NULL),(150047,156,'Zuidermeer',NULL,2612,'active',NULL,NULL,NULL),(150048,156,'Zwaag',NULL,2612,'active',NULL,NULL,NULL),(150049,156,'Zwaagdijk-West',NULL,2612,'active',NULL,NULL,NULL),(150050,156,'Boven Bolivia',NULL,2624,'active',NULL,NULL,NULL),(150051,156,'Dorp Tera Kora',NULL,2624,'active',NULL,NULL,NULL),(150052,156,'Oranjestad',NULL,2624,'active',NULL,NULL,NULL),(150053,156,'Rincon',NULL,2624,'active',NULL,NULL,NULL),(150054,156,'St. Johns',NULL,2624,'active',NULL,NULL,NULL),(150055,156,'The Bottom',NULL,2624,'active',NULL,NULL,NULL),(150056,156,'Windwardside',NULL,2624,'active',NULL,NULL,NULL),(150057,156,'Zion\'s Hill',NULL,2624,'active',NULL,NULL,NULL),(150058,155,'Boven Bolivia',NULL,5086,'active',NULL,NULL,NULL),(150059,155,'Dorp Tera Kora',NULL,5086,'active',NULL,NULL,NULL),(150060,155,'Oranjestad',NULL,5086,'active',NULL,NULL,NULL),(150061,155,'Rincon',NULL,5086,'active',NULL,NULL,NULL),(150062,155,'St. Johns',NULL,5086,'active',NULL,NULL,NULL),(150063,155,'The Bottom',NULL,5086,'active',NULL,NULL,NULL),(150064,155,'Windwardside',NULL,5086,'active',NULL,NULL,NULL),(150065,155,'Zion\'s Hill',NULL,5086,'active',NULL,NULL,NULL),(150066,139,'Diade',NULL,3338,'active',NULL,NULL,NULL),(150067,139,'Kataouane',NULL,3338,'active',NULL,NULL,NULL),(150068,139,'Timbedra',NULL,3338,'active',NULL,NULL,NULL),(150069,139,'Ayoun el Atrous',NULL,3351,'active',NULL,NULL,NULL),(150070,139,'Togba',NULL,3351,'active',NULL,NULL,NULL),(150071,139,'Bofal',NULL,3339,'active',NULL,NULL,NULL),(150072,139,'Sori Male',NULL,3339,'active',NULL,NULL,NULL),(150073,139,'Legat',NULL,3348,'active',NULL,NULL,NULL),(150074,139,'Azougui',NULL,3344,'active',NULL,NULL,NULL),(150075,139,'Ksar el Khali',NULL,3344,'active',NULL,NULL,NULL),(150076,139,'Cansado',NULL,3346,'active',NULL,NULL,NULL),(150077,139,'Iouik',NULL,3346,'active',NULL,NULL,NULL),(150078,139,'Ain Ben Tili',NULL,3340,'active',NULL,NULL,NULL),(150079,139,'Chegga',NULL,3340,'active',NULL,NULL,NULL),(150080,139,'Fderick',NULL,3340,'active',NULL,NULL,NULL),(150081,139,'Zouerat',NULL,3340,'active',NULL,NULL,NULL),(150082,139,'Ksar',NULL,3352,'active',NULL,NULL,NULL),(150083,139,'Sebkha',NULL,3352,'active',NULL,NULL,NULL),(150084,139,'Tevragh-Zeina',NULL,3352,'active',NULL,NULL,NULL),(150085,139,'Dar-Naim',NULL,3343,'active',NULL,NULL,NULL),(150086,139,'Teyarett',NULL,3343,'active',NULL,NULL,NULL),(150087,139,'Toujouonine',NULL,3343,'active',NULL,NULL,NULL),(150088,139,'Arafat',NULL,3347,'active',NULL,NULL,NULL),(150089,139,'Riyad',NULL,3347,'active',NULL,NULL,NULL),(150090,102,'Bengkayang',NULL,1806,'active',NULL,NULL,NULL),(150091,102,'Kapuas Hulu',NULL,1806,'active',NULL,NULL,NULL),(150092,102,'Kayong Utara',NULL,1806,'active',NULL,NULL,NULL),(150093,102,'Ketapang',NULL,1806,'active',NULL,NULL,NULL),(150094,102,'Kubu Raya',NULL,1806,'active',NULL,NULL,NULL),(150095,102,'Landak',NULL,1806,'active',NULL,NULL,NULL),(150096,102,'Manismata',NULL,1806,'active',NULL,NULL,NULL),(150097,102,'Melawi',NULL,1806,'active',NULL,NULL,NULL),(150098,102,'Mempawah',NULL,1806,'active',NULL,NULL,NULL),(150099,102,'Pemangkat',NULL,1806,'active',NULL,NULL,NULL),(150100,102,'Pontianak',NULL,1806,'active',NULL,NULL,NULL),(150101,102,'Sambas',NULL,1806,'active',NULL,NULL,NULL),(150102,102,'Sanggau',NULL,1806,'active',NULL,NULL,NULL),(150103,102,'Sekadau',NULL,1806,'active',NULL,NULL,NULL),(150104,102,'Singkawang',NULL,1806,'active',NULL,NULL,NULL),(150105,102,'Sintang',NULL,1806,'active',NULL,NULL,NULL),(150106,167,' Qambar','QMR',3175,'active',NULL,NULL,NULL),(150107,167,'Ahmadpur Sial','APS',3175,'active',NULL,NULL,NULL),(150108,167,'Allah Abad','ALB',3175,'active',NULL,NULL,NULL),(150109,167,'Arija ','ARJ',3175,'active',NULL,NULL,NULL),(150110,167,'Awan Sharif','AAW',3175,'active',NULL,NULL,NULL),(150111,167,'Abdul Hakeem','AKM',3175,'active',NULL,NULL,NULL),(150112,167,'Abottabad','ABT',3175,'active',NULL,NULL,NULL),(150113,167,'Afzal Pur','AZP',3175,'active',NULL,NULL,NULL),(150114,167,'Agra','AGR',3175,'active',NULL,NULL,NULL),(150115,167,'Ahmedpur East','APE',3175,'active',NULL,NULL,NULL),(150116,167,'Ahmedpur Lamma','APL',3175,'active',NULL,NULL,NULL),(150117,167,'Ajnianwala','AJN',3175,'active',NULL,NULL,NULL),(150118,167,'Akhterabad','AKR',3175,'active',NULL,NULL,NULL),(150119,167,'Akora Khattak','AKK',3175,'active',NULL,NULL,NULL),(150120,167,'Akri Choudgi','ACD',3175,'active',NULL,NULL,NULL),(150121,167,'Alhajri','PIM',3175,'active',NULL,NULL,NULL),(150122,167,'Alipur','APR',3175,'active',NULL,NULL,NULL),(150123,167,'Alipur Chatha','APC',3175,'active',NULL,NULL,NULL),(150124,167,'Aloch','ALH',3175,'active',NULL,NULL,NULL),(150125,167,'Alpuri','API',3175,'active',NULL,NULL,NULL),(150126,167,'Aman Garh','AMR',3175,'active',NULL,NULL,NULL),(150127,167,'Aman Kot','ANK',3175,'active',NULL,NULL,NULL),(150128,167,'Arifwala','AFA',3175,'active',NULL,NULL,NULL),(150129,167,'Athara Hazari','ATH',3175,'active',NULL,NULL,NULL),(150130,167,'Attershshaan','ATR',3175,'active',NULL,NULL,NULL),(150131,167,'Attock','ATT',3175,'active',NULL,NULL,NULL),(150132,167,'Badah ','BDH',3175,'active',NULL,NULL,NULL),(150133,167,'Bakrani','BKR',3175,'active',NULL,NULL,NULL),(150134,167,'Bakshapur ','LRK',3175,'active',NULL,NULL,NULL),(150135,167,'Balkasar','BKS',3175,'active',NULL,NULL,NULL),(150136,167,'Barnala','BRN',3175,'active',NULL,NULL,NULL),(150137,167,'Bharwana','BHR',3175,'active',NULL,NULL,NULL),(150138,167,'Bhera','BRA',3175,'active',NULL,NULL,NULL),(150139,167,'Bhitshah','BTS',3175,'active',NULL,NULL,NULL),(150140,167,'Bhone','BNH',3175,'active',NULL,NULL,NULL),(150141,167,'Bikhari Kalan','BKL',3175,'active',NULL,NULL,NULL),(150142,167,'Buchal Kalan','BCK',3175,'active',NULL,NULL,NULL),(150143,167,'Bulri Shah Kareem','BRS',3175,'active',NULL,NULL,NULL),(150144,167,'Baddomali','BDO',3175,'active',NULL,NULL,NULL),(150145,167,'Bagh','BAG',3175,'active',NULL,NULL,NULL),(150146,167,'Baghbana','BNA',3175,'active',NULL,NULL,NULL),(150147,167,'Bahawal Nagar','NGR',3175,'active',NULL,NULL,NULL),(150148,167,'Bahawalpur','BHV',3175,'active',NULL,NULL,NULL),(150149,167,'Bahrain','BHN',3175,'active',NULL,NULL,NULL),(150150,167,'Bajur Agency','BJA',3175,'active',NULL,NULL,NULL),(150151,167,'Balakot','BLK',3175,'active',NULL,NULL,NULL),(150152,167,'Balina Khattan','BNK',3175,'active',NULL,NULL,NULL),(150153,167,'Balogram','BOG',3175,'active',NULL,NULL,NULL),(150154,167,'Bangla Gogera','BLG',3175,'active',NULL,NULL,NULL),(150155,167,'Bannuu','BNP',3175,'active',NULL,NULL,NULL),(150156,167,'Bari Kot','BRK',3175,'active',NULL,NULL,NULL),(150157,167,'Basirpur','BSP',3175,'active',NULL,NULL,NULL),(150158,167,'Basti Shorekot','BSK',3175,'active',NULL,NULL,NULL),(150159,167,'Batkhela','BTK',3175,'active',NULL,NULL,NULL),(150160,167,'Batrasi','BTR',3175,'active',NULL,NULL,NULL),(150161,167,'Beerkund Khaki','BKH',3175,'active',NULL,NULL,NULL),(150162,167,'Behal','BHL',3175,'active',NULL,NULL,NULL),(150163,167,'Bhagatwala','BTW',3175,'active',NULL,NULL,NULL),(150164,167,'Bhai Pheru','BPR',3175,'active',NULL,NULL,NULL),(150165,167,'Bhakkar','BKK',3175,'active',NULL,NULL,NULL),(150166,167,'Bhalwal','BWL',3175,'active',NULL,NULL,NULL),(150167,167,'Bhan Saeedabad','BSA',3175,'active',NULL,NULL,NULL),(150168,167,'Bhawana','BWA',3175,'active',NULL,NULL,NULL),(150169,167,'Bheria City (Nawabshah)','BHC',3175,'active',NULL,NULL,NULL),(150170,167,'Bhikhi','BHK',3175,'active',NULL,NULL,NULL),(150171,167,'Bhimber','BMR',3175,'active',NULL,NULL,NULL),(150172,167,'Buchari','BCH',3175,'active',NULL,NULL,NULL),(150173,167,'Buner','BNR',3175,'active',NULL,NULL,NULL),(150174,167,'Burewala','BRW',3175,'active',NULL,NULL,NULL),(150175,167,'Burj Dara','BRJ',3175,'active',NULL,NULL,NULL),(150176,167,'Chaksawari','CHK',3175,'active',NULL,NULL,NULL),(150177,167,'Changa Manga','CGM',3175,'active',NULL,NULL,NULL),(150178,167,'Chitral','CJL',3175,'active',NULL,NULL,NULL),(150179,167,'Chowk Bahadur Pur','CBP',3175,'active',NULL,NULL,NULL),(150180,167,'Chowk Qureshi','CHQ',3175,'active',NULL,NULL,NULL),(150181,167,'Chowk Server Shaheed','CHS',3175,'active',NULL,NULL,NULL),(150182,167,'Chunia','CHN',3175,'active',NULL,NULL,NULL),(150183,167,'Chachian','CCN',3175,'active',NULL,NULL,NULL),(150184,167,'Chachoro','CCR',3175,'active',NULL,NULL,NULL),(150185,167,'Chak Dera','CKD',3175,'active',NULL,NULL,NULL),(150186,167,'Chak Ghazi','CGZ',3175,'active',NULL,NULL,NULL),(150187,167,'Chak Jhumra','CJM',3175,'active',NULL,NULL,NULL),(150188,167,'Chak Kharal','CKH',3175,'active',NULL,NULL,NULL),(150189,167,'Chakwal','CKL',3175,'active',NULL,NULL,NULL),(150190,167,'Char Bagh','CHR',3175,'active',NULL,NULL,NULL),(150191,167,'Charcheck','CCK',3175,'active',NULL,NULL,NULL),(150192,167,'Charsadda','CSD',3175,'active',NULL,NULL,NULL),(150193,167,'Chashma','CMA',3175,'active',NULL,NULL,NULL),(150194,167,'Chattar Plain','CTP',3175,'active',NULL,NULL,NULL),(150195,167,'Chatter Kalas','CTK',3175,'active',NULL,NULL,NULL),(150196,167,'Chaubara','CHU',3175,'active',NULL,NULL,NULL),(150197,167,'Chauwki','CUK',3175,'active',NULL,NULL,NULL),(150198,167,'Chawinda','CWD',3175,'active',NULL,NULL,NULL),(150199,167,'Chella','CHL',3175,'active',NULL,NULL,NULL),(150200,167,'Chhori','CHO',3175,'active',NULL,NULL,NULL),(150201,167,'Chianri','CHI',3175,'active',NULL,NULL,NULL),(150202,167,'Chichawatni','CCW',3175,'active',NULL,NULL,NULL),(150203,167,'Chiniot','IOT',3175,'active',NULL,NULL,NULL),(150204,167,'Chirya Wala','CYW',3175,'active',NULL,NULL,NULL),(150205,167,'Chishtian','CHT',3175,'active',NULL,NULL,NULL),(150206,167,'Chita Bata','CTB',3175,'active',NULL,NULL,NULL),(150207,167,'Chohr Cant','CHC',3175,'active',NULL,NULL,NULL),(150208,167,'Choti Zareen','CZN',3175,'active',NULL,NULL,NULL),(150209,167,'Chowk Azam','CKA',3175,'active',NULL,NULL,NULL),(150210,167,'Chowk Munda','CKM',3175,'active',NULL,NULL,NULL),(150211,167,'Chua Saidain Shah','CSS',3175,'active',NULL,NULL,NULL),(150212,167,'Chundiko','CNK',3175,'active',NULL,NULL,NULL),(150213,167,'Daira Deen Panah','DDP',3175,'active',NULL,NULL,NULL),(150214,167,'Dandot','DNT',3175,'active',NULL,NULL,NULL),(150215,167,'Darbelo','DBO',3175,'active',NULL,NULL,NULL),(150216,167,'Daro','DRO',3175,'active',NULL,NULL,NULL),(150217,167,'Darya Khan Mari','DKM',3175,'active',NULL,NULL,NULL),(150218,167,'Dera Nawab','DRN',3175,'active',NULL,NULL,NULL),(150219,167,'Dhab Kalan','DBK',3175,'active',NULL,NULL,NULL),(150220,167,'Dhudial','DHL',3175,'active',NULL,NULL,NULL),(150221,167,'Dijkot','DJK',3175,'active',NULL,NULL,NULL),(150222,167,'Dadyal Ak','DDL',3175,'active',NULL,NULL,NULL),(150223,167,'Daharki','DKI',3175,'active',NULL,NULL,NULL),(150224,167,'Dahranwala','DRW',3175,'active',NULL,NULL,NULL),(150225,167,'Dajal','DJL',3175,'active',NULL,NULL,NULL),(150226,167,'Dargai','DRG',3175,'active',NULL,NULL,NULL),(150227,167,'Darra','DAR',3175,'active',NULL,NULL,NULL),(150228,167,'Darya Khan','DRK',3175,'active',NULL,NULL,NULL),(150229,167,'Daska','DSK',3175,'active',NULL,NULL,NULL),(150230,167,'Daud Khel','DDK',3175,'active',NULL,NULL,NULL),(150231,167,'Dawood Khel','DKL',3175,'active',NULL,NULL,NULL),(150232,167,'Depalpur','DPR',3175,'active',NULL,NULL,NULL),(150233,167,'Dera Allah Yar','DAY',3175,'active',NULL,NULL,NULL),(150234,167,'Dera Ghazi Khan','DGK',3175,'active',NULL,NULL,NULL),(150235,167,'Dera Ismail Khan','DIK',3175,'active',NULL,NULL,NULL),(150236,167,'Dera Murad Jamali','DMJ',3175,'active',NULL,NULL,NULL),(150237,167,'Dhabeji','DHJ',3175,'active',NULL,NULL,NULL),(150238,167,'Dina','DIN',3175,'active',NULL,NULL,NULL),(150239,167,'Dinga','DNG',3175,'active',NULL,NULL,NULL),(150240,167,'Donga Bonga','DGB',3175,'active',NULL,NULL,NULL),(150241,167,'Doronaro','DNO',3175,'active',NULL,NULL,NULL),(150242,167,'Dour','DOR',3175,'active',NULL,NULL,NULL),(150243,167,'Duabba','DOA',3175,'active',NULL,NULL,NULL),(150244,167,'Dulywala','DYW',3175,'active',NULL,NULL,NULL),(150245,167,'Duniapur','DUR',3175,'active',NULL,NULL,NULL),(150246,167,'Dunya Pur','DNP',3175,'active',NULL,NULL,NULL),(150247,167,'Ellah Abbad','EHA',3175,'active',NULL,NULL,NULL),(150248,167,'Ehsan Pur','EHS',3175,'active',NULL,NULL,NULL),(150249,167,'Farooqabad','FQR',3175,'active',NULL,NULL,NULL),(150250,167,'Faisalabad','LYP',3175,'active',NULL,NULL,NULL),(150251,167,'Faqirwali','FRW',3175,'active',NULL,NULL,NULL),(150252,167,'Fateh Jang','FTG',3175,'active',NULL,NULL,NULL),(150253,167,'Fatehpur','FTH',3175,'active',NULL,NULL,NULL),(150254,167,'Fazal Pur','FPR',3175,'active',NULL,NULL,NULL),(150255,167,'Fazilpur','FZP',3175,'active',NULL,NULL,NULL),(150256,167,'Feroze Wattwan','FTN',3175,'active',NULL,NULL,NULL),(150257,167,'Fort Abbass','FAB',3175,'active',NULL,NULL,NULL),(150258,167,'Fort Monroe','FTM',3175,'active',NULL,NULL,NULL),(150259,167,'Gari Yasin','GRY',3175,'active',NULL,NULL,NULL),(150260,167,'Ghakhar','GKR',3175,'active',NULL,NULL,NULL),(150261,167,'Girot','GIR',3175,'active',NULL,NULL,NULL),(150262,167,'Golarchi','GLH',3175,'active',NULL,NULL,NULL),(150263,167,'Gadani','GDI',3175,'active',NULL,NULL,NULL),(150264,167,'Gadoon Amazai','GDA',3175,'active',NULL,NULL,NULL),(150265,167,'Gaggo Mandi','GMD',3175,'active',NULL,NULL,NULL),(150266,167,'Gahri Kapoora','GKP',3175,'active',NULL,NULL,NULL),(150267,167,'Gakhar Mandi','GKM',3175,'active',NULL,NULL,NULL),(150268,167,'Garh Mahraja','GHJ',3175,'active',NULL,NULL,NULL),(150269,167,'Garhi Habibullah','GHU',3175,'active',NULL,NULL,NULL),(150270,167,'Garhmore','GRM',3175,'active',NULL,NULL,NULL),(150271,167,'Gazgi','GZG',3175,'active',NULL,NULL,NULL),(150272,167,'Gharhi Mori','GHM',3175,'active',NULL,NULL,NULL),(150273,167,'Ghari Duptta','GHD',3175,'active',NULL,NULL,NULL),(150274,167,'Ghazi','GZI',3175,'active',NULL,NULL,NULL),(150275,167,'Gojra','RRA',3175,'active',NULL,NULL,NULL),(150276,167,'Goth Machi','GMI',3175,'active',NULL,NULL,NULL),(150277,167,'Guddu','GDN',3175,'active',NULL,NULL,NULL),(150278,167,'Gujar Khan','GKN',3175,'active',NULL,NULL,NULL),(150279,167,'Gujranwala','GUJ',3175,'active',NULL,NULL,NULL),(150280,167,'Gujrat','GRT',3175,'active',NULL,NULL,NULL),(150281,167,'Habiba Abad','HBA',3175,'active',NULL,NULL,NULL),(150282,167,'Harnoli','HNL',3175,'active',NULL,NULL,NULL),(150283,167,'Head Baloki','HDB',3175,'active',NULL,NULL,NULL),(150284,167,'Head Faqeerian','HFR',3175,'active',NULL,NULL,NULL),(150285,167,'Head Muhammad Wala','HMW',3175,'active',NULL,NULL,NULL),(150286,167,'Hub Chowki','HKI',3175,'active',NULL,NULL,NULL),(150287,167,'Hafizabad ','HZD',3175,'active',NULL,NULL,NULL),(150288,167,'Halani','HLI',3175,'active',NULL,NULL,NULL),(150289,167,'Hangu','HNG',3175,'active',NULL,NULL,NULL),(150290,167,'Harappa','HRP',3175,'active',NULL,NULL,NULL),(150291,167,'Haripur','HRI',3175,'active',NULL,NULL,NULL),(150292,167,'Haroonabad','HRN',3175,'active',NULL,NULL,NULL),(150293,167,'Hasilpur','HSL',3175,'active',NULL,NULL,NULL),(150294,167,'Hassan Abdal','HSN',3175,'active',NULL,NULL,NULL),(150295,167,'Hatoongo','HTG',3175,'active',NULL,NULL,NULL),(150296,167,'Hattain Bala','HTB',3175,'active',NULL,NULL,NULL),(150297,167,'Hattar','HTR',3175,'active',NULL,NULL,NULL),(150298,167,'Hattian','HTN',3175,'active',NULL,NULL,NULL),(150299,167,'Haveli Bahadur Shah','HBS',3175,'active',NULL,NULL,NULL),(150300,167,'Haveli Lakha','HLK',3175,'active',NULL,NULL,NULL),(150301,167,'Hawilian','HVL',3175,'active',NULL,NULL,NULL),(150302,167,'Hazro ','HAZ',3175,'active',NULL,NULL,NULL),(150303,167,'Head Marala','HDM',3175,'active',NULL,NULL,NULL),(150304,167,'Hindyari','HND',3175,'active',NULL,NULL,NULL),(150305,167,'Hub','HUB',3175,'active',NULL,NULL,NULL),(150306,167,'Hujra Shah Mukeem','HHM',3175,'active',NULL,NULL,NULL),(150307,167,'Hyderabad Thal','HTL',3175,'active',NULL,NULL,NULL),(150308,167,'Islam Garh','ISG',3175,'active',NULL,NULL,NULL),(150309,167,'Isakhel','ESK',3175,'active',NULL,NULL,NULL),(150310,167,'Iskandarabad','ISK',3175,'active',NULL,NULL,NULL),(150311,167,'Islamabad','ISB',3175,'active',NULL,NULL,NULL),(150312,167,'Issa Khel','IKL',3175,'active',NULL,NULL,NULL),(150313,167,'Jilalpur Bhatian','JPB',3175,'active',NULL,NULL,NULL),(150314,167,'Juddo','JDU',3175,'active',NULL,NULL,NULL),(150315,167,'Jahangira','JNG',3175,'active',NULL,NULL,NULL),(150316,167,'Jahanian','JNA',3175,'active',NULL,NULL,NULL),(150317,167,'Jalal Pur Shareef','JPS',3175,'active',NULL,NULL,NULL),(150318,167,'Jalalpur Jattan','JJT',3175,'active',NULL,NULL,NULL),(150319,167,'Jalalpur Pirwala','JPP',3175,'active',NULL,NULL,NULL),(150320,167,'Jaman Shah','JNS',3175,'active',NULL,NULL,NULL),(150321,167,'Jammbur','JMM',3175,'active',NULL,NULL,NULL),(150322,167,'Jampur','JMR',3175,'active',NULL,NULL,NULL),(150323,167,'Jand','JND',3175,'active',NULL,NULL,NULL),(150324,167,'Jaranwala','JWA',3175,'active',NULL,NULL,NULL),(150325,167,'Jatlan','JTN',3175,'active',NULL,NULL,NULL),(150326,167,'Jatoi','JOT',3175,'active',NULL,NULL,NULL),(150327,167,'Jauharabad','JRD',3175,'active',NULL,NULL,NULL),(150328,167,'Jhaamkay','JMK',3175,'active',NULL,NULL,NULL),(150329,167,'Jhabran','JHB',3175,'active',NULL,NULL,NULL),(150330,167,'Jhambra','JMA',3175,'active',NULL,NULL,NULL),(150331,167,'Jhandala Sher Khan','JSK',3175,'active',NULL,NULL,NULL),(150332,167,'Jhang','JHG',3175,'active',NULL,NULL,NULL),(150333,167,'Jhelum','JLM',3175,'active',NULL,NULL,NULL),(150334,167,'Jhok Mehar Shah','JMS',3175,'active',NULL,NULL,NULL),(150335,167,'K.N. Shah','KNS',3175,'active',NULL,NULL,NULL),(150336,167,'Kacha Khho','KCK',3175,'active',NULL,NULL,NULL),(150337,167,'Kakul ','KKL',3175,'active',NULL,NULL,NULL),(150338,167,'Kamer Mishani','KMS',3175,'active',NULL,NULL,NULL),(150339,167,'Kangan Pur','KGP',3175,'active',NULL,NULL,NULL),(150340,167,'Karam Pur','KAP',3175,'active',NULL,NULL,NULL),(150341,167,'Karoor Lalison','KRL',3175,'active',NULL,NULL,NULL),(150342,167,'Kasso Ke','KSI',3175,'active',NULL,NULL,NULL),(150343,167,'Khair Pur Mahar ','KPM',3175,'active',NULL,NULL,NULL),(150344,167,'Khairpur Tamewali','KPT',3175,'active',NULL,NULL,NULL),(150345,167,'Khan Garh','KNG',3175,'active',NULL,NULL,NULL),(150346,167,'Khanka Dogran','KHD',3175,'active',NULL,NULL,NULL),(150347,167,'Khipro','KIP',3175,'active',NULL,NULL,NULL),(150348,167,'Khuddian','KDD',3175,'active',NULL,NULL,NULL),(150349,167,'Kolo Tarar','KAR',3175,'active',NULL,NULL,NULL),(150350,167,'Kot Banglow','KTW',3175,'active',NULL,NULL,NULL),(150351,167,'Kot Gullam Mohd','KGM',3175,'active',NULL,NULL,NULL),(150352,167,'Kot Radha Kishan','KRS',3175,'active',NULL,NULL,NULL),(150353,167,'Kot Samaba','KSB',3175,'active',NULL,NULL,NULL),(150354,167,'Kot Sultan','KST',3175,'active',NULL,NULL,NULL),(150355,167,'Kotla Jam','KTJ',3175,'active',NULL,NULL,NULL),(150356,167,'Kumb','KMB',3175,'active',NULL,NULL,NULL),(150357,167,'Kundain','KND',3175,'active',NULL,NULL,NULL),(150358,167,'Kunja City','KNJ',3175,'active',NULL,NULL,NULL),(150359,167,'Kabal','KBL',3175,'active',NULL,NULL,NULL),(150360,167,'Kabirwala','KBW',3175,'active',NULL,NULL,NULL),(150361,167,'Kahori Pull','KOP',3175,'active',NULL,NULL,NULL),(150362,167,'Kahuta','KHT',3175,'active',NULL,NULL,NULL),(150363,167,'Kakra Town','KKT',3175,'active',NULL,NULL,NULL),(150364,167,'Kala Bagh','KBG',3175,'active',NULL,NULL,NULL),(150365,167,'Kala Shah Kaku','KSK',3175,'active',NULL,NULL,NULL),(150366,167,'Kaleki Mandi','KLD',3175,'active',NULL,NULL,NULL),(150367,167,'Kallar Kahar','KKR',3175,'active',NULL,NULL,NULL),(150368,167,'Kallar Saddiyian','KSD',3175,'active',NULL,NULL,NULL),(150369,167,'Kaloorkot','KLK',3175,'active',NULL,NULL,NULL),(150370,167,'Kamalia','KML',3175,'active',NULL,NULL,NULL),(150371,167,'Kamber Ali Khan','QAK',3175,'active',NULL,NULL,NULL),(150372,167,'Kamir','KMR',3175,'active',NULL,NULL,NULL),(150373,167,'Kamoke','KMK',3175,'active',NULL,NULL,NULL),(150374,167,'Kamra ','KAM',3175,'active',NULL,NULL,NULL),(150375,167,'Kandh Kot','KKK',3175,'active',NULL,NULL,NULL),(150376,167,'Kanju Township','KTS',3175,'active',NULL,NULL,NULL),(150377,167,'Karak','KRK',3175,'active',NULL,NULL,NULL),(150378,167,'Karchak','KAK',3175,'active',NULL,NULL,NULL),(150379,167,'Karianwala','KRA',3175,'active',NULL,NULL,NULL),(150380,167,'Karoondi','KRD',3175,'active',NULL,NULL,NULL),(150381,167,'Karor Pakka','KPC',3175,'active',NULL,NULL,NULL),(150382,167,'Kashmore','KSM',3175,'active',NULL,NULL,NULL),(150383,167,'Kasur','KSR',3175,'active',NULL,NULL,NULL),(150384,167,'Katlang','KTL',3175,'active',NULL,NULL,NULL),(150385,167,'Khairpur Mirs','KHM',3175,'active',NULL,NULL,NULL),(150386,167,'Khand','KHA',3175,'active',NULL,NULL,NULL),(150387,167,'Khanewahan','KWN',3175,'active',NULL,NULL,NULL),(150388,167,'Khanewal','KWL',3175,'active',NULL,NULL,NULL),(150389,167,'Khanpur','NPR',3175,'active',NULL,NULL,NULL),(150390,167,'Khanpur Dam','KPD',3175,'active',NULL,NULL,NULL),(150391,167,'Khansar','KHS',3175,'active',NULL,NULL,NULL),(150392,167,'Kharian','KRN',3175,'active',NULL,NULL,NULL),(150393,167,'Kharzan','KRZ',3175,'active',NULL,NULL,NULL),(150394,167,'Khawaja Stop','KJS',3175,'active',NULL,NULL,NULL),(150395,167,'Khawaza Khela','KZW',3175,'active',NULL,NULL,NULL),(150396,167,'Khewra','KEW',3175,'active',NULL,NULL,NULL),(150397,167,'Khichiwala','KCI',3175,'active',NULL,NULL,NULL),(150398,167,'Khurrianwala','KRW',3175,'active',NULL,NULL,NULL),(150399,167,'Khushab','SAB',3175,'active',NULL,NULL,NULL),(150400,167,'Khuzdar','KZR',3175,'active',NULL,NULL,NULL),(150401,167,'Khyber ','KYR',3175,'active',NULL,NULL,NULL),(150402,167,'Klaske','KLS',3175,'active',NULL,NULL,NULL),(150403,167,'Kohala','KOH',3175,'active',NULL,NULL,NULL),(150404,167,'Kohat','OHT',3175,'active',NULL,NULL,NULL),(150405,167,'Komi Kot','KOK',3175,'active',NULL,NULL,NULL),(150406,167,'Kot Abdul Malik','KBD',3175,'active',NULL,NULL,NULL),(150407,167,'Kot Addu','KOT',3175,'active',NULL,NULL,NULL),(150408,167,'Kot Chutta','KOC',3175,'active',NULL,NULL,NULL),(150409,167,'Kot Momin','KTM',3175,'active',NULL,NULL,NULL),(150410,167,'Kot Qaisrani','KQS',3175,'active',NULL,NULL,NULL),(150411,167,'Kot Sarwar','KOS',3175,'active',NULL,NULL,NULL),(150412,167,'Kote Jamel','KJL',3175,'active',NULL,NULL,NULL),(150413,167,'Kotla Arab Ali Khan','KRB',3175,'active',NULL,NULL,NULL),(150414,167,'Kotli Ak','KOL',3175,'active',NULL,NULL,NULL),(150415,167,'Kotli Loharan','KLA',3175,'active',NULL,NULL,NULL),(150416,167,'Kotri Kabir','KTK',3175,'active',NULL,NULL,NULL),(150417,167,'Laliyan','LLY',3175,'active',NULL,NULL,NULL),(150418,167,'Lawa','LAW',3175,'active',NULL,NULL,NULL),(150419,167,'Lachi','LCH',3175,'active',NULL,NULL,NULL),(150420,167,'Ladhana','LDN',3175,'active',NULL,NULL,NULL),(150421,167,'Lahore','LHE',3175,'active',NULL,NULL,NULL),(150422,167,'Lakki Marwat','LKI',3175,'active',NULL,NULL,NULL),(150423,167,'Lala Musa','LLM',3175,'active',NULL,NULL,NULL),(150424,167,'Languar Pura','LNG',3175,'active',NULL,NULL,NULL),(150425,167,'Layyah','LYY',3175,'active',NULL,NULL,NULL),(150426,167,'Liaqatpur','LQR',3175,'active',NULL,NULL,NULL),(150427,167,'Lodhran','LOD',3175,'active',NULL,NULL,NULL),(150428,167,'Lower Dir','LDR',3175,'active',NULL,NULL,NULL),(150429,167,'Makhdoom Ali','MDA',3175,'active',NULL,NULL,NULL),(150430,167,'Makhdoom Rasheed','MDR',3175,'active',NULL,NULL,NULL),(150431,167,'Mamukanjin','MMK',3175,'active',NULL,NULL,NULL),(150432,167,'Mandi Faizabad','MFD',3175,'active',NULL,NULL,NULL),(150433,167,'Mandi Shah Jewna','MSJ',3175,'active',NULL,NULL,NULL),(150434,167,'Mangwal','MGW',3175,'active',NULL,NULL,NULL),(150435,167,'Mari Indus','MIS',3175,'active',NULL,NULL,NULL),(150436,167,'Mehmood Kot','MKT',3175,'active',NULL,NULL,NULL),(150437,167,'Miani','MNI',3175,'active',NULL,NULL,NULL),(150438,167,'Mirpur Bathoro','MPB',3175,'active',NULL,NULL,NULL),(150439,167,'Mirwah','MRW',3175,'active',NULL,NULL,NULL),(150440,167,'Mithyani','MTI',3175,'active',NULL,NULL,NULL),(150441,167,'Mulhal Mughla','MUL',3175,'active',NULL,NULL,NULL),(150442,167,'Munara','MNR',3175,'active',NULL,NULL,NULL),(150443,167,'Murred Air Base','MBA',3175,'active',NULL,NULL,NULL),(150444,167,'Musafir Khana','MSF',3175,'active',NULL,NULL,NULL),(150445,167,'Maidain','MID',3175,'active',NULL,NULL,NULL),(150446,167,'Mailsi ','MLS',3175,'active',NULL,NULL,NULL),(150447,167,'Makhal','MKH',3175,'active',NULL,NULL,NULL),(150448,167,'Makli','MKI',3175,'active',NULL,NULL,NULL),(150449,167,'Malakand','MKN',3175,'active',NULL,NULL,NULL),(150450,167,'Malakwal ','MKL',3175,'active',NULL,NULL,NULL),(150451,167,'Mandi Ahmedabad','MAH',3175,'active',NULL,NULL,NULL),(150452,167,'Mandi Bahauddin','MBD',3175,'active',NULL,NULL,NULL),(150453,167,'Mandra','MND',3175,'active',NULL,NULL,NULL),(150454,167,'Manekra','MNK',3175,'active',NULL,NULL,NULL),(150455,167,'Manga Mandi','MMD',3175,'active',NULL,NULL,NULL),(150456,167,'Mangla','MGL',3175,'active',NULL,NULL,NULL),(150457,167,'Mannanwala','MNW',3175,'active',NULL,NULL,NULL),(150458,167,'Mansehra','MNA',3175,'active',NULL,NULL,NULL),(150459,167,'Maqsoodo','MQS',3175,'active',NULL,NULL,NULL),(150460,167,'Mardan','MDN',3175,'active',NULL,NULL,NULL),(150461,167,'Marot ','MRT',3175,'active',NULL,NULL,NULL),(150462,167,'Matta','MTA',3175,'active',NULL,NULL,NULL),(150463,167,'Mcleodganj','MLG',3175,'active',NULL,NULL,NULL),(150464,167,'Mehrabpur','MRB',3175,'active',NULL,NULL,NULL),(150465,167,'Mian Channu','MCN',3175,'active',NULL,NULL,NULL),(150466,167,'Mian Wali','MWI',3175,'active',NULL,NULL,NULL),(150467,167,'Minchinabad','MHN',3175,'active',NULL,NULL,NULL),(150468,167,'Mingora','MNG',3175,'active',NULL,NULL,NULL),(150469,167,'Mirpur Azad Kashmir','QML',3175,'active',NULL,NULL,NULL),(150470,167,'Mithankot ','KMT',3175,'active',NULL,NULL,NULL),(150471,167,'Moola','MOL',3175,'active',NULL,NULL,NULL),(150472,167,'More Aimanabad','MAD',3175,'active',NULL,NULL,NULL),(150473,167,'More Khunda','MKD',3175,'active',NULL,NULL,NULL),(150474,167,'Muhammadpur','MDP',3175,'active',NULL,NULL,NULL),(150475,167,'Multan','MUX',3175,'active',NULL,NULL,NULL),(150476,167,'Muridke','MRY',3175,'active',NULL,NULL,NULL),(150477,167,'Murree','REE',3175,'active',NULL,NULL,NULL),(150478,167,'Muzaffarabad','MAK',3175,'active',NULL,NULL,NULL),(150479,167,'Muzaffargarh ','MZG',3175,'active',NULL,NULL,NULL),(150480,167,'Nandi Pur','NDP',3175,'active',NULL,NULL,NULL),(150481,167,'Narang Mandi','NRM',3175,'active',NULL,NULL,NULL),(150482,167,'Neela Dhulla','NLD',3175,'active',NULL,NULL,NULL),(150483,167,'New Jatoi','NJT',3175,'active',NULL,NULL,NULL),(150484,167,'Noorpur Nooranga','NPN',3175,'active',NULL,NULL,NULL),(150485,167,'Nankana Shahib','NKS',3175,'active',NULL,NULL,NULL),(150486,167,'Narowal','NRL',3175,'active',NULL,NULL,NULL),(150487,167,'Nawab Shah','WNS',3175,'active',NULL,NULL,NULL),(150488,167,'Nawakalai','NWK',3175,'active',NULL,NULL,NULL),(150489,167,'New Saeedabad','NSA',3175,'active',NULL,NULL,NULL),(150490,167,'Nizampur','NMP',3175,'active',NULL,NULL,NULL),(150491,167,'Nooriabad','NRD',3175,'active',NULL,NULL,NULL),(150492,167,'Noshero Feroze','NFZ',3175,'active',NULL,NULL,NULL),(150493,167,'Notak','NTK',3175,'active',NULL,NULL,NULL),(150494,167,'Nowshera','NOW',3175,'active',NULL,NULL,NULL),(150495,167,'Nowshera Virka','NOV',3175,'active',NULL,NULL,NULL),(150496,167,'Nurkot','NUK',3175,'active',NULL,NULL,NULL),(150497,167,'Oudherwal','ODW',3175,'active',NULL,NULL,NULL),(150498,167,'Odigram','ODG',3175,'active',NULL,NULL,NULL),(150499,167,'Oghi','OGI',3175,'active',NULL,NULL,NULL),(150500,167,'Okara','OKR',3175,'active',NULL,NULL,NULL),(150501,167,'Okara Cantt','OKC',3175,'active',NULL,NULL,NULL),(150502,167,'Other','OTH',3175,'active',NULL,NULL,NULL),(150503,167,'Painsara','PNS',3175,'active',NULL,NULL,NULL),(150504,167,'Paniyal','PNY',3175,'active',NULL,NULL,NULL),(150505,167,'Phularwan','PHU',3175,'active',NULL,NULL,NULL),(150506,167,'Phull','PHL',3175,'active',NULL,NULL,NULL),(150507,167,'Pir-Jo-Goth','PJG',3175,'active',NULL,NULL,NULL),(150508,167,'Pabbi','PBI',3175,'active',NULL,NULL,NULL),(150509,167,'Pacca Chang','PAC',3175,'active',NULL,NULL,NULL),(150510,167,'Padidan','PDD',3175,'active',NULL,NULL,NULL),(150511,167,'Paharpur','PHR',3175,'active',NULL,NULL,NULL),(150512,167,'Paigham ','PGN',3175,'active',NULL,NULL,NULL),(150513,167,'Pak Pattan Sharif','PPS',3175,'active',NULL,NULL,NULL),(150514,167,'Pakky Wala','PKW',3175,'active',NULL,NULL,NULL),(150515,167,'Panj Garian','PGR',3175,'active',NULL,NULL,NULL),(150516,167,'Panno Aqil','PNQ',3175,'active',NULL,NULL,NULL),(150517,167,'Parko','PRK',3175,'active',NULL,NULL,NULL),(150518,167,'Paroa','PRV',3175,'active',NULL,NULL,NULL),(150519,167,'Pasrur','PRR',3175,'active',NULL,NULL,NULL),(150520,167,'Pattika','PTK',3175,'active',NULL,NULL,NULL),(150521,167,'Pattoki','PTI',3175,'active',NULL,NULL,NULL),(150522,167,'Peshawar','PEW',3175,'active',NULL,NULL,NULL),(150523,167,'Phalia','PLA',3175,'active',NULL,NULL,NULL),(150524,167,'Phulji Station','PHS',3175,'active',NULL,NULL,NULL),(150525,167,'Pind Dadan Khan','PDK',3175,'active',NULL,NULL,NULL),(150526,167,'Pindi Bhattian','PBT',3175,'active',NULL,NULL,NULL),(150527,167,'Pindi Gheb','PGB',3175,'active',NULL,NULL,NULL),(150528,167,'Piplan','PPN',3175,'active',NULL,NULL,NULL),(150529,167,'Pir Mahal','PML',3175,'active',NULL,NULL,NULL),(150530,167,'Piryalo','PLO',3175,'active',NULL,NULL,NULL),(150531,167,'Poona','PON',3175,'active',NULL,NULL,NULL),(150532,167,'Puran','PRN',3175,'active',NULL,NULL,NULL),(150533,167,'Qadirpur Rawan','QPR',3175,'active',NULL,NULL,NULL),(150534,167,'Qalanderabad','QLS',3175,'active',NULL,NULL,NULL),(150535,167,'Qaboola','QBL',3175,'active',NULL,NULL,NULL),(150536,167,'Qalla Didar Singh','QDS',3175,'active',NULL,NULL,NULL),(150537,167,'Qasba Gujrat','QGT',3175,'active',NULL,NULL,NULL),(150538,167,'Qazi Ahmed','KZA',3175,'active',NULL,NULL,NULL),(150539,167,'Qila Kalar Wala','QKW',3175,'active',NULL,NULL,NULL),(150540,167,'Quaid Abad','QBD',3175,'active',NULL,NULL,NULL),(150541,167,'Quetta','UET',3175,'active',NULL,NULL,NULL),(150542,167,'Rajana','RJA',3175,'active',NULL,NULL,NULL),(150543,167,'Rasool Pur Tarar','RPT',3175,'active',NULL,NULL,NULL),(150544,167,'Rabwah','AWH',3175,'active',NULL,NULL,NULL),(150545,167,'Rahim Yar Khan','RYK',3175,'active',NULL,NULL,NULL),(150546,167,'Rahwali','RHW',3175,'active',NULL,NULL,NULL),(150547,167,'Raiwind','RND',3175,'active',NULL,NULL,NULL),(150548,167,'Rajanpur','RJP',3175,'active',NULL,NULL,NULL),(150549,167,'Rajowal','RJW',3175,'active',NULL,NULL,NULL),(150550,167,'Rangpur','RNG',3175,'active',NULL,NULL,NULL),(150551,167,'Rashakae','RAS',3175,'active',NULL,NULL,NULL),(150552,167,'Rasoolabad','RLB',3175,'active',NULL,NULL,NULL),(150553,167,'Rato Dero','RTD',3175,'active',NULL,NULL,NULL),(150554,167,'Rawalakot','RKT',3175,'active',NULL,NULL,NULL),(150555,167,'Rawalpindi','RWP',3175,'active',NULL,NULL,NULL),(150556,167,'Rawat','RWT',3175,'active',NULL,NULL,NULL),(150557,167,'Renala Khurd','RLK',3175,'active',NULL,NULL,NULL),(150558,167,'Risalpur','RSP',3175,'active',NULL,NULL,NULL),(150559,167,'Rojhan','RJN',3175,'active',NULL,NULL,NULL),(150560,167,'Rukni','RKN',3175,'active',NULL,NULL,NULL),(150561,167,'Safdra Abad','SFD',3175,'active',NULL,NULL,NULL),(150562,167,'Saleem Pura Jhalan','SJN',3175,'active',NULL,NULL,NULL),(150563,167,'Saleh Pat','SLT',3175,'active',NULL,NULL,NULL),(150564,167,'Samasatta','SMS',3175,'active',NULL,NULL,NULL),(150565,167,'Sanawaan','SNN',3175,'active',NULL,NULL,NULL),(150566,167,'Setharja ','STJ',3175,'active',NULL,NULL,NULL),(150567,167,'Shabqadar','SBQ',3175,'active',NULL,NULL,NULL),(150568,167,'Shahdadkot','SDT',3175,'active',NULL,NULL,NULL),(150569,167,'Sukhiky Mandi','SKM',3175,'active',NULL,NULL,NULL),(150570,167,'Sadhokee','SKE',3175,'active',NULL,NULL,NULL),(150571,167,'Sadiqabad','SQD',3175,'active',NULL,NULL,NULL),(150572,167,'Sahiwal','SWL',3175,'active',NULL,NULL,NULL),(150573,167,'Saidu Sharif','SDF',3175,'active',NULL,NULL,NULL),(150574,167,'Sakardu','KDU',3175,'active',NULL,NULL,NULL),(150575,167,'Sakhakot','SKK',3175,'active',NULL,NULL,NULL),(150576,167,'Sakhi Sarwar','SIS',3175,'active',NULL,NULL,NULL),(150577,167,'Samahani','SHI',3175,'active',NULL,NULL,NULL),(150578,167,'Sambrial','SBR',3175,'active',NULL,NULL,NULL),(150579,167,'Samundri','SAM',3175,'active',NULL,NULL,NULL),(150580,167,'Sangla Hills','SHL',3175,'active',NULL,NULL,NULL),(150581,167,'Sara-A Mahajar','SMH',3175,'active',NULL,NULL,NULL),(150582,167,'Sara-A-Naurang','SRG',3175,'active',NULL,NULL,NULL),(150583,167,'Sara-E-Alamgir','SIR',3175,'active',NULL,NULL,NULL),(150584,167,'Sargodha','SGD',3175,'active',NULL,NULL,NULL),(150585,167,'Sasol','SSL',3175,'active',NULL,NULL,NULL),(150586,167,'Satiayana ','STN',3175,'active',NULL,NULL,NULL),(150587,167,'Sawari','SUR',3175,'active',NULL,NULL,NULL),(150588,167,'Sehwan Sharif','SHN',3175,'active',NULL,NULL,NULL),(150589,167,'Shahjamal','SJL',3175,'active',NULL,NULL,NULL),(150590,167,'Shahdara','SHD',3175,'active',NULL,NULL,NULL),(150591,167,'Shahkot','SHK',3175,'active',NULL,NULL,NULL),(150592,167,'Shahpur Jahania','SPJ',3175,'active',NULL,NULL,NULL),(150593,167,'Shahpur Saddar','SPS',3175,'active',NULL,NULL,NULL),(150594,167,'Shakargarh','SGR',3175,'active',NULL,NULL,NULL),(150595,167,'Shamki Bhattian','SHB',3175,'active',NULL,NULL,NULL),(150596,167,'Shamozai','SMZ',3175,'active',NULL,NULL,NULL),(150597,167,'Sharaq Pur','SRQ',3175,'active',NULL,NULL,NULL),(150598,167,'Shehdadpur','SPR',3175,'active',NULL,NULL,NULL),(150599,167,'Sheikh Maltoon','SMN',3175,'active',NULL,NULL,NULL),(150600,167,'Sheikhupura','SPA',3175,'active',NULL,NULL,NULL),(150601,167,'Sher Garh','SHG',3175,'active',NULL,NULL,NULL),(150602,167,'Sher Ghar','SGH',3175,'active',NULL,NULL,NULL),(150603,167,'Shirangal','SRN',3175,'active',NULL,NULL,NULL),(150604,167,'Shorkot','SQT',3175,'active',NULL,NULL,NULL),(150605,167,'Shorkot Cantonment','SKC',3175,'active',NULL,NULL,NULL),(150606,167,'Shuja Abad','SHJ',3175,'active',NULL,NULL,NULL),(150607,167,'Sialkot','SKT',3175,'active',NULL,NULL,NULL),(150608,167,'Sibi','SIB',3175,'active',NULL,NULL,NULL),(150609,167,'Sillanwali','SLW',3175,'active',NULL,NULL,NULL),(150610,167,'Sindhri','SNR',3175,'active',NULL,NULL,NULL),(150611,167,'Sohawa','SOW',3175,'active',NULL,NULL,NULL),(150612,167,'Sui Gas','SUG',3175,'active',NULL,NULL,NULL),(150613,167,'Sujawal','SUJ',3175,'active',NULL,NULL,NULL),(150614,167,'Sun Chakra','SCK',3175,'active',NULL,NULL,NULL),(150615,167,'Sundar','SDR',3175,'active',NULL,NULL,NULL),(150616,167,'Swabi','SWB',3175,'active',NULL,NULL,NULL),(150617,167,'Swat','SWT',3175,'active',NULL,NULL,NULL),(150618,167,'Tanda','TND',3175,'active',NULL,NULL,NULL),(150619,167,'Tando Jaan Muhammad','TJD',3175,'active',NULL,NULL,NULL),(150620,167,'Tulamba','TUL',3175,'active',NULL,NULL,NULL),(150621,167,'Takht-I-Bahi','TKB',3175,'active',NULL,NULL,NULL),(150622,167,'Talagang','TLG',3175,'active',NULL,NULL,NULL),(150623,167,'Tall','TAL',3175,'active',NULL,NULL,NULL),(150624,167,'Talwandi Bhindran','TBN',3175,'active',NULL,NULL,NULL),(150625,167,'Tandlianwala','TDW',3175,'active',NULL,NULL,NULL),(150626,167,'Tando Allah Yar','TDY',3175,'active',NULL,NULL,NULL),(150627,167,'Tangi','TNG',3175,'active',NULL,NULL,NULL),(150628,167,'Tank','TAN',3175,'active',NULL,NULL,NULL),(150629,167,'Tarbela','TRB',3175,'active',NULL,NULL,NULL),(150630,167,'Tatlay Wali ','TTW',3175,'active',NULL,NULL,NULL),(150631,167,'Taunsa Sharif','TNS',3175,'active',NULL,NULL,NULL),(150632,167,'Taxila','TXL',3175,'active',NULL,NULL,NULL),(150633,167,'Thana','THN',3175,'active',NULL,NULL,NULL),(150634,167,'Thari Mirwah','TMW',3175,'active',NULL,NULL,NULL),(150635,167,'Tharoshah','THS',3175,'active',NULL,NULL,NULL),(150636,167,'Thheri','THR',3175,'active',NULL,NULL,NULL),(150637,167,'Tibba Sultanpur','TSP',3175,'active',NULL,NULL,NULL),(150638,167,'Tibbi Qaisrani','TQS',3175,'active',NULL,NULL,NULL),(150639,167,'Timergara','TMG',3175,'active',NULL,NULL,NULL),(150640,167,'Toba Tek Singh','TTS',3175,'active',NULL,NULL,NULL),(150641,167,'Tootak','TOT',3175,'active',NULL,NULL,NULL),(150642,167,'Topi','TOP',3175,'active',NULL,NULL,NULL),(150643,167,'Tour Dair','TDR',3175,'active',NULL,NULL,NULL),(150644,167,'Uch Sharif','USR',3175,'active',NULL,NULL,NULL),(150645,167,'Uggi','UGG',3175,'active',NULL,NULL,NULL),(150646,167,'Ugoke','UGI',3175,'active',NULL,NULL,NULL),(150647,167,'Umar Zai','UMZ',3175,'active',NULL,NULL,NULL),(150648,167,'Umer Kot','UMK',3175,'active',NULL,NULL,NULL),(150649,167,'Upper Dir','UDR',3175,'active',NULL,NULL,NULL),(150650,167,'Usta Muhammad','UST',3175,'active',NULL,NULL,NULL),(150651,167,'Vehari','VRI',3175,'active',NULL,NULL,NULL),(150652,167,'Wagan','WGN',3175,'active',NULL,NULL,NULL),(150653,167,'Wah Cantt','WAH',3175,'active',NULL,NULL,NULL),(150654,167,'Wahowa','WOW',3175,'active',NULL,NULL,NULL),(150655,167,'Wan Bhachran','WBN',3175,'active',NULL,NULL,NULL),(150656,167,'Wanike Tarar','WKT',3175,'active',NULL,NULL,NULL),(150657,167,'Wapda Colony - Muzaffarabad','MZD',3175,'active',NULL,NULL,NULL),(150658,167,'Warbatun','WBT',3175,'active',NULL,NULL,NULL),(150659,167,'Wazirabad','WZD',3175,'active',NULL,NULL,NULL),(150660,167,'Yazman','YZM',3175,'active',NULL,NULL,NULL),(150661,167,'Zafarwal','ZFL',3175,'active',NULL,NULL,NULL),(150662,167,'Zeedi','ZED',3175,'active',NULL,NULL,NULL),(150663,167,'Zerina Khattan','ZRK',3175,'active',NULL,NULL,NULL);

--
-- Table structure for table `lookup_complain_statuses`
--

CREATE TABLE `lookup_complain_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_complain_statuses`
--

INSERT INTO `lookup_complain_statuses` VALUES (1,'Open'),(2,'Accepted'),(3,'Rejected'),(4,'Closed');

--
-- Table structure for table `lookup_complain_types`
--

CREATE TABLE `lookup_complain_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_complain_types`
--

INSERT INTO `lookup_complain_types` VALUES (1,'Leakage'),(2,'Cleaning');

--
-- Table structure for table `lookup_ledger_types`
--

CREATE TABLE `lookup_ledger_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_ledger_types`
--

INSERT INTO `lookup_ledger_types` VALUES (1,'Income'),(2,'Expense'),(3,'Capital'),(4,'Sales'),(5,'Purchase');

--
-- Table structure for table `lookup_packages`
--

CREATE TABLE `lookup_packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `icon_path` varchar(191) NOT NULL,
  `bg_color` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `short_details` text NOT NULL,
  `amount` double(8,2) NOT NULL,
  `duration` varchar(191) NOT NULL,
  `duration_in` varchar(191) NOT NULL,
  `details` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_packages`
--

INSERT INTO `lookup_packages` VALUES (1,'/subscription-packages/free-package/tea-cup.png','#FFFFFF','Free Package','Trail Deal',0.00,'Month','Month','\n   <div style=\"text-align: center\">\n    • Free Package </br>\n    • 100 Resident Registraion </br>\n    • Form 1 along with partnership witness form </br>\n    • Chat with Resident </br>\n    • Launch Complaints </br>\n    </div>\n    '),(2,'/subscription-packages/basic-package/registration-mark.png','#A020F0','Basic Package','Trail Deal',2999.00,'Month','Monthly','\n    <div style=\"text-align: center\">\n    • Free Package </br>\n    • 200+ Resident Registraion </br>\n    • Form 1 along with partnership witness form </br>\n    • Chat with Resident </br>\n    • Launch Complaints </br>\n    </div>\n    '),(3,'/subscription-packages/gold-package/star.png','#FFA500','Gold Package','Trail Deal',3999.00,'Month','Monthly','\n    <div style=\"text-align: center\">\n        • Basic Package </br>\n        • 200 Residents </br>\n        • Employee Management </br>\n        • Project Management </br>\n    </div>\n    '),(4,'/subscription-packages/super-gold-package/star.png','#008000','Gold Package','Trail Deal',5999.00,'Month','Monthly','\n    <div style=\"text-align: center\">\n        • Premium Package </br>\n        • 200+ Residents </br>\n        • Cashflow Management </br>\n        • Sale and Rent Property </br>\n    </div>\n    ');

--
-- Table structure for table `lookup_payment_modes`
--

CREATE TABLE `lookup_payment_modes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_payment_modes`
--

INSERT INTO `lookup_payment_modes` VALUES (1,'Bank Transfer'),(2,'Card Payment'),(3,'Cash');

--
-- Table structure for table `lookup_payment_types`
--

CREATE TABLE `lookup_payment_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_payment_types`
--

INSERT INTO `lookup_payment_types` VALUES (1,'Once'),(2,'Monthly');

--
-- Table structure for table `lookup_penalty_recuring_types`
--

CREATE TABLE `lookup_penalty_recuring_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_penalty_recuring_types`
--

INSERT INTO `lookup_penalty_recuring_types` VALUES (1,'Per Day'),(2,'Per Month');

--
-- Table structure for table `lookup_penalty_types`
--

CREATE TABLE `lookup_penalty_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_penalty_types`
--

INSERT INTO `lookup_penalty_types` VALUES (1,'Fix'),(2,'Recuring');

--
-- Table structure for table `lookup_residence_statuses`
--

CREATE TABLE `lookup_residence_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_residence_statuses`
--

INSERT INTO `lookup_residence_statuses` VALUES (1,'Owner'),(2,'Tenant'),(3,'Vacant');

--
-- Table structure for table `lookup_residence_types`
--

CREATE TABLE `lookup_residence_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_residence_types`
--

INSERT INTO `lookup_residence_types` VALUES (1,'Residential'),(2,'Commercial');

--
-- Table structure for table `lookup_resident_types`
--

CREATE TABLE `lookup_resident_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_resident_types`
--

INSERT INTO `lookup_resident_types` VALUES (1,'Owner'),(2,'Tenant');

--
-- Table structure for table `lookup_room_qty_types`
--

CREATE TABLE `lookup_room_qty_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_room_qty_types`
--

INSERT INTO `lookup_room_qty_types` VALUES (1,'1'),(2,'2'),(3,'3'),(4,'4'),(5,'5'),(6,'5+');

--
-- Table structure for table `lookup_society_expense_types`
--

CREATE TABLE `lookup_society_expense_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_society_expense_types`
--

INSERT INTO `lookup_society_expense_types` VALUES (1,1,'Salary',1),(2,1,'Photo Copy',1),(3,1,'Equipment Purchase',1);

--
-- Table structure for table `lookup_subscription_payment_modes`
--

CREATE TABLE `lookup_subscription_payment_modes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_subscription_payment_modes`
--

INSERT INTO `lookup_subscription_payment_modes` VALUES (1,'Bank Transfer'),(2,'Card Payment');

--
-- Table structure for table `lookup_towns`
--

CREATE TABLE `lookup_towns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_towns`
--

INSERT INTO `lookup_towns` VALUES (1,'demo Islamabad',167,3169,85475,1,NULL,NULL),(2,'demo Barishal',167,3170,85352,1,NULL,NULL),(3,'demo Gilgit',167,3170,85450,1,NULL,NULL),(4,'demo Skardu',167,3170,85724,1,NULL,NULL),(5,'demo Abbottabad',167,3171,85329,1,NULL,NULL),(6,'demo Akora',167,3171,85333,1,NULL,NULL),(7,'demo Aman Garh',167,3171,85337,1,NULL,NULL),(8,'demo Amirabad',167,3171,85338,1,NULL,NULL),(9,'demo Ashanagro Koto',167,3171,85340,1,NULL,NULL),(10,'demo Baffa',167,3171,85345,1,NULL,NULL),(11,'demo Bannu',167,3171,85351,1,NULL,NULL),(12,'demo Bat Khela',167,3171,85356,1,NULL,NULL),(13,'demo Battagram',167,3171,85357,1,NULL,NULL),(14,'demo Battagram District',167,3171,85358,1,NULL,NULL),(15,'demo Buner District',167,3171,85374,1,NULL,NULL);

--
-- Table structure for table `lookup_user_roles`
--

CREATE TABLE `lookup_user_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_user_roles`
--

INSERT INTO `lookup_user_roles` VALUES (1,'Admin'),(2,'Finance'),(3,'Staff'),(4,'Tenant'),(5,'Owner'),(6,'Shop');

--
-- Table structure for table `lookup_user_types`
--

CREATE TABLE `lookup_user_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_user_types`
--

INSERT INTO `lookup_user_types` VALUES (1,'App Admin'),(2,'Society User');

--
-- Table structure for table `lookup_verification_types`
--

CREATE TABLE `lookup_verification_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_verification_types`
--

INSERT INTO `lookup_verification_types` VALUES (1,'SMS Verification'),(2,'Email Verification');

--
-- Table structure for table `lookup_years`
--

CREATE TABLE `lookup_years` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2025 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lookup_years`
--

INSERT INTO `lookup_years` VALUES (2021,'2021'),(2022,'2022'),(2023,'2023'),(2024,'2024');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (115,'2024_05_02_170901_create_banner_images_table',8),(135,'2014_10_12_000000_create_users_table',9),(136,'2014_10_12_100000_create_password_resets_table',9),(137,'2019_08_19_000000_create_failed_jobs_table',9),(138,'2019_12_14_000001_create_personal_access_tokens_table',9),(139,'2022_03_05_000001_create_faq_sections_table',9),(140,'2022_03_05_000001_create_faqs_table',9),(141,'2022_03_05_000001_create_page_metas_table',9),(142,'2022_03_05_000001_create_pages_table',9),(143,'2022_06_19_104545_create_notifications_table',9),(144,'2022_12_16_121033_create_jobs_table',9),(145,'2023_11_15_135729_create_lookup_cities_table',9),(146,'2024_03_23_051553_create_lookup_verification_types_table',9),(147,'2024_03_23_051804_create_lookup_user_types_table',9),(148,'2024_03_23_052010_create_lookup_packages_table',9),(149,'2024_03_23_052252_create_lookup_payment_modes_table',9),(150,'2024_03_23_052252_create_lookup_subscription_payment_modes_table',9),(151,'2024_03_23_052433_create_lookup_banks_table',9),(152,'2024_03_23_052708_create_lookup_apartment_categories_table',9),(153,'2024_03_23_053231_create_lookup_residence_statuses_table',9),(154,'2024_03_23_053536_create_lookup_residence_types_table',9),(155,'2024_03_23_053737_create_lookup_resident_types_table',9),(156,'2024_03_23_053925_create_lookup_payment_types_table',9),(157,'2024_03_23_054207_create_lookup_penalty_types_table',9),(158,'2024_03_23_054448_create_lookup_complain_types_table',9),(159,'2024_03_23_054644_create_lookup_complain_statuses_table',9),(160,'2024_03_23_054841_create_lookup_ads_types_table',9),(161,'2024_03_23_055140_create_lookup_apartment_payment_statuses_table',9),(162,'2024_03_23_062114_create_societies_signups_table',9),(163,'2024_03_23_063648_create_societies_table',9),(164,'2024_03_23_064220_create_society_subscription_payments_table',9),(165,'2024_03_23_065013_create_society_subscriptions_table',9),(166,'2024_03_23_065325_create_apartments_table',9),(167,'2024_03_23_065909_create_apartment_documents_table',9),(168,'2024_03_23_070244_create_apartment_services_table',9),(169,'2024_03_23_071202_create_service_apartment_table',9),(170,'2024_03_23_071302_create_service_block_table',9),(171,'2024_03_23_071403_create_apartment_payments_table',9),(172,'2024_03_23_072019_create_society_complains_table',9),(173,'2024_03_23_072728_create_society_ads_table',9),(174,'2024_03_23_073239_create_society_ad_medias_table',9),(175,'2024_03_23_073750_create_society_expenses_table',9),(176,'2024_03_23_074143_create_notices_table',9),(177,'2024_03_23_074433_create_notice_medias_table',9),(178,'2024_03_23_084107_create_lookup_society_expense_types_table',9),(179,'2024_03_23_085046_create_lookup_apartment_blocks_table',9),(181,'2024_03_28_092122_create_lookup_user_roles_table',9),(182,'2024_04_14_075109_create_society_complain_medias_table',9),(183,'2024_04_15_081806_create_lookup_room_qty_types_table',9),(184,'2024_04_15_081906_create_lookup_room_qty_types_table',9),(185,'2024_04_15_090056_alter_lookup_apartment_services',9),(186,'2024_04_16_093459_alter_users_add_subscription_id_table',9),(187,'2024_04_24_042736_create_lookup_penalty_recuring_types_table',9),(188,'2024_04_26_080248_create_lookup_years_table',9),(189,'2024_04_26_112211_create_apartment_payment_rpt_by_months_table',9),(190,'2024_04_26_112212_create_apartment_payment_rpt_by_days_table',9),(191,'2024_04_26_112213_create_apartment_payment_rpt_by_years_table',9),(192,'2024_04_26_161001_create_society_complain_chats_table',9),(193,'2024_05_02_170901_create_lookup_banner_images_table',9),(194,'2024_05_06_091015_create_ledgers_table',9),(195,'2024_05_06_092141_create_lookup_ledger_types_table',9),(196,'2024_05_06_093026_create_ledger_entries_table',9),(197,'2024_05_08_063943_create_ledger_rpt_by_days_table',9),(198,'2024_05_08_064201_create_ledger_rpt_by_months_table',9),(199,'2024_05_08_064654_create_ledger_rpt_by_years_table',9),(200,'2023_02_21_110637_create_user_messages_table',10),(201,'2023_02_22_071104_create_user_message_contacts_table',10),(202,'2023_12_14_071602_create_user_message_medias_table',10),(203,'2024_03_26_091430_create_lookup_towns_table',11),(204,'2024_06_03_060214_alter_apartment_table',12),(205,'2024_06_04_061133_alter_apartment_table',13),(206,'2024_06_04_062907_alter_society_ads',14),(207,'2024_06_04_065458_alter_users_table',15),(208,'2024_06_04_072533_alter_society_signup_table',15),(209,'2024_06_04_075549_alter_society_ads_table',16),(210,'2024_06_04_121811_alter_society_complain',17),(211,'2024_06_28_064807_alter_society_complain_chat_table',18),(212,'2024_07_31_082223_alter_users_table',19);

--
-- Table structure for table `notice_medias`
--

CREATE TABLE `notice_medias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notice_id` bigint(20) unsigned NOT NULL,
  `media_path` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notice_medias`
--

INSERT INTO `notice_medias` VALUES (1,1,'notices/wQtC5FJZRVUkop088uD6ySP3yb4WzGnnrmgKafpa.jpg'),(2,5,'notices/FkmVMndSBKBkEBHCH1pCPAl0nwe2I5cGCwyQfRLD.jpg'),(3,6,'notices/LA3tOkHzX3amqu20LxrU46KqPV7QlBnTT7BU5Jcs.jpg'),(4,7,'notices/c43OBd0UJXm0QRsD5tIVi6Xte7MVn6Kc8gNdQsgg.jpg'),(5,8,'notices/Ms4qQyn5JWBvq5zqY7BdsjVN5lUSKBsclUvOIO5Q.jpg'),(6,9,'notices/SvFs0wNFG5TezUV2l5aXTXI3gASc1qhLQJKjQaA7.jpg'),(7,10,'notices/cuetlJylJSFYTs9AMUwJZmqNnmGIYUHNJrpVJxA3.jpg'),(8,11,'notices/H6p8CpQtuOW2AyrvVgp0r2u7YQS5i758eDuGe3KC.jpg'),(9,12,'notices/HSBKv8ci4QFLHVVmVCahiFq2h6zqGVVvIGMk8vRT.jpg'),(10,13,'notices/BKqfUBDlpsHwqSKwyU3wcYBdzYazoArBwf7lTV8o.jpg'),(11,14,'notices/aqaASBj2QBnA5C6C7hBi7Py8PebIp6zw3Jm1cwAD.jpg'),(12,15,'notices/PrLkEaU7JRtL91PzpWn8F6iPZmia0ruvvQ3JhDNh.jpg'),(13,16,'notices/daEuDTE2F8X1PjwjtF4lw9r2wpuD8XEzrldL2jxr.jpg'),(14,17,'notices/iSkPkHRQQboP8xtn2zUg0tQdZLjyNqnOnEgREUsf.jpg'),(15,19,'notices/8w2PQ6U3kMlxH0K4nonImlse1GiMebso0InTfxOZ.jpg'),(16,20,'notices/hC3V8tuPUyr4t8xjcoWR5XNNkoGJIcH6KUwPJrNb.jpg'),(17,21,'notices/WUEhwCWvlyCau4cB2gL2iO5ayv2f6dUquYoOShxl.jpg'),(18,22,'notices/JEe9ILm7WRrf0uyCFSLKvFAMcPYG4I2Uk5d5Md3r.jpg');

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_id` bigint(20) unsigned NOT NULL,
  `subject` varchar(191) NOT NULL,
  `details` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` VALUES (1,3,'KE BILL COMING','KE DUE DATE : 12/3/24',1,'2024-05-17 10:36:08','2024-05-21 07:34:13'),(2,3,'bills','test',1,'2024-05-21 07:35:12','2024-05-21 07:35:12'),(3,5,'water tank','test',1,'2024-05-30 10:11:31','2024-05-30 10:11:31'),(4,1,'Electrice Bill is Ready','All Tenant should pay there maintenance',1,'2024-05-30 10:14:15','2024-05-30 10:14:15'),(5,1,'Electrice Bill is Ready','All Tenant should pay there maintenance',1,'2024-05-30 10:14:31','2024-05-30 10:14:31'),(6,1,'Eid greetings','blah',1,'2024-05-30 10:15:28','2024-05-30 10:15:28'),(7,1,'Electrice Bill is Ready','All Tenant should pay there maintenance',1,'2024-05-30 10:18:10','2024-05-30 10:18:10'),(8,1,'Electrice Bill is Readyyyy','All Tenant should pay there maintenance',1,'2024-05-30 10:18:17','2024-06-03 12:52:10'),(9,1,'Electrice Bill is Ready','All Tenant should pay there maintenance',1,'2024-05-30 10:18:23','2024-05-30 12:02:20'),(10,5,'Eid Greetings','Etc etc',1,'2024-05-30 10:19:05','2024-05-30 10:19:05'),(11,6,'Eid-ul-Azha Wishes','Have a delightful Eid and keep the society neat and clean. Share happiness with your neighbors and keep a friendly environment.',1,'2024-06-04 05:50:18','2024-06-04 05:56:32'),(12,3,'test','test',1,'2024-06-05 07:55:01','2024-06-05 07:55:01'),(13,3,'Water supply','Nsbsjznshdjsjsjsjbdbsbshsbevdvebs BB bsbdbdhshsbbdbdbdvdvdbdhjdjsnbd',1,'2024-06-05 07:57:34','2024-06-05 07:57:34'),(14,7,'test','test',1,'2024-06-05 12:20:36','2024-06-05 12:20:36'),(15,3,'test','test',1,'2024-06-06 11:37:28','2024-06-06 11:37:28'),(16,3,'water supply','shortage',1,'2024-07-01 07:33:08','2024-07-01 07:33:08'),(17,3,'sales','appt for sale',1,'2024-07-01 11:25:56','2024-07-01 11:25:56'),(18,12,'water supply','test',1,'2024-07-31 07:51:16','2024-07-31 07:51:16'),(19,6,'bb','etc',1,'2024-08-23 13:00:55','2024-08-23 13:00:55'),(20,13,'BILLS','BILSSS PENDINGGGGG',1,'2024-08-28 14:08:14','2024-08-28 14:08:14'),(21,14,'Election Meeting','Election for the month 2024 and 2025',1,'2024-08-28 15:36:20','2024-08-28 15:36:20'),(22,15,'bill','utility bill',1,'2024-08-28 15:37:18','2024-08-28 15:37:18');

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL DEFAULT 0,
  `society_id` int(11) NOT NULL DEFAULT 0,
  `message` varchar(191) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES (1,1,1,'KE BILL COMING','\"KE DUE DATE : 12\\/3\\/24\"','2024-05-17 10:36:08','2024-05-17 10:36:08'),(2,1,3,'bills','\"test\"','2024-05-21 07:35:12','2024-05-21 07:35:12'),(3,1,5,'water tank','\"test\"','2024-05-30 10:11:31','2024-05-30 10:11:31'),(4,1,1,'Electrice Bill is Ready','\"All Tenant should pay there maintenance\"','2024-05-30 10:14:15','2024-05-30 10:14:15'),(5,1,1,'Electrice Bill is Ready','\"All Tenant should pay there maintenance\"','2024-05-30 10:14:31','2024-05-30 10:14:31'),(6,1,1,'Eid greetings','\"blah\"','2024-05-30 10:15:28','2024-05-30 10:15:28'),(7,1,1,'Electrice Bill is Ready','\"All Tenant should pay there maintenance\"','2024-05-30 10:18:10','2024-05-30 10:18:10'),(8,1,1,'Electrice Bill is Ready','\"All Tenant should pay there maintenance\"','2024-05-30 10:18:17','2024-05-30 10:18:17'),(9,1,1,'Electrice Bill is Ready','\"All Tenant should pay there maintenance\"','2024-05-30 10:18:23','2024-05-30 10:18:23'),(10,1,5,'Eid Greetings','\"Etc etc\"','2024-05-30 10:19:05','2024-05-30 10:19:05'),(11,1,6,'Eid-ul-Azha Wishes','\"Have a delightful Eid.\"','2024-06-04 05:50:18','2024-06-04 05:50:18'),(12,1,3,'test','\"test\"','2024-06-05 07:55:01','2024-06-05 07:55:01'),(13,1,3,'Water supply','\"Nsbsjznshdjsjsjsjbdbsbshsbevdvebs BB bsbdbdhshsbbdbdbdvdvdbdhjdjsnbd\"','2024-06-05 07:57:34','2024-06-05 07:57:34'),(14,1,7,'test','\"test\"','2024-06-05 12:20:36','2024-06-05 12:20:36'),(15,1,3,'test','\"test\"','2024-06-06 11:37:28','2024-06-06 11:37:28'),(16,1,3,'water supply','\"shortage\"','2024-07-01 07:33:08','2024-07-01 07:33:08'),(17,1,3,'sales','\"appt for sale\"','2024-07-01 11:25:56','2024-07-01 11:25:56'),(18,1,12,'water supply','\"test\"','2024-07-31 07:51:16','2024-07-31 07:51:16'),(19,1,6,'bb','\"etc\"','2024-08-23 13:00:55','2024-08-23 13:00:55'),(20,1,13,'BILLS','\"BILSSS PENDINGGGGG\"','2024-08-28 14:08:14','2024-08-28 14:08:14'),(21,1,14,'Election Meeting','\"Election for the month 2024 and 2025\"','2024-08-28 15:36:20','2024-08-28 15:36:20'),(22,1,15,'bill','\"utility bill\"','2024-08-28 15:37:18','2024-08-28 15:37:18');

--
-- Table structure for table `page_metas`
--

CREATE TABLE `page_metas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `meta_key` varchar(191) DEFAULT NULL,
  `meta_value` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `page_metas`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pages`
--


--
-- Table structure for table `service_apartment`
--

CREATE TABLE `service_apartment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint(20) unsigned NOT NULL,
  `apartment_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_apartment`
--

INSERT INTO `service_apartment` VALUES (1,1,1),(2,2,1),(3,1,2),(4,2,2),(5,3,1),(6,4,1),(7,5,16),(8,6,25),(9,7,25),(10,8,16),(11,9,28),(12,10,27),(13,11,33),(14,12,34);

--
-- Table structure for table `service_block`
--

CREATE TABLE `service_block` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint(20) unsigned NOT NULL,
  `block_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_block`
--

INSERT INTO `service_block` VALUES (1,1,1),(2,2,1),(3,1,2),(4,2,2),(5,3,1),(6,4,1),(7,5,12),(8,6,12),(9,7,17),(10,8,17),(11,9,13),(12,10,14),(13,11,28),(14,12,30);

--
-- Table structure for table `societies`
--

CREATE TABLE `societies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `address_1` varchar(255) NOT NULL,
  `city_id` bigint(20) unsigned NOT NULL,
  `city_id_name` varchar(191) NOT NULL,
  `town_id` bigint(20) unsigned NOT NULL,
  `town_id_name` varchar(191) NOT NULL,
  `cp_full_name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `profile_photo_path` varchar(191) DEFAULT NULL,
  `verification_type_id` bigint(20) unsigned NOT NULL,
  `verification_type_id_name` varchar(191) NOT NULL,
  `is_agree_terms` tinyint(1) NOT NULL,
  `resident_count` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `societies`
--

INSERT INTO `societies` VALUES (1,1,'DHA-Phase 2','Abc-aria',1,'Karachi',1,'Karachi','John ','info@mail.com','123456789','society/1/profile/nYl3BJNtdfUPtPbHkaSFANpfzyN7BbQGoalt1jEF.jpg',1,'Email Verification',1,NULL),(2,3,'Al karam','garden west',85475,'Islamabad',1,'Islamabad_town_1','sarfaraz','sarfaraz_dina@hotmail.con','3341822211','society/4/profile/S8I8N1GhGNhWK19HB9TLQ3ILvbgIZFlFuXfv5qog.jpg',2,'Email Verification',1,NULL),(3,4,'PAK','R370/10 sector 14A',85475,'Islamabad',2,'Islamabad_town_2','Areeba','areebaarshad208@gmail.com','3181118709','society/3/profile/j7XRhLYcsgtuWajFYP78FVmhe2ywZcwjbHpeujvH.jpg',2,'Email Verification',1,NULL),(4,8,'syed','nazimbad',85475,'Islamabad',1,'Islamabad_town_1','sameer','sarfaraz.dina@gmail.com','3341822211','society/12/profile/sGeeyDRk64Ce3xQyIDrvay8VMbZ86wtUAQ6rcFED.jpg',2,'Email Verification',1,NULL),(5,9,'Pakistan','R370',85329,'Abbottabad',5,'demo Abbottabad','areeba','pakistan123@gmail.com','3181118709','society/13/profile/c8Oabyy4CITGCf5NE3lJohhy3lCTqg1dPmgMCwrp.jpg',1,'SMS Verification',1,NULL),(6,12,'Saima Arabian Vill','Gadap Town, Karachi',85475,'Islamabad',1,'demo Islamabad','Areeba Jawed','areeba.jawed@synergates.com','3162850590','society/14/profile/sCDnSbxa5vpgokum0kkUG4DNaGdZNlUFtVo5B2i2.jpg',1,'SMS Verification',1,NULL),(7,20,'New KPK','420',85329,'Abbottabad',5,'demo Abbottabad','Basit','KPK123@gmail.com','3181118709','society/18/profile/9wIufTWWkipTnhNpo315BxRGg4AoaafOnuataSKY.jpg',1,'SMS Verification',1,NULL),(8,21,'Al-Azhar Garden','Scheme 33, Gulzare-E-Hijiri',1,'Andorra la Vella',1,'demo Islamabad','Ali Khan','ali.khan@mail.comm','03331234567','society/19/profile/OAyAsLW72w5cqw0GnYPHwyVP5JcBygyXfHZ042an.jpg',2,'Email Verification',1,NULL),(9,28,'Virani','V-12 KARIMABAD.4 NUMBER',85475,'Islamabad',1,'demo Islamabad','Sohail','sohail.virani@gmail.com','3341822222','society/25/profile/K64xE5V6dvw2N1KWRILk5WVRnAisVJ2qpNlYsiKD.jpg',1,'SMS Verification',1,NULL),(10,31,'Zee','R655',85329,'Abbottabad',5,'demo Abbottabad','zeeshan','zeeshan@gmail.com','3121234567','society/26/profile/XC79dBrcAj2oKOEQ9qNVWLLKKoHyIJGobwwpQe6a.jpg',1,'SMS Verification',1,NULL),(11,32,'rok','schene',85475,'Islamabad',1,'demo Islamabad','affaf','affaf.naeem86@gmail.com','3463546334','society/32/profile/nnTNmBI4IsPQS1eqff8yy5QFdy9NRzy05KGtVi6v.jpg',2,'Email Verification',1,NULL),(12,33,'Saima Arabian','surjani town',85475,'Islamabad',1,'demo Islamabad','03142847091','areebaarshad@gmail.com','3142847091','society/33/profile/Lcbawsr506SIypJ9iJHF5CyqoaV3Q57w35SKw5iH.jpg',1,'SMS Verification',1,NULL),(13,39,'LKT TOWERS12','LKT PLot 89',85475,'Islamabad',1,'demo Islamabad','ALISHAN','alishan.synergates@gmail.com','3312345678','society/13/profile/MNjQuTEheshXh0bsbQbeaZx0sBHiqcUJxfahxwhb.jpg',2,'Email Verification',1,NULL),(14,40,'Grey Noor Towers','Grey Noor Towe, Gulzar-e-Hijri Sector 29 Gulzar E Hijri Scheme 33, Karachi, Karachi City, Sindh',85475,'Islamabad',1,'demo Islamabad','Abdul Basit Qureshi','basitabdul746@gmail.com','3442074966','society/39/profile/7TeJXnQwGoXfuif5BEG6x0wd5yq81Ut0DNb5eX4m.jpg',1,'SMS Verification',1,NULL),(15,41,'Madrass','Scheme#33',85475,'Islamabad',1,'demo Islamabad','affaf naeem','affaf.naeem86@gmail.com','3463546334','society/37/profile/9OoFJmiIB4MJoap36Eyid7w4rMBKKOlYH5KBb9Z3.jpg',1,'SMS Verification',1,NULL);

--
-- Table structure for table `society_ad_medias`
--

CREATE TABLE `society_ad_medias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_ad_id` bigint(20) unsigned NOT NULL,
  `media_path` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_ad_medias`
--

INSERT INTO `society_ad_medias` VALUES (1,1,'society/ads/1/3EJTdqzArhAvDRLTF0QkmrKw8ExrbJWSimCCKLP6.jpg','2024-05-13 06:37:02','2024-05-13 06:37:02'),(2,1,'society/ads/1/TV27yFv557l8s0MdgT0HUphcnCgBg0DjYCJhN47B.jpg','2024-05-13 06:37:02','2024-05-13 06:37:02'),(3,1,'society/ads/1/f4sboJrzwRJ6A0HNH8apI2FsIkO662cybWCrJGsV.jpg','2024-05-13 06:37:02','2024-05-13 06:37:02'),(4,1,'society/ads/1/mxNr8Hcgw9B53f2WjVy8je7hEZlUcq0KhJ8dZ4Mt.jpg','2024-05-13 06:37:02','2024-05-13 06:37:02'),(5,1,'society/ads/1/cTXEQhc1USXvmHksDK2USt0ruoqcVY7gE4iCa3CU.png','2024-05-13 06:37:02','2024-05-13 06:37:02'),(6,2,'society/ads/2/Jpe9JWqPkhC2yYbMfacG9ZuSVSPlqZ6GzzehZX92.jpg','2024-05-13 06:42:29','2024-05-13 06:42:29'),(7,2,'society/ads/2/hrXLpvs0HP1ISiFqusE0OSUSVGhpo0QvzCsPCNbP.jpg','2024-05-13 06:42:29','2024-05-13 06:42:29'),(8,2,'society/ads/2/lFk6MK9qzXJS92SEK6pbEjRGV0g1S0fYUiZr7iOf.jpg','2024-05-13 06:42:29','2024-05-13 06:42:29'),(9,2,'society/ads/2/XRcVkO1OJPgKJ9DgiiVjDcWBQL07bTPIl2ciy0Rp.jpg','2024-05-13 06:42:29','2024-05-13 06:42:29'),(10,2,'society/ads/2/LJYXmTQ9K5xEO8qWRNktz7GejAU1KKU3tLvhvalY.png','2024-05-13 06:42:29','2024-05-13 06:42:29'),(11,1,'society/ads/1/NVwO4yApmDJ2YnX3NNZqCv6K2m3iP7ZrFTgmRn4q.jpg','2024-05-24 12:24:21','2024-05-24 12:24:21'),(12,1,'society/ads/1/FUDPViBxNRTfsq4VZyYjO0OATWdelVlTmY3KfmkF.jpg','2024-05-24 12:24:21','2024-05-24 12:24:21'),(13,1,'society/ads/1/Fue3Nc8PvHy5lSOCQarCi9ISH7Qx458AMGJ0EuHr.jpg','2024-05-24 12:24:21','2024-05-24 12:24:21'),(14,1,'society/ads/1/tDJdxW6wPmop4G4vAJeqgMqqelHudFb0GnD6hwhq.jpg','2024-05-24 12:24:21','2024-05-24 12:24:21'),(15,1,'society/ads/1/ZS7363uGp32x3s6kWOMyfngk8sFxlc8Dl6Lw8Ob0.png','2024-05-24 12:24:21','2024-05-24 12:24:21'),(16,1,'society/ads/1/x4571p9YOGeLYnwiprfGuCeRmamdpA9QW0ae3Mt1.jpg','2024-05-24 12:24:21','2024-05-24 12:24:21'),(17,1,'society/ads/1/wla12z0WlDpI7j6PZesj1LY2zccYBwoHU3d1R0tQ.jpg','2024-05-24 12:51:20','2024-05-24 12:51:20'),(18,1,'society/ads/1/OLYWvHeXn5uf8sUBSmztQf8QvwQZ4peVkawvHl8c.jpg','2024-05-24 12:51:20','2024-05-24 12:51:20'),(19,1,'society/ads/1/6bIyk3kLHtHAZbJjuMfkqydShNBNLIqKZtIsL9Hv.jpg','2024-05-24 12:51:20','2024-05-24 12:51:20'),(20,3,'society/ads/3/lLx1nnpLNZX7CxBscGeDNUZ8PE9nms8wEKaiUL39.jpg','2024-06-04 07:56:07','2024-06-04 07:56:07'),(21,3,'society/ads/3/JghhG8dDQUSvi2ttHEGpF1ndCkL973BbpmCndvdt.jpg','2024-06-04 07:56:07','2024-06-04 07:56:07'),(22,3,'society/ads/3/VTCNhxdcYq2xsaUfMzx8NTtNrPE3yEVGKzPD5cSa.jpg','2024-06-04 07:56:07','2024-06-04 07:56:07'),(23,4,'society/ads/4/jvKUM185cNz9CuwFsQrvGBiXe7JNM67kHlIpK4H5.jpg','2024-06-04 07:58:41','2024-06-04 07:58:41'),(24,4,'society/ads/4/E4ktKDO4eQ9okc7EyOeOK4dDXTtM7CKz7zjskHuv.jpg','2024-06-04 07:58:41','2024-06-04 07:58:41'),(25,4,'society/ads/4/aLnGnR4huwViCJeMERnlhoVJWum1fgVTSw0td0T5.jpg','2024-06-04 07:58:41','2024-06-04 07:58:41'),(26,5,'society/ads/5/09iWNxvYQx8iOXt3HBY4CoxtRbIeFHnicYPN30x8.jpg','2024-06-04 08:00:16','2024-06-04 08:00:16'),(27,6,'society/ads/6/0oDb8yQY8y0ZGTe9AGfKnzF3ddtam2kEKDxkcd0N.jpg','2024-06-04 08:02:14','2024-06-04 08:02:14'),(28,7,'society/ads/7/qesjqC1pzmieZVKROmulUcUlCVvmQAi3BJQNwWKB.jpg','2024-06-04 08:09:43','2024-06-04 08:09:43'),(29,8,'society/ads/8/dYWBYE68Vz7nqEyQWy2sViCC456G9uVrWAzeJaWE.jpg','2024-06-04 08:16:57','2024-06-04 08:16:57'),(30,9,'society/ads/9/lP5fgUE8fOGO8wkAsZE6IIwDx6RJAk6ZT5e5thL2.jpg','2024-06-04 08:17:00','2024-06-04 08:17:00'),(31,4,'society/ads/4/Jni0uu8NCRFTMMXoi7VZzqtlw38WBVuq05jyB1p2.jpg','2024-06-04 09:28:08','2024-06-04 09:28:08'),(32,4,'society/ads/4/ksdkafRntaFbOMkNyTIOorNJ20jVyrUJYb9rCMly.jpg','2024-06-04 09:28:08','2024-06-04 09:28:08'),(33,4,'society/ads/4/qhYEcR3QBEEt2tMR2yZLFQvEaQuu6SlxUOynHtho.jpg','2024-06-04 09:28:08','2024-06-04 09:28:08'),(34,10,'society/ads/10/2S4fjdPtDVAnF0wrDusjRDmoaJx8cwnmCUc0vLVq.jpg','2024-06-04 12:34:41','2024-06-04 12:34:41'),(35,10,'society/ads/10/qQRCFzatEKcsXH7FnPtH25ZE3dlgjvVA2kL3aJHz.jpg','2024-06-04 12:34:41','2024-06-04 12:34:41'),(36,11,'society/ads/11/Vesr9B0YyG4OfwaEnuSjpzucNNa7XTGHu2Nozb2f.jpg','2024-06-05 11:48:58','2024-06-05 11:48:58'),(37,12,'society/ads/12/GNacrj8oCRKhqjSb8WXxxlG82KvANe4r84kmFDyv.jpg','2024-06-05 11:52:23','2024-06-05 11:52:23'),(38,13,'society/ads/13/L71VvKKdiariIgXhHflvZFA74guekJReJNITpknp.jpg','2024-06-05 11:53:51','2024-06-05 11:53:51'),(39,14,'society/ads/14/Bsc65f6uoIKxSVRhgP0Uo6NmKLA7NOz8I0U9NVIH.jpg','2024-06-05 11:54:08','2024-06-05 11:54:08'),(40,15,'society/ads/15/uIHQWU3rv0CbyoO0954Exq0AJs0I8MzgWH9MdG4l.jpg','2024-06-05 11:57:23','2024-06-05 11:57:23'),(41,16,'society/ads/16/pG4T8wzzmvpNkK4LKvxMgyuiw58BHtplK02l2qKq.jpg','2024-06-06 11:53:05','2024-06-06 11:53:05'),(42,17,'society/ads/17/9M36VNZZQrdkDMHm6PFpUabyitPfQABBfQzkRhT0.jpg','2024-07-01 07:51:51','2024-07-01 07:51:51'),(43,17,'society/ads/17/OKOI2nxLlCQ9QHI9pmFMjjhQJMnpLtFhO3vyPi1o.jpg','2024-07-01 07:51:51','2024-07-01 07:51:51'),(44,18,'society/ads/18/mC9sTKuTVasXL7gbRCqYOO5wMLiN6JbYwF8zjXqi.jpg','2024-07-03 08:09:35','2024-07-03 08:09:35'),(45,19,'society/ads/19/EuHItAFuB53OIxhTywG1U9jkXTUeWcUCrEtyvyKS.jpg','2024-07-03 09:33:38','2024-07-03 09:33:38'),(46,19,'society/ads/19/WVl9NauY7f74HolwxCJF0HHA47iaEVNXdoedR50x.jpg','2024-07-03 09:33:38','2024-07-03 09:33:38'),(47,20,'society/ads/20/ADAVrmiOHhuuLiWpxQhHawsp776Gey78m8R8eJdu.png','2024-07-31 11:20:23','2024-07-31 11:20:23'),(48,21,'society/ads/21/Wk6hP6fOFSjkeDb9IAdAsaLCPa1zkmJnEyqrtMuR.jpg','2024-08-28 14:09:58','2024-08-28 14:09:58'),(49,21,'society/ads/21/Xv3PoedDc8r0qL3TZ2ACpsrGVZ2n8MpcOqcZc3gW.jpg','2024-08-28 14:09:58','2024-08-28 14:09:58'),(50,21,'society/ads/21/Xm5CJaGUupKDqMaIWISX4StKfl5lsQwdWWOsq0SV.jpg','2024-08-28 14:09:58','2024-08-28 14:09:58'),(51,21,'society/ads/21/G3rXowgLHXcAtJVDtfdRpgDP526Tp8K9i3B1gsn5.jpg','2024-08-28 14:09:58','2024-08-28 14:09:58'),(52,22,'society/ads/22/h7T99taIyQJ40oqazeVX2No7pdWjIrmWWMHenqNs.jpg','2024-08-28 14:11:58','2024-08-28 14:11:58'),(53,22,'society/ads/22/0i3S8hsShHqxjDnq3Pn9LPnz07Ex27pspVgvO3ub.jpg','2024-08-28 14:11:58','2024-08-28 14:11:58'),(54,22,'society/ads/22/Zs0T5zYsUYi7JiiRz1Jqu74jevCxTgnTdATmEFwv.jpg','2024-08-28 14:11:58','2024-08-28 14:11:58'),(55,22,'society/ads/22/KbhGmPrEMLbuJaHNOotBGRzKYZqrA4a7cR5tXZZm.jpg','2024-08-28 14:11:58','2024-08-28 14:11:58'),(56,23,'society/ads/23/BtIxvJzUcMemJ96f5DOIsRlop3dtW5geG6675dZS.jpg','2024-08-28 15:13:34','2024-08-28 15:13:34'),(57,24,'society/ads/24/ZkGhn1K8rPzNFmnHSqfXkWNEzsiiQTHFl1RsDkla.jpg','2024-08-28 15:27:06','2024-08-28 15:27:06'),(58,24,'society/ads/24/bMcA9LnsRrHwAxymEYWyyUUo2S8ylYzU1KvHHIog.jpg','2024-08-28 15:27:06','2024-08-28 15:27:06'),(59,24,'society/ads/24/no53QZbdULj4Y7vGktGTUYim5PISOHzmeYVorHUv.jpg','2024-08-28 15:27:06','2024-08-28 15:27:06');

--
-- Table structure for table `society_ads`
--

CREATE TABLE `society_ads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `address` tinytext NOT NULL,
  `ad_type_id` int(11) NOT NULL,
  `ad_type_id_name` varchar(191) NOT NULL,
  `demand_amount` bigint(20) NOT NULL DEFAULT 0,
  `contact_person_name` varchar(191) NOT NULL,
  `dail_code` varchar(191) NOT NULL DEFAULT '92',
  `phone_number` varchar(191) NOT NULL,
  `room_qty_type_id` int(11) NOT NULL DEFAULT 0,
  `room_qty_type_id_name` varchar(191) DEFAULT NULL,
  `bathroom_qty_type_id` int(11) NOT NULL DEFAULT 0,
  `bathroom_qty_type_id_name` varchar(191) DEFAULT NULL,
  `property_dimension` varchar(191) NOT NULL,
  `description` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_ads`
--

INSERT INTO `society_ads` VALUES (1,0,2,'A-16, Amina Center',2,'Sale',24000,'ALISHAN','92','+923312678729',6,'5+',6,'5+','1260 sqft sqft sqft','2 Bed room, 1 Hall, 2 bathrooms. well fursished','2024-05-13 06:37:02','2024-05-24 12:51:19'),(2,0,2,'A-16, Amina Center',1,'Rent',24000,'ALISHAN','92','+929233126787',1,'1',1,'1','1260 sqft sqft sqft','2 Bed room, 1 Hall, 2 bathrooms. well fursished','2024-05-13 06:42:29','2024-05-24 12:16:31'),(3,6,13,'Block-E, Saima Arabian Vilas',1,'Rent',50000,'Areeba','92','+920856980852',6,'5+',6,'5+','150 sqft','Good property','2024-06-04 07:56:07','2024-06-04 07:56:07'),(4,6,13,'Block-A',2,'Sale',400000000,'Ayesha','92','+924085236998',6,'5+',6,'5+','2000 sqft sqft','etc etc etc','2024-06-04 07:58:41','2024-06-04 09:28:08'),(5,1,1,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-04 08:00:16','2024-06-04 08:00:16'),(6,1,1,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-04 08:02:14','2024-06-04 08:02:14'),(7,1,1,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-04 08:09:43','2024-06-04 08:09:43'),(8,1,1,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-04 08:16:57','2024-06-04 08:16:57'),(9,1,1,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-04 08:17:00','2024-06-04 08:17:00'),(10,6,14,'Blah Blah',1,'Rent',1000000,'Areeba','92','1234567890',5,'5',3,'3','2000 sqft','stecshaj','2024-06-04 12:34:41','2024-06-04 12:34:41'),(11,3,19,'R370',1,'Rent',35000,'Areeba','92','3181118709',2,'2',2,'2','123 sqft','test','2024-06-05 11:48:58','2024-06-05 11:48:58'),(12,6,14,'Block-H',2,'Sale',90000000,'Fouzia','92','0909090909',5,'5',5,'5','2000 sqft','etc etc etc','2024-06-05 11:52:23','2024-06-05 11:52:23'),(13,6,14,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-05 11:53:51','2024-06-05 11:53:51'),(14,6,14,'Block-10, Karachi',1,'Rent',30,'Hamidullah','92','0233337834',4,'4',3,'3','1200 sqft','New adertisment for rent','2024-06-05 11:54:08','2024-06-05 11:54:08'),(15,6,14,'Block-F, A-210',1,'Rent',45000,'Areeba','92','2342342343',5,'5',6,'5+','1222 sqft','blah blah','2024-06-05 11:57:23','2024-06-05 11:57:23'),(16,3,19,'108373',2,'Sale',300000,'Syed Noor','92','3181118709',5,'5',4,'4','test sqft','test','2024-06-06 11:53:05','2024-06-06 11:53:05'),(17,3,23,'A655',2,'Sale',5000000,'Burhan','92','3353090281',6,'5+',5,'5','400 sqft','test','2024-07-01 07:51:51','2024-07-01 07:51:51'),(18,6,24,'Abcd',2,'Sale',1000000000,'Ashar','92','3162313333',5,'5',5,'5','400 sqft','etc','2024-07-03 08:09:35','2024-07-03 08:09:35'),(19,6,24,'North Karachi',1,'Rent',50000,'AShar','92','3134554334',4,'4',4,'4','4000 sqft','eteccc','2024-07-03 09:33:38','2024-07-03 09:33:38'),(20,12,38,'AB 101',2,'Sale',500000,'hira','92','3616754675',2,'2',1,'1','400sqft sqft','test','2024-07-31 11:20:23','2024-07-31 11:20:23'),(21,13,39,'FLAT 409 C BLOCK',1,'Rent',650000,'LKT','92','3312345678',3,'3',3,'3','1840 sqft','BEST','2024-08-28 14:09:58','2024-08-28 14:09:58'),(22,13,39,'wddsad3242',2,'Sale',32432423423,'LKT','92','3312345678',4,'4',4,'4','1326 sqft','dsadasdsadsad','2024-08-28 14:11:58','2024-08-28 14:11:58'),(23,15,41,'zainab',1,'Rent',25000,'Madrass','92','3463546334',3,'3',2,'2','896 sqft','good family','2024-08-28 15:13:34','2024-08-28 15:13:34'),(24,14,42,'FT Marketing Group, Shop 53. Grey Noor Towe, Gulzar-e-Hijri Sector 29 Gulzar E Hijri Scheme 33, Karachi, Karachi City, Sindh',1,'Rent',40000,'Ansaar Aziz','92','3402062045',4,'4',2,'2','1050 sqft','Best property in own and best rate','2024-08-28 15:27:06','2024-08-28 15:27:06');

--
-- Table structure for table `society_complain_chats`
--

CREATE TABLE `society_complain_chats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `complain_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `user_id_name` varchar(191) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `profile_photo_path` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_complain_chats`
--

INSERT INTO `society_complain_chats` VALUES (1,6,12,'Beeba','fixed','2024-06-27 10:47:56','2024-06-27 10:47:56','society/14/profile/sCDnSbxa5vpgokum0kkUG4DNaGdZNlUFtVo5B2i2.jpg'),(2,6,12,'Beeba','coming','2024-06-27 11:15:04','2024-06-27 11:15:04','society/14/profile/sCDnSbxa5vpgokum0kkUG4DNaGdZNlUFtVo5B2i2.jpg'),(3,5,12,'Beeba','hi','2024-06-27 11:35:35','2024-06-27 11:35:35','society/14/profile/sCDnSbxa5vpgokum0kkUG4DNaGdZNlUFtVo5B2i2.jpg'),(4,6,12,'Beeba','Please Fix it as soon as possible','2024-06-28 07:24:14','2024-06-28 07:24:14','society/14/profile/sCDnSbxa5vpgokum0kkUG4DNaGdZNlUFtVo5B2i2.jpg'),(5,8,4,'PAK','test','2024-07-10 06:59:52','2024-07-10 06:59:52','society/6/profile/OYHDZZrbOnKJc92oXqtvbw7RpzQ4ZxxhV7JVyoLl.jpg'),(6,8,4,'PAK','test','2024-07-10 06:59:52','2024-07-10 06:59:52','society/6/profile/OYHDZZrbOnKJc92oXqtvbw7RpzQ4ZxxhV7JVyoLl.jpg'),(7,8,4,'PAK','test','2024-07-10 07:00:54','2024-07-10 07:00:54','society/6/profile/OYHDZZrbOnKJc92oXqtvbw7RpzQ4ZxxhV7JVyoLl.jpg'),(8,7,4,'PAK','checking','2024-07-10 09:34:17','2024-07-10 09:34:17','society/6/profile/OYHDZZrbOnKJc92oXqtvbw7RpzQ4ZxxhV7JVyoLl.jpg'),(9,7,4,'PAK','testing','2024-07-10 09:36:44','2024-07-10 09:36:44','society/6/profile/OYHDZZrbOnKJc92oXqtvbw7RpzQ4ZxxhV7JVyoLl.jpg');

--
-- Table structure for table `society_complain_medias`
--

CREATE TABLE `society_complain_medias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_complain_id` bigint(20) unsigned NOT NULL,
  `media_path` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_complain_medias`
--

INSERT INTO `society_complain_medias` VALUES (1,1,'society/complains/1.jpg'),(2,1,'society/complains/2.png'),(3,1,'society/complains/3.png'),(4,1,'society/complains/1/X9fTzPLpywnU1YHnwGN1ow15L4RDJCckGGsSDatC.jpg'),(5,1,'society/complains/1/36jAVi9NGTaaCZaz1A2rontpRif0oE3zeKLuHEYw.jpg'),(6,1,'society/complains/1/4Npqj7X909KaXopXDFYRSfKvzcV9kwSQGFNydWcH.jpg'),(7,4,'society/complains/4/U9pWmb5ErvStSgg4T6AMaN8diOuzvGjT8wudM7OJ.jpg'),(8,5,'society/complains/5/n9NBKfterDCr6O2cW3dVUT6Kb2f46B0aYtHDvmGh.jpg'),(9,5,'society/complains/5/Y5LvgNIFAkaSxTTSCnzfN1SJEFPpJpKmnE8sRgDe.jpg'),(10,5,'society/complains/5/iVm6uuk8Ftdv5d7WFaQSTRFV7qvlMUVgHyG2NnR5.jpg'),(11,6,'society/complains/6/6sulIFaTxQTyD3YH0wNWG7oULZTHiPYzq2UMzDG0.jpg'),(12,7,'society/complains/7/fbt6eeGtNP9ZOjir086sYSIQyRUFc5NlNdbe5eoB.jpg'),(13,8,'society/complains/8/OP9qNPwIcgvEAaI8Chv5UOfpEspLwkMwiukQbMEj.jpg'),(14,9,'society/complains/9/NfMerejVSpywhNmTfjdiDp3wosAGcK7Kr9uc3MRX.jpg');

--
-- Table structure for table `society_complains`
--

CREATE TABLE `society_complains` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_id` bigint(20) unsigned NOT NULL,
  `apartment_id` bigint(20) unsigned NOT NULL,
  `apartment_number` varchar(191) NOT NULL,
  `apartment_block_id` bigint(20) unsigned NOT NULL,
  `apartment_block_id_name` varchar(191) NOT NULL,
  `complain_by` varchar(191) NOT NULL,
  `dail_code` varchar(191) NOT NULL DEFAULT '92',
  `contact_number` varchar(191) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `details` text DEFAULT NULL,
  `complain_type_id` bigint(20) unsigned NOT NULL,
  `complain_type_id_name` varchar(191) NOT NULL,
  `complain_status_id` bigint(20) unsigned NOT NULL,
  `complain_status_id_name` varchar(191) NOT NULL,
  `closed_by_user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `closed_by_user_id_name` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_complains`
--

INSERT INTO `society_complains` VALUES (1,1,1,'Scheme-33',1,'Block A',' ALISHAN','92','1234567890','LEAKAGE','LEAKGE HORHI HY BHAII JAN',1,'Leakage',3,'Rejected',0,NULL,'2024-05-13 06:34:57','2024-05-21 07:41:13'),(2,6,16,'A-219',12,'Block A','Almas','92','1234567890','Society Not clean','our block is not clean. dirt and trash everywhere.',2,'Cleaning',4,'Closed',0,NULL,'2024-06-04 11:41:06','2024-06-27 10:36:03'),(3,6,16,'A-219',12,'Block A','Almas','92','1234567890','Leackage','There is some leakage inside the wall, in room no-4',1,'Leakage',1,'Open',0,NULL,'2024-06-04 11:43:21','2024-06-27 11:37:12'),(4,6,16,'A-219',12,'Block A','Almas','92','1234567890','Society Not clean','our block is not clean. dirt and trash everywhere.',2,'Cleaning',3,'Rejected',0,NULL,'2024-06-04 11:43:32','2024-06-04 12:14:51'),(5,6,16,'A-219',12,'Block A','Almas','92','1234567890','Testing Complaints','As Michael Harvey writes, paragraphs are “in essence—a form of punctuation, and like other forms of punctuation they are meant to make written material easy to read.”[1] Effective paragraphs are the fundamental units of academic writing; consequently, the thoughtful, multifaceted arguments that your professors expect depend on them. Without good paragraphs, you simply cannot clearly convey sequential points and their relationships to one another. \n\nMany novice writers tend to make a sharp distinction between content and style, thinking that a paper can be strong in one and weak in the other, but focusing on organization shows how content and style converge in deliberative academic writing. Your professors will view even the most elegant prose as rambling and tedious if there isn’t a careful, coherent argument to give the text meaning. Paragraphs are the “stuff ” of academic writing and, thus, worth our attention here.As Michael Harvey writes, paragraphs are “in essence—a form of punctuation, and like other forms of punctuation they are meant to make written material easy to read.”[1] Effective paragraphs are the fundamental units of academic writing; consequently, the thoughtful, multifaceted arguments that your professors expect depend on them. Without good paragraphs, you simply cannot clearly convey sequential points and their relationships to one another. \n\nMany novice writers tend to make a sharp distinction between content and style, thinking that a paper can be strong in one and weak in the other, but focusing on organization shows how content and style converge in deliberative academic writing. Your professors will view even the most elegant prose as rambling and tedious if there isn’t a careful, coherent argument to give the text meaning. Paragraphs are the “stuff ” of academic writing and, thus, worth our attention here.',1,'Leakage',4,'Closed',0,NULL,'2024-06-04 11:47:55','2024-06-27 11:35:42'),(6,6,16,'A-219',12,'Block A','Fouzia','92','1234567890','Leakage in my home','come fix fast',1,'Leakage',4,'Closed',0,NULL,'2024-06-04 12:29:31','2024-06-27 11:19:23'),(7,3,26,'111',18,'R','Burhan','92','3181118709','Management','test',2,'Cleaning',4,'Closed',0,NULL,'2024-07-01 07:44:14','2024-07-10 09:36:50'),(8,3,26,'111',18,'R','Burhan','92','3181118709','testing','water leakage',1,'Leakage',4,'Closed',0,NULL,'2024-07-01 12:57:17','2024-07-10 09:33:24'),(9,14,34,'903',30,'Block D','Ansaar Aziz','92','3402062045','Garbage in corridors','corridors main bachey bht kachra phenktey hain aur cleaner bhi daily nahin araha',2,'Cleaning',4,'Closed',0,NULL,'2024-08-28 15:30:14','2024-08-28 16:15:06');

--
-- Table structure for table `society_expenses`
--

CREATE TABLE `society_expenses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `details` text NOT NULL,
  `amount` double(8,2) NOT NULL DEFAULT 0.00,
  `expense_type_id` bigint(20) unsigned NOT NULL,
  `expense_type_id_name` varchar(191) NOT NULL,
  `recorded_by_user_id` bigint(20) unsigned NOT NULL,
  `recorded_by_user_id_name` varchar(191) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_expenses`
--


--
-- Table structure for table `society_subscriptions`
--

CREATE TABLE `society_subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `society_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `society_subscriptions`
--


--
-- Table structure for table `user_message_contacts`
--

CREATE TABLE `user_message_contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `owner_user_id` int(11) DEFAULT NULL,
  `contact_user_id` int(11) DEFAULT NULL,
  `total_unread` int(11) NOT NULL DEFAULT 0,
  `last_message_id` int(11) DEFAULT NULL,
  `last_message` text DEFAULT NULL,
  `last_message_time` datetime DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_message_contacts`
--

INSERT INTO `user_message_contacts` VALUES (1,2,1,0,374,'??','2024-08-28 07:34:15',0,'2024-05-21 07:30:44','2024-08-28 07:34:39'),(2,1,2,9,374,'??','2024-08-28 07:34:15',0,'2024-05-21 07:30:44','2024-08-28 07:34:15'),(4,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:31:00','2024-08-28 07:34:39'),(5,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:31:15','2024-08-28 07:34:39'),(8,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:31:22','2024-08-28 07:34:39'),(9,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:31:35','2024-08-28 07:34:39'),(12,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:31:48','2024-08-28 07:34:39'),(13,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:32:34','2024-08-28 07:34:39'),(16,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:33:21','2024-08-28 07:34:39'),(17,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:33:29','2024-08-28 07:34:39'),(20,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:33:55','2024-08-28 07:34:39'),(21,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:33:59','2024-08-28 07:34:39'),(23,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:36:19','2024-08-28 07:34:39'),(25,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:36:26','2024-08-28 07:34:39'),(27,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:36:45','2024-08-28 07:34:39'),(29,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:36:55','2024-08-28 07:34:39'),(31,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:37:10','2024-08-28 07:34:39'),(33,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:39:05','2024-08-28 07:34:39'),(35,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:52:42','2024-08-28 07:34:39'),(37,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:52:45','2024-08-28 07:34:39'),(39,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:53:15','2024-08-28 07:34:39'),(44,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:54:39','2024-08-28 07:34:39'),(45,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:54:58','2024-08-28 07:34:39'),(48,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:55:03','2024-08-28 07:34:39'),(49,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:56:28','2024-08-28 07:34:39'),(52,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 07:56:41','2024-08-28 07:34:39'),(53,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 08:02:03','2024-08-28 07:34:39'),(55,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 08:02:21','2024-08-28 07:34:39'),(57,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 08:02:33','2024-08-28 07:34:39'),(59,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 08:02:41','2024-08-28 07:34:39'),(61,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 08:02:52','2024-08-28 07:34:39'),(65,2,1,0,2,'hi alishan','2024-05-21 07:31:00',0,'2024-05-21 10:58:33','2024-08-28 07:34:39'),(67,6,1,0,61,'HELLO HAMID/ your maintenance is DUE','2024-05-22 07:01:33',0,'2024-05-22 07:01:33','2024-05-22 07:01:33'),(69,7,1,0,90,'hi','2024-05-23 12:25:06',0,'2024-05-23 12:25:06','2024-05-23 12:25:06'),(70,8,8,0,99,'available..?','2024-05-27 12:11:48',0,'2024-05-27 12:11:48','2024-05-27 12:11:48'),(71,9,9,0,108,'test','2024-05-30 10:20:24',0,'2024-05-30 10:20:24','2024-05-30 10:20:24'),(72,12,13,0,199,'hii','2024-06-24 06:59:16',0,'2024-06-04 06:45:24','2024-06-27 10:30:42'),(73,13,12,2,199,'hii','2024-06-24 06:59:16',0,'2024-06-04 06:45:24','2024-06-04 06:45:24'),(74,4,19,0,367,'tester','2024-07-10 06:59:15',0,'2024-06-05 12:09:12','2024-07-10 09:40:57'),(75,19,4,5,367,'tester','2024-07-10 06:59:15',0,'2024-06-05 12:09:12','2024-07-10 06:59:15'),(76,12,12,0,124,'hh','2024-06-13 11:53:49',0,'2024-06-13 11:30:51','2024-06-13 11:30:51'),(77,12,17,0,262,'hii','2024-06-26 11:14:15',0,'2024-06-13 11:37:36','2024-06-26 11:14:21'),(78,17,12,7,262,'hii','2024-06-26 11:14:15',0,'2024-06-13 11:37:36','2024-06-26 11:14:15'),(79,12,15,2,351,'tyy','2024-07-03 12:30:07',0,'2024-06-13 11:46:04','2024-07-03 12:30:07'),(80,15,12,0,351,'tyy','2024-07-03 12:30:07',0,'2024-06-13 11:46:04','2024-07-03 12:30:07'),(81,14,12,0,345,'hi ,m','2024-07-03 07:09:09',0,'2024-06-24 07:25:12','2024-07-05 06:04:12'),(82,12,14,0,345,'hi ,m','2024-07-03 07:09:09',0,'2024-06-24 07:25:12','2024-07-03 07:09:09'),(83,15,14,1,330,'hi almas','2024-06-27 07:38:46',0,'2024-06-27 05:47:04','2024-06-27 07:38:46'),(84,14,15,0,330,'hi almas','2024-06-27 07:38:46',0,'2024-06-27 05:47:04','2024-06-27 07:38:46'),(85,4,22,0,365,'test','2024-07-10 06:55:28',0,'2024-07-01 07:23:09','2024-07-10 09:41:06'),(86,22,4,1,365,'test','2024-07-10 06:55:28',0,'2024-07-01 07:23:09','2024-07-10 06:55:28'),(87,23,19,0,338,'testing','2024-07-01 13:04:42',0,'2024-07-01 13:04:39','2024-07-01 13:04:42'),(88,19,23,1,338,'testing','2024-07-01 13:04:42',0,'2024-07-01 13:04:39','2024-07-01 13:04:42'),(89,12,24,2,347,'miop','2024-07-03 08:00:39',0,'2024-07-03 06:35:36','2024-07-03 08:00:39'),(90,24,12,0,347,'miop','2024-07-03 08:00:39',0,'2024-07-03 06:35:36','2024-07-03 08:01:27'),(91,24,14,1,349,'hello y','2024-07-03 09:36:46',0,'2024-07-03 08:02:30','2024-07-03 09:36:46'),(92,14,24,0,349,'hello y','2024-07-03 09:36:46',0,'2024-07-03 08:02:30','2024-07-03 09:37:07'),(93,15,24,0,353,'ttttt','2024-07-03 12:32:45',0,'2024-07-03 12:31:46','2024-07-03 12:32:45'),(94,24,15,1,353,'ttttt','2024-07-03 12:32:45',0,'2024-07-03 12:31:46','2024-07-03 12:32:45'),(95,25,24,0,354,'hi ashar','2024-07-03 12:42:32',0,'2024-07-03 12:42:32','2024-07-03 12:42:32'),(96,24,25,0,354,'hi ashar','2024-07-03 12:42:32',0,'2024-07-03 12:42:32','2024-07-03 12:42:32'),(97,25,14,0,355,'pop','2024-07-03 12:52:07',0,'2024-07-03 12:52:07','2024-07-03 12:52:07'),(98,14,25,0,355,'pop','2024-07-03 12:52:07',0,'2024-07-03 12:52:07','2024-07-03 12:52:07'),(99,25,12,0,356,'hi Areeba Admin','2024-07-05 06:28:03',0,'2024-07-05 06:28:03','2024-07-05 06:28:03'),(100,12,25,0,356,'hi Areeba Admin','2024-07-05 06:28:03',0,'2024-07-05 06:28:03','2024-07-05 06:28:03'),(101,25,17,0,359,'m','2024-07-05 08:28:42',0,'2024-07-05 08:22:27','2024-07-05 08:28:42'),(102,17,25,1,359,'m','2024-07-05 08:28:42',0,'2024-07-05 08:22:28','2024-07-05 08:28:42'),(103,14,17,0,360,'hii','2024-07-05 08:33:58',0,'2024-07-05 08:33:58','2024-07-05 08:33:58'),(104,17,14,0,360,'hii','2024-07-05 08:33:58',0,'2024-07-05 08:33:58','2024-07-05 08:34:03'),(105,15,17,0,364,'ff','2024-07-05 08:40:26',0,'2024-07-05 08:40:01','2024-07-05 08:40:26'),(106,17,15,4,364,'ff','2024-07-05 08:40:26',0,'2024-07-05 08:40:01','2024-07-05 08:40:26'),(107,4,23,2,371,'kya h','2024-07-10 09:41:20',0,'2024-07-10 06:59:01','2024-07-10 09:41:20'),(108,23,4,0,371,'kya h','2024-07-10 09:41:20',0,'2024-07-10 06:59:01','2024-07-10 09:41:20'),(109,42,40,0,378,'hi','2024-08-28 11:20:46',0,'2024-08-28 11:09:53','2024-08-28 11:20:46'),(110,40,42,4,378,'hi','2024-08-28 11:20:46',0,'2024-08-28 11:09:53','2024-08-28 11:20:46');

--
-- Table structure for table `user_message_medias`
--

CREATE TABLE `user_message_medias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message_id` int(11) NOT NULL,
  `media_type_id` varchar(191) NOT NULL,
  `media_path` varchar(191) NOT NULL,
  `thumb_path` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_message_medias`
--

INSERT INTO `user_message_medias` VALUES (1,69,'1','2/69/test_image_3.jpg','2/69/test_image_3.jpg','2024-05-23 10:44:46','2024-05-23 10:44:46'),(2,70,'1','2/70/test_image_3.jpg','2/70/test_image_3.jpg','2024-05-23 10:45:25','2024-05-23 10:45:25'),(3,71,'1','2/71/test_image_3.jpg','2/71/test_image_3.jpg','2024-05-23 10:46:09','2024-05-23 10:46:09'),(4,72,'1','1/72/test_image_3.jpg','1/72/test_image_3.jpg','2024-05-23 11:34:05','2024-05-23 11:34:05'),(5,77,'1','1/77/test_image_3.jpg','1/77/test_image_3.jpg','2024-05-23 11:55:52','2024-05-23 11:55:52'),(6,85,'1','1/85/test_image_3.jpg','1/85/test_image_3.jpg','2024-05-23 12:11:15','2024-05-23 12:11:15'),(7,89,'1','2/89/image_cropper_A35F8A32-8305-44FF-9EA2-FF6289E1CE0A-45180-0000146C4B06C056.jpg','2/89/image_cropper_A35F8A32-8305-44FF-9EA2-FF6289E1CE0A-45180-0000146C4B06C056.jpg','2024-05-23 12:22:54','2024-05-23 12:22:54'),(8,90,'1','1/90/null','1/90/null','2024-05-23 12:25:06','2024-05-23 12:25:06'),(9,91,'1','1/91/image_cropper_98DD61E4-650F-49E2-915A-B3167D0C43A2-45180-0000149CC9BE0663.jpg','1/91/image_cropper_98DD61E4-650F-49E2-915A-B3167D0C43A2-45180-0000149CC9BE0663.jpg','2024-05-23 12:26:18','2024-05-23 12:26:18'),(10,92,'1','1/92/null','1/92/null','2024-05-23 12:26:26','2024-05-23 12:26:26'),(11,93,'1','1/93/null','1/93/null','2024-05-23 12:27:03','2024-05-23 12:27:03'),(12,95,'1','1/95/image_cropper_97C7C676-9960-4B2E-AAA3-35230B1C1248-45180-000014B23C62C88B.jpg','1/95/image_cropper_97C7C676-9960-4B2E-AAA3-35230B1C1248-45180-000014B23C62C88B.jpg','2024-05-23 12:27:50','2024-05-23 12:27:50'),(13,110,'1','12/110/image_cropper_1717483539769.jpg','12/110/image_cropper_1717483539769.jpg','2024-06-04 06:45:46','2024-06-04 06:45:46'),(14,114,'1','19/114/image_cropper_1717589413412.jpg','19/114/image_cropper_1717589413412.jpg','2024-06-05 12:10:31','2024-06-05 12:10:31'),(15,139,'1','12/139/image_cropper_1718280876870.jpg','12/139/image_cropper_1718280876870.jpg','2024-06-13 12:14:43','2024-06-13 12:14:43'),(16,140,'1','15/140/image_cropper_8B491D16-CCA7-4FDF-86E0-CE6521514D18-27479-0000135C71E50162.jpg','15/140/image_cropper_8B491D16-CCA7-4FDF-86E0-CE6521514D18-27479-0000135C71E50162.jpg','2024-06-13 12:14:54','2024-06-13 12:14:54');

--
-- Table structure for table `user_messages`
--

CREATE TABLE `user_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sender_user_id` int(11) DEFAULT NULL,
  `receiver_user_id` int(11) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `medias` text DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `parent_message_id` int(11) DEFAULT NULL,
  `is_edited` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=379 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_messages`
--

INSERT INTO `user_messages` VALUES (1,2,1,'HELLO ADMIN SHAIB','',0,NULL,0,NULL,'2024-05-21 07:30:44',NULL),(2,1,2,'hi alishan','',0,NULL,0,NULL,'2024-05-21 07:31:00',NULL),(3,2,1,'I need to talk to you are you available? For short message chat?','',0,NULL,0,NULL,'2024-05-21 07:31:15',NULL),(4,1,2,'yes','',0,NULL,0,NULL,'2024-05-21 07:31:22',NULL),(5,2,1,'Why there is delay in your chat socket message?','',0,NULL,0,NULL,'2024-05-21 07:31:35',NULL),(6,1,2,'busy','',0,NULL,0,NULL,'2024-05-21 07:31:48',NULL),(7,2,1,'Once free let me know so I can discuss my query','',0,NULL,0,NULL,'2024-05-21 07:32:34',NULL),(8,1,2,'i am free now','',0,NULL,0,NULL,'2024-05-21 07:33:21',NULL),(9,2,1,'Cool','',0,NULL,0,NULL,'2024-05-21 07:33:29',NULL),(10,1,2,'It means our socket is working perfectly right?','',0,NULL,0,NULL,'2024-05-21 07:33:55',NULL),(11,2,1,'100%','',0,NULL,0,NULL,'2024-05-21 07:33:59',NULL),(12,2,1,'<3','',0,NULL,0,NULL,'2024-05-21 07:36:19',NULL),(13,2,1,'<3 <3 <3','',0,NULL,0,NULL,'2024-05-21 07:36:26',NULL),(14,2,1,'Is there any issue?','',0,NULL,0,NULL,'2024-05-21 07:36:45',NULL),(15,2,1,'No na?','',0,NULL,0,NULL,'2024-05-21 07:36:55',NULL),(16,2,1,'Cool then No Issues Found at my end','',0,NULL,0,NULL,'2024-05-21 07:37:10',NULL),(17,2,1,'Okay BYE','',0,NULL,0,NULL,'2024-05-21 07:39:05',NULL),(18,2,1,'??','',0,NULL,0,NULL,'2024-05-21 07:52:42',NULL),(19,2,1,'??','',0,NULL,0,NULL,'2024-05-21 07:52:45',NULL),(20,2,1,'HELLO MR?','',0,NULL,0,NULL,'2024-05-21 07:53:15',NULL),(21,1,1,'HELLO MR?','',0,NULL,0,NULL,'2024-05-21 07:54:05',NULL),(22,1,1,'HELLO','',0,NULL,0,NULL,'2024-05-21 07:54:24',NULL),(23,1,2,'HELLO MR?','',0,NULL,0,NULL,'2024-05-21 07:54:39',NULL),(24,2,1,'WHAT HAPPNED/','',0,NULL,0,NULL,'2024-05-21 07:54:58',NULL),(25,1,2,'YES?','',0,NULL,0,NULL,'2024-05-21 07:55:03',NULL),(26,2,1,'Nothing , Please do your work don’t disturb','',0,NULL,0,NULL,'2024-05-21 07:56:28',NULL),(27,1,2,'OKAY BYE !','',0,NULL,0,NULL,'2024-05-21 07:56:41',NULL),(28,2,1,'COOL','',0,NULL,0,NULL,'2024-05-21 08:02:03',NULL),(29,2,1,'YES COOL','',0,NULL,0,NULL,'2024-05-21 08:02:21',NULL),(30,2,1,'NICE NA','',0,NULL,0,NULL,'2024-05-21 08:02:33',NULL),(31,2,1,'YES','',0,NULL,0,NULL,'2024-05-21 08:02:41',NULL),(32,2,1,'THANKS','',0,NULL,0,NULL,'2024-05-21 08:02:52',NULL),(33,1,1,'HELLO?','',0,NULL,0,NULL,'2024-05-21 08:49:36',NULL),(34,1,2,'THERE?','',0,NULL,0,NULL,'2024-05-21 10:58:33',NULL),(35,2,NULL,'Hello','',0,NULL,0,NULL,'2024-05-21 11:10:20',NULL),(36,2,NULL,'YES?','',0,NULL,0,NULL,'2024-05-21 12:06:49',NULL),(37,2,1,'??','',0,NULL,0,NULL,'2024-05-21 12:33:11',NULL),(38,2,1,'HELLO?','',0,NULL,0,NULL,'2024-05-21 12:33:20',NULL),(39,1,2,'??','',0,NULL,0,NULL,'2024-05-21 12:45:39',NULL),(40,2,1,'hi from the future','',0,NULL,0,NULL,'2024-05-21 12:47:06',NULL),(41,1,2,'??','',0,NULL,0,NULL,'2024-05-21 12:47:16',NULL),(42,1,2,'Lololo','',0,NULL,0,NULL,'2024-05-21 12:47:21',NULL),(43,1,2,'Popopo','',0,NULL,0,NULL,'2024-05-21 12:47:27',NULL),(44,1,2,'Lal','',0,NULL,0,NULL,'2024-05-21 12:47:33',NULL),(45,2,1,'HELLO? FROM 15 PRO','',0,NULL,0,NULL,'2024-05-21 12:54:25',NULL),(46,1,2,'HELO FROM 15 PRO MAX','',0,NULL,0,NULL,'2024-05-21 12:54:32',NULL),(47,1,2,'??','',0,NULL,0,NULL,'2024-05-21 12:54:46',NULL),(48,2,1,'ACHA JI','',0,NULL,0,NULL,'2024-05-21 12:54:54',NULL),(49,2,1,'HAN JI','',0,NULL,0,NULL,'2024-05-21 12:55:40',NULL),(50,1,2,'Lol','',0,NULL,0,NULL,'2024-05-21 12:55:45',NULL),(51,2,1,'NH KRO YAR','',0,NULL,0,NULL,'2024-05-21 12:55:53',NULL),(52,1,2,'Q NA KRO','',0,NULL,0,NULL,'2024-05-21 12:56:02',NULL),(53,1,2,'CHAT DONE?','',0,NULL,0,NULL,'2024-05-21 12:56:20',NULL),(54,2,1,'YES DONE','',0,NULL,0,NULL,'2024-05-21 12:56:26',NULL),(55,2,1,'PERFEECT','',0,NULL,0,NULL,'2024-05-21 12:56:30',NULL),(56,1,2,'ByE','',0,NULL,0,NULL,'2024-05-21 12:56:56',NULL),(57,2,1,'BYE TC','',0,NULL,0,NULL,'2024-05-21 12:57:00',NULL),(58,1,2,'TC','',0,NULL,0,NULL,'2024-05-21 12:57:31',NULL),(59,2,1,'TC','',0,NULL,0,NULL,'2024-05-21 12:57:43',NULL),(60,1,2,'??','',0,NULL,0,NULL,'2024-05-22 06:44:35',NULL),(61,1,6,'HELLO HAMID/ your maintenance is DUE','',0,NULL,0,NULL,'2024-05-22 07:01:33',NULL),(62,2,1,'a','',0,NULL,0,NULL,'2024-05-23 07:27:17',NULL),(63,2,1,'ml','',0,NULL,0,NULL,'2024-05-23 07:27:50',NULL),(64,2,1,'ml','',0,NULL,0,NULL,'2024-05-23 07:28:16',NULL),(65,2,1,'hi admin from 23','',0,NULL,0,NULL,'2024-05-23 10:40:08',NULL),(66,2,1,'','',0,NULL,0,NULL,'2024-05-23 10:40:17',NULL),(67,1,2,'hi to','',0,NULL,0,NULL,'2024-05-23 10:41:47',NULL),(68,2,1,'hi from','',0,NULL,0,NULL,'2024-05-23 10:43:39',NULL),(69,2,1,'heh','2/69/test_image_3.jpg',0,NULL,0,NULL,'2024-05-23 10:44:46',NULL),(70,2,1,'hi','2/70/test_image_3.jpg',0,NULL,0,NULL,'2024-05-23 10:45:25',NULL),(71,2,1,'','2/71/test_image_3.jpg',0,NULL,0,NULL,'2024-05-23 10:46:09',NULL),(72,1,2,'hi ali','1/72/test_image_3.jpg',0,NULL,0,NULL,'2024-05-23 11:34:05',NULL),(73,1,2,'Mm','',0,NULL,0,NULL,'2024-05-23 11:50:39',NULL),(74,1,2,'Mlml','',0,NULL,0,NULL,'2024-05-23 11:50:52',NULL),(75,1,2,'hi','',0,NULL,0,NULL,'2024-05-23 11:54:27',NULL),(76,1,2,'he','',0,NULL,0,NULL,'2024-05-23 11:54:46',NULL),(77,1,2,'hi','1/77/test_image_3.jpg',0,NULL,0,NULL,'2024-05-23 11:55:52',NULL),(78,1,2,'mm','',0,NULL,0,NULL,'2024-05-23 11:58:14',NULL),(79,1,2,'mma','',0,NULL,0,NULL,'2024-05-23 11:58:28',NULL),(80,1,2,'as','',0,NULL,0,NULL,'2024-05-23 12:04:57',NULL),(81,1,2,'mm','',0,NULL,0,NULL,'2024-05-23 12:06:19',NULL),(82,1,2,'yu','',0,NULL,0,NULL,'2024-05-23 12:06:33',NULL),(83,1,2,'ast','',0,NULL,0,NULL,'2024-05-23 12:06:54',NULL),(84,2,1,'ml','',0,NULL,0,NULL,'2024-05-23 12:08:30',NULL),(85,1,2,'hi','1/85/test_image_3.jpg',0,NULL,0,NULL,'2024-05-23 12:11:15',NULL),(86,2,1,'aaa','',0,NULL,0,NULL,'2024-05-23 12:11:53',NULL),(87,2,1,'mi','',0,NULL,0,NULL,'2024-05-23 12:15:02',NULL),(88,2,1,'ml','',0,NULL,0,NULL,'2024-05-23 12:18:02',NULL),(89,2,1,'media 2','2/89/image_cropper_A35F8A32-8305-44FF-9EA2-FF6289E1CE0A-45180-0000146C4B06C056.jpg',0,NULL,0,NULL,'2024-05-23 12:22:54',NULL),(90,1,7,'hi','1/90/null',0,NULL,0,NULL,'2024-05-23 12:25:06',NULL),(91,1,7,'','1/91/image_cropper_98DD61E4-650F-49E2-915A-B3167D0C43A2-45180-0000149CC9BE0663.jpg',0,NULL,0,NULL,'2024-05-23 12:26:18',NULL),(92,1,7,'mm','1/92/null',0,NULL,0,NULL,'2024-05-23 12:26:26',NULL),(93,1,6,'a','1/93/null',0,NULL,0,NULL,'2024-05-23 12:27:03',NULL),(94,1,6,'s','',0,NULL,0,NULL,'2024-05-23 12:27:29',NULL),(95,1,6,'','1/95/image_cropper_97C7C676-9960-4B2E-AAA3-35230B1C1248-45180-000014B23C62C88B.jpg',0,NULL,0,NULL,'2024-05-23 12:27:50',NULL),(96,1,6,'saa','',0,NULL,0,NULL,'2024-05-23 12:27:56',NULL),(97,1,6,'aaaa','',0,NULL,0,NULL,'2024-05-23 12:29:09',NULL),(98,1,6,'mm','',0,NULL,0,NULL,'2024-05-23 12:30:11',NULL),(99,8,8,'available..?','',0,NULL,0,NULL,'2024-05-27 12:11:48',NULL),(100,8,8,'is that?','',0,NULL,0,NULL,'2024-05-27 12:12:02',NULL),(101,8,8,'house available','',0,NULL,0,NULL,'2024-05-27 12:13:15',NULL),(102,1,2,'hi','',0,NULL,0,NULL,'2024-05-30 06:27:29',NULL),(103,2,1,'hello','',0,NULL,0,NULL,'2024-05-30 06:29:17',NULL),(104,2,1,'hi','',0,NULL,0,NULL,'2024-05-30 06:29:29',NULL),(105,2,1,'hi','',0,NULL,0,NULL,'2024-05-30 06:37:04',NULL),(106,2,1,'mk','',0,NULL,0,NULL,'2024-05-30 07:03:07',NULL),(107,2,1,'l','',0,NULL,0,NULL,'2024-05-30 07:03:13',NULL),(108,9,9,'test','',0,NULL,0,NULL,'2024-05-30 10:20:24',NULL),(109,12,13,'hi ammad.','',0,NULL,0,NULL,'2024-06-04 06:45:24',NULL),(110,12,13,'i hope you\'re doing well. ','12/110/image_cropper_1717483539769.jpg',0,NULL,0,NULL,'2024-06-04 06:45:46',NULL),(111,13,12,'i am good.. how are you','',0,NULL,0,NULL,'2024-06-04 07:51:01',NULL),(112,4,19,'bhghg','',0,NULL,0,NULL,'2024-06-05 12:09:12',NULL),(113,19,4,'cccvcuccu','',0,NULL,0,NULL,'2024-06-05 12:10:02',NULL),(114,19,4,'','19/114/image_cropper_1717589413412.jpg',0,NULL,0,NULL,'2024-06-05 12:10:31',NULL),(115,12,12,'hi','',0,NULL,0,NULL,'2024-06-13 11:30:51',NULL),(116,12,12,'ho','',0,NULL,0,NULL,'2024-06-13 11:32:54',NULL),(117,12,17,'blh','',0,NULL,0,NULL,'2024-06-13 11:37:36',NULL),(118,12,17,'ee','',0,NULL,0,NULL,'2024-06-13 11:37:53',NULL),(119,12,17,'hhh','',0,NULL,0,NULL,'2024-06-13 11:38:04',NULL),(120,12,17,'q','',0,NULL,0,NULL,'2024-06-13 11:38:36',NULL),(121,12,17,'tt','',0,NULL,0,NULL,'2024-06-13 11:39:23',NULL),(122,12,17,'mmmm','',0,NULL,0,NULL,'2024-06-13 11:41:30',NULL),(123,12,15,'hello','',0,NULL,0,NULL,'2024-06-13 11:46:04',NULL),(124,12,12,'hh','',0,NULL,0,NULL,'2024-06-13 11:53:49',NULL),(125,12,13,'h','',0,NULL,0,NULL,'2024-06-13 11:54:04',NULL),(126,12,15,'hhh','',0,NULL,0,NULL,'2024-06-13 11:55:18',NULL),(127,12,15,'fdfd','',0,NULL,0,NULL,'2024-06-13 11:55:39',NULL),(128,1,2,'hi','',0,NULL,0,NULL,'2024-06-13 11:57:42',NULL),(129,1,2,'new','',0,NULL,0,NULL,'2024-06-13 11:57:48',NULL),(130,12,15,'xxx','',0,NULL,0,NULL,'2024-06-13 11:59:19',NULL),(131,12,15,'ttt','',0,NULL,0,NULL,'2024-06-13 11:59:39',NULL),(132,15,12,'mmm','',0,NULL,0,NULL,'2024-06-13 12:11:34',NULL),(133,12,15,'mmmmmm','',0,NULL,0,NULL,'2024-06-13 12:11:51',NULL),(134,15,12,'kkkk','',0,NULL,0,NULL,'2024-06-13 12:12:35',NULL),(135,15,12,'mmm','',0,NULL,0,NULL,'2024-06-13 12:13:46',NULL),(136,15,12,'mm','',0,NULL,0,NULL,'2024-06-13 12:14:20',NULL),(137,12,15,'kiii','',0,NULL,0,NULL,'2024-06-13 12:14:25',NULL),(138,12,15,'pop','',0,NULL,0,NULL,'2024-06-13 12:14:30',NULL),(139,12,15,'','12/139/image_cropper_1718280876870.jpg',0,NULL,0,NULL,'2024-06-13 12:14:43',NULL),(140,15,12,'','15/140/image_cropper_8B491D16-CCA7-4FDF-86E0-CE6521514D18-27479-0000135C71E50162.jpg',0,NULL,0,NULL,'2024-06-13 12:14:54',NULL),(141,15,12,'mmmm','',0,NULL,0,NULL,'2024-06-13 12:22:38',NULL),(142,15,12,'mmmmmmm','',0,NULL,0,NULL,'2024-06-13 12:23:22',NULL),(143,15,12,'mmmmmmmdasda','',0,NULL,0,NULL,'2024-06-13 12:24:39',NULL),(144,15,12,'m','',0,NULL,0,NULL,'2024-06-13 12:24:55',NULL),(145,15,12,'bbb','',0,NULL,0,NULL,'2024-06-13 12:25:26',NULL),(146,15,12,'m','',0,NULL,0,NULL,'2024-06-13 12:26:09',NULL),(147,15,12,'mop','',0,NULL,0,NULL,'2024-06-13 12:26:58',NULL),(148,15,12,'mmmmm','',0,NULL,0,NULL,'2024-06-13 12:27:08',NULL),(149,15,12,'m','',0,NULL,0,NULL,'2024-06-13 12:28:30',NULL),(150,15,12,'m','',0,NULL,0,NULL,'2024-06-13 12:29:00',NULL),(151,15,12,'x','',0,NULL,0,NULL,'2024-06-13 12:32:24',NULL),(152,15,12,'i','',0,NULL,0,NULL,'2024-06-13 12:32:35',NULL),(153,15,12,'u','',0,NULL,0,NULL,'2024-06-13 12:32:45',NULL),(154,15,12,'mm','',0,NULL,0,NULL,'2024-06-13 12:33:53',NULL),(155,15,12,'mmp','',0,NULL,0,NULL,'2024-06-13 12:34:11',NULL),(156,15,12,'mmiiiiii','',0,NULL,0,NULL,'2024-06-13 12:55:53',NULL),(157,15,12,'mmmqq','',0,NULL,0,NULL,'2024-06-13 12:57:34',NULL),(158,15,12,'m','',0,NULL,0,NULL,'2024-06-13 13:03:27',NULL),(159,15,12,'x','',0,NULL,0,NULL,'2024-06-13 13:03:41',NULL),(160,15,12,'pop','',0,NULL,0,NULL,'2024-06-13 13:05:25',NULL),(161,15,12,'pppp','',0,NULL,0,NULL,'2024-06-13 13:05:43',NULL),(162,12,15,'q','',0,NULL,0,NULL,'2024-06-13 13:06:14',NULL),(163,15,12,'mp','',0,NULL,0,NULL,'2024-06-14 07:14:34',NULL),(164,15,12,'pop','',0,NULL,0,NULL,'2024-06-14 07:26:30',NULL),(165,15,12,'sop','',0,NULL,0,NULL,'2024-06-14 07:26:56',NULL),(166,12,15,'ooo','',0,NULL,0,NULL,'2024-06-14 07:29:08',NULL),(167,12,15,'c','',0,NULL,0,NULL,'2024-06-14 07:30:06',NULL),(168,15,12,'mm','',0,NULL,0,NULL,'2024-06-14 07:30:23',NULL),(169,15,12,'hi','',0,NULL,0,NULL,'2024-06-14 07:36:22',NULL),(170,15,12,'er','',0,NULL,0,NULL,'2024-06-14 07:40:29',NULL),(171,15,12,'pppp','',0,NULL,0,NULL,'2024-06-14 07:41:50',NULL),(172,15,12,'pop','',0,NULL,0,NULL,'2024-06-14 07:42:07',NULL),(173,15,12,'yyy','',0,NULL,0,NULL,'2024-06-14 07:42:23',NULL),(174,15,12,'z','',0,NULL,0,NULL,'2024-06-14 07:42:35',NULL),(175,12,15,'ty','',0,NULL,0,NULL,'2024-06-14 07:44:11',NULL),(176,12,15,'ty','',0,NULL,0,NULL,'2024-06-14 07:44:52',NULL),(177,12,15,'qy','',0,NULL,0,NULL,'2024-06-14 07:45:01',NULL),(178,12,15,'tyyy','',0,NULL,0,NULL,'2024-06-14 07:45:21',NULL),(179,12,15,'qyuii','',0,NULL,0,NULL,'2024-06-14 07:45:31',NULL),(180,12,15,'typ','',0,NULL,0,NULL,'2024-06-14 07:47:47',NULL),(181,12,15,'abc','',0,NULL,0,NULL,'2024-06-14 07:48:39',NULL),(182,12,15,'def','',0,NULL,0,NULL,'2024-06-14 07:51:03',NULL),(183,15,12,'ghi','',0,NULL,0,NULL,'2024-06-14 07:51:35',NULL),(184,15,12,'ty','',0,NULL,0,NULL,'2024-06-14 07:59:04',NULL),(185,1,2,'hi from admin','',0,NULL,0,NULL,'2024-06-14 08:03:18',NULL),(186,1,2,'haha','',0,NULL,0,NULL,'2024-06-14 08:04:36',NULL),(187,2,1,'hi','',0,NULL,0,NULL,'2024-06-14 08:08:51',NULL),(188,12,15,'heelloo','',0,NULL,0,NULL,'2024-06-14 09:03:58',NULL),(189,15,12,'hi','',0,NULL,0,NULL,'2024-06-14 09:04:17',NULL),(190,15,12,'r','',0,NULL,0,NULL,'2024-06-14 09:06:05',NULL),(191,15,12,'m','',0,NULL,0,NULL,'2024-06-14 09:06:48',NULL),(192,15,12,'g','',0,NULL,0,NULL,'2024-06-14 09:07:07',NULL),(193,15,12,'q','',0,NULL,0,NULL,'2024-06-14 09:09:43',NULL),(194,15,12,'ast','',0,NULL,0,NULL,'2024-06-14 09:11:19',NULL),(195,15,12,'x','',0,NULL,0,NULL,'2024-06-14 09:12:03',NULL),(196,15,12,'ass','',0,NULL,0,NULL,'2024-06-14 09:12:20',NULL),(197,15,12,'z','',0,NULL,0,NULL,'2024-06-14 09:13:51',NULL),(198,1,2,'hi','',0,NULL,0,NULL,'2024-06-24 06:47:36',NULL),(199,12,13,'hii','',0,NULL,0,NULL,'2024-06-24 06:59:16',NULL),(200,14,12,'hi beeba','',0,NULL,0,NULL,'2024-06-24 07:25:12',NULL),(201,14,12,'hey','',0,NULL,0,NULL,'2024-06-24 12:31:55',NULL),(202,14,12,'g','',0,NULL,0,NULL,'2024-06-24 12:32:19',NULL),(203,12,14,'m','',0,NULL,0,NULL,'2024-06-24 12:32:52',NULL),(204,14,12,'dd','',0,NULL,0,NULL,'2024-06-24 12:33:04',NULL),(205,14,12,'t','',0,NULL,0,NULL,'2024-06-24 12:33:09',NULL),(206,14,12,'e','',0,NULL,0,NULL,'2024-06-24 12:33:30',NULL),(207,14,12,'qqq','',0,NULL,0,NULL,'2024-06-24 12:34:41',NULL),(208,14,12,'t','',0,NULL,0,NULL,'2024-06-24 12:36:30',NULL),(209,12,14,'t','',0,NULL,0,NULL,'2024-06-24 12:36:40',NULL),(210,12,14,'tt','',0,NULL,0,NULL,'2024-06-24 12:36:50',NULL),(211,12,14,'rt','',0,NULL,0,NULL,'2024-06-24 12:40:30',NULL),(212,14,12,'hhh','',0,NULL,0,NULL,'2024-06-24 12:41:40',NULL),(213,12,14,'m','',0,NULL,0,NULL,'2024-06-24 12:42:21',NULL),(214,2,1,'hi','',0,NULL,0,NULL,'2024-06-24 12:45:18',NULL),(215,2,1,'hi','',0,NULL,0,NULL,'2024-06-24 12:45:42',NULL),(216,2,1,'hi','',0,NULL,0,NULL,'2024-06-24 12:45:57',NULL),(217,1,2,'hi ali','',0,NULL,0,NULL,'2024-06-24 12:46:52',NULL),(218,14,12,'you','',0,NULL,0,NULL,'2024-06-24 12:47:18',NULL),(219,2,1,'haha','',0,NULL,0,NULL,'2024-06-24 12:48:17',NULL),(220,2,1,'hehe','',0,NULL,0,NULL,'2024-06-24 12:48:27',NULL),(221,1,2,'hi','',0,NULL,0,NULL,'2024-06-24 12:48:52',NULL),(222,12,14,'p','',0,NULL,0,NULL,'2024-06-24 12:49:34',NULL),(223,12,14,'poppp','',0,NULL,0,NULL,'2024-06-24 12:49:46',NULL),(224,14,12,'ty','',0,NULL,0,NULL,'2024-06-24 12:51:44',NULL),(225,12,14,'mmlmlmltyyy','',0,NULL,0,NULL,'2024-06-24 12:51:59',NULL),(226,14,12,'qwe','',0,NULL,0,NULL,'2024-06-24 12:52:55',NULL),(227,1,2,'hi','',0,NULL,0,NULL,'2024-06-24 12:56:54',NULL),(228,2,1,'hi','',0,NULL,0,NULL,'2024-06-24 12:57:30',NULL),(229,2,1,'hehe','',0,NULL,0,NULL,'2024-06-24 12:57:38',NULL),(230,1,2,'hi','',0,NULL,0,NULL,'2024-06-24 12:57:57',NULL),(231,1,2,'haha','',0,NULL,0,NULL,'2024-06-24 12:58:07',NULL),(232,2,1,'haha','',0,NULL,0,NULL,'2024-06-24 12:58:15',NULL),(233,1,2,'hahaehuhdiu','',0,NULL,0,NULL,'2024-06-24 13:01:08',NULL),(234,2,1,'2132saa','',0,NULL,0,NULL,'2024-06-24 13:01:21',NULL),(235,2,1,'hi','',0,NULL,0,NULL,'2024-06-25 05:50:41',NULL),(236,2,1,'haha','',0,NULL,0,NULL,'2024-06-25 05:52:00',NULL),(237,15,12,'lll','',0,NULL,0,NULL,'2024-06-25 06:43:36',NULL),(238,15,12,'lll','',0,NULL,0,NULL,'2024-06-25 06:44:53',NULL),(239,15,12,'x','',0,NULL,0,NULL,'2024-06-25 06:46:50',NULL),(240,15,12,'o','',0,NULL,0,NULL,'2024-06-25 06:49:49',NULL),(241,12,15,'0i','',0,NULL,0,NULL,'2024-06-25 06:50:48',NULL),(242,12,15,'ty','',0,NULL,0,NULL,'2024-06-25 06:51:07',NULL),(243,12,15,'tttttt','',0,NULL,0,NULL,'2024-06-25 06:53:46',NULL),(244,12,15,'vgh','',0,NULL,0,NULL,'2024-06-25 06:55:36',NULL),(245,12,15,'7j','',0,NULL,0,NULL,'2024-06-25 06:55:38',NULL),(246,12,15,'tttt','',0,NULL,0,NULL,'2024-06-25 07:02:32',NULL),(247,12,15,'pop','',0,NULL,0,NULL,'2024-06-25 07:05:17',NULL),(248,12,15,'x','',0,NULL,0,NULL,'2024-06-25 07:13:02',NULL),(249,12,15,'iop','',0,NULL,0,NULL,'2024-06-25 07:13:08',NULL),(250,12,14,'po','',0,NULL,0,NULL,'2024-06-26 06:44:52',NULL),(251,12,14,'pop','',0,NULL,0,NULL,'2024-06-26 06:45:01',NULL),(252,14,12,'ty','',0,NULL,0,NULL,'2024-06-26 07:14:32',NULL),(253,14,12,'qqq','',0,NULL,0,NULL,'2024-06-26 07:14:58',NULL),(254,12,14,'q','',0,NULL,0,NULL,'2024-06-26 07:15:55',NULL),(255,14,12,'qwer','',0,NULL,0,NULL,'2024-06-26 07:16:45',NULL),(256,12,14,'r','',0,NULL,0,NULL,'2024-06-26 07:17:01',NULL),(257,12,14,'ty','',0,NULL,0,NULL,'2024-06-26 09:02:32',NULL),(258,12,14,'se','',0,NULL,0,NULL,'2024-06-26 10:16:33','2024-06-26 10:16:33'),(259,12,14,'ml','',0,NULL,0,NULL,'2024-06-26 10:56:19','2024-06-26 10:56:19'),(260,12,14,'lisy','',0,NULL,0,NULL,'2024-06-26 11:10:47','2024-06-26 11:10:47'),(261,12,17,'listtt','',0,NULL,0,NULL,'2024-06-26 11:11:35','2024-06-26 11:11:35'),(262,12,17,'hii','',0,NULL,0,NULL,'2024-06-26 11:14:15','2024-06-26 11:14:15'),(263,12,14,'hello fouzia','',0,NULL,0,NULL,'2024-06-26 11:47:25','2024-06-26 11:47:25'),(264,12,14,'ty','',0,NULL,0,NULL,'2024-06-26 11:48:31','2024-06-26 11:48:31'),(265,14,12,'hi areeba','',0,NULL,0,NULL,'2024-06-26 11:49:08','2024-06-26 11:49:08'),(266,12,14,'hi ','',0,NULL,0,NULL,'2024-06-26 11:57:46','2024-06-26 11:57:46'),(267,12,14,'aaa','',0,NULL,0,NULL,'2024-06-26 11:59:22','2024-06-26 11:59:22'),(268,12,14,'eee','',0,NULL,0,NULL,'2024-06-26 11:59:28','2024-06-26 11:59:28'),(269,12,14,'qq','',0,NULL,0,NULL,'2024-06-26 12:00:12','2024-06-26 12:00:12'),(270,12,14,'t','',0,NULL,0,NULL,'2024-06-26 12:02:59','2024-06-26 12:02:59'),(271,12,14,'w','',0,NULL,0,NULL,'2024-06-26 12:03:08','2024-06-26 12:03:08'),(272,12,14,'r','',0,NULL,0,NULL,'2024-06-26 12:03:24','2024-06-26 12:03:24'),(273,12,14,'test','',0,NULL,0,NULL,'2024-06-26 12:06:10','2024-06-26 12:06:10'),(274,12,14,'t','',0,NULL,0,NULL,'2024-06-26 12:12:26','2024-06-26 12:12:26'),(275,12,14,'ttttt','',0,NULL,0,NULL,'2024-06-26 12:12:40','2024-06-26 12:12:40'),(276,12,14,'qw','',0,NULL,0,NULL,'2024-06-26 12:12:46','2024-06-26 12:12:46'),(277,14,12,'tttyyiopp','',0,NULL,0,NULL,'2024-06-26 12:13:04','2024-06-26 12:13:04'),(278,14,12,'tyy','',0,NULL,0,NULL,'2024-06-26 12:23:36','2024-06-26 12:23:36'),(279,15,14,'hi fouzia','',0,NULL,0,NULL,'2024-06-27 05:47:04','2024-06-27 05:47:04'),(280,15,14,'hiiii','',0,NULL,0,NULL,'2024-06-27 06:03:05','2024-06-27 06:03:05'),(281,12,14,'hi','',0,NULL,0,NULL,'2024-06-27 06:09:12','2024-06-27 06:09:12'),(282,12,14,'ttt','',0,NULL,0,NULL,'2024-06-27 06:09:38','2024-06-27 06:09:38'),(283,12,14,'tt','',0,NULL,0,NULL,'2024-06-27 06:10:31','2024-06-27 06:10:31'),(284,12,14,'lll','',0,NULL,0,NULL,'2024-06-27 06:25:01','2024-06-27 06:25:01'),(285,12,14,'ty','',0,NULL,0,NULL,'2024-06-27 06:26:19','2024-06-27 06:26:19'),(286,12,14,'t','',0,NULL,0,NULL,'2024-06-27 06:27:22','2024-06-27 06:27:22'),(287,12,14,'x','',0,NULL,0,NULL,'2024-06-27 06:30:03','2024-06-27 06:30:03'),(288,12,14,'f','',0,NULL,0,NULL,'2024-06-27 06:31:07','2024-06-27 06:31:07'),(289,12,14,'q','',0,NULL,0,NULL,'2024-06-27 06:31:33','2024-06-27 06:31:33'),(290,12,14,'q','',0,NULL,0,NULL,'2024-06-27 06:31:46','2024-06-27 06:31:46'),(291,12,14,'t','',0,NULL,0,NULL,'2024-06-27 06:32:09','2024-06-27 06:32:09'),(292,12,14,'pop','',0,NULL,0,NULL,'2024-06-27 06:32:49','2024-06-27 06:32:49'),(293,12,14,'ee','',0,NULL,0,NULL,'2024-06-27 06:33:53','2024-06-27 06:33:53'),(294,12,14,'oo','',0,NULL,0,NULL,'2024-06-27 06:35:12','2024-06-27 06:35:12'),(295,12,14,'ff','',0,NULL,0,NULL,'2024-06-27 06:36:12','2024-06-27 06:36:12'),(296,12,14,'qq','',0,NULL,0,NULL,'2024-06-27 06:36:44','2024-06-27 06:36:44'),(297,12,14,'zz','',0,NULL,0,NULL,'2024-06-27 06:37:13','2024-06-27 06:37:13'),(298,12,14,'cc','',0,NULL,0,NULL,'2024-06-27 06:38:07','2024-06-27 06:38:07'),(299,14,12,'success','',0,NULL,0,NULL,'2024-06-27 06:38:29','2024-06-27 06:38:29'),(300,14,12,'xxx','',0,NULL,0,NULL,'2024-06-27 06:39:27','2024-06-27 06:39:27'),(301,14,12,'ff','',0,NULL,0,NULL,'2024-06-27 06:40:42','2024-06-27 06:40:42'),(302,12,14,'ppp','',0,NULL,0,NULL,'2024-06-27 06:40:49','2024-06-27 06:40:49'),(303,14,12,'tt','',0,NULL,0,NULL,'2024-06-27 06:40:55','2024-06-27 06:40:55'),(304,12,14,'x','',0,NULL,0,NULL,'2024-06-27 06:42:23','2024-06-27 06:42:23'),(305,12,14,'qqqq','',0,NULL,0,NULL,'2024-06-27 06:45:11','2024-06-27 06:45:11'),(306,12,14,'a','',0,NULL,0,NULL,'2024-06-27 06:46:29','2024-06-27 06:46:29'),(307,12,14,'k','',0,NULL,0,NULL,'2024-06-27 06:47:08','2024-06-27 06:47:08'),(308,12,14,'kl','',0,NULL,0,NULL,'2024-06-27 06:47:17','2024-06-27 06:47:17'),(309,12,14,'qw','',0,NULL,0,NULL,'2024-06-27 06:48:49','2024-06-27 06:48:49'),(310,12,14,'ass','',0,NULL,0,NULL,'2024-06-27 06:50:09','2024-06-27 06:50:09'),(311,12,14,'axxx','',0,NULL,0,NULL,'2024-06-27 06:51:14','2024-06-27 06:51:14'),(312,12,14,'rrr','',0,NULL,0,NULL,'2024-06-27 07:19:53','2024-06-27 07:19:53'),(313,12,14,'ff','',0,NULL,0,NULL,'2024-06-27 07:20:24','2024-06-27 07:20:24'),(314,12,14,'qw','',0,NULL,0,NULL,'2024-06-27 07:20:46','2024-06-27 07:20:46'),(315,12,14,'z','',0,NULL,0,NULL,'2024-06-27 07:21:12','2024-06-27 07:21:12'),(316,12,14,'q','',0,NULL,0,NULL,'2024-06-27 07:22:19','2024-06-27 07:22:19'),(317,12,14,'sdf','',0,NULL,0,NULL,'2024-06-27 07:23:07','2024-06-27 07:23:07'),(318,12,14,'eeee','',0,NULL,0,NULL,'2024-06-27 07:23:49','2024-06-27 07:23:49'),(319,12,14,'assjjj','',0,NULL,0,NULL,'2024-06-27 07:25:07','2024-06-27 07:25:07'),(320,12,14,'asx','',0,NULL,0,NULL,'2024-06-27 07:26:56','2024-06-27 07:26:56'),(321,12,14,'mlmk','',0,NULL,0,NULL,'2024-06-27 07:27:50','2024-06-27 07:27:50'),(322,12,14,'qe','',0,NULL,0,NULL,'2024-06-27 07:28:34','2024-06-27 07:28:34'),(323,12,14,'asdd','',0,NULL,0,NULL,'2024-06-27 07:29:03','2024-06-27 07:29:03'),(324,12,14,'aaaa','',0,NULL,0,NULL,'2024-06-27 07:30:45','2024-06-27 07:30:45'),(325,12,14,'aaaaaqaa','',0,NULL,0,NULL,'2024-06-27 07:30:59','2024-06-27 07:30:59'),(326,12,14,'ij','',0,NULL,0,NULL,'2024-06-27 07:31:52','2024-06-27 07:31:52'),(327,12,14,'adgh','',0,NULL,0,NULL,'2024-06-27 07:32:40','2024-06-27 07:32:40'),(328,14,12,'tuio','',0,NULL,0,NULL,'2024-06-27 07:32:50','2024-06-27 07:32:50'),(329,12,14,'fy','',0,NULL,0,NULL,'2024-06-27 07:38:20','2024-06-27 07:38:20'),(330,14,15,'hi almas','',0,NULL,0,NULL,'2024-06-27 07:38:46','2024-06-27 07:38:46'),(331,14,12,'hey admin','',0,NULL,0,NULL,'2024-06-27 10:34:11','2024-06-27 10:34:11'),(332,4,19,'test','',0,NULL,0,NULL,'2024-07-01 06:52:10','2024-07-01 06:52:10'),(333,4,19,'test','',0,NULL,0,NULL,'2024-07-01 06:52:28','2024-07-01 06:52:28'),(334,4,22,'test','',0,NULL,0,NULL,'2024-07-01 07:23:09','2024-07-01 07:23:09'),(335,4,19,'tedting','',0,NULL,0,NULL,'2024-07-01 11:20:05','2024-07-01 11:20:05'),(336,4,19,'testing ','',0,NULL,0,NULL,'2024-07-01 11:20:10','2024-07-01 11:20:10'),(337,23,19,'hello','',0,NULL,0,NULL,'2024-07-01 13:04:39','2024-07-01 13:04:39'),(338,23,19,'testing','',0,NULL,0,NULL,'2024-07-01 13:04:42','2024-07-01 13:04:42'),(339,12,14,'hi n','',0,NULL,0,NULL,'2024-07-03 06:23:29','2024-07-03 06:23:29'),(340,12,24,'hi ashar','',0,NULL,0,NULL,'2024-07-03 06:35:36','2024-07-03 06:35:36'),(341,12,24,'hhii','',0,NULL,0,NULL,'2024-07-03 07:02:30','2024-07-03 07:02:30'),(342,12,24,'hii','',0,NULL,0,NULL,'2024-07-03 07:02:48','2024-07-03 07:02:48'),(343,12,24,'hi x','',0,NULL,0,NULL,'2024-07-03 07:04:51','2024-07-03 07:04:51'),(344,12,24,'xx','',0,NULL,0,NULL,'2024-07-03 07:07:52','2024-07-03 07:07:52'),(345,12,14,'hi ,m','',0,NULL,0,NULL,'2024-07-03 07:09:09','2024-07-03 07:09:09'),(346,24,12,'hiisse','',0,NULL,0,NULL,'2024-07-03 07:42:49','2024-07-03 07:42:49'),(347,24,12,'miop','',0,NULL,0,NULL,'2024-07-03 08:00:39','2024-07-03 08:00:39'),(348,24,14,'hello x','',0,NULL,0,NULL,'2024-07-03 08:02:30','2024-07-03 08:02:30'),(349,14,24,'hello y','',0,NULL,0,NULL,'2024-07-03 09:36:46','2024-07-03 09:36:46'),(350,15,12,'xxx','',0,NULL,0,NULL,'2024-07-03 12:30:02','2024-07-03 12:30:02'),(351,15,12,'tyy','',0,NULL,0,NULL,'2024-07-03 12:30:07','2024-07-03 12:30:07'),(352,15,24,'xxx','',0,NULL,0,NULL,'2024-07-03 12:31:46','2024-07-03 12:31:46'),(353,15,24,'ttttt','',0,NULL,0,NULL,'2024-07-03 12:32:45','2024-07-03 12:32:45'),(354,25,24,'hi ashar','',0,NULL,0,NULL,'2024-07-03 12:42:32','2024-07-03 12:42:32'),(355,25,14,'pop','',0,NULL,0,NULL,'2024-07-03 12:52:07','2024-07-03 12:52:07'),(356,25,12,'hi Areeba Admin','',0,NULL,0,NULL,'2024-07-05 06:28:03','2024-07-05 06:28:03'),(357,25,17,'hhhhuuuu','',0,NULL,0,NULL,'2024-07-05 08:22:28','2024-07-05 08:22:28'),(358,25,17,'yu','',0,NULL,0,NULL,'2024-07-05 08:23:00','2024-07-05 08:23:00'),(359,25,17,'m','',0,NULL,0,NULL,'2024-07-05 08:28:42','2024-07-05 08:28:42'),(360,14,17,'hii','',0,NULL,0,NULL,'2024-07-05 08:33:58','2024-07-05 08:33:58'),(361,15,17,'xxxx','',0,NULL,0,NULL,'2024-07-05 08:40:01','2024-07-05 08:40:01'),(362,15,17,'yyyy','',0,NULL,0,NULL,'2024-07-05 08:40:21','2024-07-05 08:40:21'),(363,15,17,'dd','',0,NULL,0,NULL,'2024-07-05 08:40:23','2024-07-05 08:40:23'),(364,15,17,'ff','',0,NULL,0,NULL,'2024-07-05 08:40:26','2024-07-05 08:40:26'),(365,4,22,'test','',0,NULL,0,NULL,'2024-07-10 06:55:28','2024-07-10 06:55:28'),(366,4,23,'test','',0,NULL,0,NULL,'2024-07-10 06:59:01','2024-07-10 06:59:01'),(367,4,19,'tester','',0,NULL,0,NULL,'2024-07-10 06:59:15','2024-07-10 06:59:15'),(368,4,23,'qqqq','',0,NULL,0,NULL,'2024-07-10 09:38:52','2024-07-10 09:38:52'),(369,4,23,'uy','',0,NULL,0,NULL,'2024-07-10 09:40:45','2024-07-10 09:40:45'),(370,23,4,',,??','',0,NULL,0,NULL,'2024-07-10 09:41:15','2024-07-10 09:41:15'),(371,23,4,'kya h','',0,NULL,0,NULL,'2024-07-10 09:41:20','2024-07-10 09:41:20'),(372,2,1,'HEllo','',0,NULL,0,NULL,'2024-08-28 07:28:32','2024-08-28 07:28:32'),(373,2,1,'HEllo','',0,NULL,0,NULL,'2024-08-28 07:29:17','2024-08-28 07:29:17'),(374,2,1,'??','',0,NULL,0,NULL,'2024-08-28 07:34:15','2024-08-28 07:34:15'),(375,42,40,'hello admin','',0,NULL,0,NULL,'2024-08-28 11:09:53','2024-08-28 11:09:53'),(376,42,40,'not opening? ','',0,NULL,0,NULL,'2024-08-28 11:10:29','2024-08-28 11:10:29'),(377,42,40,'iuop','',0,NULL,0,NULL,'2024-08-28 11:11:46','2024-08-28 11:11:46'),(378,42,40,'hi','',0,NULL,0,NULL,'2024-08-28 11:20:46','2024-08-28 11:20:46');


