REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug) VALUES 
('IE', 'Ireland', 'ireland');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781464, 'ie', 'Carlow', 1, 'carlow');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(274631, 781464, 'ie', 'Rathvilly', 1, 'rathvilly'),
(274632, 781464, 'ie', 'An Urnaí', 1, 'an-urnai'),
(274633, 781464, 'ie', 'Myshall', 1, 'myshall'),
(274634, 781464, 'ie', 'Leithghlinn an Droichid', 1, 'leithghlinn-an-droichid'),
(274635, 781464, 'ie', 'Kildavin', 1, 'kildavin'),
(274636, 781464, 'ie', 'Baile Haicéid', 1, 'baile-haiceid'),
(274637, 781464, 'ie', 'Glynn', 1, 'glynn'),
(274638, 781464, 'ie', 'Cluain na nGall', 1, 'cluain-na-ngall'),
(274639, 781464, 'ie', 'An Bhuiríos', 1, 'an-bhuirios'),
(274640, 781464, 'ie', 'Balana', 1, 'balana'),
(274641, 781464, 'ie', 'Carlow Town', 1, 'carlow-town'),
(274642, 781464, 'ie', 'Fenagh', 1, 'fenagh'),
(274643, 781464, 'ie', 'Garryhill', 1, 'garryhill'),
(274644, 781464, 'ie', 'Graiguecullen', 1, 'graiguecullen'),
(274645, 781464, 'ie', 'Magney', 1, 'magney'),
(274646, 781464, 'ie', 'Palatine', 1, 'palatine'),
(274647, 781464, 'ie', 'St. Mullins', 1, 'st-mullins'),
(274648, 781464, 'ie', 'Tullow', 1, 'tullow'),
(274649, 781464, 'ie', 'Muine Bheag', 1, 'muine-bheag');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781465, 'ie', 'Cavan', 1, 'cavan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(274650, 781465, 'ie', 'Achadh an Iúir', 1, 'achadh-an-iuir'),
(274651, 781465, 'ie', 'An Muileann Iarainn', 1, 'an-muileann-iarainn'),
(274652, 781465, 'ie', 'Stradone', 1, 'stradone'),
(274653, 781465, 'ie', 'Shercock', 1, 'shercock'),
(274654, 781465, 'ie', 'An Cnoc Rua', 1, 'an-cnoc-rua'),
(274655, 781465, 'ie', 'An Mullach', 1, 'an-mullach'),
(274656, 781465, 'ie', 'Larah', 1, 'larah'),
(274657, 781465, 'ie', 'Dún An Ri', 1, 'dun-an-ri'),
(274658, 781465, 'ie', 'Cill na Leice', 1, 'cill-na-leice'),
(274659, 781465, 'ie', 'Cill na Seanrátha', 1, 'cill-na-seanratha'),
(274660, 781465, 'ie', 'Crossdoney', 1, 'crossdoney'),
(274661, 781465, 'ie', 'Cloverhill', 1, 'cloverhill'),
(274662, 781465, 'ie', 'An Blaic', 1, 'an-blaic'),
(274663, 781465, 'ie', 'Bellananagh', 1, 'bellananagh'),
(274664, 781465, 'ie', 'Bawnboy', 1, 'bawnboy'),
(274665, 781465, 'ie', 'Baile Shéamais Dhuibh', 1, 'baile-sheamais-dhuibh'),
(274666, 781465, 'ie', 'Ballyhaise', 1, 'ballyhaise'),
(274667, 781465, 'ie', 'Béal Átha Conaill', 1, 'beal-atha-conaill'),
(274668, 781465, 'ie', 'Arvagh', 1, 'arvagh'),
(274669, 781465, 'ie', 'Ardlougher', 1, 'ardlougher'),
(274670, 781465, 'ie', 'Cornafean', 1, 'cornafean'),
(274671, 781465, 'ie', 'Poles', 1, 'poles'),
(274672, 781465, 'ie', 'Ballyheelan', 1, 'ballyheelan'),
(274673, 781465, 'ie', 'Ballymacgovern', 1, 'ballymacgovern'),
(274674, 781465, 'ie', 'Carrickaboy', 1, 'carrickaboy'),
(274675, 781465, 'ie', 'Castlerahan', 1, 'castlerahan'),
(274676, 781465, 'ie', 'Corlough', 1, 'corlough'),
(274677, 781465, 'ie', 'Crosserlough', 1, 'crosserlough'),
(274678, 781465, 'ie', 'Crosskeys', 1, 'crosskeys'),
(274679, 781465, 'ie', 'Finea', 1, 'finea'),
(274680, 781465, 'ie', 'Garadice', 1, 'garadice'),
(274681, 781465, 'ie', 'Gowna', 1, 'gowna'),
(274682, 781465, 'ie', 'Kilcogy', 1, 'kilcogy'),
(274683, 781465, 'ie', 'Loughduff', 1, 'loughduff'),
(274684, 781465, 'ie', 'Mountnugent', 1, 'mountnugent'),
(274685, 781465, 'ie', 'Belturbet', 1, 'belturbet'),
(274686, 781465, 'ie', 'Baileborough', 1, 'baileborough'),
(274687, 781465, 'ie', 'Cootehill', 1, 'cootehill');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781466, 'ie', 'Clare', 1, 'clare');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(274688, 781466, 'ie', 'An Geata Bán', 1, 'an-geata-ban'),
(274689, 781466, 'ie', 'An Tulach', 1, 'an-tulach'),
(274690, 781466, 'ie', 'Tuaim Gréine', 1, 'tuaim-greine'),
(274691, 781466, 'ie', 'Droíchead Abhann Ó gCearnaigh', 1, 'droichead-abhann-o-gcearnaigh'),
(274692, 781466, 'ie', 'An Scairbh', 1, 'an-scairbh'),
(274693, 781466, 'ie', 'Ruan', 1, 'ruan'),
(274694, 781466, 'ie', 'Cuinche', 1, 'cuinche'),
(274695, 781466, 'ie', 'Quilty', 1, 'quilty'),
(274696, 781466, 'ie', 'Droichead Uí Bhriain', 1, 'droichead-ui-bhriain'),
(274697, 781466, 'ie', 'Mullach', 1, 'mullach'),
(274698, 781466, 'ie', 'Moyasta', 1, 'moyasta'),
(274699, 781466, 'ie', 'Baile Uí Bheoláin', 1, 'baile-ui-bheolain'),
(274700, 781466, 'ie', 'Sráid na Cathrach', 1, 'sraid-na-cathrach'),
(274701, 781466, 'ie', 'Lisdoonvarna', 1, 'lisdoonvarna'),
(274702, 781466, 'ie', 'Lios Ceannúir', 1, 'lios-ceannuir'),
(274703, 781466, 'ie', 'An Leacht', 1, 'an-leacht'),
(274704, 781466, 'ie', 'Labasheeda', 1, 'labasheeda'),
(274705, 781466, 'ie', 'Kilmaley', 1, 'kilmaley'),
(274706, 781466, 'ie', 'Cill Dalua', 1, 'cill-dalua'),
(274707, 781466, 'ie', 'Cill an Dísirt', 1, 'cill-an-disirt'),
(274708, 781466, 'ie', 'Cill Chisín', 1, 'cill-chisin'),
(274709, 781466, 'ie', 'Cill Chaoi', 1, 'cill-chaoi'),
(274710, 781466, 'ie', 'Cill Fhionnúrach', 1, 'cill-fhionnurach'),
(274711, 781466, 'ie', 'Cill Bheathach', 1, 'cill-bheathach'),
(274712, 781466, 'ie', 'Inagh', 1, 'inagh'),
(274713, 781466, 'ie', 'Flagmount', 1, 'flagmount'),
(274714, 781466, 'ie', 'An Fhiacail', 1, 'an-fhiacail'),
(274715, 781466, 'ie', 'Fanore', 1, 'fanore'),
(274716, 781466, 'ie', 'Inis Díomáin', 1, 'inis-diomain'),
(274717, 781466, 'ie', 'Doonbeg', 1, 'doonbeg'),
(274718, 781466, 'ie', 'Doolin', 1, 'doolin'),
(274719, 781466, 'ie', 'Crusheen', 1, 'crusheen'),
(274720, 781466, 'ie', 'Creegh', 1, 'creegh'),
(274721, 781466, 'ie', 'Cratloe', 1, 'cratloe'),
(274722, 781466, 'ie', 'Cora Finne', 1, 'cora-finne'),
(274723, 781466, 'ie', 'Connolly', 1, 'connolly'),
(274724, 781466, 'ie', 'Droíchead an Chláir', 1, 'droichead-an-chlair'),
(274725, 781466, 'ie', 'Carraig an Chabhaltaigh', 1, 'carraig-an-chabhaltaigh'),
(274726, 781466, 'ie', 'Bunratty', 1, 'bunratty'),
(274727, 781466, 'ie', 'Áth Leathen', 1, 'ath-leathen'),
(274728, 781466, 'ie', 'Bodyke', 1, 'bodyke'),
(274729, 781466, 'ie', 'Baile Uí Bheacháin', 1, 'baile-ui-bheachain'),
(274730, 781466, 'ie', 'Ballynacally', 1, 'ballynacally'),
(274731, 781466, 'ie', 'Kilshanny', 1, 'kilshanny'),
(274732, 781466, 'ie', 'Ardnacrusha', 1, 'ardnacrusha'),
(274733, 781466, 'ie', 'Ballina', 1, 'ballina'),
(274734, 781466, 'ie', 'Ballybeg', 1, 'ballybeg'),
(274735, 781466, 'ie', 'Barefield', 1, 'barefield'),
(274736, 781466, 'ie', 'Bellharbour', 1, 'bellharbour'),
(274737, 781466, 'ie', 'Clonlara', 1, 'clonlara'),
(274738, 781466, 'ie', 'Clooney', 1, 'clooney'),
(274739, 781466, 'ie', 'Cranny', 1, 'cranny'),
(274740, 781466, 'ie', 'Islands', 1, 'islands'),
(274741, 781466, 'ie', 'Killmihil', 1, 'killmihil'),
(274742, 781466, 'ie', 'Lissycasey', 1, 'lissycasey'),
(274743, 781466, 'ie', 'Loop Head', 1, 'loop-head'),
(274744, 781466, 'ie', 'Meelick', 1, 'meelick'),
(274745, 781466, 'ie', 'Newquay', 1, 'newquay'),
(274746, 781466, 'ie', 'Ogonelloe', 1, 'ogonelloe'),
(274747, 781466, 'ie', 'Parteen', 1, 'parteen'),
(274748, 781466, 'ie', 'Tarbert', 1, 'tarbert'),
(274749, 781466, 'ie', 'The Burren', 1, 'the-burren'),
(274750, 781466, 'ie', 'Tubber', 1, 'tubber'),
(274751, 781466, 'ie', 'Newmarket on Fergus', 1, 'newmarket-on-fergus'),
(274752, 781466, 'ie', 'Kilrush', 1, 'kilrush'),
(274753, 781466, 'ie', 'Shannon ', 1, 'shannon'),
(274754, 781466, 'ie', 'Ennis', 1, 'ennis');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781467, 'ie', 'Cork', 1, 'cork');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(274755, 781467, 'ie', 'An Geata Bán', 1, 'an-geata-ban'),
(274756, 781467, 'ie', 'Whitechurch', 1, 'whitechurch'),
(274757, 781467, 'ie', 'Cnocán na Biolraí', 1, 'cnocan-na-biolrai'),
(274758, 781467, 'ie', 'Waterfall', 1, 'waterfall'),
(274759, 781467, 'ie', 'Togher', 1, 'togher'),
(274760, 781467, 'ie', 'Timoleague', 1, 'timoleague'),
(274761, 781467, 'ie', 'An Seanbhaile Mór', 1, 'an-seanbhaile-mor'),
(274762, 781467, 'ie', 'Shanagarry', 1, 'shanagarry'),
(274763, 781467, 'ie', 'Rylane Cross', 1, 'rylane-cross'),
(274764, 781467, 'ie', 'Rostellan', 1, 'rostellan'),
(274765, 781467, 'ie', 'Riverstown', 1, 'riverstown'),
(274766, 781467, 'ie', 'Riverstick', 1, 'riverstick'),
(274767, 781467, 'ie', 'Rinn an Scidígh', 1, 'rinn-an-scidigh'),
(274768, 781467, 'ie', 'Rathduff', 1, 'rathduff'),
(274769, 781467, 'ie', 'Rathcormack', 1, 'rathcormack'),
(274770, 781467, 'ie', 'Ovens', 1, 'ovens'),
(274771, 781467, 'ie', 'Baile Nua Sheandroma', 1, 'baile-nua-sheandroma'),
(274772, 781467, 'ie', 'Áth Trasna', 1, 'ath-trasna'),
(274773, 781467, 'ie', 'Monkstown', 1, 'monkstown'),
(274774, 781467, 'ie', 'Sráid an Mhuilinn', 1, 'sraid-an-mhuilinn'),
(274775, 781467, 'ie', 'Lyre', 1, 'lyre'),
(274776, 781467, 'ie', 'Lislevane', 1, 'lislevane'),
(274777, 781467, 'ie', 'Leap', 1, 'leap'),
(274778, 781467, 'ie', 'Droichead na Scuab', 1, 'droichead-na-scuab'),
(274779, 781467, 'ie', 'Cill Uird', 1, 'cill-uird'),
(274780, 781467, 'ie', 'Killeagh', 1, 'killeagh'),
(274781, 781467, 'ie', 'Cill Dairbhre', 1, 'cill-dairbhre'),
(274782, 781467, 'ie', 'Kilcully', 1, 'kilcully'),
(274783, 781467, 'ie', 'Kilcrohane', 1, 'kilcrohane'),
(274784, 781467, 'ie', 'Cill Briotáin', 1, 'cill-briotain'),
(274785, 781467, 'ie', 'Inis Eonáin', 1, 'inis-eonain'),
(274786, 781467, 'ie', 'Grenagh', 1, 'grenagh'),
(274787, 781467, 'ie', 'Goleen', 1, 'goleen'),
(274788, 781467, 'ie', 'Gleann an Phréacháin', 1, 'gleann-an-phreachain'),
(274789, 781467, 'ie', 'An Gleann Garbh', 1, 'an-gleann-garbh'),
(274790, 781467, 'ie', 'Glenbrook', 1, 'glenbrook'),
(274791, 781467, 'ie', 'Glanworth', 1, 'glanworth'),
(274792, 781467, 'ie', 'Gleann Maghair', 1, 'gleann-maghair'),
(274793, 781467, 'ie', 'Cúan Dor', 1, 'cuan-dor'),
(274794, 781467, 'ie', 'Garryvoe', 1, 'garryvoe'),
(274795, 781467, 'ie', 'Cillín an Chrónáin', 1, 'cillin-an-chronain'),
(274796, 781467, 'ie', 'Farnanes Cross Roads', 1, 'farnanes-cross-roads'),
(274797, 781467, 'ie', 'Na hAoraí', 1, 'na-haorai'),
(274798, 781467, 'ie', 'Durrus', 1, 'durrus'),
(274799, 781467, 'ie', 'Dunderrow', 1, 'dunderrow'),
(274800, 781467, 'ie', 'Dripsey', 1, 'dripsey'),
(274801, 781467, 'ie', 'Drinagh', 1, 'drinagh'),
(274802, 781467, 'ie', 'Drom dhá Liag', 1, 'drom-dha-liag'),
(274803, 781467, 'ie', 'Douglas', 1, 'douglas'),
(274804, 781467, 'ie', 'Dún ar Aill', 1, 'dun-ar-aill'),
(274805, 781467, 'ie', 'Curraheen', 1, 'curraheen'),
(274806, 781467, 'ie', 'Bun an Tábhairne', 1, 'bun-an-tabhairne'),
(274807, 781467, 'ie', 'Crookstown', 1, 'crookstown'),
(274808, 781467, 'ie', 'An Cruachán', 1, 'an-cruachan'),
(274809, 781467, 'ie', 'Cúirt Mhic Shéafraidh', 1, 'cuirt-mhic-sheafraidh'),
(274810, 781467, 'ie', 'Conna', 1, 'conna'),
(274811, 781467, 'ie', 'Áth an Chóiste', 1, 'ath-an-choiste'),
(274812, 781467, 'ie', 'Cluain', 1, 'cluain'),
(274813, 781467, 'ie', 'Baile an Chaisleáin', 1, 'baile-an-chaisleain'),
(274814, 781467, 'ie', 'Baile Chaisleáin an Róistigh', 1, 'baile-chaisleain-an-roistigh'),
(274815, 781467, 'ie', 'Baile Chaisleáin Bhéarra', 1, 'baile-chaisleain-bhearra'),
(274816, 781467, 'ie', 'Castlemartyr', 1, 'castlemartyr'),
(274817, 781467, 'ie', 'Caisleán Ó Liatháin', 1, 'caislean-o-liathain'),
(274818, 781467, 'ie', 'Carraig Thuathail', 1, 'carraig-thuathail'),
(274819, 781467, 'ie', 'Carrignavar', 1, 'carrignavar'),
(274820, 781467, 'ie', 'Buttevant', 1, 'buttevant'),
(274821, 781467, 'ie', 'Blackrock', 1, 'blackrock'),
(274822, 781467, 'ie', 'Belgooly', 1, 'belgooly'),
(274823, 781467, 'ie', 'Banteer', 1, 'banteer'),
(274824, 781467, 'ie', 'Dún na Séad', 1, 'dun-na-sead'),
(274825, 781467, 'ie', 'Baile Bhuirne', 1, 'baile-bhuirne'),
(274826, 781467, 'ie', 'Ballygarvan', 1, 'ballygarvan'),
(274827, 781467, 'ie', 'Ballydehob', 1, 'ballydehob'),
(274828, 781467, 'ie', 'Baile Choitín', 1, 'baile-choitin'),
(274829, 781467, 'ie', 'Ballintemple', 1, 'ballintemple'),
(274830, 781467, 'ie', 'Béal Átha an Spidéil', 1, 'beal-atha-an-spideil'),
(274831, 781467, 'ie', 'Ballinhassig', 1, 'ballinhassig'),
(274832, 781467, 'ie', 'Béal Átha Fhínín', 1, 'beal-atha-fhinin'),
(274833, 781467, 'ie', 'Ballincollig', 1, 'ballincollig'),
(274834, 781467, 'ie', 'Ballinadee', 1, 'ballinadee'),
(274835, 781467, 'ie', 'Ardgroom', 1, 'ardgroom'),
(274836, 781467, 'ie', 'Na hAilichí', 1, 'na-hailichi'),
(274837, 781467, 'ie', 'Aherla', 1, 'aherla'),
(274838, 781467, 'ie', 'Ahakista', 1, 'ahakista'),
(274839, 781467, 'ie', 'Aghada', 1, 'aghada'),
(274840, 781467, 'ie', 'Eadargóil', 1, 'eadargoil'),
(274841, 781467, 'ie', 'Oysterhaven', 1, 'oysterhaven'),
(274842, 781467, 'ie', 'Berrings', 1, 'berrings'),
(274843, 781467, 'ie', 'Cloghroe', 1, 'cloghroe'),
(274844, 781467, 'ie', 'Castlemagner', 1, 'castlemagner'),
(274845, 781467, 'ie', 'Brinny', 1, 'brinny'),
(274846, 781467, 'ie', 'Templemartin', 1, 'templemartin'),
(274847, 781467, 'ie', 'Clogheen', 1, 'clogheen'),
(274848, 781467, 'ie', 'Dublin Pike', 1, 'dublin-pike'),
(274849, 781467, 'ie', 'Glounthaune', 1, 'glounthaune'),
(274850, 781467, 'ie', 'Rochestown', 1, 'rochestown'),
(274851, 781467, 'ie', 'Leamlara', 1, 'leamlara'),
(274852, 781467, 'ie', 'Farran', 1, 'farran'),
(274853, 781467, 'ie', 'Grange', 1, 'grange'),
(274854, 781467, 'ie', 'Ballinlough', 1, 'ballinlough'),
(274855, 781467, 'ie', 'Ballinure', 1, 'ballinure'),
(274856, 781467, 'ie', 'Ballyphehane', 1, 'ballyphehane'),
(274857, 781467, 'ie', 'Ballyvolane', 1, 'ballyvolane'),
(274858, 781467, 'ie', 'Barley Cove', 1, 'barley-cove'),
(274859, 781467, 'ie', 'Barnavara', 1, 'barnavara'),
(274860, 781467, 'ie', 'Beara', 1, 'beara'),
(274861, 781467, 'ie', 'Bere Island', 1, 'bere-island'),
(274862, 781467, 'ie', 'Bishopstown', 1, 'bishopstown'),
(274863, 781467, 'ie', 'Blackpool', 1, 'blackpool'),
(274864, 781467, 'ie', 'Boherbue', 1, 'boherbue'),
(274865, 781467, 'ie', 'Bweeng', 1, 'bweeng'),
(274866, 781467, 'ie', 'Carrigrohane', 1, 'carrigrohane'),
(274867, 781467, 'ie', 'City Centre Nth', 1, 'city-centre-nth'),
(274868, 781467, 'ie', 'City Centre Sth', 1, 'city-centre-sth'),
(274869, 781467, 'ie', 'Cork Airport', 1, 'cork-airport'),
(274870, 781467, 'ie', 'Cork City', 1, 'cork-city'),
(274871, 781467, 'ie', 'Cork North', 1, 'cork-north'),
(274872, 781467, 'ie', 'Cork West', 1, 'cork-west'),
(274873, 781467, 'ie', 'Crossbarry', 1, 'crossbarry'),
(274874, 781467, 'ie', 'Donnybrook', 1, 'donnybrook'),
(274875, 781467, 'ie', 'Dublin Hill', 1, 'dublin-hill'),
(274876, 781467, 'ie', 'Enniskeane', 1, 'enniskeane'),
(274877, 781467, 'ie', 'Fota', 1, 'fota'),
(274878, 781467, 'ie', 'Frankfield', 1, 'frankfield'),
(274879, 781467, 'ie', 'Glasheen', 1, 'glasheen'),
(274880, 781467, 'ie', 'Gurranabraher', 1, 'gurranabraher'),
(274881, 781467, 'ie', 'Halfway', 1, 'halfway'),
(274882, 781467, 'ie', 'Inniscarra', 1, 'inniscarra'),
(274883, 781467, 'ie', 'Islands', 1, 'islands'),
(274884, 781467, 'ie', 'Jacobs Island', 1, 'jacobs-island'),
(274885, 781467, 'ie', 'Kerry Pike', 1, 'kerry-pike'),
(274886, 781467, 'ie', 'Kerrypike', 1, 'kerrypike'),
(274887, 781467, 'ie', 'Kileady', 1, 'kileady'),
(274888, 781467, 'ie', 'Kileens', 1, 'kileens'),
(274889, 781467, 'ie', 'Knocknaheeny', 1, 'knocknaheeny'),
(274890, 781467, 'ie', 'Lissarda', 1, 'lissarda'),
(274891, 781467, 'ie', 'Little Island', 1, 'little-island'),
(274892, 781467, 'ie', 'Mahon', 1, 'mahon'),
(274893, 781467, 'ie', 'Mahon Point', 1, 'mahon-point'),
(274894, 781467, 'ie', 'Mayfield', 1, 'mayfield'),
(274895, 781467, 'ie', 'Model Farm Road', 1, 'model-farm-road'),
(274896, 781467, 'ie', 'Montenotte', 1, 'montenotte'),
(274897, 781467, 'ie', 'Raheen', 1, 'raheen'),
(274898, 781467, 'ie', 'Rockchapel', 1, 'rockchapel'),
(274899, 781467, 'ie', 'Rosscarbery', 1, 'rosscarbery'),
(274900, 781467, 'ie', 'Schull', 1, 'schull'),
(274901, 781467, 'ie', 'Shanakiel', 1, 'shanakiel'),
(274902, 781467, 'ie', 'St Lukes', 1, 'st-lukes'),
(274903, 781467, 'ie', 'Sundays Well', 1, 'sundays-well'),
(274904, 781467, 'ie', 'Tivoli', 1, 'tivoli'),
(274905, 781467, 'ie', 'Tullylease', 1, 'tullylease'),
(274906, 781467, 'ie', 'Turners Cross', 1, 'turners-cross'),
(274907, 781467, 'ie', 'Union Hall', 1, 'union-hall'),
(274908, 781467, 'ie', 'Whites Cross', 1, 'whites-cross'),
(274909, 781467, 'ie', 'Wilton', 1, 'wilton'),
(274910, 781467, 'ie', 'Dunmanway', 1, 'dunmanway'),
(274911, 781467, 'ie', 'Kanturk', 1, 'kanturk'),
(274912, 781467, 'ie', 'Skibbereen', 1, 'skibbereen'),
(274913, 781467, 'ie', 'Blarney', 1, 'blarney'),
(274914, 781467, 'ie', 'Charleville', 1, 'charleville'),
(274915, 781467, 'ie', 'Tower', 1, 'tower'),
(274916, 781467, 'ie', 'Macroom', 1, 'macroom'),
(274917, 781467, 'ie', 'Bantry', 1, 'bantry'),
(274918, 781467, 'ie', 'Mitchelstown', 1, 'mitchelstown'),
(274919, 781467, 'ie', 'Kinsale', 1, 'kinsale'),
(274920, 781467, 'ie', 'Clonakilty', 1, 'clonakilty'),
(274921, 781467, 'ie', 'Passage West', 1, 'passage-west'),
(274922, 781467, 'ie', 'Fermoy', 1, 'fermoy'),
(274923, 781467, 'ie', 'Bandon', 1, 'bandon'),
(274924, 781467, 'ie', 'Youghal', 1, 'youghal'),
(274925, 781467, 'ie', 'Midleton', 1, 'midleton'),
(274926, 781467, 'ie', 'Mallow', 1, 'mallow'),
(274927, 781467, 'ie', 'Cobh', 1, 'cobh'),
(274928, 781467, 'ie', 'Carrigaline', 1, 'carrigaline');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781468, 'ie', 'Donegal', 1, 'donegal');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(274929, 781468, 'ie', 'Srath an Urláir', 1, 'srath-an-urlair'),
(274930, 781468, 'ie', 'Rossnowlagh Lower', 1, 'rossnowlagh-lower'),
(274931, 781468, 'ie', 'Rathmullan', 1, 'rathmullan'),
(274932, 781468, 'ie', 'Rathmelton', 1, 'rathmelton'),
(274933, 781468, 'ie', 'Ráth Bhoth', 1, 'rath-bhoth'),
(274934, 781468, 'ie', 'Portsalon', 1, 'portsalon'),
(274935, 781468, 'ie', 'Portnoo', 1, 'portnoo'),
(274936, 781468, 'ie', 'An Baile Nua', 1, 'an-baile-nua'),
(274937, 781468, 'ie', 'Naran', 1, 'naran'),
(274938, 781468, 'ie', 'Muff', 1, 'muff'),
(274939, 781468, 'ie', 'Moin Séarlas', 1, 'moin-searlas'),
(274940, 781468, 'ie', 'Baile na nGallóglach', 1, 'baile-na-ngalloglach'),
(274941, 781468, 'ie', 'Manorcunningham', 1, 'manorcunningham'),
(274942, 781468, 'ie', 'Malin', 1, 'malin'),
(274943, 781468, 'ie', 'Cionn Caslach', 1, 'cionn-caslach'),
(274944, 781468, 'ie', 'Cill Mhic Réanáin', 1, 'cill-mhic-reanain'),
(274945, 781468, 'ie', 'Cúil na gCuirridín', 1, 'cuil-na-gcuirridin'),
(274946, 781468, 'ie', 'Cill Charthaigh', 1, 'cill-charthaigh'),
(274947, 781468, 'ie', 'Inbhear', 1, 'inbhear'),
(274948, 781468, 'ie', 'Gort an Choirce', 1, 'gort-an-choirce'),
(274949, 781468, 'ie', 'Fathain', 1, 'fathain'),
(274950, 781468, 'ie', 'Dunkineely', 1, 'dunkineely'),
(274951, 781468, 'ie', 'Dungloe', 1, 'dungloe'),
(274952, 781468, 'ie', 'Dún Fionnachaidh', 1, 'dun-fionnachaidh'),
(274953, 781468, 'ie', 'An Dúchoraidh', 1, 'an-duchoraidh'),
(274954, 781468, 'ie', 'Doirí Beaga', 1, 'doiri-beaga'),
(274955, 781468, 'ie', 'Culdaff', 1, 'culdaff'),
(274956, 781468, 'ie', 'An Fál Carrach', 1, 'an-fal-carrach'),
(274957, 781468, 'ie', 'An Craoslach', 1, 'an-craoslach'),
(274958, 781468, 'ie', 'Convoy', 1, 'convoy'),
(274959, 781468, 'ie', 'Cluain Maine', 1, 'cluain-maine'),
(274960, 781468, 'ie', 'Cloghan', 1, 'cloghan'),
(274961, 781468, 'ie', 'Castlefinn', 1, 'castlefinn'),
(274962, 781468, 'ie', 'An Cheathrú Chaol', 1, 'an-cheathru-chaol'),
(274963, 781468, 'ie', 'Carraig Airt', 1, 'carraig-airt'),
(274964, 781468, 'ie', 'An Charraig', 1, 'an-charraig'),
(274965, 781468, 'ie', 'Ailt an Chorráin', 1, 'ailt-an-chorrain'),
(274966, 781468, 'ie', 'An Bun Beag', 1, 'an-bun-beag'),
(274967, 781468, 'ie', 'Bruckless', 1, 'bruckless'),
(274968, 781468, 'ie', 'Baile Lifín', 1, 'baile-lifin'),
(274969, 781468, 'ie', 'Ballintra', 1, 'ballintra'),
(274970, 781468, 'ie', 'Loch an Iúir', 1, 'loch-an-iuir'),
(274971, 781468, 'ie', 'Port na Bláiche', 1, 'port-na-blaiche'),
(274972, 781468, 'ie', 'Downings', 1, 'downings'),
(274973, 781468, 'ie', 'Leitir Mhic an Bhaird', 1, 'leitir-mhic-an-bhaird'),
(274974, 781468, 'ie', 'Annagry', 1, 'annagry'),
(274975, 781468, 'ie', 'Burt', 1, 'burt'),
(274976, 781468, 'ie', 'Castlefin', 1, 'castlefin'),
(274977, 781468, 'ie', 'Churchill', 1, 'churchill'),
(274978, 781468, 'ie', 'Cruit Island', 1, 'cruit-island'),
(274979, 781468, 'ie', 'Donegal Town', 1, 'donegal-town'),
(274980, 781468, 'ie', 'Drumkeen', 1, 'drumkeen'),
(274981, 781468, 'ie', 'Dunlewey', 1, 'dunlewey'),
(274982, 781468, 'ie', 'Fanad', 1, 'fanad'),
(274983, 781468, 'ie', 'Glencolmcille', 1, 'glencolmcille'),
(274984, 781468, 'ie', 'Glengad', 1, 'glengad'),
(274985, 781468, 'ie', 'Greencastle', 1, 'greencastle'),
(274986, 781468, 'ie', 'Inch Island', 1, 'inch-island'),
(274987, 781468, 'ie', 'Inishowen', 1, 'inishowen'),
(274988, 781468, 'ie', 'Islands', 1, 'islands'),
(274989, 781468, 'ie', 'Laghey', 1, 'laghey'),
(274990, 781468, 'ie', 'Malin Head', 1, 'malin-head'),
(274991, 781468, 'ie', 'Mullaghuff', 1, 'mullaghuff'),
(274992, 781468, 'ie', 'Pettigo', 1, 'pettigo'),
(274993, 781468, 'ie', 'Quigleys Point', 1, 'quigleys-point'),
(274994, 781468, 'ie', 'Redcastle', 1, 'redcastle'),
(274995, 781468, 'ie', 'St Johns Point', 1, 'st-johns-point'),
(274996, 781468, 'ie', 'St. Johnston', 1, 'st-johnston'),
(274997, 781468, 'ie', 'Bun an Phobail', 1, 'bun-an-phobail'),
(274998, 781468, 'ie', 'Glenties', 1, 'glenties'),
(274999, 781468, 'ie', 'Carndonagh', 1, 'carndonagh'),
(275000, 781468, 'ie', 'Lifford', 1, 'lifford'),
(275001, 781468, 'ie', 'Killybegs', 1, 'killybegs'),
(275002, 781468, 'ie', 'Bundoran', 1, 'bundoran'),
(275003, 781468, 'ie', 'Ardara', 1, 'ardara'),
(275004, 781468, 'ie', 'Ballyshannon', 1, 'ballyshannon'),
(275005, 781468, 'ie', 'Ballybofey', 1, 'ballybofey'),
(275006, 781468, 'ie', 'Gweedore', 1, 'gweedore'),
(275007, 781468, 'ie', 'Buncrana', 1, 'buncrana'),
(275008, 781468, 'ie', 'Letterkenny', 1, 'letterkenny');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781469, 'ie', 'Dublin', 1, 'dublin');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275009, 781469, 'ie', 'Dublin', 1, 'dublin');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781470, 'ie', 'Galway', 1, 'galway');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275010, 781470, 'ie', 'An Ghráig', 1, 'an-ghraig'),
(275011, 781470, 'ie', 'Turloughmore', 1, 'turloughmore'),
(275012, 781470, 'ie', 'Tubber', 1, 'tubber'),
(275013, 781470, 'ie', 'An Spidéal', 1, 'an-spideal'),
(275014, 781470, 'ie', 'Cloch na Rón', 1, 'cloch-na-ron'),
(275015, 781470, 'ie', 'Rosmuck', 1, 'rosmuck'),
(275016, 781470, 'ie', 'Portumna', 1, 'portumna'),
(275017, 781470, 'ie', 'Uachtar Ard', 1, 'uachtar-ard'),
(275018, 781470, 'ie', 'New Inn', 1, 'new-inn'),
(275019, 781470, 'ie', 'Newcastle', 1, 'newcastle'),
(275020, 781470, 'ie', 'Moyard', 1, 'moyard'),
(275021, 781470, 'ie', 'An Creagán', 1, 'an-creagan'),
(275022, 781470, 'ie', 'Muine Mheá', 1, 'muine-mhea'),
(275023, 781470, 'ie', 'Maam Cross', 1, 'maam-cross'),
(275024, 781470, 'ie', 'Letterfrack', 1, 'letterfrack'),
(275025, 781470, 'ie', 'Cinn Mhara', 1, 'cinn-mhara'),
(275026, 781470, 'ie', 'Kiltullagh', 1, 'kiltullagh'),
(275027, 781470, 'ie', 'Cill Tormóir', 1, 'cill-tormoir'),
(275028, 781470, 'ie', 'Cill Íomair', 1, 'cill-iomair'),
(275029, 781470, 'ie', 'Cill Chiaráin', 1, 'cill-chiarain'),
(275030, 781470, 'ie', 'Cill Cholgáin', 1, 'cill-cholgain'),
(275031, 781470, 'ie', 'Cill Chríost', 1, 'cill-chriost'),
(275032, 781470, 'ie', 'Indreabhán', 1, 'indreabhan'),
(275033, 781470, 'ie', 'Áth Cinn', 1, 'ath-cinn'),
(275034, 781470, 'ie', 'Glinsk', 1, 'glinsk'),
(275035, 781470, 'ie', 'Gleann na Madadh', 1, 'gleann-na-madadh'),
(275036, 781470, 'ie', 'Dún an Uchta', 1, 'dun-an-uchta'),
(275037, 781470, 'ie', 'Dunmore', 1, 'dunmore'),
(275038, 781470, 'ie', 'Craughwell', 1, 'craughwell'),
(275039, 781470, 'ie', 'Cloonboo', 1, 'cloonboo'),
(275040, 781470, 'ie', 'An Cloigeann', 1, 'an-cloigeann'),
(275041, 781470, 'ie', 'Droichead an Chláirín', 1, 'droichead-an-chlairin'),
(275042, 781470, 'ie', 'Baile Chláir', 1, 'baile-chlair'),
(275043, 781470, 'ie', 'Claddagh', 1, 'claddagh'),
(275044, 781470, 'ie', 'Gallach', 1, 'gallach'),
(275045, 781470, 'ie', 'An Cheathrú Rua', 1, 'an-cheathru-rua'),
(275046, 781470, 'ie', 'Carna', 1, 'carna'),
(275047, 781470, 'ie', 'Bullaun', 1, 'bullaun'),
(275048, 781470, 'ie', 'Barna', 1, 'barna'),
(275049, 781470, 'ie', 'Ballinderreen', 1, 'ballinderreen'),
(275050, 781470, 'ie', 'Eachroim', 1, 'eachroim'),
(275051, 781470, 'ie', 'Attymon', 1, 'attymon'),
(275052, 781470, 'ie', 'Ardrahan', 1, 'ardrahan'),
(275053, 781470, 'ie', 'Annaghdown', 1, 'annaghdown'),
(275054, 781470, 'ie', 'Ahascragh', 1, 'ahascragh'),
(275055, 781470, 'ie', 'Baile Conaola', 1, 'baile-conaola'),
(275056, 781470, 'ie', 'Claddaghduff', 1, 'claddaghduff'),
(275057, 781470, 'ie', 'Lettermore', 1, 'lettermore'),
(275058, 781470, 'ie', 'Doughiska', 1, 'doughiska'),
(275059, 781470, 'ie', 'Ballybrit', 1, 'ballybrit'),
(275060, 781470, 'ie', 'Castlegar', 1, 'castlegar'),
(275061, 781470, 'ie', 'Terryland', 1, 'terryland'),
(275062, 781470, 'ie', 'Tonabrocky', 1, 'tonabrocky'),
(275063, 781470, 'ie', 'Corrandulla', 1, 'corrandulla'),
(275064, 781470, 'ie', 'Mionlach', 1, 'mionlach'),
(275065, 781470, 'ie', 'Shanbally', 1, 'shanbally'),
(275066, 781470, 'ie', 'Tullycross', 1, 'tullycross'),
(275067, 781470, 'ie', 'Abbeyknockmoy', 1, 'abbeyknockmoy'),
(275068, 781470, 'ie', 'Ballinahinch', 1, 'ballinahinch'),
(275069, 781470, 'ie', 'Ballybane', 1, 'ballybane'),
(275070, 781470, 'ie', 'Bohermore', 1, 'bohermore'),
(275071, 781470, 'ie', 'Boleybeg', 1, 'boleybeg'),
(275072, 781470, 'ie', 'Bushypark', 1, 'bushypark'),
(275073, 781470, 'ie', 'Caherlistrane', 1, 'caherlistrane'),
(275074, 781470, 'ie', 'Cashel', 1, 'cashel'),
(275075, 781470, 'ie', 'City Centre', 1, 'city-centre'),
(275076, 781470, 'ie', 'Clonbur', 1, 'clonbur'),
(275077, 781470, 'ie', 'Cong', 1, 'cong'),
(275078, 781470, 'ie', 'Coose', 1, 'coose'),
(275079, 781470, 'ie', 'Corcullen', 1, 'corcullen'),
(275080, 781470, 'ie', 'Cornamona', 1, 'cornamona'),
(275081, 781470, 'ie', 'Corofin', 1, 'corofin'),
(275082, 781470, 'ie', 'Creggs', 1, 'creggs'),
(275083, 781470, 'ie', 'Dangan', 1, 'dangan'),
(275084, 781470, 'ie', 'Furbo', 1, 'furbo'),
(275085, 781470, 'ie', 'Galway City', 1, 'galway-city'),
(275086, 781470, 'ie', 'Gurteen', 1, 'gurteen'),
(275087, 781470, 'ie', 'Headford Road', 1, 'headford-road'),
(275088, 781470, 'ie', 'Islands', 1, 'islands'),
(275089, 781470, 'ie', 'Keeraun', 1, 'keeraun'),
(275090, 781470, 'ie', 'Kilreekil', 1, 'kilreekil'),
(275091, 781470, 'ie', 'Kingston', 1, 'kingston'),
(275092, 781470, 'ie', 'Knocknacarra', 1, 'knocknacarra'),
(275093, 781470, 'ie', 'Lackagh', 1, 'lackagh'),
(275094, 781470, 'ie', 'Leenane', 1, 'leenane'),
(275095, 781470, 'ie', 'Menlo', 1, 'menlo'),
(275096, 781470, 'ie', 'Merlin', 1, 'merlin'),
(275097, 781470, 'ie', 'Mervue', 1, 'mervue'),
(275098, 781470, 'ie', 'Moylough', 1, 'moylough'),
(275099, 781470, 'ie', 'Rahoon', 1, 'rahoon'),
(275100, 781470, 'ie', 'Recess', 1, 'recess'),
(275101, 781470, 'ie', 'Renmore', 1, 'renmore'),
(275102, 781470, 'ie', 'Renvyle', 1, 'renvyle'),
(275103, 781470, 'ie', 'Roscam', 1, 'roscam'),
(275104, 781470, 'ie', 'Rosscahill', 1, 'rosscahill'),
(275105, 781470, 'ie', 'Salthill', 1, 'salthill'),
(275106, 781470, 'ie', 'Shantalla', 1, 'shantalla'),
(275107, 781470, 'ie', 'Taylors Hill', 1, 'taylors-hill'),
(275108, 781470, 'ie', 'Tirellan', 1, 'tirellan'),
(275109, 781470, 'ie', 'Wellpark', 1, 'wellpark'),
(275110, 781470, 'ie', 'Williamstown', 1, 'williamstown'),
(275111, 781470, 'ie', 'Woodlawn', 1, 'woodlawn'),
(275112, 781470, 'ie', 'Moycullen', 1, 'moycullen'),
(275113, 781470, 'ie', 'Oranmore', 1, 'oranmore'),
(275114, 781470, 'ie', 'Clifden', 1, 'clifden'),
(275115, 781470, 'ie', 'Gort', 1, 'gort'),
(275116, 781470, 'ie', 'Athenry', 1, 'athenry'),
(275117, 781470, 'ie', 'Loughrea', 1, 'loughrea'),
(275118, 781470, 'ie', 'Tuam', 1, 'tuam'),
(275119, 781470, 'ie', 'Ballinasloe', 1, 'ballinasloe');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781471, 'ie', 'Kerry', 1, 'kerry');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275120, 781471, 'ie', 'An Coireán', 1, 'an-coirean'),
(275121, 781471, 'ie', 'Tarbert', 1, 'tarbert'),
(275122, 781471, 'ie', 'An Snaidhm', 1, 'an-snaidhm'),
(275123, 781471, 'ie', 'An Ráth Mhór', 1, 'an-rath-mhor'),
(275124, 781471, 'ie', 'Baile an Mhuilinn', 1, 'baile-an-mhuilinn'),
(275125, 781471, 'ie', 'Leic Snámha', 1, 'leic-snamha'),
(275126, 781471, 'ie', 'An Láithreach', 1, 'an-laithreach'),
(275127, 781471, 'ie', 'Cill Garbháin', 1, 'cill-garbhain'),
(275128, 781471, 'ie', 'Glenbeigh', 1, 'glenbeigh'),
(275129, 781471, 'ie', 'An Fhianait', 1, 'an-fhianait'),
(275130, 781471, 'ie', 'An Fearann Fuar', 1, 'an-fearann-fuar'),
(275131, 781471, 'ie', 'An Tóchar', 1, 'an-tochar'),
(275132, 781471, 'ie', 'Caisleán na Mainge', 1, 'caislean-na-mainge'),
(275133, 781471, 'ie', 'Camp', 1, 'camp'),
(275134, 781471, 'ie', 'Cathair Dónall', 1, 'cathair-donall'),
(275135, 781471, 'ie', 'Ballynagall', 1, 'ballynagall'),
(275136, 781471, 'ie', 'Ballylongford', 1, 'ballylongford'),
(275137, 781471, 'ie', 'Baile Uí Thaidhg', 1, 'baile-ui-thaidhg'),
(275138, 781471, 'ie', 'Ballyferriter', 1, 'ballyferriter'),
(275139, 781471, 'ie', 'Ballinskelligs', 1, 'ballinskelligs'),
(275140, 781471, 'ie', 'Ardfert', 1, 'ardfert'),
(275141, 781471, 'ie', 'An Cromán', 1, 'an-croman'),
(275142, 781471, 'ie', 'Ballyard', 1, 'ballyard'),
(275143, 781471, 'ie', 'Beaufort', 1, 'beaufort'),
(275144, 781471, 'ie', 'Brosna', 1, 'brosna'),
(275145, 781471, 'ie', 'Caherciveen', 1, 'caherciveen'),
(275146, 781471, 'ie', 'Caragh Lake', 1, 'caragh-lake'),
(275147, 781471, 'ie', 'Castlecove', 1, 'castlecove'),
(275148, 781471, 'ie', 'Islands', 1, 'islands'),
(275149, 781471, 'ie', 'Kilflynn', 1, 'kilflynn'),
(275150, 781471, 'ie', 'Leith', 1, 'leith'),
(275151, 781471, 'ie', 'Moyvane', 1, 'moyvane'),
(275152, 781471, 'ie', 'Rossbeigh', 1, 'rossbeigh'),
(275153, 781471, 'ie', 'Tuosist', 1, 'tuosist'),
(275154, 781471, 'ie', 'Killorglin', 1, 'killorglin'),
(275155, 781471, 'ie', 'Ballybunion', 1, 'ballybunion'),
(275156, 781471, 'ie', 'Dingle', 1, 'dingle'),
(275157, 781471, 'ie', 'Kenmare', 1, 'kenmare'),
(275158, 781471, 'ie', 'Castleisland', 1, 'castleisland'),
(275159, 781471, 'ie', 'Listowel', 1, 'listowel'),
(275160, 781471, 'ie', 'Killarney', 1, 'killarney'),
(275161, 781471, 'ie', 'Tralee', 1, 'tralee');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781472, 'ie', 'Kildare', 1, 'kildare');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275162, 781472, 'ie', 'Timolin', 1, 'timolin'),
(275163, 781472, 'ie', 'Straffan', 1, 'straffan'),
(275164, 781472, 'ie', 'Baile Riobaird', 1, 'baile-riobaird'),
(275165, 781472, 'ie', 'Nurney', 1, 'nurney'),
(275166, 781472, 'ie', 'Narraghmore', 1, 'narraghmore'),
(275167, 781472, 'ie', 'Moyvally', 1, 'moyvally'),
(275168, 781472, 'ie', 'Moone', 1, 'moone'),
(275169, 781472, 'ie', 'Kilteel', 1, 'kilteel'),
(275170, 781472, 'ie', 'Cill Maodhóg', 1, 'cill-maodhog'),
(275171, 781472, 'ie', 'Cill Chuillinn', 1, 'cill-chuillinn'),
(275172, 781472, 'ie', 'Johnstown', 1, 'johnstown'),
(275173, 781472, 'ie', 'Donadea', 1, 'donadea'),
(275174, 781472, 'ie', 'Derrinturn', 1, 'derrinturn'),
(275175, 781472, 'ie', 'Díseart Diarmada', 1, 'diseart-diarmada'),
(275176, 781472, 'ie', 'Carbury', 1, 'carbury'),
(275177, 781472, 'ie', 'Calverstown', 1, 'calverstown'),
(275178, 781472, 'ie', 'An Baile Mór', 1, 'an-baile-mor'),
(275179, 781472, 'ie', 'Béal Atha an Tuair', 1, 'beal-atha-an-tuair'),
(275180, 781472, 'ie', 'Athgarvan', 1, 'athgarvan'),
(275181, 781472, 'ie', 'Allenwood', 1, 'allenwood'),
(275182, 781472, 'ie', 'Kilkea', 1, 'kilkea'),
(275183, 781472, 'ie', 'Kildangan', 1, 'kildangan'),
(275184, 781472, 'ie', 'Suncroft', 1, 'suncroft'),
(275185, 781472, 'ie', 'Brannockstown', 1, 'brannockstown'),
(275186, 781472, 'ie', 'Milltown', 1, 'milltown'),
(275187, 781472, 'ie', 'Allen', 1, 'allen'),
(275188, 781472, 'ie', 'An Chill', 1, 'an-chill'),
(275189, 781472, 'ie', 'Eadestown', 1, 'eadestown'),
(275190, 781472, 'ie', 'Ballysax', 1, 'ballysax'),
(275191, 781472, 'ie', 'Ballyshannon', 1, 'ballyshannon'),
(275192, 781472, 'ie', 'Broadford', 1, 'broadford'),
(275193, 781472, 'ie', 'Brownstown', 1, 'brownstown'),
(275194, 781472, 'ie', 'Caragh', 1, 'caragh'),
(275195, 781472, 'ie', 'Coill Dubh', 1, 'coill-dubh'),
(275196, 781472, 'ie', 'Curragh', 1, 'curragh'),
(275197, 781472, 'ie', 'Enfield', 1, 'enfield'),
(275198, 781472, 'ie', 'Johnstownbridge', 1, 'johnstownbridge'),
(275199, 781472, 'ie', 'Kilcloon', 1, 'kilcloon'),
(275200, 781472, 'ie', 'Pollardstown', 1, 'pollardstown'),
(275201, 781472, 'ie', 'Two Mile House', 1, 'two-mile-house'),
(275202, 781472, 'ie', 'Prosperous', 1, 'prosperous'),
(275203, 781472, 'ie', 'Rathangan', 1, 'rathangan'),
(275204, 781472, 'ie', 'Monasterevan', 1, 'monasterevan'),
(275205, 781472, 'ie', 'Sallins', 1, 'sallins'),
(275206, 781472, 'ie', 'Kilcock', 1, 'kilcock'),
(275207, 781472, 'ie', 'Clane', 1, 'clane'),
(275208, 781472, 'ie', 'Athy', 1, 'athy'),
(275209, 781472, 'ie', 'Maynooth', 1, 'maynooth'),
(275210, 781472, 'ie', 'Leixlip', 1, 'leixlip'),
(275211, 781472, 'ie', 'Celbridge', 1, 'celbridge'),
(275212, 781472, 'ie', 'Newbridge', 1, 'newbridge'),
(275213, 781472, 'ie', 'Naas', 1, 'naas');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781473, 'ie', 'Kilkenny', 1, 'kilkenny');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275214, 781473, 'ie', 'Bearna na Gaoithe', 1, 'bearna-na-gaoithe'),
(275215, 781473, 'ie', 'Baile Phóil', 1, 'baile-phoil'),
(275216, 781473, 'ie', 'Áth na nUrlainn', 1, 'ath-na-nurlainn'),
(275217, 781473, 'ie', 'Baile an Phoill', 1, 'baile-an-phoill'),
(275218, 781473, 'ie', 'Muileann an Bhata', 1, 'muileann-an-bhata'),
(275219, 781473, 'ie', 'Mooncoin', 1, 'mooncoin'),
(275220, 781473, 'ie', 'Lisdowney', 1, 'lisdowney'),
(275221, 781473, 'ie', 'Knocktopher', 1, 'knocktopher'),
(275222, 781473, 'ie', 'Cill Mogeanna', 1, 'cill-mogeanna'),
(275223, 781473, 'ie', 'Cill Mhic Bhúith', 1, 'cill-mhic-bhuith'),
(275224, 781473, 'ie', 'Kells', 1, 'kells'),
(275225, 781473, 'ie', 'Baile Sheáin', 1, 'baile-sheain'),
(275226, 781473, 'ie', 'Jenkinstown', 1, 'jenkinstown'),
(275227, 781473, 'ie', 'Inistioge', 1, 'inistioge'),
(275228, 781473, 'ie', 'Graiguenamanagh', 1, 'graiguenamanagh'),
(275229, 781473, 'ie', 'Gabhrán', 1, 'gabhran'),
(275230, 781473, 'ie', 'An Droichead Nua', 1, 'an-droichead-nua'),
(275231, 781473, 'ie', 'Achadh Úr', 1, 'achadh-ur'),
(275232, 781473, 'ie', 'Fiodh Dúin', 1, 'fiodh-duin'),
(275233, 781473, 'ie', 'Callan', 1, 'callan'),
(275234, 781473, 'ie', 'Droichead Binéid', 1, 'droichead-bineid'),
(275235, 781473, 'ie', 'Ballyragget', 1, 'ballyragget'),
(275236, 781473, 'ie', 'Baile Héil', 1, 'baile-heil'),
(275237, 781473, 'ie', 'Glenmore', 1, 'glenmore'),
(275238, 781473, 'ie', 'The Rower', 1, 'the-rower'),
(275239, 781473, 'ie', 'Owning', 1, 'owning'),
(275240, 781473, 'ie', 'Clara', 1, 'clara'),
(275241, 781473, 'ie', 'Conahy', 1, 'conahy'),
(275242, 781473, 'ie', 'Cuffesgrange', 1, 'cuffesgrange'),
(275243, 781473, 'ie', 'Dunmore', 1, 'dunmore'),
(275244, 781473, 'ie', 'Mullinbeg', 1, 'mullinbeg'),
(275245, 781473, 'ie', 'Rosbercon', 1, 'rosbercon'),
(275246, 781473, 'ie', 'Slieverue', 1, 'slieverue'),
(275247, 781473, 'ie', 'Stoneyford', 1, 'stoneyford'),
(275248, 781473, 'ie', 'Templorum', 1, 'templorum'),
(275249, 781473, 'ie', 'Tullogher', 1, 'tullogher'),
(275250, 781473, 'ie', 'Thomastown', 1, 'thomastown'),
(275251, 781473, 'ie', 'Castlecomer', 1, 'castlecomer');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781474, 'ie', 'Laois', 1, 'laois');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275252, 781474, 'ie', 'Vicarstown', 1, 'vicarstown'),
(275253, 781474, 'ie', 'Timahoe', 1, 'timahoe'),
(275254, 781474, 'ie', 'An Sráidbhaile', 1, 'an-sraidbhaile'),
(275255, 781474, 'ie', 'Ráth Domhnaigh', 1, 'rath-domhnaigh'),
(275256, 781474, 'ie', 'Errill', 1, 'errill'),
(275257, 781474, 'ie', 'Emo', 1, 'emo'),
(275258, 781474, 'ie', 'Durrow', 1, 'durrow'),
(275259, 781474, 'ie', 'Cullahill', 1, 'cullahill'),
(275260, 781474, 'ie', 'Clonaslee', 1, 'clonaslee'),
(275261, 781474, 'ie', 'Baile an Chaisleáin', 1, 'baile-an-chaisleain'),
(275262, 781474, 'ie', 'Buiríos Mór Osraí', 1, 'buirios-mor-osrai'),
(275263, 781474, 'ie', 'Baile Átha an Róine', 1, 'baile-atha-an-roine'),
(275264, 781474, 'ie', 'Baile Uí Laigheanáin', 1, 'baile-ui-laigheanain'),
(275265, 781474, 'ie', 'Ballybrittas', 1, 'ballybrittas'),
(275266, 781474, 'ie', 'Shanahoe', 1, 'shanahoe'),
(275267, 781474, 'ie', 'Killeen', 1, 'killeen'),
(275268, 781474, 'ie', 'Killenard', 1, 'killenard'),
(275269, 781474, 'ie', 'Ballyfin', 1, 'ballyfin'),
(275270, 781474, 'ie', 'Crettyard', 1, 'crettyard'),
(275271, 781474, 'ie', 'Magney', 1, 'magney'),
(275272, 781474, 'ie', 'Mountrath', 1, 'mountrath'),
(275273, 781474, 'ie', 'Abbeyleix', 1, 'abbeyleix'),
(275274, 781474, 'ie', 'Mountmellick', 1, 'mountmellick'),
(275275, 781474, 'ie', 'Portarlington', 1, 'portarlington'),
(275276, 781474, 'ie', 'Port Laoise', 1, 'port-laoise');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781475, 'ie', 'Leitrim', 1, 'leitrim');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275277, 781475, 'ie', 'Tullaghan', 1, 'tullaghan'),
(275278, 781475, 'ie', 'Maothail', 1, 'maothail'),
(275279, 781475, 'ie', 'Cluainín', 1, 'cluainin'),
(275280, 781475, 'ie', 'Cionn Locha', 1, 'cionn-locha'),
(275281, 781475, 'ie', 'Coillte Clochair', 1, 'coillte-clochair'),
(275282, 781475, 'ie', 'Keshcarrigan', 1, 'keshcarrigan'),
(275283, 781475, 'ie', 'Glenfarne', 1, 'glenfarne'),
(275284, 781475, 'ie', 'Fenagh', 1, 'fenagh'),
(275285, 781475, 'ie', 'Droim ar Snámh', 1, 'droim-ar-snamh'),
(275286, 781475, 'ie', 'Droim Seanbhó', 1, 'droim-seanbho'),
(275287, 781475, 'ie', 'Dromad', 1, 'dromad'),
(275288, 781475, 'ie', 'Droim Caorthainn', 1, 'droim-caorthainn'),
(275289, 781475, 'ie', 'Dromahair', 1, 'dromahair'),
(275290, 781475, 'ie', 'An Chluaine', 1, 'an-chluaine'),
(275291, 781475, 'ie', 'Carraig Álainn', 1, 'carraig-alainn'),
(275292, 781475, 'ie', 'Béal an Átha Móir', 1, 'beal-an-atha-moir'),
(275293, 781475, 'ie', 'Aughavas', 1, 'aughavas'),
(275294, 781475, 'ie', 'Dowra', 1, 'dowra'),
(275295, 781475, 'ie', 'Gorvagh', 1, 'gorvagh'),
(275296, 781475, 'ie', 'Leitrim Village', 1, 'leitrim-village'),
(275297, 781475, 'ie', 'Newtowngore', 1, 'newtowngore'),
(275298, 781475, 'ie', 'Rooskey', 1, 'rooskey'),
(275299, 781475, 'ie', 'Carrick on Shannon', 1, 'carrick-on-shannon');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781476, 'ie', 'Limerick', 1, 'limerick');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275300, 781476, 'ie', 'Shanagolden', 1, 'shanagolden'),
(275301, 781476, 'ie', 'Tobar Phádraig', 1, 'tobar-phadraig'),
(275302, 781476, 'ie', 'Pailís Chaonraí', 1, 'pailis-chaonrai'),
(275303, 781476, 'ie', 'Pallas Grean', 1, 'pallas-grean'),
(275304, 781476, 'ie', 'Úlla', 1, 'ulla'),
(275305, 781476, 'ie', 'Mungairit', 1, 'mungairit'),
(275306, 781476, 'ie', 'Knocklong', 1, 'knocklong'),
(275307, 781476, 'ie', 'Cill Tíle', 1, 'cill-tile'),
(275308, 781476, 'ie', 'Cill Fhíonáin', 1, 'cill-fhionain'),
(275309, 781476, 'ie', 'An tOspidéal', 1, 'an-tospideal'),
(275310, 781476, 'ie', 'Baile Hiobaird', 1, 'baile-hiobaird'),
(275311, 781476, 'ie', 'An Gleann', 1, 'an-gleann'),
(275312, 781476, 'ie', 'An Gallbhaile', 1, 'an-gallbhaile'),
(275313, 781476, 'ie', 'Foynes', 1, 'foynes'),
(275314, 781476, 'ie', 'Feohanagh', 1, 'feohanagh'),
(275315, 781476, 'ie', 'Fedamore', 1, 'fedamore'),
(275316, 781476, 'ie', 'Dún', 1, 'dun'),
(275317, 781476, 'ie', 'Croom', 1, 'croom'),
(275318, 781476, 'ie', 'Croagh', 1, 'croagh'),
(275319, 781476, 'ie', 'Clarina', 1, 'clarina'),
(275320, 781476, 'ie', 'An Cheapach Mhór', 1, 'an-cheapach-mhor'),
(275321, 781476, 'ie', 'Caherconlish', 1, 'caherconlish'),
(275322, 781476, 'ie', 'Brú Rí', 1, 'bru-ri'),
(275323, 781476, 'ie', 'An Brú', 1, 'an-bru'),
(275324, 781476, 'ie', 'Béal an Átha', 1, 'beal-an-atha'),
(275325, 781476, 'ie', 'Ballyneety', 1, 'ballyneety'),
(275326, 781476, 'ie', 'Baile an Londraigh', 1, 'baile-an-londraigh'),
(275327, 781476, 'ie', 'Ballingarry', 1, 'ballingarry'),
(275328, 781476, 'ie', 'Athlacca', 1, 'athlacca'),
(275329, 781476, 'ie', 'Eas Géitine', 1, 'eas-geitine'),
(275330, 781476, 'ie', 'Ardpatrick', 1, 'ardpatrick'),
(275331, 781476, 'ie', 'Adare', 1, 'adare'),
(275332, 781476, 'ie', 'Caisleáñ Ui Chonaill', 1, 'caislean-ui-chonaill'),
(275333, 781476, 'ie', 'Ballysheedy', 1, 'ballysheedy'),
(275334, 781476, 'ie', 'Annacotty', 1, 'annacotty'),
(275335, 781476, 'ie', 'Ballinacurra', 1, 'ballinacurra'),
(275336, 781476, 'ie', 'Ballyclough', 1, 'ballyclough'),
(275337, 781476, 'ie', 'Ballysimon', 1, 'ballysimon'),
(275338, 781476, 'ie', 'Caherdavin', 1, 'caherdavin'),
(275339, 781476, 'ie', 'Castletroy', 1, 'castletroy'),
(275340, 781476, 'ie', 'City Centre (Limerick)', 1, 'city-centre-limerick'),
(275341, 781476, 'ie', 'Clareview', 1, 'clareview'),
(275342, 781476, 'ie', 'Corbally', 1, 'corbally'),
(275343, 781476, 'ie', 'Crecora', 1, 'crecora'),
(275344, 781476, 'ie', 'Dooradoyle', 1, 'dooradoyle'),
(275345, 781476, 'ie', 'Dromcollogher', 1, 'dromcollogher'),
(275346, 781476, 'ie', 'Dromore', 1, 'dromore'),
(275347, 781476, 'ie', 'Droombanna', 1, 'droombanna'),
(275348, 781476, 'ie', 'Dublin Road', 1, 'dublin-road'),
(275349, 781476, 'ie', 'Ennis Road', 1, 'ennis-road'),
(275350, 781476, 'ie', 'Garryowen', 1, 'garryowen'),
(275351, 781476, 'ie', 'Granagh', 1, 'granagh'),
(275352, 781476, 'ie', 'Janesboro', 1, 'janesboro'),
(275353, 781476, 'ie', 'Kilbane', 1, 'kilbane'),
(275354, 781476, 'ie', 'Kilcornan', 1, 'kilcornan'),
(275355, 781476, 'ie', 'Kildimo', 1, 'kildimo'),
(275356, 781476, 'ie', 'Knockainey', 1, 'knockainey'),
(275357, 781476, 'ie', 'Limerick City', 1, 'limerick-city'),
(275358, 781476, 'ie', 'Lisnagry', 1, 'lisnagry'),
(275359, 781476, 'ie', 'Lisselton', 1, 'lisselton'),
(275360, 781476, 'ie', 'Monaleen', 1, 'monaleen'),
(275361, 781476, 'ie', 'Mountcollins', 1, 'mountcollins'),
(275362, 781476, 'ie', 'Moyross', 1, 'moyross'),
(275363, 781476, 'ie', 'Murroe', 1, 'murroe'),
(275364, 781476, 'ie', 'North Circular Road', 1, 'north-circular-road'),
(275365, 781476, 'ie', 'Old Singland Road', 1, 'old-singland-road'),
(275366, 781476, 'ie', 'Pennywell', 1, 'pennywell'),
(275367, 781476, 'ie', 'Raheen', 1, 'raheen'),
(275368, 781476, 'ie', 'Rathbane', 1, 'rathbane'),
(275369, 781476, 'ie', 'Rhebogue', 1, 'rhebogue'),
(275370, 781476, 'ie', 'Sth Circ Rd', 1, 'sth-circ-rd'),
(275371, 781476, 'ie', 'Templeglantine', 1, 'templeglantine'),
(275372, 781476, 'ie', 'Thomondgate', 1, 'thomondgate'),
(275373, 781476, 'ie', 'Tournafulla', 1, 'tournafulla'),
(275374, 781476, 'ie', 'Rathkeale', 1, 'rathkeale'),
(275375, 781476, 'ie', 'Kilmallock', 1, 'kilmallock'),
(275376, 781476, 'ie', 'Abbeyfeale', 1, 'abbeyfeale'),
(275377, 781476, 'ie', 'Newcastle West', 1, 'newcastle-west');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781477, 'ie', 'Longford', 1, 'longford');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275378, 781477, 'ie', 'Legan', 1, 'legan'),
(275379, 781477, 'ie', 'Caonach', 1, 'caonach'),
(275380, 781477, 'ie', 'Meathas Troim', 1, 'meathas-troim'),
(275381, 781477, 'ie', 'Drumlish', 1, 'drumlish'),
(275382, 781477, 'ie', 'Baile Uí Mhatháin', 1, 'baile-ui-mhathain'),
(275383, 781477, 'ie', 'Béal Átha na Lao', 1, 'beal-atha-na-lao'),
(275384, 781477, 'ie', 'Ardagh', 1, 'ardagh'),
(275385, 781477, 'ie', 'Aughnacliffe', 1, 'aughnacliffe'),
(275386, 781477, 'ie', 'Ballinamuck', 1, 'ballinamuck'),
(275387, 781477, 'ie', 'Dring', 1, 'dring'),
(275388, 781477, 'ie', 'Lanesboro', 1, 'lanesboro'),
(275389, 781477, 'ie', 'Moyne', 1, 'moyne'),
(275390, 781477, 'ie', 'Newtowncashel', 1, 'newtowncashel'),
(275391, 781477, 'ie', 'Newtownforbes', 1, 'newtownforbes'),
(275392, 781477, 'ie', 'Ratharney', 1, 'ratharney'),
(275393, 781477, 'ie', 'Rooskey', 1, 'rooskey'),
(275394, 781477, 'ie', 'Tarmonbarry', 1, 'tarmonbarry'),
(275395, 781477, 'ie', 'Granard', 1, 'granard');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781478, 'ie', 'Louth', 1, 'louth');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275396, 781478, 'ie', 'Tullyallen', 1, 'tullyallen'),
(275397, 781478, 'ie', 'Togher', 1, 'togher'),
(275398, 781478, 'ie', 'Tearmann Feichín', 1, 'tearmann-feichin'),
(275399, 781478, 'ie', 'Tallanstown', 1, 'tallanstown'),
(275400, 781478, 'ie', 'Ravensdale', 1, 'ravensdale'),
(275401, 781478, 'ie', 'Omeath', 1, 'omeath'),
(275402, 781478, 'ie', 'Newtown Monasterboice', 1, 'newtown-monasterboice'),
(275403, 781478, 'ie', 'Mansfieldstown', 1, 'mansfieldstown'),
(275404, 781478, 'ie', 'Grangebellew', 1, 'grangebellew'),
(275405, 781478, 'ie', 'Dunleer', 1, 'dunleer'),
(275406, 781478, 'ie', 'Dromiskin', 1, 'dromiskin'),
(275407, 781478, 'ie', 'Collon', 1, 'collon'),
(275408, 781478, 'ie', 'Clogherhead', 1, 'clogherhead'),
(275409, 781478, 'ie', 'Baile an Ghearlánaigh', 1, 'baile-an-ghearlanaigh'),
(275410, 781478, 'ie', 'Carlingford', 1, 'carlingford'),
(275411, 781478, 'ie', 'Blackrock', 1, 'blackrock'),
(275412, 781478, 'ie', 'Baile Trá', 1, 'baile-tra'),
(275413, 781478, 'ie', 'Annagassan', 1, 'annagassan'),
(275414, 781478, 'ie', 'Dunany', 1, 'dunany'),
(275415, 781478, 'ie', 'Cooley', 1, 'cooley'),
(275416, 781478, 'ie', 'Hackballscross', 1, 'hackballscross'),
(275417, 781478, 'ie', 'Stamullen', 1, 'stamullen'),
(275418, 781478, 'ie', 'Tinure', 1, 'tinure'),
(275419, 781478, 'ie', 'Knockbridge', 1, 'knockbridge'),
(275420, 781478, 'ie', 'Ardee', 1, 'ardee'),
(275421, 781478, 'ie', 'Dundalk', 1, 'dundalk'),
(275422, 781478, 'ie', 'Drogheda', 1, 'drogheda');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781479, 'ie', 'Mayo', 1, 'mayo');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275423, 781479, 'ie', 'Shruthair', 1, 'shruthair'),
(275424, 781479, 'ie', 'Baile Uí Fhiacháin', 1, 'baile-ui-fhiachain'),
(275425, 781479, 'ie', 'Cluain Cearbán', 1, 'cluain-cearban'),
(275426, 781479, 'ie', 'Coillte Mach', 1, 'coillte-mach'),
(275427, 781479, 'ie', 'Cill Cheallaigh', 1, 'cill-cheallaigh'),
(275428, 781479, 'ie', 'Béal Easa', 1, 'beal-easa'),
(275429, 781479, 'ie', 'Crossmolina', 1, 'crossmolina'),
(275430, 781479, 'ie', 'Cong', 1, 'cong'),
(275431, 781479, 'ie', 'Baile Chathail', 1, 'baile-chathail'),
(275432, 781479, 'ie', 'Belmullet', 1, 'belmullet'),
(275433, 781479, 'ie', 'Baingear', 1, 'baingear'),
(275434, 781479, 'ie', 'Baile an Daighin', 1, 'baile-an-daighin'),
(275435, 781479, 'ie', 'Achill', 1, 'achill'),
(275436, 781479, 'ie', 'Balla', 1, 'balla'),
(275437, 781479, 'ie', 'Ballintober', 1, 'ballintober'),
(275438, 781479, 'ie', 'Clonbur', 1, 'clonbur'),
(275439, 781479, 'ie', 'Cross', 1, 'cross'),
(275440, 781479, 'ie', 'Hollymount', 1, 'hollymount'),
(275441, 781479, 'ie', 'Irishtown', 1, 'irishtown'),
(275442, 781479, 'ie', 'Islands', 1, 'islands'),
(275443, 781479, 'ie', 'Killala', 1, 'killala'),
(275444, 781479, 'ie', 'Kilmaine', 1, 'kilmaine'),
(275445, 781479, 'ie', 'Knock', 1, 'knock'),
(275446, 781479, 'ie', 'Lacken', 1, 'lacken'),
(275447, 781479, 'ie', 'Leenane', 1, 'leenane'),
(275448, 781479, 'ie', 'Mulranny', 1, 'mulranny'),
(275449, 781479, 'ie', 'Partry', 1, 'partry'),
(275450, 781479, 'ie', 'The Neale', 1, 'the-neale'),
(275451, 781479, 'ie', 'Tourmakeady', 1, 'tourmakeady'),
(275452, 781479, 'ie', 'Swinford', 1, 'swinford'),
(275453, 781479, 'ie', 'Ballyhaunis', 1, 'ballyhaunis'),
(275454, 781479, 'ie', 'Ballinrobe', 1, 'ballinrobe'),
(275455, 781479, 'ie', 'Claremorris', 1, 'claremorris'),
(275456, 781479, 'ie', 'Westport', 1, 'westport'),
(275457, 781479, 'ie', 'Ballina', 1, 'ballina'),
(275458, 781479, 'ie', 'Castlebar', 1, 'castlebar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781480, 'ie', 'Meath', 1, 'meath');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275459, 781480, 'ie', 'Summerhill', 1, 'summerhill'),
(275460, 781480, 'ie', 'Baile Shláine', 1, 'baile-shlaine'),
(275461, 781480, 'ie', 'Rathmolyon', 1, 'rathmolyon'),
(275462, 781480, 'ie', 'An Seanchaisleán', 1, 'an-seanchaislean'),
(275463, 781480, 'ie', 'Nobber', 1, 'nobber'),
(275464, 781480, 'ie', 'Moynalty', 1, 'moynalty'),
(275465, 781480, 'ie', 'Mornington', 1, 'mornington'),
(275466, 781480, 'ie', 'Longwood', 1, 'longwood'),
(275467, 781480, 'ie', 'Kilmessan', 1, 'kilmessan'),
(275468, 781480, 'ie', 'Kildalkey', 1, 'kildalkey'),
(275469, 781480, 'ie', 'Kilbride Cross Roads', 1, 'kilbride-cross-roads'),
(275470, 781480, 'ie', 'Julianstown', 1, 'julianstown'),
(275471, 781480, 'ie', 'Johnstown', 1, 'johnstown'),
(275472, 781480, 'ie', 'Baile Mhic Gormáin', 1, 'baile-mhic-gormain'),
(275473, 781480, 'ie', 'Innfield', 1, 'innfield'),
(275474, 781480, 'ie', 'Drumone', 1, 'drumone'),
(275475, 781480, 'ie', 'Drumcondra', 1, 'drumcondra'),
(275476, 781480, 'ie', 'Donore', 1, 'donore'),
(275477, 781480, 'ie', 'Donacarney', 1, 'donacarney'),
(275478, 781480, 'ie', 'Clonee', 1, 'clonee'),
(275479, 781480, 'ie', 'Clonard', 1, 'clonard'),
(275480, 781480, 'ie', 'Castlejordan', 1, 'castlejordan'),
(275481, 781480, 'ie', 'Carnaross', 1, 'carnaross'),
(275482, 781480, 'ie', 'Carlanstown', 1, 'carlanstown'),
(275483, 781480, 'ie', 'Baile an Bhiataigh', 1, 'baile-an-bhiataigh'),
(275484, 781480, 'ie', 'Batterstown', 1, 'batterstown'),
(275485, 781480, 'ie', 'Balrath', 1, 'balrath'),
(275486, 781480, 'ie', 'Baile Íomhair', 1, 'baile-iomhair'),
(275487, 781480, 'ie', 'Ardcath', 1, 'ardcath'),
(275488, 781480, 'ie', 'Ballinabrackey', 1, 'ballinabrackey'),
(275489, 781480, 'ie', 'Bellewstown', 1, 'bellewstown'),
(275490, 781480, 'ie', 'Athlumney', 1, 'athlumney'),
(275491, 781480, 'ie', 'Bullstown', 1, 'bullstown'),
(275492, 781480, 'ie', 'Castletown', 1, 'castletown'),
(275493, 781480, 'ie', 'Clonmellon', 1, 'clonmellon'),
(275494, 781480, 'ie', 'Drogheda', 1, 'drogheda'),
(275495, 781480, 'ie', 'Drumree', 1, 'drumree'),
(275496, 781480, 'ie', 'Dunsany', 1, 'dunsany'),
(275497, 781480, 'ie', 'Fordstown', 1, 'fordstown'),
(275498, 781480, 'ie', 'Garristown', 1, 'garristown'),
(275499, 781480, 'ie', 'Hammondtown', 1, 'hammondtown'),
(275500, 781480, 'ie', 'Jordanstown', 1, 'jordanstown'),
(275501, 781480, 'ie', 'Kentstown', 1, 'kentstown'),
(275502, 781480, 'ie', 'Kilcloon', 1, 'kilcloon'),
(275503, 781480, 'ie', 'Kilcock', 1, 'kilcock'),
(275504, 781480, 'ie', 'Oldtown', 1, 'oldtown'),
(275505, 781480, 'ie', 'Stamullen', 1, 'stamullen'),
(275506, 781480, 'ie', 'Tara', 1, 'tara'),
(275507, 781480, 'ie', 'The Ward', 1, 'the-ward'),
(275508, 781480, 'ie', 'Athboy', 1, 'athboy'),
(275509, 781480, 'ie', 'Trim', 1, 'trim'),
(275510, 781480, 'ie', 'Duleek', 1, 'duleek'),
(275511, 781480, 'ie', 'Dunshaughlin', 1, 'dunshaughlin'),
(275512, 781480, 'ie', 'Ratoath', 1, 'ratoath'),
(275513, 781480, 'ie', 'Kells', 1, 'kells'),
(275514, 781480, 'ie', 'Laytown', 1, 'laytown'),
(275515, 781480, 'ie', 'Dunboyne', 1, 'dunboyne'),
(275516, 781480, 'ie', 'Ashbourne', 1, 'ashbourne'),
(275517, 781480, 'ie', 'Navan', 1, 'navan');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781481, 'ie', 'Monaghan', 1, 'monaghan');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275518, 781481, 'ie', 'Smithborough', 1, 'smithborough'),
(275519, 781481, 'ie', 'Scairbh na gCaorach', 1, 'scairbh-na-gcaorach'),
(275520, 781481, 'ie', 'Clontibret', 1, 'clontibret'),
(275521, 781481, 'ie', 'Béal Átha na Beithe', 1, 'beal-atha-na-beithe'),
(275522, 781481, 'ie', 'Ballinode', 1, 'ballinode'),
(275523, 781481, 'ie', 'Monaghan Town', 1, 'monaghan-town'),
(275524, 781481, 'ie', 'Scottstown', 1, 'scottstown'),
(275525, 781481, 'ie', 'Clones', 1, 'clones'),
(275526, 781481, 'ie', 'Castleblayney', 1, 'castleblayney'),
(275527, 781481, 'ie', 'Carrickmacross', 1, 'carrickmacross');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781482, 'ie', 'Offaly', 1, 'offaly');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275528, 781482, 'ie', 'Shinrone', 1, 'shinrone'),
(275529, 781482, 'ie', 'Droichead na Sionainne', 1, 'droichead-na-sionainne'),
(275530, 781482, 'ie', 'Rhode', 1, 'rhode'),
(275531, 781482, 'ie', 'An Daingean', 1, 'an-daingean'),
(275532, 781482, 'ie', 'Moneygall', 1, 'moneygall'),
(275533, 781482, 'ie', 'Cionn Eitigh', 1, 'cionn-eitigh'),
(275534, 781482, 'ie', 'Cill Aichidh', 1, 'cill-aichidh'),
(275535, 781482, 'ie', 'Géisill', 1, 'geisill'),
(275536, 781482, 'ie', 'An Féar Bán', 1, 'an-fear-ban'),
(275537, 781482, 'ie', 'An Clochán', 1, 'an-clochan'),
(275538, 781482, 'ie', 'Bracknagh', 1, 'bracknagh'),
(275539, 781482, 'ie', 'Béal Átha Chomair', 1, 'beal-atha-chomair'),
(275540, 781482, 'ie', 'Ballinagar', 1, 'ballinagar'),
(275541, 781482, 'ie', 'Clonbullogue', 1, 'clonbullogue'),
(275542, 781482, 'ie', 'Horseleap', 1, 'horseleap'),
(275543, 781482, 'ie', 'Kilcormac', 1, 'kilcormac'),
(275544, 781482, 'ie', 'Banagher', 1, 'banagher'),
(275545, 781482, 'ie', 'Clara', 1, 'clara'),
(275546, 781482, 'ie', 'Birr', 1, 'birr'),
(275547, 781482, 'ie', 'Edenderry', 1, 'edenderry'),
(275548, 781482, 'ie', 'Tullamore', 1, 'tullamore');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781483, 'ie', 'Roscommon', 1, 'roscommon');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275549, 781483, 'ie', 'Tulsk', 1, 'tulsk'),
(275550, 781483, 'ie', 'Béal na mBuillí', 1, 'beal-na-mbuilli'),
(275551, 781483, 'ie', 'Rúscaigh', 1, 'ruscaigh'),
(275552, 781483, 'ie', 'Knockvicar Bridge', 1, 'knockvicar-bridge'),
(275553, 781483, 'ie', 'Cnoc an Chrochaire', 1, 'cnoc-an-chrochaire'),
(275554, 781483, 'ie', 'Frenchpark', 1, 'frenchpark'),
(275555, 781483, 'ie', 'Ail Finn', 1, 'ail-finn'),
(275556, 781483, 'ie', 'Cootehall', 1, 'cootehall'),
(275557, 781483, 'ie', 'Ballydangan', 1, 'ballydangan'),
(275558, 781483, 'ie', 'Ballinlough', 1, 'ballinlough'),
(275559, 781483, 'ie', 'Athleague', 1, 'athleague'),
(275560, 781483, 'ie', 'Arigna', 1, 'arigna'),
(275561, 781483, 'ie', 'Corrigeenroe', 1, 'corrigeenroe'),
(275562, 781483, 'ie', 'Cloonfad', 1, 'cloonfad'),
(275563, 781483, 'ie', 'Athlone East', 1, 'athlone-east'),
(275564, 781483, 'ie', 'Athlone West', 1, 'athlone-west'),
(275565, 781483, 'ie', 'Ballagh', 1, 'ballagh'),
(275566, 781483, 'ie', 'Ballaghadereen', 1, 'ballaghadereen'),
(275567, 781483, 'ie', 'Ballinagare', 1, 'ballinagare'),
(275568, 781483, 'ie', 'Ballinameen', 1, 'ballinameen'),
(275569, 781483, 'ie', 'Ballintubber', 1, 'ballintubber'),
(275570, 781483, 'ie', 'Ballyforan', 1, 'ballyforan'),
(275571, 781483, 'ie', 'Ballygar', 1, 'ballygar'),
(275572, 781483, 'ie', 'Ballyleague', 1, 'ballyleague'),
(275573, 781483, 'ie', 'Ballymoe', 1, 'ballymoe'),
(275574, 781483, 'ie', 'Brideswell', 1, 'brideswell'),
(275575, 781483, 'ie', 'Castlecoote', 1, 'castlecoote'),
(275576, 781483, 'ie', 'Castleplunkett', 1, 'castleplunkett'),
(275577, 781483, 'ie', 'Creggs', 1, 'creggs'),
(275578, 781483, 'ie', 'Croghan', 1, 'croghan'),
(275579, 781483, 'ie', 'Curraghboy', 1, 'curraghboy'),
(275580, 781483, 'ie', 'Derrane', 1, 'derrane'),
(275581, 781483, 'ie', 'Donamon', 1, 'donamon'),
(275582, 781483, 'ie', 'Dysart', 1, 'dysart'),
(275583, 781483, 'ie', 'Four Mile House', 1, 'four-mile-house'),
(275584, 781483, 'ie', 'Fuerty', 1, 'fuerty'),
(275585, 781483, 'ie', 'Gallowstown', 1, 'gallowstown'),
(275586, 781483, 'ie', 'Garranlahan', 1, 'garranlahan'),
(275587, 781483, 'ie', 'Keadue', 1, 'keadue'),
(275588, 781483, 'ie', 'Kilglass', 1, 'kilglass'),
(275589, 781483, 'ie', 'Kilmore', 1, 'kilmore'),
(275590, 781483, 'ie', 'Kilrooskey', 1, 'kilrooskey'),
(275591, 781483, 'ie', 'Kilteevan', 1, 'kilteevan'),
(275592, 781483, 'ie', 'Kiltoom', 1, 'kiltoom'),
(275593, 781483, 'ie', 'Lanesboro', 1, 'lanesboro'),
(275594, 781483, 'ie', 'Lecarrow', 1, 'lecarrow'),
(275595, 781483, 'ie', 'Lisacul', 1, 'lisacul'),
(275596, 781483, 'ie', 'Loughglynn', 1, 'loughglynn'),
(275597, 781483, 'ie', 'Mount Talbot', 1, 'mount-talbot'),
(275598, 781483, 'ie', 'Scramoge', 1, 'scramoge'),
(275599, 781483, 'ie', 'Tarmonbarry', 1, 'tarmonbarry'),
(275600, 781483, 'ie', 'Tibohine', 1, 'tibohine'),
(275601, 781483, 'ie', 'An Caisleán Riabhach', 1, 'an-caislean-riabhach'),
(275602, 781483, 'ie', 'Boyle', 1, 'boyle');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781484, 'ie', 'Sligo', 1, 'sligo');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275603, 781484, 'ie', 'Dromore West', 1, 'dromore-west'),
(275604, 781484, 'ie', 'Tobar an Choire', 1, 'tobar-an-choire'),
(275605, 781484, 'ie', 'Templeboy', 1, 'templeboy'),
(275606, 781484, 'ie', 'An Ros', 1, 'an-ros'),
(275607, 781484, 'ie', 'Baile idir dhá Abhainn', 1, 'baile-idir-dha-abhainn'),
(275608, 781484, 'ie', 'Mullaghmore', 1, 'mullaghmore'),
(275609, 781484, 'ie', 'An Leathros', 1, 'an-leathros'),
(275610, 781484, 'ie', 'Kilglass', 1, 'kilglass'),
(275611, 781484, 'ie', 'An Ghráinseach', 1, 'an-ghrainseach'),
(275612, 781484, 'ie', 'Drumfin', 1, 'drumfin'),
(275613, 781484, 'ie', 'Drumcliff', 1, 'drumcliff'),
(275614, 781484, 'ie', 'Curry', 1, 'curry'),
(275615, 781484, 'ie', 'Cúil Áine', 1, 'cuil-aine'),
(275616, 781484, 'ie', 'Cúil Mhuine', 1, 'cuil-mhuine'),
(275617, 781484, 'ie', 'Carney', 1, 'carney'),
(275618, 781484, 'ie', 'Beltra', 1, 'beltra'),
(275619, 781484, 'ie', 'Baile an Mhóta', 1, 'baile-an-mhota'),
(275620, 781484, 'ie', 'Ballintogher', 1, 'ballintogher'),
(275621, 781484, 'ie', 'Béal an Átha Fada', 1, 'beal-an-atha-fada'),
(275622, 781484, 'ie', 'Aclare', 1, 'aclare'),
(275623, 781484, 'ie', 'Culfadda', 1, 'culfadda'),
(275624, 781484, 'ie', 'Castlebaldwin', 1, 'castlebaldwin'),
(275625, 781484, 'ie', 'Achonry', 1, 'achonry'),
(275626, 781484, 'ie', 'Ballygawley', 1, 'ballygawley'),
(275627, 781484, 'ie', 'Knocknahur', 1, 'knocknahur'),
(275628, 781484, 'ie', 'Carrowmore', 1, 'carrowmore'),
(275629, 781484, 'ie', 'Ballinacarrow', 1, 'ballinacarrow'),
(275630, 781484, 'ie', 'Ballinode', 1, 'ballinode'),
(275631, 781484, 'ie', 'Ballisodare', 1, 'ballisodare'),
(275632, 781484, 'ie', 'Ballyrush', 1, 'ballyrush'),
(275633, 781484, 'ie', 'Bunduff', 1, 'bunduff'),
(275634, 781484, 'ie', 'Buntra', 1, 'buntra'),
(275635, 781484, 'ie', 'Calry', 1, 'calry'),
(275636, 781484, 'ie', 'Cliffoney', 1, 'cliffoney'),
(275637, 781484, 'ie', 'Doocastle', 1, 'doocastle'),
(275638, 781484, 'ie', 'Dunally', 1, 'dunally'),
(275639, 781484, 'ie', 'Easkey', 1, 'easkey'),
(275640, 781484, 'ie', 'East Sligo', 1, 'east-sligo'),
(275641, 781484, 'ie', 'Enniscrone', 1, 'enniscrone'),
(275642, 781484, 'ie', 'Gurteen', 1, 'gurteen'),
(275643, 781484, 'ie', 'Lissadell', 1, 'lissadell'),
(275644, 781484, 'ie', 'Maugheraboy', 1, 'maugheraboy'),
(275645, 781484, 'ie', 'Monasteraden', 1, 'monasteraden'),
(275646, 781484, 'ie', 'North Sligo', 1, 'north-sligo'),
(275647, 781484, 'ie', 'Rosscarbery', 1, 'rosscarbery'),
(275648, 781484, 'ie', 'Sligo City', 1, 'sligo-city'),
(275649, 781484, 'ie', 'South Sligo', 1, 'south-sligo'),
(275650, 781484, 'ie', 'Tonaphubble', 1, 'tonaphubble'),
(275651, 781484, 'ie', 'Tourlestrane', 1, 'tourlestrane'),
(275652, 781484, 'ie', 'West Sligo', 1, 'west-sligo');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781485, 'ie', 'Tipperary', 1, 'tipperary');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275653, 781485, 'ie', 'Terryglass', 1, 'terryglass'),
(275654, 781485, 'ie', 'Béal Átha Gabhann', 1, 'beal-atha-gabhann'),
(275655, 781485, 'ie', 'An Port Rua', 1, 'an-port-rua'),
(275656, 781485, 'ie', 'An Port Nua', 1, 'an-port-nua'),
(275657, 781485, 'ie', 'Newcastle', 1, 'newcastle'),
(275658, 781485, 'ie', 'Muileann na hUamhan', 1, 'muileann-na-huamhan'),
(275659, 781485, 'ie', 'Lisronagh', 1, 'lisronagh'),
(275660, 781485, 'ie', 'Lattin', 1, 'lattin'),
(275661, 781485, 'ie', 'Cill Náile', 1, 'cill-naile'),
(275662, 781485, 'ie', 'An Gabhailín', 1, 'an-gabhailin'),
(275663, 781485, 'ie', 'Garrykennedy', 1, 'garrykennedy'),
(275664, 781485, 'ie', 'Fethard', 1, 'fethard'),
(275665, 781485, 'ie', 'Imleach', 1, 'imleach'),
(275666, 781485, 'ie', 'Dundrum', 1, 'dundrum'),
(275667, 781485, 'ie', 'Dromineer', 1, 'dromineer'),
(275668, 781485, 'ie', 'Drangan', 1, 'drangan'),
(275669, 781485, 'ie', 'Coolbaun', 1, 'coolbaun'),
(275670, 781485, 'ie', 'Cloneen', 1, 'cloneen'),
(275671, 781485, 'ie', 'Cloghjordan', 1, 'cloghjordan'),
(275672, 781485, 'ie', 'An Cloichín', 1, 'an-cloichin'),
(275673, 781485, 'ie', 'Carrigahorig', 1, 'carrigahorig'),
(275674, 781485, 'ie', 'An Cheapach', 1, 'an-cheapach'),
(275675, 781485, 'ie', 'Burncourt', 1, 'burncourt'),
(275676, 781485, 'ie', 'Buiríos Uí Chéin', 1, 'buirios-ui-chein'),
(275677, 781485, 'ie', 'Birdhill', 1, 'birdhill'),
(275678, 781485, 'ie', 'An Bháinseach', 1, 'an-bhainseach'),
(275679, 781485, 'ie', 'Béal Átha Póirin', 1, 'beal-atha-poirin'),
(275680, 781485, 'ie', 'Ballymackey', 1, 'ballymackey'),
(275681, 781485, 'ie', 'Ballylooby', 1, 'ballylooby'),
(275682, 781485, 'ie', 'Ballinure', 1, 'ballinure'),
(275683, 781485, 'ie', 'Ballingarry', 1, 'ballingarry'),
(275684, 781485, 'ie', 'Ballina', 1, 'ballina'),
(275685, 781485, 'ie', 'Ardfinnan', 1, 'ardfinnan'),
(275686, 781485, 'ie', 'Kilcommon', 1, 'kilcommon'),
(275687, 781485, 'ie', 'Ballypatrick', 1, 'ballypatrick'),
(275688, 781485, 'ie', 'Newtown', 1, 'newtown'),
(275689, 781485, 'ie', 'Ballycommon', 1, 'ballycommon'),
(275690, 781485, 'ie', 'Clerahan', 1, 'clerahan'),
(275691, 781485, 'ie', 'Dolla', 1, 'dolla'),
(275692, 781485, 'ie', 'Kilsheelan', 1, 'kilsheelan'),
(275693, 781485, 'ie', 'Kilusty', 1, 'kilusty'),
(275694, 781485, 'ie', 'Knocklofty', 1, 'knocklofty'),
(275695, 781485, 'ie', 'New Inn', 1, 'new-inn'),
(275696, 781485, 'ie', 'Nine Mile House', 1, 'nine-mile-house'),
(275697, 781485, 'ie', 'Oola', 1, 'oola'),
(275698, 781485, 'ie', 'Puckane', 1, 'puckane'),
(275699, 781485, 'ie', 'Rosegreen', 1, 'rosegreen'),
(275700, 781485, 'ie', 'Tipperary Town', 1, 'tipperary-town'),
(275701, 781485, 'ie', 'Toomevara', 1, 'toomevara'),
(275702, 781485, 'ie', 'Templemore', 1, 'templemore'),
(275703, 781485, 'ie', 'Cashel', 1, 'cashel'),
(275704, 781485, 'ie', 'Cahir', 1, 'cahir'),
(275705, 781485, 'ie', 'Roscrea', 1, 'roscrea'),
(275706, 781485, 'ie', 'Nenagh', 1, 'nenagh'),
(275707, 781485, 'ie', 'Carrick-on-Suir', 1, 'carrick-on-suir'),
(275708, 781485, 'ie', 'Thurles', 1, 'thurles'),
(275709, 781485, 'ie', 'Clonmel', 1, 'clonmel');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781486, 'ie', 'Waterford', 1, 'waterford');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275710, 781486, 'ie', 'Tulach an Iarainn', 1, 'tulach-an-iarainn'),
(275711, 781486, 'ie', 'An tSráidbhaile', 1, 'an-tsraidbhaile'),
(275712, 781486, 'ie', 'Ringville', 1, 'ringville'),
(275713, 781486, 'ie', 'Port Lách', 1, 'port-lach'),
(275714, 781486, 'ie', 'An Pasáiste', 1, 'an-pasaiste'),
(275715, 781486, 'ie', 'Lios Mór', 1, 'lios-mor'),
(275716, 781486, 'ie', 'Knockanore', 1, 'knockanore'),
(275717, 781486, 'ie', 'Coill Mhic Thomáisín', 1, 'coill-mhic-thomaisin'),
(275718, 781486, 'ie', 'Dunhill', 1, 'dunhill'),
(275719, 781486, 'ie', 'Cheekpoint', 1, 'cheekpoint'),
(275720, 781486, 'ie', 'Ceapach Choinn', 1, 'ceapach-choinn'),
(275721, 781486, 'ie', 'Ballynamult', 1, 'ballynamult'),
(275722, 781486, 'ie', 'Ballymacarbry', 1, 'ballymacarbry'),
(275723, 781486, 'ie', 'An Baile Dubh', 1, 'an-baile-dubh'),
(275724, 781486, 'ie', 'Ardmore', 1, 'ardmore'),
(275725, 781486, 'ie', 'Annestown', 1, 'annestown'),
(275726, 781486, 'ie', 'Aglish', 1, 'aglish'),
(275727, 781486, 'ie', 'Lemybrien', 1, 'lemybrien'),
(275728, 781486, 'ie', 'Mahon Bridge', 1, 'mahon-bridge'),
(275729, 781486, 'ie', 'Woodstown', 1, 'woodstown'),
(275730, 781486, 'ie', 'Bonmahon', 1, 'bonmahon'),
(275731, 781486, 'ie', 'Carrick-beg', 1, 'carrick-beg'),
(275732, 781486, 'ie', 'Clonea-Power', 1, 'clonea-power'),
(275733, 781486, 'ie', 'Cork Road', 1, 'cork-road'),
(275734, 781486, 'ie', 'Dunmore Road', 1, 'dunmore-road'),
(275735, 781486, 'ie', 'Faithlegge', 1, 'faithlegge'),
(275736, 781486, 'ie', 'Ferrybank', 1, 'ferrybank'),
(275737, 781486, 'ie', 'Gracedieu', 1, 'gracedieu'),
(275738, 781486, 'ie', 'Grantstown', 1, 'grantstown'),
(275739, 781486, 'ie', 'Killowen', 1, 'killowen'),
(275740, 781486, 'ie', 'Kilmacow', 1, 'kilmacow'),
(275741, 781486, 'ie', 'Rathgormack', 1, 'rathgormack'),
(275742, 781486, 'ie', 'Tramore', 1, 'tramore'),
(275743, 781486, 'ie', 'Waterford City', 1, 'waterford-city'),
(275744, 781486, 'ie', 'Dunmore East', 1, 'dunmore-east'),
(275745, 781486, 'ie', 'Kill', 1, 'kill'),
(275746, 781486, 'ie', 'Dungarvan', 1, 'dungarvan');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781487, 'ie', 'Westmeath', 1, 'westmeath');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275747, 781487, 'ie', 'Bealach an Tirialaigh', 1, 'bealach-an-tirialaigh'),
(275748, 781487, 'ie', 'Droichead Chaisleán Loiste', 1, 'droichead-chaislean-loiste'),
(275749, 781487, 'ie', 'Ráth Eoghain', 1, 'rath-eoghain'),
(275750, 781487, 'ie', 'Raharney', 1, 'raharney'),
(275751, 781487, 'ie', 'Multyfarnham', 1, 'multyfarnham'),
(275752, 781487, 'ie', 'Milltownpass', 1, 'milltownpass'),
(275753, 781487, 'ie', 'Cionn Átha Gad', 1, 'cionn-atha-gad'),
(275754, 781487, 'ie', 'Cill Liúcainne', 1, 'cill-liucainne'),
(275755, 781487, 'ie', 'Cill Bheagáin', 1, 'cill-bheagain'),
(275756, 781487, 'ie', 'Glasson', 1, 'glasson'),
(275757, 781487, 'ie', 'Fore', 1, 'fore'),
(275758, 781487, 'ie', 'Delvin', 1, 'delvin'),
(275759, 781487, 'ie', 'An Chúil', 1, 'an-chuil'),
(275760, 781487, 'ie', 'Collinstown', 1, 'collinstown'),
(275761, 781487, 'ie', 'Ráistín', 1, 'raistin'),
(275762, 781487, 'ie', 'Castletown Gheoghegan', 1, 'castletown-gheoghegan'),
(275763, 781487, 'ie', 'Castlepollard', 1, 'castlepollard'),
(275764, 781487, 'ie', 'Baile na Carraige', 1, 'baile-na-carraige'),
(275765, 781487, 'ie', 'An Baile Mór', 1, 'an-baile-mor'),
(275766, 781487, 'ie', 'Ardmorney', 1, 'ardmorney'),
(275767, 781487, 'ie', 'An Móta', 1, 'an-mota'),
(275768, 781487, 'ie', 'Athlone East', 1, 'athlone-east'),
(275769, 781487, 'ie', 'Ballinagore', 1, 'ballinagore'),
(275770, 781487, 'ie', 'Ballinahown', 1, 'ballinahown'),
(275771, 781487, 'ie', 'Ballinalack', 1, 'ballinalack'),
(275772, 781487, 'ie', 'Ballykeeran', 1, 'ballykeeran'),
(275773, 781487, 'ie', 'Ballymahon', 1, 'ballymahon'),
(275774, 781487, 'ie', 'Ballynafid', 1, 'ballynafid'),
(275775, 781487, 'ie', 'Bracklin', 1, 'bracklin'),
(275776, 781487, 'ie', 'Clonard', 1, 'clonard'),
(275777, 781487, 'ie', 'Crookedwood', 1, 'crookedwood'),
(275778, 781487, 'ie', 'Drumraney', 1, 'drumraney'),
(275779, 781487, 'ie', 'Dysart', 1, 'dysart'),
(275780, 781487, 'ie', 'Geoghegan', 1, 'geoghegan'),
(275781, 781487, 'ie', 'Horseleap', 1, 'horseleap'),
(275782, 781487, 'ie', 'Lismacaffrey', 1, 'lismacaffrey'),
(275783, 781487, 'ie', 'Mount Temple', 1, 'mount-temple'),
(275784, 781487, 'ie', 'Moyvore', 1, 'moyvore'),
(275785, 781487, 'ie', 'Rathconrath', 1, 'rathconrath'),
(275786, 781487, 'ie', 'Streamstown', 1, 'streamstown'),
(275787, 781487, 'ie', 'Streete', 1, 'streete'),
(275788, 781487, 'ie', 'Tang', 1, 'tang'),
(275789, 781487, 'ie', 'Mullingar', 1, 'mullingar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781488, 'ie', 'Wexford', 1, 'wexford');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275790, 781488, 'ie', 'Wellingtonbridge', 1, 'wellingtonbridge'),
(275791, 781488, 'ie', 'Teach Munna', 1, 'teach-munna'),
(275792, 781488, 'ie', 'Rosslare', 1, 'rosslare'),
(275793, 781488, 'ie', 'Maolán na nGabhar', 1, 'maolan-na-ngabhar'),
(275794, 781488, 'ie', 'Monaseed', 1, 'monaseed'),
(275795, 781488, 'ie', 'Cill Téile', 1, 'cill-teile'),
(275796, 781488, 'ie', 'Kilrane', 1, 'kilrane'),
(275797, 781488, 'ie', 'Cill Mhucraise', 1, 'cill-mhucraise'),
(275798, 781488, 'ie', 'Cé na Cille Móire', 1, 'ce-na-cille-moire'),
(275799, 781488, 'ie', 'Killinick', 1, 'killinick'),
(275800, 781488, 'ie', 'Inch', 1, 'inch'),
(275801, 781488, 'ie', 'Hollyfort', 1, 'hollyfort'),
(275802, 781488, 'ie', 'Fiodh Ard', 1, 'fiodh-ard'),
(275803, 781488, 'ie', 'Fearna', 1, 'fearna'),
(275804, 781488, 'ie', 'Duncannon', 1, 'duncannon'),
(275805, 781488, 'ie', 'Crossabeg', 1, 'crossabeg'),
(275806, 781488, 'ie', 'Craanford', 1, 'craanford'),
(275807, 781488, 'ie', 'Baile na Cúirte', 1, 'baile-na-cuirte'),
(275808, 781488, 'ie', 'Cúil Ghréine', 1, 'cuil-ghreine'),
(275809, 781488, 'ie', 'Cluain an Róistigh', 1, 'cluain-an-roistigh'),
(275810, 781488, 'ie', 'Clogh', 1, 'clogh'),
(275811, 781488, 'ie', 'Droichead an Chaisleáin', 1, 'droichead-an-chaisleain'),
(275812, 781488, 'ie', 'Ceann Poill', 1, 'ceann-poill'),
(275813, 781488, 'ie', 'Camolin', 1, 'camolin'),
(275814, 781488, 'ie', 'Bun Clóidi', 1, 'bun-cloidi'),
(275815, 781488, 'ie', 'Bree', 1, 'bree'),
(275816, 781488, 'ie', 'An Abhainn Dubh', 1, 'an-abhainn-dubh'),
(275817, 781488, 'ie', 'Ballygarrett', 1, 'ballygarrett'),
(275818, 781488, 'ie', 'Ballycullane', 1, 'ballycullane'),
(275819, 781488, 'ie', 'Baile Uí Chonnmhaí', 1, 'baile-ui-chonnmhai'),
(275820, 781488, 'ie', 'Arthurstown', 1, 'arthurstown'),
(275821, 781488, 'ie', 'Castletown', 1, 'castletown'),
(275822, 781488, 'ie', 'Annagh', 1, 'annagh'),
(275823, 781488, 'ie', 'Ardamine', 1, 'ardamine'),
(275824, 781488, 'ie', 'Balledmond', 1, 'balledmond'),
(275825, 781488, 'ie', 'Ballymoney', 1, 'ballymoney'),
(275826, 781488, 'ie', 'Clonegal', 1, 'clonegal'),
(275827, 781488, 'ie', 'Creagh', 1, 'creagh'),
(275828, 781488, 'ie', 'Curracloe', 1, 'curracloe'),
(275829, 781488, 'ie', 'Foulksmills', 1, 'foulksmills'),
(275830, 781488, 'ie', 'Kilanerin', 1, 'kilanerin'),
(275831, 781488, 'ie', 'Kilrush', 1, 'kilrush'),
(275832, 781488, 'ie', 'Piercestown', 1, 'piercestown'),
(275833, 781488, 'ie', 'Raheenagurran', 1, 'raheenagurran'),
(275834, 781488, 'ie', 'Rosslare Strand', 1, 'rosslare-strand'),
(275835, 781488, 'ie', 'St. Helens', 1, 'st-helens'),
(275836, 781488, 'ie', 'Tara Hill', 1, 'tara-hill'),
(275837, 781488, 'ie', 'Wexford Town', 1, 'wexford-town'),
(275838, 781488, 'ie', 'Gorey', 1, 'gorey'),
(275839, 781488, 'ie', 'New Ross', 1, 'new-ross'),
(275840, 781488, 'ie', 'Enniscorthy', 1, 'enniscorthy');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(781489, 'ie', 'Wicklow', 1, 'wicklow');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(275841, 781489, 'ie', 'Woodenbridge', 1, 'woodenbridge'),
(275842, 781489, 'ie', 'An Tóchar', 1, 'an-tochar'),
(275843, 781489, 'ie', 'Tinahely', 1, 'tinahely'),
(275844, 781489, 'ie', 'Shillelagh', 1, 'shillelagh'),
(275845, 781489, 'ie', 'An Chrois Dhearg', 1, 'an-chrois-dhearg'),
(275846, 781489, 'ie', 'Ráth Naoi', 1, 'rath-naoi'),
(275847, 781489, 'ie', 'Rathdangan', 1, 'rathdangan'),
(275848, 781489, 'ie', 'Abhóca', 1, 'abhoca'),
(275849, 781489, 'ie', 'An Caisleán Nua', 1, 'an-caislean-nua'),
(275850, 781489, 'ie', 'Knockananna', 1, 'knockananna'),
(275851, 781489, 'ie', 'Kiltegan', 1, 'kiltegan'),
(275852, 781489, 'ie', 'Cillín Chaoimhín', 1, 'cillin-chaoimhin'),
(275853, 781489, 'ie', 'Gleann Fhaidhle', 1, 'gleann-fhaidhle'),
(275854, 781489, 'ie', 'Dún Luáin', 1, 'dun-luain'),
(275855, 781489, 'ie', 'Dún Ard', 1, 'dun-ard'),
(275856, 781489, 'ie', 'Delgany', 1, 'delgany'),
(275857, 781489, 'ie', 'Carn an Bhua', 1, 'carn-an-bhua'),
(275858, 781489, 'ie', 'Baltinglass', 1, 'baltinglass'),
(275859, 781489, 'ie', 'Eachroim', 1, 'eachroim'),
(275860, 781489, 'ie', 'Grange Con', 1, 'grange-con'),
(275861, 781489, 'ie', 'Ath na Fuinseoige', 1, 'ath-na-fuinseoige'),
(275862, 781489, 'ie', 'Kilpedder', 1, 'kilpedder'),
(275863, 781489, 'ie', 'Aughavannagh', 1, 'aughavannagh'),
(275864, 781489, 'ie', 'Brittas', 1, 'brittas'),
(275865, 781489, 'ie', 'Brittas Bay', 1, 'brittas-bay'),
(275866, 781489, 'ie', 'Glen of Imaal', 1, 'glen-of-imaal'),
(275867, 781489, 'ie', 'Glendalough', 1, 'glendalough'),
(275868, 781489, 'ie', 'Glenmalure', 1, 'glenmalure'),
(275869, 781489, 'ie', 'Kilmacanogue', 1, 'kilmacanogue'),
(275870, 781489, 'ie', 'Kilquade', 1, 'kilquade'),
(275871, 781489, 'ie', 'Lacken', 1, 'lacken'),
(275872, 781489, 'ie', 'Newtownmountkennedy', 1, 'newtownmountkennedy'),
(275873, 781489, 'ie', 'Stratford-on-Slaney', 1, 'stratford-on-slaney'),
(275874, 781489, 'ie', 'Laragh', 1, 'laragh'),
(275875, 781489, 'ie', 'Rathdrum', 1, 'rathdrum'),
(275876, 781489, 'ie', 'Enniskerry', 1, 'enniskerry'),
(275877, 781489, 'ie', 'Kilcoole', 1, 'kilcoole'),
(275878, 781489, 'ie', 'Blessington', 1, 'blessington'),
(275879, 781489, 'ie', 'Arklow', 1, 'arklow'),
(275880, 781489, 'ie', 'Greystones', 1, 'greystones'),
(275881, 781489, 'ie', 'Bray', 1, 'bray');

