REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('BE', 'Belgium', 'belgium', '32', 'België', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001381, 'BE', 'Antwerp', 1, 'antwerp');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001376, 'BE', 'Brussels-Capital Region', 1, 'brussels-capital-region');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1008693, 1001376, 'BE', 'Brussels', 1, 'brussels', 50.85045000, 4.34878000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001377, 'BE', 'East Flanders', 1, 'east-flanders');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001373, 'BE', 'Flanders', 1, 'flanders');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1008608, 1001373, 'BE', 'Aalst', 1, 'aalst', 50.93604000, 4.03550000),
(1008609, 1001373, 'BE', 'Aalter', 1, 'aalter', 51.09017000, 3.44693000),
(1008610, 1001373, 'BE', 'Aarschot', 1, 'aarschot', 50.98715000, 4.83695000),
(1008611, 1001373, 'BE', 'Aartselaar', 1, 'aartselaar', 51.13412000, 4.38678000),
(1008613, 1001373, 'BE', 'Alken', 1, 'alken', 50.87553000, 5.30558000),
(1008614, 1001373, 'BE', 'Alveringem', 1, 'alveringem', 51.01238000, 2.71117000),
(1008623, 1001373, 'BE', 'Antwerpen', 1, 'antwerpen', 51.21989000, 4.40346000),
(1008624, 1001373, 'BE', 'Anzegem', 1, 'anzegem', 50.83700000, 3.47786000),
(1008625, 1001373, 'BE', 'Ardooie', 1, 'ardooie', 50.97570000, 3.19736000),
(1008626, 1001373, 'BE', 'Arendonk', 1, 'arendonk', 51.32267000, 5.08289000),
(1008628, 1001373, 'BE', 'As', 1, 'as', 51.00755000, 5.58453000),
(1008629, 1001373, 'BE', 'Asse', 1, 'asse', 50.91011000, 4.19836000),
(1008630, 1001373, 'BE', 'Assenede', 1, 'assenede', 51.22598000, 3.75085000),
(1008636, 1001373, 'BE', 'Avelgem', 1, 'avelgem', 50.77618000, 3.44502000),
(1008639, 1001373, 'BE', 'Baarle-Hertog', 1, 'baarle-hertog', 51.40504000, 4.89226000),
(1008641, 1001373, 'BE', 'Balen', 1, 'balen', 51.16837000, 5.17027000),
(1008648, 1001373, 'BE', 'Beernem', 1, 'beernem', 51.13981000, 3.33896000),
(1008649, 1001373, 'BE', 'Beerse', 1, 'beerse', 51.31927000, 4.85304000),
(1008650, 1001373, 'BE', 'Beersel', 1, 'beersel', 50.76589000, 4.30020000),
(1008651, 1001373, 'BE', 'Begijnendijk', 1, 'begijnendijk', 51.01942000, 4.78377000),
(1008652, 1001373, 'BE', 'Bekkevoort', 1, 'bekkevoort', 50.94074000, 4.96900000),
(1008654, 1001373, 'BE', 'Beringen', 1, 'beringen', 51.04954000, 5.22606000),
(1008655, 1001373, 'BE', 'Berlaar', 1, 'berlaar', 51.11760000, 4.65835000),
(1008656, 1001373, 'BE', 'Berlare', 1, 'berlare', 51.03333000, 4.00000000),
(1008659, 1001373, 'BE', 'Bertem', 1, 'bertem', 50.86403000, 4.62918000),
(1008662, 1001373, 'BE', 'Bever', 1, 'bever', 50.91667000, 4.31667000),
(1008663, 1001373, 'BE', 'Beveren', 1, 'beveren', 51.21187000, 4.25633000),
(1008665, 1001373, 'BE', 'Bierbeek', 1, 'bierbeek', 50.82876000, 4.75949000),
(1008666, 1001373, 'BE', 'Bilzen', 1, 'bilzen', 50.87325000, 5.51840000),
(1008669, 1001373, 'BE', 'Blankenberge', 1, 'blankenberge', 51.31306000, 3.13227000),
(1008671, 1001373, 'BE', 'Bocholt', 1, 'bocholt', 51.17337000, 5.57994000),
(1008672, 1001373, 'BE', 'Boechout', 1, 'boechout', 51.15959000, 4.49195000),
(1008673, 1001373, 'BE', 'Bonheiden', 1, 'bonheiden', 51.02261000, 4.54714000),
(1008674, 1001373, 'BE', 'Boom', 1, 'boom', 51.09242000, 4.37170000),
(1008675, 1001373, 'BE', 'Boortmeerbeek', 1, 'boortmeerbeek', 50.97929000, 4.57443000),
(1008676, 1001373, 'BE', 'Borgloon', 1, 'borgloon', 50.80505000, 5.34366000),
(1008677, 1001373, 'BE', 'Bornem', 1, 'bornem', 51.09716000, 4.24364000),
(1008678, 1001373, 'BE', 'Borsbeek', 1, 'borsbeek', 51.19661000, 4.48543000),
(1008681, 1001373, 'BE', 'Boutersem', 1, 'boutersem', 50.83511000, 4.83450000),
(1008686, 1001373, 'BE', 'Brasschaat', 1, 'brasschaat', 51.29120000, 4.49182000),
(1008687, 1001373, 'BE', 'Brecht', 1, 'brecht', 51.35024000, 4.63829000),
(1008688, 1001373, 'BE', 'Bredene', 1, 'bredene', 51.23489000, 2.97559000),
(1008689, 1001373, 'BE', 'Bree', 1, 'bree', 51.14152000, 5.59690000),
(1008691, 1001373, 'BE', 'Brugge', 1, 'brugge', 51.20892000, 3.22424000),
(1008694, 1001373, 'BE', 'Buggenhout', 1, 'buggenhout', 51.01590000, 4.20173000),
(1008718, 1001373, 'BE', 'Damme', 1, 'damme', 51.25147000, 3.28144000),
(1008720, 1001373, 'BE', 'De Haan', 1, 'de-haan', 51.27261000, 3.03446000),
(1008721, 1001373, 'BE', 'De Panne', 1, 'de-panne', 51.09793000, 2.59368000),
(1008722, 1001373, 'BE', 'De Pinte', 1, 'de-pinte', 50.99339000, 3.64747000),
(1008723, 1001373, 'BE', 'Deerlijk', 1, 'deerlijk', 50.85337000, 3.35416000),
(1008724, 1001373, 'BE', 'Deinze', 1, 'deinze', 50.98175000, 3.53096000),
(1008725, 1001373, 'BE', 'Denderleeuw', 1, 'denderleeuw', 50.88506000, 4.07601000),
(1008726, 1001373, 'BE', 'Dendermonde', 1, 'dendermonde', 51.02869000, 4.10106000),
(1008727, 1001373, 'BE', 'Dentergem', 1, 'dentergem', 50.96429000, 3.41617000),
(1008728, 1001373, 'BE', 'Dessel', 1, 'dessel', 51.23855000, 5.11448000),
(1008729, 1001373, 'BE', 'Destelbergen', 1, 'destelbergen', 51.05952000, 3.79899000),
(1008730, 1001373, 'BE', 'Deurne', 1, 'deurne', 51.22134000, 4.46595000),
(1008731, 1001373, 'BE', 'Diegem', 1, 'diegem', 50.89727000, 4.43354000),
(1008732, 1001373, 'BE', 'Diepenbeek', 1, 'diepenbeek', 50.90769000, 5.41875000),
(1008733, 1001373, 'BE', 'Diest', 1, 'diest', 50.98923000, 5.05062000),
(1008734, 1001373, 'BE', 'Diksmuide', 1, 'diksmuide', 51.03248000, 2.86384000),
(1008735, 1001373, 'BE', 'Dilbeek', 1, 'dilbeek', 50.84799000, 4.25972000),
(1008741, 1001373, 'BE', 'Drogenbos', 1, 'drogenbos', 50.78733000, 4.31471000),
(1008742, 1001373, 'BE', 'Duffel', 1, 'duffel', 51.09554000, 4.50903000),
(1008744, 1001373, 'BE', 'Edegem', 1, 'edegem', 51.15662000, 4.44504000),
(1008745, 1001373, 'BE', 'Eeklo', 1, 'eeklo', 51.18703000, 3.55654000),
(1008751, 1001373, 'BE', 'Essen', 1, 'essen', 51.46791000, 4.46901000),
(1008755, 1001373, 'BE', 'Evergem', 1, 'evergem', 51.11306000, 3.70976000),
(1008773, 1001373, 'BE', 'Galmaarden', 1, 'galmaarden', 50.75389000, 3.97121000),
(1008774, 1001373, 'BE', 'Gavere', 1, 'gavere', 50.92917000, 3.66184000),
(1008776, 1001373, 'BE', 'Geel', 1, 'geel', 51.16557000, 4.98917000),
(1008778, 1001373, 'BE', 'Geetbets', 1, 'geetbets', 50.89431000, 5.11199000),
(1008781, 1001373, 'BE', 'Genk', 1, 'genk', 50.96500000, 5.50082000),
(1008782, 1001373, 'BE', 'Gent', 1, 'gent', 51.05000000, 3.71667000),
(1008783, 1001373, 'BE', 'Geraardsbergen', 1, 'geraardsbergen', 50.77343000, 3.88223000),
(1008786, 1001373, 'BE', 'Gingelom', 1, 'gingelom', 50.74792000, 5.13422000),
(1008787, 1001373, 'BE', 'Gistel', 1, 'gistel', 51.15612000, 2.96387000),
(1008788, 1001373, 'BE', 'Glabbeek', 1, 'glabbeek', 50.87267000, 4.95615000),
(1008789, 1001373, 'BE', 'Gooik', 1, 'gooik', 50.79443000, 4.11378000),
(1008792, 1001373, 'BE', 'Grimbergen', 1, 'grimbergen', 50.93409000, 4.37213000),
(1008793, 1001373, 'BE', 'Grobbendonk', 1, 'grobbendonk', 51.19043000, 4.73562000),
(1008794, 1001373, 'BE', 'Haacht', 1, 'haacht', 50.97737000, 4.63777000),
(1008795, 1001373, 'BE', 'Haaltert', 1, 'haaltert', 50.90634000, 4.00093000),
(1008797, 1001373, 'BE', 'Halen', 1, 'halen', 50.94837000, 5.11096000),
(1008798, 1001373, 'BE', 'Halle', 1, 'halle', 50.73385000, 4.23454000),
(1008799, 1001373, 'BE', 'Hamme', 1, 'hamme', 51.09822000, 4.13705000),
(1008803, 1001373, 'BE', 'Harelbeke', 1, 'harelbeke', 50.85343000, 3.30935000),
(1008804, 1001373, 'BE', 'Hasselt', 1, 'hasselt', 50.93106000, 5.33781000),
(1008807, 1001373, 'BE', 'Heers', 1, 'heers', 50.75383000, 5.30210000),
(1008808, 1001373, 'BE', 'Heist-op-den-Berg', 1, 'heist-op-den-berg', 51.07537000, 4.72827000),
(1008809, 1001373, 'BE', 'Helchteren', 1, 'helchteren', 51.05591000, 5.38244000),
(1008810, 1001373, 'BE', 'Hemiksem', 1, 'hemiksem', 51.14484000, 4.33874000),
(1008813, 1001373, 'BE', 'Herent', 1, 'herent', 50.90861000, 4.67056000),
(1008814, 1001373, 'BE', 'Herentals', 1, 'herentals', 51.17655000, 4.83248000),
(1008815, 1001373, 'BE', 'Herenthout', 1, 'herenthout', 51.14010000, 4.75572000),
(1008816, 1001373, 'BE', 'Herk-de-Stad', 1, 'herk-de-stad', 50.94013000, 5.16636000),
(1008817, 1001373, 'BE', 'Herne', 1, 'herne', 50.72423000, 4.03481000),
(1008818, 1001373, 'BE', 'Herselt', 1, 'herselt', 51.05159000, 4.88231000),
(1008821, 1001373, 'BE', 'Herzele', 1, 'herzele', 50.88681000, 3.89014000),
(1008822, 1001373, 'BE', 'Heusden', 1, 'heusden', 51.03664000, 5.28013000),
(1008823, 1001373, 'BE', 'Hoboken', 1, 'hoboken', 51.17611000, 4.34844000),
(1008824, 1001373, 'BE', 'Hoegaarden', 1, 'hoegaarden', 50.77560000, 4.88952000),
(1008825, 1001373, 'BE', 'Hoeilaart', 1, 'hoeilaart', 50.76730000, 4.46835000),
(1008826, 1001373, 'BE', 'Hoeselt', 1, 'hoeselt', 50.84714000, 5.48767000),
(1008827, 1001373, 'BE', 'Holsbeek', 1, 'holsbeek', 50.92097000, 4.75747000),
(1008828, 1001373, 'BE', 'Hooglede', 1, 'hooglede', 50.98333000, 3.08333000),
(1008829, 1001373, 'BE', 'Hoogstraten', 1, 'hoogstraten', 51.40029000, 4.76034000),
(1008832, 1001373, 'BE', 'Houthalen', 1, 'houthalen', 51.03427000, 5.37429000),
(1008833, 1001373, 'BE', 'Houthulst', 1, 'houthulst', 50.97824000, 2.95050000),
(1008835, 1001373, 'BE', 'Hove', 1, 'hove', 51.15446000, 4.47070000),
(1008836, 1001373, 'BE', 'Huldenberg', 1, 'huldenberg', 50.78939000, 4.58310000),
(1008837, 1001373, 'BE', 'Hulshout', 1, 'hulshout', 51.07451000, 4.79081000),
(1008840, 1001373, 'BE', 'Ichtegem', 1, 'ichtegem', 51.09572000, 3.01549000),
(1008841, 1001373, 'BE', 'Ieper', 1, 'ieper', 50.85114000, 2.88569000),
(1008843, 1001373, 'BE', 'Ingelmunster', 1, 'ingelmunster', 50.92081000, 3.25571000),
(1008845, 1001373, 'BE', 'Izegem', 1, 'izegem', 50.91396000, 3.21378000),
(1008846, 1001373, 'BE', 'Jabbeke', 1, 'jabbeke', 51.18185000, 3.08935000),
(1008851, 1001373, 'BE', 'Kalmthout', 1, 'kalmthout', 51.38442000, 4.47556000),
(1008852, 1001373, 'BE', 'Kampenhout', 1, 'kampenhout', 50.94210000, 4.55103000),
(1008853, 1001373, 'BE', 'Kapelle-op-den-Bos', 1, 'kapelle-op-den-bos', 51.00970000, 4.36303000),
(1008854, 1001373, 'BE', 'Kapellen', 1, 'kapellen', 51.31377000, 4.43539000),
(1008855, 1001373, 'BE', 'Kaprijke', 1, 'kaprijke', 51.21720000, 3.61519000),
(1008856, 1001373, 'BE', 'Kasterlee', 1, 'kasterlee', 51.24118000, 4.96651000),
(1008857, 1001373, 'BE', 'Keerbergen', 1, 'keerbergen', 51.00295000, 4.63434000),
(1008858, 1001373, 'BE', 'Kinrooi', 1, 'kinrooi', 51.14543000, 5.74207000),
(1008859, 1001373, 'BE', 'Knesselare', 1, 'knesselare', 51.13932000, 3.41282000),
(1008860, 1001373, 'BE', 'Knokke-Heist', 1, 'knokke-heist', 51.35000000, 3.26667000),
(1008861, 1001373, 'BE', 'Koekelare', 1, 'koekelare', 51.09047000, 2.97830000),
(1008862, 1001373, 'BE', 'Koksijde', 1, 'koksijde', 51.11642000, 2.63772000),
(1008863, 1001373, 'BE', 'Kontich', 1, 'kontich', 51.13213000, 4.44706000),
(1008864, 1001373, 'BE', 'Kortemark', 1, 'kortemark', 51.02951000, 3.04112000),
(1008865, 1001373, 'BE', 'Kortenaken', 1, 'kortenaken', 50.90862000, 5.05968000),
(1008866, 1001373, 'BE', 'Kortenberg', 1, 'kortenberg', 50.88982000, 4.54353000),
(1008867, 1001373, 'BE', 'Kortessem', 1, 'kortessem', 50.85890000, 5.38974000),
(1008868, 1001373, 'BE', 'Kortrijk', 1, 'kortrijk', 50.82803000, 3.26487000),
(1008869, 1001373, 'BE', 'Kraainem', 1, 'kraainem', 50.86155000, 4.46946000),
(1008870, 1001373, 'BE', 'Kruibeke', 1, 'kruibeke', 51.17048000, 4.31444000),
(1008871, 1001373, 'BE', 'Kruishoutem', 1, 'kruishoutem', 50.90168000, 3.52588000),
(1008872, 1001373, 'BE', 'Kuurne', 1, 'kuurne', 50.85143000, 3.28240000),
(1008878, 1001373, 'BE', 'Laarne', 1, 'laarne', 51.03078000, 3.85077000),
(1008879, 1001373, 'BE', 'Lanaken', 1, 'lanaken', 50.89318000, 5.64680000),
(1008880, 1001373, 'BE', 'Landen', 1, 'landen', 50.75267000, 5.08200000),
(1008881, 1001373, 'BE', 'Lebbeke', 1, 'lebbeke', 51.00464000, 4.13457000),
(1008882, 1001373, 'BE', 'Lede', 1, 'lede', 50.96626000, 3.98594000),
(1008883, 1001373, 'BE', 'Ledeberg', 1, 'ledeberg', 51.03859000, 3.74458000),
(1008884, 1001373, 'BE', 'Ledegem', 1, 'ledegem', 50.85785000, 3.12409000),
(1008885, 1001373, 'BE', 'Lendelede', 1, 'lendelede', 50.88626000, 3.23747000),
(1008887, 1001373, 'BE', 'Leopoldsburg', 1, 'leopoldsburg', 51.11667000, 5.25000000),
(1008889, 1001373, 'BE', 'Leuven', 1, 'leuven', 50.87959000, 4.70093000),
(1008891, 1001373, 'BE', 'Lichtervelde', 1, 'lichtervelde', 51.03333000, 3.15000000),
(1008892, 1001373, 'BE', 'Liedekerke', 1, 'liedekerke', 50.86892000, 4.08743000),
(1008893, 1001373, 'BE', 'Lier', 1, 'lier', 51.13128000, 4.57041000),
(1008895, 1001373, 'BE', 'Lille', 1, 'lille', 51.24197000, 4.82313000),
(1008898, 1001373, 'BE', 'Linkebeek', 1, 'linkebeek', 50.76781000, 4.33688000),
(1008899, 1001373, 'BE', 'Lint', 1, 'lint', 51.12707000, 4.49669000),
(1008902, 1001373, 'BE', 'Lochristi', 1, 'lochristi', 51.09644000, 3.83194000),
(1008903, 1001373, 'BE', 'Lokeren', 1, 'lokeren', 51.10364000, 3.99339000),
(1008904, 1001373, 'BE', 'Lommel', 1, 'lommel', 51.23074000, 5.31349000),
(1008905, 1001373, 'BE', 'Londerzeel', 1, 'londerzeel', 51.00468000, 4.30304000),
(1008908, 1001373, 'BE', 'Lovendegem', 1, 'lovendegem', 51.10168000, 3.61298000),
(1008909, 1001373, 'BE', 'Lubbeek', 1, 'lubbeek', 50.88278000, 4.83896000),
(1008910, 1001373, 'BE', 'Lummen', 1, 'lummen', 50.98772000, 5.19121000),
(1008912, 1001373, 'BE', 'Maaseik', 1, 'maaseik', 51.09802000, 5.78379000),
(1008913, 1001373, 'BE', 'Maasmechelen', 1, 'maasmechelen', 50.96545000, 5.69452000),
(1008914, 1001373, 'BE', 'Machelen', 1, 'machelen', 50.91061000, 4.44174000),
(1008915, 1001373, 'BE', 'Maldegem', 1, 'maldegem', 51.20737000, 3.44511000),
(1008922, 1001373, 'BE', 'Mechelen', 1, 'mechelen', 51.02574000, 4.47762000),
(1008923, 1001373, 'BE', 'Meerhout', 1, 'meerhout', 51.13210000, 5.07842000),
(1008924, 1001373, 'BE', 'Meise', 1, 'meise', 50.93934000, 4.32655000),
(1008926, 1001373, 'BE', 'Melle', 1, 'melle', 51.00232000, 3.80526000),
(1008927, 1001373, 'BE', 'Menen', 1, 'menen', 50.79722000, 3.12245000),
(1008929, 1001373, 'BE', 'Merchtem', 1, 'merchtem', 50.95129000, 4.23197000),
(1008930, 1001373, 'BE', 'Merelbeke', 1, 'merelbeke', 50.99447000, 3.74621000),
(1008931, 1001373, 'BE', 'Merksplas', 1, 'merksplas', 51.35851000, 4.86513000),
(1008934, 1001373, 'BE', 'Meulebeke', 1, 'meulebeke', 50.95136000, 3.28804000),
(1008935, 1001373, 'BE', 'Middelkerke', 1, 'middelkerke', 51.18532000, 2.82077000),
(1008937, 1001373, 'BE', 'Moerbeke', 1, 'moerbeke', 51.17409000, 3.93001000),
(1008938, 1001373, 'BE', 'Mol', 1, 'mol', 51.19188000, 5.11662000),
(1008943, 1001373, 'BE', 'Moorslede', 1, 'moorslede', 50.89190000, 3.06117000),
(1008945, 1001373, 'BE', 'Mortsel', 1, 'mortsel', 51.16697000, 4.45127000),
(1008951, 1001373, 'BE', 'Nazareth', 1, 'nazareth', 50.95686000, 3.59425000),
(1008952, 1001373, 'BE', 'Neerpelt', 1, 'neerpelt', 51.22807000, 5.44270000),
(1008954, 1001373, 'BE', 'Nevele', 1, 'nevele', 51.03531000, 3.54574000),
(1008955, 1001373, 'BE', 'Niel', 1, 'niel', 51.11096000, 4.33428000),
(1008956, 1001373, 'BE', 'Nieuwerkerken', 1, 'nieuwerkerken', 50.86380000, 5.19467000),
(1008957, 1001373, 'BE', 'Nieuwpoort', 1, 'nieuwpoort', 51.13008000, 2.75135000),
(1008958, 1001373, 'BE', 'Nijlen', 1, 'nijlen', 51.16096000, 4.67008000),
(1008959, 1001373, 'BE', 'Ninove', 1, 'ninove', 50.82776000, 4.02657000),
(1008963, 1001373, 'BE', 'Olen', 1, 'olen', 51.14391000, 4.85980000),
(1008966, 1001373, 'BE', 'Oostduinkerke', 1, 'oostduinkerke', 51.11565000, 2.68217000),
(1008967, 1001373, 'BE', 'Oosterzele', 1, 'oosterzele', 50.95261000, 3.79826000),
(1008968, 1001373, 'BE', 'Oostkamp', 1, 'oostkamp', 51.15432000, 3.23128000),
(1008969, 1001373, 'BE', 'Oostmalle', 1, 'oostmalle', 51.30000000, 4.73333000),
(1008970, 1001373, 'BE', 'Oostrozebeke', 1, 'oostrozebeke', 50.92093000, 3.33799000),
(1008971, 1001373, 'BE', 'Opglabbeek', 1, 'opglabbeek', 51.04258000, 5.58346000),
(1008972, 1001373, 'BE', 'Opwijk', 1, 'opwijk', 50.96724000, 4.18442000),
(1008974, 1001373, 'BE', 'Ostend', 1, 'ostend', 51.21551000, 2.92700000),
(1008976, 1001373, 'BE', 'Oud-Heverlee', 1, 'oud-heverlee', 50.83522000, 4.66421000),
(1008977, 1001373, 'BE', 'Oud-Turnhout', 1, 'oud-turnhout', 51.31978000, 4.98410000),
(1008978, 1001373, 'BE', 'Oudenaarde', 1, 'oudenaarde', 50.85168000, 3.60891000),
(1008979, 1001373, 'BE', 'Oudenburg', 1, 'oudenburg', 51.18489000, 3.00035000),
(1008982, 1001373, 'BE', 'Overijse', 1, 'overijse', 50.77436000, 4.53461000),
(1008983, 1001373, 'BE', 'Overpelt', 1, 'overpelt', 51.21038000, 5.41557000),
(1008986, 1001373, 'BE', 'Peer', 1, 'peer', 51.13030000, 5.45952000),
(1008987, 1001373, 'BE', 'Pepingen', 1, 'pepingen', 50.75922000, 4.15983000),
(1008989, 1001373, 'BE', 'Perre', 1, 'perre', 50.88914000, 3.86098000),
(1008992, 1001373, 'BE', 'Pittem', 1, 'pittem', 50.99279000, 3.26317000),
(1008995, 1001373, 'BE', 'Poperinge', 1, 'poperinge', 50.85386000, 2.72659000),
(1009002, 1001373, 'BE', 'Provincie Antwerpen', 1, 'provincie-antwerpen', 51.16558000, 4.83402000),
(1009003, 1001373, 'BE', 'Provincie Limburg', 1, 'provincie-limburg', 51.00000000, 5.50000000),
(1009004, 1001373, 'BE', 'Provincie Oost-Vlaanderen', 1, 'provincie-oost-vlaanderen', 51.00000000, 3.75000000),
(1009005, 1001373, 'BE', 'Provincie Vlaams-Brabant', 1, 'provincie-vlaams-brabant', 50.91667000, 4.58333000),
(1009006, 1001373, 'BE', 'Provincie West-Vlaanderen', 1, 'provincie-west-vlaanderen', 51.00000000, 3.00000000),
(1009007, 1001373, 'BE', 'Putte', 1, 'putte', 51.05337000, 4.63263000),
(1009008, 1001373, 'BE', 'Puurs', 1, 'puurs', 51.07409000, 4.28844000),
(1009015, 1001373, 'BE', 'Ranst', 1, 'ranst', 51.18983000, 4.56533000),
(1009016, 1001373, 'BE', 'Ravels', 1, 'ravels', 51.37274000, 4.99210000),
(1009020, 1001373, 'BE', 'Retie', 1, 'retie', 51.26652000, 5.08242000),
(1009021, 1001373, 'BE', 'Riemst', 1, 'riemst', 50.80995000, 5.60131000),
(1009022, 1001373, 'BE', 'Rijkevorsel', 1, 'rijkevorsel', 51.34795000, 4.76053000),
(1009025, 1001373, 'BE', 'Roeselare', 1, 'roeselare', 50.94653000, 3.12269000),
(1009027, 1001373, 'BE', 'Ronse', 1, 'ronse', 50.74574000, 3.60050000),
(1009028, 1001373, 'BE', 'Rotselaar', 1, 'rotselaar', 50.95302000, 4.71665000),
(1009030, 1001373, 'BE', 'Ruiselede', 1, 'ruiselede', 51.04039000, 3.39416000),
(1009032, 1001373, 'BE', 'Rumst', 1, 'rumst', 51.08153000, 4.42217000),
(1009039, 1001373, 'BE', 'Schelle', 1, 'schelle', 51.12615000, 4.34114000),
(1009040, 1001373, 'BE', 'Schilde', 1, 'schilde', 51.24107000, 4.58336000),
(1009041, 1001373, 'BE', 'Schoten', 1, 'schoten', 51.25251000, 4.50268000),
(1009045, 1001373, 'BE', 'Sint-Amands', 1, 'sint-amands', 51.05645000, 4.20957000),
(1009046, 1001373, 'BE', 'Sint-Genesius-Rode', 1, 'sint-genesius-rode', 50.74645000, 4.35754000),
(1009047, 1001373, 'BE', 'Sint-Gillis-Waas', 1, 'sint-gillis-waas', 51.21914000, 4.12374000),
(1009048, 1001373, 'BE', 'Sint-Joris', 1, 'sint-joris', 50.87117000, 5.27200000),
(1009049, 1001373, 'BE', 'Sint-Katelijne-Waver', 1, 'sint-katelijne-waver', 51.06691000, 4.53469000),
(1009050, 1001373, 'BE', 'Sint-Kruis', 1, 'sint-kruis', 51.21399000, 3.24949000),
(1009051, 1001373, 'BE', 'Sint-Laureins', 1, 'sint-laureins', 51.24202000, 3.52441000),
(1009052, 1001373, 'BE', 'Sint-Lievens-Houtem', 1, 'sint-lievens-houtem', 50.91970000, 3.86225000),
(1009053, 1001373, 'BE', 'Sint-Maria-Lierde', 1, 'sint-maria-lierde', 50.81867000, 3.84436000),
(1009054, 1001373, 'BE', 'Sint-Martens-Latem', 1, 'sint-martens-latem', 51.01459000, 3.63779000),
(1009055, 1001373, 'BE', 'Sint-Martens-Lennik', 1, 'sint-martens-lennik', 50.81158000, 4.16965000),
(1009056, 1001373, 'BE', 'Sint-Niklaas', 1, 'sint-niklaas', 51.16509000, 4.14370000),
(1009057, 1001373, 'BE', 'Sint-Pieters-Leeuw', 1, 'sint-pieters-leeuw', 50.77926000, 4.24355000),
(1009058, 1001373, 'BE', 'Sint-Pieters-Voeren', 1, 'sint-pieters-voeren', 50.73863000, 5.82224000),
(1009059, 1001373, 'BE', 'Sint-Truiden', 1, 'sint-truiden', 50.81679000, 5.18647000),
(1009066, 1001373, 'BE', 'Stabroek', 1, 'stabroek', 51.33189000, 4.37127000),
(1009067, 1001373, 'BE', 'Staden', 1, 'staden', 50.97456000, 3.01469000),
(1009069, 1001373, 'BE', 'Steenokkerzeel', 1, 'steenokkerzeel', 50.91851000, 4.50989000),
(1009070, 1001373, 'BE', 'Stekene', 1, 'stekene', 51.20990000, 4.03651000),
(1009073, 1001373, 'BE', 'Temse', 1, 'temse', 51.12794000, 4.21372000),
(1009075, 1001373, 'BE', 'Terkoest', 1, 'terkoest', 50.89832000, 5.27623000),
(1009076, 1001373, 'BE', 'Ternat', 1, 'ternat', 50.86654000, 4.16682000),
(1009077, 1001373, 'BE', 'Tervuren', 1, 'tervuren', 50.82372000, 4.51418000),
(1009078, 1001373, 'BE', 'Tessenderlo', 1, 'tessenderlo', 51.06513000, 5.08856000),
(1009081, 1001373, 'BE', 'Tielt', 1, 'tielt', 50.99931000, 3.32707000),
(1009082, 1001373, 'BE', 'Tienen', 1, 'tienen', 50.80745000, 4.93780000),
(1009085, 1001373, 'BE', 'Tongeren', 1, 'tongeren', 50.78054000, 5.46484000),
(1009086, 1001373, 'BE', 'Torhout', 1, 'torhout', 51.06560000, 3.10085000),
(1009088, 1001373, 'BE', 'Tremelo', 1, 'tremelo', 50.99231000, 4.70807000),
(1009092, 1001373, 'BE', 'Turnhout', 1, 'turnhout', 51.32254000, 4.94471000),
(1009096, 1001373, 'BE', 'Veurne', 1, 'veurne', 51.07316000, 2.66803000),
(1009100, 1001373, 'BE', 'Vilvoorde', 1, 'vilvoorde', 50.92814000, 4.42938000),
(1009103, 1001373, 'BE', 'Vorselaar', 1, 'vorselaar', 51.20243000, 4.77259000),
(1009104, 1001373, 'BE', 'Vosselaar', 1, 'vosselaar', 51.30856000, 4.88960000),
(1009105, 1001373, 'BE', 'Waarschoot', 1, 'waarschoot', 51.15250000, 3.60500000),
(1009106, 1001373, 'BE', 'Waasmunster', 1, 'waasmunster', 51.10572000, 4.08573000),
(1009107, 1001373, 'BE', 'Wachtebeke', 1, 'wachtebeke', 51.16852000, 3.87183000),
(1009112, 1001373, 'BE', 'Waregem', 1, 'waregem', 50.88898000, 3.42756000),
(1009118, 1001373, 'BE', 'Wellen', 1, 'wellen', 50.84096000, 5.33867000),
(1009120, 1001373, 'BE', 'Wemmel', 1, 'wemmel', 50.90812000, 4.30613000),
(1009121, 1001373, 'BE', 'Wenduine', 1, 'wenduine', 51.29830000, 3.08213000),
(1009122, 1001373, 'BE', 'Wervik', 1, 'wervik', 50.78069000, 3.03854000),
(1009123, 1001373, 'BE', 'Westerlo', 1, 'westerlo', 51.09049000, 4.91544000),
(1009124, 1001373, 'BE', 'Wetteren', 1, 'wetteren', 51.00526000, 3.88341000),
(1009125, 1001373, 'BE', 'Wevelgem', 1, 'wevelgem', 50.80000000, 3.16667000),
(1009126, 1001373, 'BE', 'Wezembeek-Oppem', 1, 'wezembeek-oppem', 50.83950000, 4.49427000),
(1009127, 1001373, 'BE', 'Wichelen', 1, 'wichelen', 51.00526000, 3.97683000),
(1009128, 1001373, 'BE', 'Wielsbeke', 1, 'wielsbeke', 50.90000000, 3.36667000),
(1009129, 1001373, 'BE', 'Wijnegem', 1, 'wijnegem', 51.22787000, 4.51895000),
(1009130, 1001373, 'BE', 'Willebroek', 1, 'willebroek', 51.06041000, 4.36019000),
(1009131, 1001373, 'BE', 'Wingene', 1, 'wingene', 51.05782000, 3.27359000),
(1009132, 1001373, 'BE', 'Wommelgem', 1, 'wommelgem', 51.20452000, 4.52250000),
(1009133, 1001373, 'BE', 'Wuustwezel', 1, 'wuustwezel', 51.39214000, 4.59546000),
(1009135, 1001373, 'BE', 'Zandhoven', 1, 'zandhoven', 51.21488000, 4.66164000),
(1009136, 1001373, 'BE', 'Zaventem', 1, 'zaventem', 50.88365000, 4.47298000),
(1009137, 1001373, 'BE', 'Zedelgem', 1, 'zedelgem', 51.14236000, 3.13680000),
(1009138, 1001373, 'BE', 'Zeebrugge', 1, 'zeebrugge', 51.32901000, 3.18188000),
(1009139, 1001373, 'BE', 'Zele', 1, 'zele', 51.06566000, 4.04030000),
(1009140, 1001373, 'BE', 'Zelzate', 1, 'zelzate', 51.18963000, 3.80777000),
(1009141, 1001373, 'BE', 'Zemst', 1, 'zemst', 50.98318000, 4.46079000),
(1009142, 1001373, 'BE', 'Zingem', 1, 'zingem', 50.90409000, 3.65305000),
(1009143, 1001373, 'BE', 'Zoersel', 1, 'zoersel', 51.26825000, 4.71296000),
(1009144, 1001373, 'BE', 'Zomergem', 1, 'zomergem', 51.11994000, 3.56496000),
(1009145, 1001373, 'BE', 'Zonhoven', 1, 'zonhoven', 50.99064000, 5.36819000),
(1009146, 1001373, 'BE', 'Zonnebeke', 1, 'zonnebeke', 50.87260000, 2.98725000),
(1009147, 1001373, 'BE', 'Zottegem', 1, 'zottegem', 50.86955000, 3.81052000),
(1009148, 1001373, 'BE', 'Zoutleeuw', 1, 'zoutleeuw', 50.83316000, 5.10376000),
(1009149, 1001373, 'BE', 'Zuienkerke', 1, 'zuienkerke', 51.26511000, 3.15506000),
(1009150, 1001373, 'BE', 'Zulte', 1, 'zulte', 50.91954000, 3.44859000),
(1009151, 1001373, 'BE', 'Zutendaal', 1, 'zutendaal', 50.93306000, 5.57530000),
(1009152, 1001373, 'BE', 'Zwevegem', 1, 'zwevegem', 50.81268000, 3.33848000),
(1009153, 1001373, 'BE', 'Zwijndrecht', 1, 'zwijndrecht', 51.21979000, 4.32664000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001374, 'BE', 'Flemish Brabant', 1, 'flemish-brabant');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001375, 'BE', 'Hainaut', 1, 'hainaut');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001384, 'BE', 'Liège', 1, 'liege');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001372, 'BE', 'Limburg', 1, 'limburg');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001379, 'BE', 'Luxembourg', 1, 'luxembourg');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001378, 'BE', 'Namur', 1, 'namur');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001380, 'BE', 'Wallonia', 1, 'wallonia');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1008612, 1001380, 'BE', 'Aiseau', 1, 'aiseau', 50.41158000, 4.58671000),
(1008615, 1001380, 'BE', 'Amay', 1, 'amay', 50.54829000, 5.30974000),
(1008616, 1001380, 'BE', 'Amblève', 1, 'ambleve', 50.35357000, 6.17002000),
(1008617, 1001380, 'BE', 'Andenne', 1, 'andenne', 50.48941000, 5.09513000),
(1008618, 1001380, 'BE', 'Anderlues', 1, 'anderlues', 50.40704000, 4.27136000),
(1008619, 1001380, 'BE', 'Anhée', 1, 'anhee', 50.31039000, 4.87827000),
(1008620, 1001380, 'BE', 'Ans', 1, 'ans', 50.66230000, 5.52029000),
(1008621, 1001380, 'BE', 'Anthisnes', 1, 'anthisnes', 50.48323000, 5.51900000),
(1008622, 1001380, 'BE', 'Antoing', 1, 'antoing', 50.56765000, 3.44920000),
(1008627, 1001380, 'BE', 'Arlon', 1, 'arlon', 49.68333000, 5.81667000),
(1008631, 1001380, 'BE', 'Assesse', 1, 'assesse', 50.36934000, 5.02204000),
(1008632, 1001380, 'BE', 'Ath', 1, 'ath', 50.62937000, 3.77801000),
(1008633, 1001380, 'BE', 'Attert', 1, 'attert', 49.75035000, 5.78634000),
(1008634, 1001380, 'BE', 'Aubange', 1, 'aubange', 49.56652000, 5.80492000),
(1008635, 1001380, 'BE', 'Aubel', 1, 'aubel', 50.70189000, 5.85812000),
(1008637, 1001380, 'BE', 'Awans', 1, 'awans', 50.66774000, 5.46329000),
(1008638, 1001380, 'BE', 'Aywaille', 1, 'aywaille', 50.47411000, 5.67684000),
(1008640, 1001380, 'BE', 'Baelen', 1, 'baelen', 50.63131000, 5.97433000),
(1008642, 1001380, 'BE', 'Basse Lasne', 1, 'basse-lasne', 50.69503000, 4.49218000),
(1008643, 1001380, 'BE', 'Bassenge', 1, 'bassenge', 50.75883000, 5.60989000),
(1008644, 1001380, 'BE', 'Bastogne', 1, 'bastogne', 50.00347000, 5.71844000),
(1008645, 1001380, 'BE', 'Beaumont', 1, 'beaumont', 50.23699000, 4.23926000),
(1008646, 1001380, 'BE', 'Beauraing', 1, 'beauraing', 50.11042000, 4.95554000),
(1008647, 1001380, 'BE', 'Beauvechain', 1, 'beauvechain', 50.78195000, 4.77180000),
(1008653, 1001380, 'BE', 'Beloeil', 1, 'beloeil', 50.55047000, 3.73484000),
(1008657, 1001380, 'BE', 'Berloz', 1, 'berloz', 50.69829000, 5.21236000),
(1008658, 1001380, 'BE', 'Bernissart', 1, 'bernissart', 50.47460000, 3.64961000),
(1008660, 1001380, 'BE', 'Bertogne', 1, 'bertogne', 50.08364000, 5.66689000),
(1008661, 1001380, 'BE', 'Bertrix', 1, 'bertrix', 49.85596000, 5.25539000),
(1008664, 1001380, 'BE', 'Beyne-Heusay', 1, 'beyne-heusay', 50.62251000, 5.66508000),
(1008668, 1001380, 'BE', 'Bièvre', 1, 'bievre', 49.94085000, 5.01591000),
(1008667, 1001380, 'BE', 'Binche', 1, 'binche', 50.41155000, 4.16469000),
(1008670, 1001380, 'BE', 'Blégny', 1, 'blegny', 50.67255000, 5.72508000),
(1008679, 1001380, 'BE', 'Bouillon', 1, 'bouillon', 49.79324000, 5.06703000),
(1008680, 1001380, 'BE', 'Boussu', 1, 'boussu', 50.43417000, 3.79440000),
(1008682, 1001380, 'BE', 'Braine-l\'Alleud', 1, 'braine-l-alleud', 50.68363000, 4.36784000),
(1008683, 1001380, 'BE', 'Braine-le-Château', 1, 'braine-le-chateau', 50.67990000, 4.27385000),
(1008684, 1001380, 'BE', 'Braine-le-Comte', 1, 'braine-le-comte', 50.60979000, 4.14658000),
(1008685, 1001380, 'BE', 'Braives', 1, 'braives', 50.61745000, 5.13302000),
(1008690, 1001380, 'BE', 'Brugelette', 1, 'brugelette', 50.59577000, 3.85363000),
(1008692, 1001380, 'BE', 'Brunehault', 1, 'brunehault', 50.50524000, 4.43209000),
(1008695, 1001380, 'BE', 'Bullange', 1, 'bullange', 50.40731000, 6.25749000),
(1008696, 1001380, 'BE', 'Burdinne', 1, 'burdinne', 50.58454000, 5.07663000),
(1008697, 1001380, 'BE', 'Butgenbach', 1, 'butgenbach', 50.42689000, 6.20504000),
(1008698, 1001380, 'BE', 'Celles', 1, 'celles', 50.71229000, 3.45733000),
(1008699, 1001380, 'BE', 'Cerfontaine', 1, 'cerfontaine', 50.17047000, 4.41028000),
(1008700, 1001380, 'BE', 'Chapelle-lez-Herlaimont', 1, 'chapelle-lez-herlaimont', 50.47130000, 4.28227000),
(1008701, 1001380, 'BE', 'Charleroi', 1, 'charleroi', 50.41136000, 4.44448000),
(1008702, 1001380, 'BE', 'Chastre-Villeroux-Blanmont', 1, 'chastre-villeroux-blanmont', 50.60857000, 4.64198000),
(1008708, 1001380, 'BE', 'Châtelet', 1, 'chatelet', 50.40338000, 4.52826000),
(1008703, 1001380, 'BE', 'Chaudfontaine', 1, 'chaudfontaine', 50.58280000, 5.63410000),
(1008704, 1001380, 'BE', 'Chaumont-Gistoux', 1, 'chaumont-gistoux', 50.67753000, 4.72120000),
(1008707, 1001380, 'BE', 'Chièvres', 1, 'chievres', 50.58787000, 3.80711000),
(1008705, 1001380, 'BE', 'Chimay', 1, 'chimay', 50.04856000, 4.31712000),
(1008706, 1001380, 'BE', 'Chiny', 1, 'chiny', 49.73833000, 5.34104000),
(1008709, 1001380, 'BE', 'Ciney', 1, 'ciney', 50.29449000, 5.10015000),
(1008710, 1001380, 'BE', 'Clavier', 1, 'clavier', 50.40069000, 5.35154000),
(1008711, 1001380, 'BE', 'Colfontaine', 1, 'colfontaine', 50.41410000, 3.85569000),
(1008712, 1001380, 'BE', 'Comblain-au-Pont', 1, 'comblain-au-pont', 50.47488000, 5.57711000),
(1008713, 1001380, 'BE', 'Courcelles', 1, 'courcelles', 50.46379000, 4.37470000),
(1008714, 1001380, 'BE', 'Court-Saint-Étienne', 1, 'court-saint-etienne', 50.63378000, 4.56851000),
(1008715, 1001380, 'BE', 'Couvin', 1, 'couvin', 50.05284000, 4.49495000),
(1008716, 1001380, 'BE', 'Crisnée', 1, 'crisnee', 50.71703000, 5.39802000),
(1008717, 1001380, 'BE', 'Dalhem', 1, 'dalhem', 50.71315000, 5.72774000),
(1008719, 1001380, 'BE', 'Daverdisse', 1, 'daverdisse', 50.02161000, 5.11811000),
(1008736, 1001380, 'BE', 'Dinant', 1, 'dinant', 50.25807000, 4.91166000),
(1008737, 1001380, 'BE', 'Dison', 1, 'dison', 50.61004000, 5.85340000),
(1008738, 1001380, 'BE', 'Doische', 1, 'doische', 50.13356000, 4.73545000),
(1008739, 1001380, 'BE', 'Donceel', 1, 'donceel', 50.64827000, 5.32000000),
(1008740, 1001380, 'BE', 'Dour', 1, 'dour', 50.39583000, 3.77792000),
(1008743, 1001380, 'BE', 'Durbuy', 1, 'durbuy', 50.35291000, 5.45631000),
(1009154, 1001380, 'BE', 'Écaussinnes-d’Enghien', 1, 'ecaussinnes-d-enghien', 50.56822000, 4.16580000),
(1009155, 1001380, 'BE', 'Éghezée', 1, 'eghezee', 50.59076000, 4.91175000),
(1008746, 1001380, 'BE', 'Ellezelles', 1, 'ellezelles', 50.73512000, 3.67985000),
(1008747, 1001380, 'BE', 'Enghien', 1, 'enghien', 50.68373000, 4.03284000),
(1008748, 1001380, 'BE', 'Engis', 1, 'engis', 50.58156000, 5.39916000),
(1009156, 1001380, 'BE', 'Érezée', 1, 'erezee', 50.29292000, 5.55815000),
(1008749, 1001380, 'BE', 'Erquelinnes', 1, 'erquelinnes', 50.30688000, 4.11129000),
(1008750, 1001380, 'BE', 'Esneux', 1, 'esneux', 50.53596000, 5.56775000),
(1008752, 1001380, 'BE', 'Estaimpuis', 1, 'estaimpuis', 50.70485000, 3.26785000),
(1008753, 1001380, 'BE', 'Estinnes-au-Val', 1, 'estinnes-au-val', 50.41016000, 4.10477000),
(1009157, 1001380, 'BE', 'Étalle', 1, 'etalle', 49.67385000, 5.60019000),
(1008754, 1001380, 'BE', 'Eupen', 1, 'eupen', 50.62790000, 6.03647000),
(1008756, 1001380, 'BE', 'Faimes', 1, 'faimes', 50.66252000, 5.26005000),
(1008757, 1001380, 'BE', 'Farciennes', 1, 'farciennes', 50.43006000, 4.54152000),
(1008758, 1001380, 'BE', 'Fauvillers', 1, 'fauvillers', 49.85116000, 5.66405000),
(1008759, 1001380, 'BE', 'Ferrières', 1, 'ferrieres', 50.40157000, 5.61092000),
(1008760, 1001380, 'BE', 'Fexhe-le-Haut-Clocher', 1, 'fexhe-le-haut-clocher', 50.66540000, 5.39978000),
(1008766, 1001380, 'BE', 'Flémalle-Haute', 1, 'flemalle-haute', 50.59994000, 5.44471000),
(1008767, 1001380, 'BE', 'Fléron', 1, 'fleron', 50.61516000, 5.68062000),
(1008761, 1001380, 'BE', 'Fleurus', 1, 'fleurus', 50.48351000, 4.55006000),
(1008762, 1001380, 'BE', 'Flobecq', 1, 'flobecq', 50.73733000, 3.73876000),
(1008763, 1001380, 'BE', 'Floreffe', 1, 'floreffe', 50.43452000, 4.75960000),
(1008764, 1001380, 'BE', 'Florennes', 1, 'florennes', 50.25127000, 4.60636000),
(1008765, 1001380, 'BE', 'Florenville', 1, 'florenville', 49.69983000, 5.30740000),
(1008768, 1001380, 'BE', 'Forville', 1, 'forville', 50.57424000, 4.99861000),
(1008769, 1001380, 'BE', 'Fosses-la-Ville', 1, 'fosses-la-ville', 50.39517000, 4.69623000),
(1008770, 1001380, 'BE', 'Frameries', 1, 'frameries', 50.40578000, 3.89603000),
(1008771, 1001380, 'BE', 'Frasnes-lez-Buissenal', 1, 'frasnes-lez-buissenal', 50.66783000, 3.62047000),
(1008772, 1001380, 'BE', 'Froidchapelle', 1, 'froidchapelle', 50.15106000, 4.32742000),
(1008775, 1001380, 'BE', 'Gedinne', 1, 'gedinne', 49.98037000, 4.93674000),
(1008777, 1001380, 'BE', 'Geer', 1, 'geer', 50.66990000, 5.17364000),
(1008779, 1001380, 'BE', 'Gembloux', 1, 'gembloux', 50.56149000, 4.69889000),
(1008780, 1001380, 'BE', 'Genappe', 1, 'genappe', 50.61173000, 4.45152000),
(1008784, 1001380, 'BE', 'Gerpinnes', 1, 'gerpinnes', 50.33789000, 4.52731000),
(1008785, 1001380, 'BE', 'Gesves', 1, 'gesves', 50.40146000, 5.07457000),
(1008790, 1001380, 'BE', 'Gouvy', 1, 'gouvy', 50.18600000, 5.93917000),
(1008791, 1001380, 'BE', 'Grez-Doiceau', 1, 'grez-doiceau', 50.73901000, 4.69829000),
(1008796, 1001380, 'BE', 'Habay-la-Vieille', 1, 'habay-la-vieille', 49.72329000, 5.61999000),
(1008800, 1001380, 'BE', 'Hamoir', 1, 'hamoir', 50.42675000, 5.53304000),
(1008801, 1001380, 'BE', 'Hamois', 1, 'hamois', 50.34020000, 5.15619000),
(1008802, 1001380, 'BE', 'Hannut', 1, 'hannut', 50.67142000, 5.07898000),
(1008805, 1001380, 'BE', 'Hastière-Lavaux', 1, 'hastiere-lavaux', 50.21849000, 4.82446000),
(1008806, 1001380, 'BE', 'Havelange', 1, 'havelange', 50.38931000, 5.23816000),
(1008811, 1001380, 'BE', 'Hensies', 1, 'hensies', 50.43263000, 3.68411000),
(1008812, 1001380, 'BE', 'Herbeumont', 1, 'herbeumont', 49.78086000, 5.23580000),
(1008839, 1001380, 'BE', 'Héron', 1, 'heron', 50.54731000, 5.09774000),
(1008819, 1001380, 'BE', 'Herstal', 1, 'herstal', 50.66415000, 5.62346000),
(1008820, 1001380, 'BE', 'Herve', 1, 'herve', 50.64083000, 5.79353000),
(1008830, 1001380, 'BE', 'Hotton', 1, 'hotton', 50.26742000, 5.44609000),
(1008831, 1001380, 'BE', 'Houffalize', 1, 'houffalize', 50.13235000, 5.78962000),
(1008834, 1001380, 'BE', 'Houyet', 1, 'houyet', 50.18619000, 5.00762000),
(1008838, 1001380, 'BE', 'Huy', 1, 'huy', 50.51894000, 5.23284000),
(1008842, 1001380, 'BE', 'Incourt', 1, 'incourt', 50.69151000, 4.79816000),
(1008844, 1001380, 'BE', 'Ittre', 1, 'ittre', 50.64396000, 4.26476000),
(1008847, 1001380, 'BE', 'Jalhay', 1, 'jalhay', 50.55876000, 5.96764000),
(1008848, 1001380, 'BE', 'Jodoigne', 1, 'jodoigne', 50.72357000, 4.86914000),
(1008849, 1001380, 'BE', 'Juprelle', 1, 'juprelle', 50.70760000, 5.53127000),
(1008850, 1001380, 'BE', 'Jurbise', 1, 'jurbise', 50.53100000, 3.90942000),
(1008873, 1001380, 'BE', 'La Bruyère', 1, 'la-bruyere', 50.39478000, 4.61444000),
(1008874, 1001380, 'BE', 'La Calamine', 1, 'la-calamine', 50.71809000, 6.01107000),
(1008875, 1001380, 'BE', 'La Hulpe', 1, 'la-hulpe', 50.73091000, 4.48577000),
(1008876, 1001380, 'BE', 'La Louvière', 1, 'la-louviere', 50.48657000, 4.18785000),
(1008877, 1001380, 'BE', 'La Roche-en-Ardenne', 1, 'la-roche-en-ardenne', 50.18361000, 5.57547000),
(1008911, 1001380, 'BE', 'Léglise', 1, 'leglise', 49.79985000, 5.53652000),
(1008886, 1001380, 'BE', 'Lens', 1, 'lens', 50.55696000, 3.89946000),
(1008888, 1001380, 'BE', 'Lessines', 1, 'lessines', 50.71104000, 3.83579000),
(1008890, 1001380, 'BE', 'Libin', 1, 'libin', 49.98107000, 5.25612000),
(1008900, 1001380, 'BE', 'Liège', 1, 'liege', 50.63373000, 5.56749000),
(1008894, 1001380, 'BE', 'Lierneux', 1, 'lierneux', 50.28477000, 5.79236000),
(1008896, 1001380, 'BE', 'Limbourg', 1, 'limbourg', 50.61222000, 5.94120000),
(1008897, 1001380, 'BE', 'Lincent', 1, 'lincent', 50.71222000, 5.03654000),
(1008901, 1001380, 'BE', 'Lobbes', 1, 'lobbes', 50.35258000, 4.26716000),
(1008906, 1001380, 'BE', 'Lontzen', 1, 'lontzen', 50.68126000, 6.00712000),
(1008907, 1001380, 'BE', 'Louvain-la-Neuve', 1, 'louvain-la-neuve', 50.66829000, 4.61443000),
(1008916, 1001380, 'BE', 'Malmédy', 1, 'malmedy', 50.42686000, 6.02794000),
(1008917, 1001380, 'BE', 'Manage', 1, 'manage', 50.50312000, 4.23589000),
(1008918, 1001380, 'BE', 'Manhay', 1, 'manhay', 50.29219000, 5.67562000),
(1008919, 1001380, 'BE', 'Marche-en-Famenne', 1, 'marche-en-famenne', 50.22678000, 5.34416000),
(1008920, 1001380, 'BE', 'Marchin', 1, 'marchin', 50.46707000, 5.24280000),
(1008921, 1001380, 'BE', 'Martelange', 1, 'martelange', 49.83195000, 5.73655000),
(1008925, 1001380, 'BE', 'Meix-devant-Virton', 1, 'meix-devant-virton', 49.60581000, 5.48045000),
(1008928, 1001380, 'BE', 'Merbes-le-Château', 1, 'merbes-le-chateau', 50.32449000, 4.16489000),
(1008932, 1001380, 'BE', 'Messancy', 1, 'messancy', 49.59201000, 5.81879000),
(1008933, 1001380, 'BE', 'Mettet', 1, 'mettet', 50.32119000, 4.66232000),
(1008936, 1001380, 'BE', 'Modave', 1, 'modave', 50.44614000, 5.29532000),
(1008939, 1001380, 'BE', 'Momignies', 1, 'momignies', 50.02710000, 4.16519000),
(1008940, 1001380, 'BE', 'Mons', 1, 'mons', 50.45413000, 3.95229000),
(1008941, 1001380, 'BE', 'Mons-lez-Liège', 1, 'mons-lez-liege', 50.61667000, 5.46667000),
(1008942, 1001380, 'BE', 'Mont-Saint-Guibert', 1, 'mont-saint-guibert', 50.63427000, 4.61061000),
(1008944, 1001380, 'BE', 'Morlanwelz-Mariemont', 1, 'morlanwelz-mariemont', 50.45502000, 4.24519000),
(1008946, 1001380, 'BE', 'Mouscron', 1, 'mouscron', 50.74497000, 3.20639000),
(1008947, 1001380, 'BE', 'Musson', 1, 'musson', 49.55835000, 5.70525000),
(1008948, 1001380, 'BE', 'Namur', 1, 'namur', 50.46690000, 4.86746000),
(1008949, 1001380, 'BE', 'Nandrin', 1, 'nandrin', 50.50675000, 5.41905000),
(1008950, 1001380, 'BE', 'Nassogne', 1, 'nassogne', 50.12849000, 5.34274000),
(1008953, 1001380, 'BE', 'Neufchâteau', 1, 'neufchateau', 49.84074000, 5.43535000),
(1008960, 1001380, 'BE', 'Nivelles', 1, 'nivelles', 50.59833000, 4.32848000),
(1008961, 1001380, 'BE', 'Noville-les-Bois', 1, 'noville-les-bois', 50.55702000, 4.98466000),
(1008962, 1001380, 'BE', 'Ohey', 1, 'ohey', 50.43570000, 5.12375000),
(1008964, 1001380, 'BE', 'Olne', 1, 'olne', 50.58994000, 5.74662000),
(1008965, 1001380, 'BE', 'Onhaye', 1, 'onhaye', 50.24148000, 4.84069000),
(1008973, 1001380, 'BE', 'Oreye', 1, 'oreye', 50.71749000, 5.34880000),
(1008975, 1001380, 'BE', 'Ottignies', 1, 'ottignies', 50.66535000, 4.56679000),
(1008980, 1001380, 'BE', 'Ouffet', 1, 'ouffet', 50.43870000, 5.46570000),
(1008981, 1001380, 'BE', 'Oupeye', 1, 'oupeye', 50.71184000, 5.64680000),
(1008984, 1001380, 'BE', 'Paliseul', 1, 'paliseul', 49.90395000, 5.13537000),
(1008985, 1001380, 'BE', 'Pecq', 1, 'pecq', 50.68619000, 3.33789000),
(1008988, 1001380, 'BE', 'Pepinster', 1, 'pepinster', 50.57375000, 5.80490000),
(1009009, 1001380, 'BE', 'Péruwelz', 1, 'peruwelz', 50.50819000, 3.59373000),
(1008990, 1001380, 'BE', 'Perwez', 1, 'perwez', 50.62426000, 4.81354000),
(1008991, 1001380, 'BE', 'Philippeville', 1, 'philippeville', 50.19612000, 4.54374000),
(1008993, 1001380, 'BE', 'Plombières', 1, 'plombieres', 50.73656000, 5.95922000),
(1008994, 1001380, 'BE', 'Pont-à-Celles', 1, 'pont-a-celles', 50.50518000, 4.36887000),
(1008996, 1001380, 'BE', 'Profondeville', 1, 'profondeville', 50.37581000, 4.86506000),
(1008997, 1001380, 'BE', 'Province de Liège', 1, 'province-de-liege', 50.63427000, 5.56543000),
(1008998, 1001380, 'BE', 'Province de Namur', 1, 'province-de-namur', 50.33333000, 4.83333000),
(1008999, 1001380, 'BE', 'Province du Brabant Wallon', 1, 'province-du-brabant-wallon', 50.75000000, 4.58333000),
(1009000, 1001380, 'BE', 'Province du Hainaut', 1, 'province-du-hainaut', 50.50000000, 3.83333000),
(1009001, 1001380, 'BE', 'Province du Luxembourg', 1, 'province-du-luxembourg', 50.00000000, 5.50000000),
(1009010, 1001380, 'BE', 'Quaregnon', 1, 'quaregnon', 50.44067000, 3.86530000),
(1009012, 1001380, 'BE', 'Quévy-le-Petit', 1, 'quevy-le-petit', 50.36879000, 3.93602000),
(1009011, 1001380, 'BE', 'Quiévrain', 1, 'quievrain', 50.40737000, 3.68351000),
(1009013, 1001380, 'BE', 'Raeren', 1, 'raeren', 50.66720000, 6.11535000),
(1009014, 1001380, 'BE', 'Ramillies', 1, 'ramillies', 50.63395000, 4.90119000),
(1009017, 1001380, 'BE', 'Rebecq-Rognon', 1, 'rebecq-rognon', 50.65147000, 4.10683000),
(1009018, 1001380, 'BE', 'Remicourt', 1, 'remicourt', 50.68069000, 5.32785000),
(1009019, 1001380, 'BE', 'Rendeux', 1, 'rendeux', 50.23423000, 5.50414000),
(1009023, 1001380, 'BE', 'Rixensart', 1, 'rixensart', 50.71229000, 4.52529000),
(1009024, 1001380, 'BE', 'Rochefort', 1, 'rochefort', 50.16310000, 5.22160000),
(1009026, 1001380, 'BE', 'Roeulx', 1, 'roeulx', 50.50365000, 4.11163000),
(1009029, 1001380, 'BE', 'Rouvroy', 1, 'rouvroy', 49.53771000, 5.49031000),
(1009031, 1001380, 'BE', 'Rumes', 1, 'rumes', 50.55450000, 3.30535000),
(1009033, 1001380, 'BE', 'Saint-Ghislain', 1, 'saint-ghislain', 50.44816000, 3.81886000),
(1009034, 1001380, 'BE', 'Saint-Hubert', 1, 'saint-hubert', 50.02668000, 5.37401000),
(1009035, 1001380, 'BE', 'Saint-Léger', 1, 'saint-leger', 49.61196000, 5.65688000),
(1009036, 1001380, 'BE', 'Saint-Nicolas', 1, 'saint-nicolas', 50.62837000, 5.53243000),
(1009037, 1001380, 'BE', 'Saint-Vith', 1, 'saint-vith', 50.28146000, 6.12724000),
(1009038, 1001380, 'BE', 'Sainte-Ode', 1, 'sainte-ode', 50.01723000, 5.51926000),
(1009042, 1001380, 'BE', 'Seneffe', 1, 'seneffe', 50.53135000, 4.26301000),
(1009043, 1001380, 'BE', 'Seraing', 1, 'seraing', 50.58362000, 5.50115000),
(1009044, 1001380, 'BE', 'Silly', 1, 'silly', 50.64877000, 3.92363000),
(1009060, 1001380, 'BE', 'Soignies', 1, 'soignies', 50.57904000, 4.07129000),
(1009061, 1001380, 'BE', 'Sombreffe', 1, 'sombreffe', 50.52865000, 4.60087000),
(1009062, 1001380, 'BE', 'Somme-Leuze', 1, 'somme-leuze', 50.33699000, 5.36705000),
(1009063, 1001380, 'BE', 'Soumagne', 1, 'soumagne', 50.61385000, 5.74679000),
(1009064, 1001380, 'BE', 'Spa', 1, 'spa', 50.48375000, 5.86674000),
(1009065, 1001380, 'BE', 'Sprimont', 1, 'sprimont', 50.50922000, 5.65950000),
(1009068, 1001380, 'BE', 'Stavelot', 1, 'stavelot', 50.39500000, 5.93124000),
(1009071, 1001380, 'BE', 'Stoumont', 1, 'stoumont', 50.40667000, 5.80838000),
(1009072, 1001380, 'BE', 'Tellin', 1, 'tellin', 50.08038000, 5.21638000),
(1009074, 1001380, 'BE', 'Tenneville', 1, 'tenneville', 50.09501000, 5.52895000),
(1009079, 1001380, 'BE', 'Theux', 1, 'theux', 50.53323000, 5.81245000),
(1009080, 1001380, 'BE', 'Thuin', 1, 'thuin', 50.33933000, 4.28604000),
(1009083, 1001380, 'BE', 'Tinlot', 1, 'tinlot', 50.47493000, 5.37755000),
(1009084, 1001380, 'BE', 'Tintigny', 1, 'tintigny', 49.68326000, 5.51349000),
(1009087, 1001380, 'BE', 'Tournai', 1, 'tournai', 50.60715000, 3.38932000),
(1009089, 1001380, 'BE', 'Trois-Ponts', 1, 'trois-ponts', 50.37128000, 5.87146000),
(1009090, 1001380, 'BE', 'Trooz', 1, 'trooz', 50.57026000, 5.69521000),
(1009091, 1001380, 'BE', 'Tubize', 1, 'tubize', 50.69059000, 4.20090000),
(1009093, 1001380, 'BE', 'Vaux-sur-Sûre', 1, 'vaux-sur-sure', 49.91100000, 5.57848000),
(1009094, 1001380, 'BE', 'Verlaine', 1, 'verlaine', 50.60743000, 5.31740000),
(1009095, 1001380, 'BE', 'Verviers', 1, 'verviers', 50.58907000, 5.86241000),
(1009097, 1001380, 'BE', 'Vielsalm', 1, 'vielsalm', 50.28407000, 5.91502000),
(1009098, 1001380, 'BE', 'Villers-la-Ville', 1, 'villers-la-ville', 50.56667000, 4.51667000),
(1009099, 1001380, 'BE', 'Villers-le-Bouillet', 1, 'villers-le-bouillet', 50.57708000, 5.25945000),
(1009101, 1001380, 'BE', 'Virton', 1, 'virton', 49.56824000, 5.53259000),
(1009102, 1001380, 'BE', 'Visé', 1, 'vise', 50.73760000, 5.69907000),
(1009108, 1001380, 'BE', 'Waimes', 1, 'waimes', 50.41488000, 6.11207000),
(1009109, 1001380, 'BE', 'Walcourt', 1, 'walcourt', 50.25401000, 4.43796000),
(1009110, 1001380, 'BE', 'Walhain-Saint-Paul', 1, 'walhain-saint-paul', 50.62627000, 4.69837000),
(1009111, 1001380, 'BE', 'Wanze', 1, 'wanze', 50.53907000, 5.20846000),
(1009113, 1001380, 'BE', 'Waremme', 1, 'waremme', 50.69760000, 5.25524000),
(1009114, 1001380, 'BE', 'Wasseiges', 1, 'wasseiges', 50.62186000, 5.00528000),
(1009115, 1001380, 'BE', 'Waterloo', 1, 'waterloo', 50.71469000, 4.39910000),
(1009116, 1001380, 'BE', 'Wavre', 1, 'wavre', 50.71717000, 4.60138000),
(1009117, 1001380, 'BE', 'Welkenraedt', 1, 'welkenraedt', 50.66050000, 5.97034000),
(1009119, 1001380, 'BE', 'Wellin', 1, 'wellin', 50.08133000, 5.11413000),
(1009134, 1001380, 'BE', 'Yvoir', 1, 'yvoir', 50.32790000, 4.88059000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001382, 'BE', 'Walloon Brabant', 1, 'walloon-brabant');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001383, 'BE', 'West Flanders', 1, 'west-flanders');

