CREATE TABLE `il_ilce_mahalle` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `il` varchar(45) COLLATE utf8_turkish_ci NOT NULL,
 `ilce` varchar(45) COLLATE utf8_turkish_ci NOT NULL,
 `semt_bucak` varchar(45) COLLATE utf8_turkish_ci NOT NULL,
 `mahalle` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
 `pk` varchar(15) COLLATE utf8_turkish_ci NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=73727 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Akıncılar', 'Lurucina', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Alayköy', 'Yerolakko', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Balıkesir', 'Balikitre', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Beyköy', 'Beyköy', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Cihangir', 'Abohor', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Çukurova', 'Kuru Manastır', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Değirmenlik', 'Kitrea', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Demirhan', 'Tirfon', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Dilekkaya', 'Aya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Düzova', 'Eksomedoş', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Erdemli', 'Tremeşe', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Gayretköy', 'Avlona', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Gaziler', 'Piroyi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Gaziköy', 'Afanya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Gökhan', 'Voni', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Gönyeli', 'Gönyeli', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Gürpınar', 'Aymarina', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Hamitköy', 'Mandırez', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Haspolat', 'Mia Milia', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'İkidere', 'Dyo Potami', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Kalavaç', 'Kalavaç', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Kanlıköy', 'Kanlıköy', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Kargı', 'Margo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Kırıkkale', 'Meluşa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Kırklar', 'Kırklar', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Lefkoşa', 'Lefkoşa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Meriç', 'Mora', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Metehan', 'Kermiya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Minareliköy', 'Neohorio', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Türkeli', 'Ayvasıl', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Yeniceköy', 'Yeniceköy', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Yenikent', 'Yenikent', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Yılmazköy', 'Şillura', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefkoşa', 'Yiğitler', 'Arçoz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Akdoğan', 'Lisi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Akova', 'Yipsos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Alaniçi', 'Piperisterona', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Arıdamı', 'Artemi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Aslanköy', 'Angastina', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Atlılar', 'Aloda', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Beyarmudu', 'Pergama', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Baykal', '', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Çamlıca', 'Küfez', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Çanakkale', '', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Çayönü', 'Kalopsida', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Çınarlı', 'Bladan', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Dörtyol', 'Prastyo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Düzce', 'Ahna', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Ergenekon', 'Ayharida', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Gazimağusa', '', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Geçitkale', 'Lefkonuk', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Gönendere', 'Gonedra', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Görneç', 'Görneç', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Güvercinlik', 'Aheridu', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'İncirli', 'Makrasiga', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'İnönü', 'Sinde', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Korkuteli', 'Gaydura', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Köprülü', 'Kukla', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Kurudere', 'Musulida', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Mallıdağ', 'Melunda', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Mormenekşe', 'Limya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Muratağa', 'Marata', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Mutluyaka', 'Stilos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Nergisli', 'Yenağra', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Paşaköy', 'Aşa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Pınarlı', 'Vitsada', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Pile', 'Pile', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Pirhan', 'Pirga', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Sandallar', 'Sandallar', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Serdarlı', 'Çatoz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Sütlüce', 'İpsillat', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Tatlısu', 'Akatu', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Tirmen', 'Tirmen', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Turunçlu', 'Stroncilo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Tuzla', 'Enkomi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Türkmenköy', 'Gondea', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Ulukışla', 'Marotovuno', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Vadili', 'Vatili', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Yamaçköy', 'Aynikola', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Yeniboğaziçi', 'Aysergi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Gazimağusa', 'Yıldırım', 'Milya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Ağırdağ', 'Ağırda', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Akçiçek', 'Sisglibo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Akdeniz', 'Ay. İrini', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Alemdağ', 'Agridaci', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Alsancak', 'Karava', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Arapköy', 'Arapkoy', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Aşağı Dikmen', 'Digomo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Aşağı Taşkent', 'Sihari', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Bahçeli', 'Kalturga', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Beşparmak', 'Trabeza', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Beylerbeyi', 'Balabayıs', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Boğazköy', 'Boğaz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Çamlıbel', 'Mirtu', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Çatalköy', 'Çatalköy', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Dağyolu', 'Fota', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Doğanköy', 'Thermia', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Edremit', 'Trimit', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Esentepe', 'Ay Guruş', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Geçitköy', 'Panagra', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Girne', '', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Göçeri', 'Bilelle', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Güngör', 'Kutsovendi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Hisarköy', 'Gambilli', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Ilgaz', 'Fderiha', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'İncesu', 'Modiyes', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Karaağaç', 'Harca', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Karaman', 'Karmi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Karaoğlanoğlu', 'Ayorgi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Karpaşa', 'Karpasa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Karşıyaka', 'Vasilya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Kayalar', 'Orga', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Kılıçaslan', 'Kördümen', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Koruçam', 'Kormacit', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Kozan', 'Larnaka tis Lapitos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Kömürcü', 'Kömürcü', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Lapta', 'Lapithos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Malatya', 'Balyosofo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Ozanköy', 'Gazafana', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Özhan', 'Asomato', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Pınarbaşı', 'Gırnı', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Sadrazamköy', 'Liveraos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Şirinevler', 'Ayermola', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Tepebaşı', 'Yorgoz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Yeşiltepe', 'Elya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Yukarı Dikmen', 'Digomo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Yukarı Taşkent', 'Vuni', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Girne', 'Zeytinlik', 'Templos, Temroz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Akçay', 'Argaca', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Aşağı Bostancı', 'Aşağı Zodya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Aydınköy', 'Prastyo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Gayretköy', 'Avlona', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Güneşköy', 'Nikita', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Güzelyurt', 'Omorfo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Kalkanlı', 'Gabudi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Mevlevi', 'Cira', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Serhatköy', 'Filya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Şahinler', 'Masari', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Yayla', 'Siryanohori', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Yukarı Bostancı', 'Yukarı Zodya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Yuvacık', 'Hrisilyu', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Güzelyurt', 'Zümrütköy', 'Gadagopya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Adaçay', 'Melanağra', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Ağıllar', 'Mandres', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Altınova', 'Aynakofo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Ardahan', 'Ardana', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Avtepe', 'Ay Simon', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Aygün', 'Ayorgi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Bafra', 'Vogolida', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Balalan', 'Planadinissa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Boltaşlı', 'Litrangomi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Boğaz', 'Boğaz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Boğaziçi', 'Lapatos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Boğaztepe', 'Monarga', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Büyükkonuk', 'Komikebir', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Çayırova', 'Aytotoro', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Derince', 'Vatilakka', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Dipkarpaz', 'Rizokarpaso', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Ergazi', 'Ovgoroz', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Esenköy', 'Cilanemo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Gelincik', 'Litrangomi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'İskele', 'Trikomo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'İskele Bahçeler (Cevizli)', 'Pervolia', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kaleburnu', 'Galinoborni', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kalecik', 'Gastria', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kantara', 'Kantara', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kaplıca', 'Davlos', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kilitkaya', 'Kiridya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kumyalı', 'Kumyalik', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kurtuluş', 'Avgalida', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kuruova', 'Korovya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Kuzucuk', 'Arnayi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Mehmetçik', 'Galatya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Mersinlik', 'Flamudi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Ötüken', 'Spatarigo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Pamuklu', 'Tavro', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Sazlıköy', 'Livadya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Sınırüstü', 'Singrasi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Sipahi', 'Aytrias', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Taşlıca', 'Neta', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Topçuköy', 'Topçuköy', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Turnalar', 'Gerani', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Tuzluca', 'Batrıç', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Yarköy', 'Ayilya', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Yedikonuk', 'Eftagomi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Yeni Erenköy', 'Yalusa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Yeşilköy', 'Ay Andronigo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Zeybekköy', 'Ayestat', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'İskele', 'Ziyamet', 'Ziyamet', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Aplıç', 'Apliki', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Bademliköy', 'Lutro', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Bağlıköy', 'Ambeligu', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Cengizköy', 'Peristeronari', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Çamlıköy', 'Kalo Horyo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Denizli', 'İksero', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Doğancı', 'Elye', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Erenköy', 'Koççina', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Gaziveren', 'Gaziveran', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Gemikonağı', 'İksero', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Günebakan', 'Amadyes', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Kurutepe', 'Kserovuno', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Lefke', 'Lefka', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Madenliköy', 'Ay Yorgi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Ömerli', 'Galini', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Şirinköy', 'Varisa', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Taşköy', 'Petre', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Taşpınar', 'Angolem', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Yedidalga', 'Potamos du Gambo', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Yeşilırmak', 'Limnidi', '0');
INSERT INTO `il_ilce_mahalle` (`il`, `ilce`, `semt_bucak`, `mahalle`, `pk`) VALUES ('Kıbrıs', 'Lefke', 'Yeşilyurt', 'Pendaya', '0');