
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Luxembourg", "Luxembourg", "Luxembourg", NULL, 74, 0, 1, NULL, "49.6112768", "6.129799"),
("Alzingen", "Alzingen", "Alzingen", NULL, 74, 0, 1, NULL, "49.56885", "6.16394"),
("Aspelt", "Aspelt", "Aspelt", NULL, 74, 0, 1, NULL, "49.52089", "6.22501"),
("Bereldange", "Bereldange", "Bereldange", NULL, 74, 0, 1, NULL, "49.65527", "6.1157"),
("Bascharage", "Bascharage", "Bascharage", NULL, 74, 0, 1, NULL, "49.5676807", "5.9125481"),
("Beaufort", "Beaufort", "Beaufort", NULL, 74, 0, 1, NULL, "49.8353307", "6.2925122"),
("Belvaux", "Belvaux", "Belvaux", NULL, 74, 0, 1, NULL, "49.5095817", "5.9221177"),
("Bergem", "Bergem", "Bergem", NULL, 74, 0, 1, NULL, "49.5243606", "6.0411033"),
("Bertrange", "Bertrange", "Bertrange", NULL, 74, 0, 1, NULL, "49.6082663", "6.0510573"),
("Bettembourg", "Bettembourg", "Bettembourg", NULL, 74, 0, 1, NULL, "49.5192118", "6.1002461"),
("Bettendorf", "Bettendorf", "Bettendorf", NULL, 74, 0, 1, NULL, "49.8759969", "6.2109434"),
("Bissen", "Bissen", "Bissen", NULL, 74, 0, 1, NULL, "49.7876693", "6.0657007"),
("Bridel", "Bridel", "Bridel", NULL, 74, 0, 1, NULL, "49.6557", "6.08326"),
("Capellen", "Capellen", "Capellen", NULL, 74, 0, 1, NULL, "49.646245", "5.9907576"),
("Clemency", "Clemency", "Clemency", NULL, 74, 0, 1, NULL, "49.5962192", "5.8756022"),
("Clervaux", "Clervaux", "Clervaux", NULL, 74, 0, 1, NULL, "50.0546313", "6.0285875"),
("Colmar", "Colmar", "Colmar", NULL, 74, 0, 1, NULL, "49.8101893", "6.0933607"),
("Consdorf", "Consdorf", "Consdorf", NULL, 74, 0, 1, NULL, "49.7796266", "6.3374009"),
("Contern", "Contern", "Contern", NULL, 74, 0, 1, NULL, "49.5851593", "6.227488"),
("Crauthem", "Crauthem", "Crauthem", NULL, 74, 0, 1, NULL, "49.53517", "6.14526"),
("Dalheim", "Dalheim", "Dalheim", NULL, 74, 0, 1, NULL, "49.5432964", "6.2592461"),
("Diekirch", "Diekirch", "Diekirch", NULL, 74, 0, 1, NULL, "49.8671784", "6.1595633"),
("Differdange", "Differdange", "Differdange", NULL, 74, 0, 1, NULL, "49.52273", "5.88896"),
("Dudelange", "Dudelange", "Dudelange", NULL, 74, 0, 1, NULL, "49.4784623", "6.0858789"),
("Echternach", "Echternach", "Echternach", NULL, 74, 0, 1, NULL, "49.8114133", "6.4175635"),
("Eischen", "Eischen", "Eischen", NULL, 74, 0, 1, NULL, "49.6855507", "5.8798793"),
("Esch-sur-Alzette", "Esch-sur-Alzette", "Esch-sur-Alzette", NULL, 74, 0, 1, NULL, "49.5008805", "5.9860925"),
("Ettelbruck", "Ettelbruck", "Ettelbruck", NULL, 74, 0, 1, NULL, "49.8478019", "6.0985234"),
("Fentange", "Fentange", "Fentange", NULL, 74, 0, 1, NULL, "49.5639872", "6.1518553"),
("Frisange", "Frisange", "Frisange", NULL, 74, 0, 1, NULL, "49.515919", "6.1879173"),
("Gonderange", "Gonderange", "Gonderange", NULL, 74, 0, 1, NULL, "49.6938934", "6.2498095"),
("Grevenmacher", "Grevenmacher", "Grevenmacher", NULL, 74, 0, 1, NULL, "49.680841", "6.4407593"),
("Hautcharage", "Hautcharage", "Hautcharage", NULL, 74, 0, 1, NULL, "49.57458", "5.90932"),
("Heisdorf-sur-Alzette", "Heisdorf-sur-Alzette", "Heisdorf-sur-Alzette", NULL, 74, 0, 1, NULL, "49.6764642", "6.1293104"),
("Helmsange", "Helmsange", "Helmsange", NULL, 74, 0, 1, NULL, "49.65813", "6.14102"),
("Hesperange", "Hesperange", "Hesperange", NULL, 74, 0, 1, NULL, "49.5708937", "6.152703"),
("Hobscheid", "Hobscheid", "Hobscheid", NULL, 74, 0, 1, NULL, "49.6875715", "5.9136849"),
("Itzig", "Itzig", "Itzig", NULL, 74, 0, 1, NULL, "49.58695", "6.17255"),
("Junglinster", "Junglinster", "Junglinster", NULL, 74, 0, 1, NULL, "49.7117373", "6.2519177"),
("Kayl", "Kayl", "Kayl", NULL, 74, 0, 1, NULL, "49.4868207", "6.0395281"),
("Kehlen", "Kehlen", "Kehlen", NULL, 74, 0, 1, NULL, "49.6674493", "6.0392093"),
("Koerich", "Koerich", "Koerich", NULL, 74, 0, 1, NULL, "49.6692631", "5.9486121"),
("Lamadelaine", "Lamadelaine", "Lamadelaine", NULL, 74, 0, 1, NULL, "49.54604", "5.85659"),
("Larochette", "Larochette", "Larochette", NULL, 74, 0, 1, NULL, "49.783709", "6.2194409"),
("Leudelange", "Leudelange", "Leudelange", NULL, 74, 0, 1, NULL, "49.5658269", "6.0578061"),
("Lintgen", "Lintgen", "Lintgen", NULL, 74, 0, 1, NULL, "49.7223591", "6.129119"),
("Mullendorf", "Mullendorf", "Mullendorf", NULL, 74, 0, 1, NULL, "49.68037", "6.128"),
("Mamer", "Mamer", "Mamer", NULL, 74, 0, 1, NULL, "49.6294233", "6.0211741"),
("Mersch", "Mersch", "Mersch", NULL, 74, 0, 1, NULL, "49.7528287", "6.1027786"),
("Mertert", "Mertert", "Mertert", NULL, 74, 0, 1, NULL, "49.7003465", "6.4812308");
