
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("سوسة", "سوسة", "Sousse", NULL, 191, 0, 1, NULL, "35.8288175", "10.6405392"),
("تونس", "تونس", "Tunis", NULL, 191, 0, 1, NULL, "36.8002068", "10.1857757"),
("قفصة", "قفصة", "Gafsa", NULL, 191, 0, 1, NULL, "34.4224374", "8.7843862"),
("سيدي بوزيد", "سيدي بوزيد", "Sidi Bouzid", NULL, 191, 0, 1, NULL, "35.0382386", "9.4865301"),
("قابس", "قابس", "Gabes", NULL, 191, 0, 1, NULL, "33.8878082", "10.10044"),
("صفاقس", "صفاقس", "Sfax", NULL, 191, 0, 1, NULL, "34.7394361", "10.7604024"),
("القصرين", "القصرين", "Kasserine", NULL, 191, 0, 1, NULL, "35.1687646", "8.8365654"),
("الكاف", "الكاف", "Al-Kaf", NULL, 191, 0, 1, NULL, "36.1784491", "8.707347"),
("القيروان", "القيروان", "Kairouan", NULL, 191, 0, 1, NULL, "35.6710101", "10.10062"),
("المهدية", "المهدية", "Mahdia", NULL, 191, 0, 1, NULL, "35.5036811", "11.0682429"),
("المنستير", "المنستير", "Monastir", NULL, 191, 0, 1, NULL, "35.7707582", "10.8280511"),
("نابل", "نابل", "Nabeul", NULL, 191, 0, 1, NULL, "36.4512897", "10.7355915"),
("الحمامات", "الحمامات", "Hammamet", NULL, 191, 0, 1, NULL, "36.4006557", "10.6190626"),
("باجة", "باجة", "Béja", NULL, 191, 0, 1, NULL, "36.7236241", "9.1853919"),
("أريانة", "أريانة", "Ariana", NULL, 191, 0, 1, NULL, "36.8587351", "10.188232"),
("بن عروس", "بن عروس", "Ben Arous", NULL, 191, 0, 1, NULL, "36.7516855", "10.2245072"),
("المدينة الجديدة", "المدينة الجديدة", "المدينة الجديدة", NULL, 191, 0, 1, NULL, "36.742946", "10.2507635"),
("قرطاج", "قرطاج", "Carthage", NULL, 191, 0, 1, NULL, "36.8548083", "10.3309924"),
("قليبية", "قليبية", "Kelibia", NULL, 191, 0, 1, NULL, "36.8456561", "11.0935701"),
("بنزرت", "بنزرت", "Bizerte", NULL, 191, 0, 1, NULL, "37.2720905", "9.8708565"),
("As Sayyadah", "As Sayyadah", "As Sayyadah", NULL, 191, 0, 1, NULL, "35.1833333", "37.25"),
("Akouda", "Akouda", "Akouda", NULL, 191, 0, 1, NULL, "35.8746739", "10.5718086"),
("Al Hammamat", "Al Hammamat", "Al Hammamat", NULL, 191, 0, 1, NULL, "36.4072574", "10.6224706"),
("Al Baqalitah", "Al Baqalitah", "Al Baqalitah", NULL, 191, 0, 1, NULL, "34.85", "9.5666667"),
("Al Firnanah", "Al Firnanah", "Al Firnanah", NULL, 191, 0, 1, NULL, "36.65712", "8.693229"),
("Al Karib", "Al Karib", "Al Karib", NULL, 191, 0, 1, NULL, "36.3284259", "9.1359301"),
("Al Aliyah", "Al Aliyah", "Al Aliyah", NULL, 191, 0, 1, NULL, "36.3672222", "9.135"),
("Al Masdur", "Al Masdur", "Al Masdur", NULL, 191, 0, 1, NULL, "33.5958333", "36.2955556"),
("Al Marsa", "Al Marsa", "Al Marsa", NULL, 191, 0, 1, NULL, "33.2", "11.216667"),
("Al Matlin", "Al Matlin", "Al Matlin", NULL, 191, 0, 1, NULL, "37.2488951", "10.0415603"),
("Al Mazzunah", "Al Mazzunah", "Al Mazzunah", NULL, 191, 0, 1, NULL, "34.5773859", "9.8431866"),
("Al Metlaoui", "Al Metlaoui", "Al Metlaoui", NULL, 191, 0, 1, NULL, "34.35", "8.4333333"),
("Al Qarmadah", "Al Qarmadah", "Al Qarmadah", NULL, 191, 0, 1, NULL, "23.1122222", "53.8213889"),
("Al Wardanin", "Al Wardanin", "Al Wardanin", NULL, 191, 0, 1, NULL, "33.1245286", "8.8362755"),
("Saqanis", "Saqanis", "Saqanis", NULL, 191, 0, 1, NULL, "35.7836915", "10.6890065"),
("Ar Riqab", "Ar Riqab", "Ar Riqab", NULL, 191, 0, 1, NULL, "34.866667", "9.783333"),
("Ar Rudayyif", "Ar Rudayyif", "Ar Rudayyif", NULL, 191, 0, 1, NULL, "35.20105", "-91.8318334"),
("As Sanad", "As Sanad", "As Sanad", NULL, 191, 0, 1, NULL, "34.4623974", "9.2633141"),
("As Sars", "As Sars", "As Sars", NULL, 191, 0, 1, NULL, "36.0774387", "9.0211813"),
("Bu Aradah", "Bu Aradah", "Bu Aradah", NULL, 191, 0, 1, NULL, "36.3475304", "9.6257837"),
("Bu Urqub", "Bu Urqub", "Bu Urqub", NULL, 191, 0, 1, NULL, "36.6478364", "10.5915072"),
("Bani Hassan", "Bani Hassan", "Bani Hassan", NULL, 191, 0, 1, NULL, "35.5673752", "10.8084675"),
("Bani Khaddash", "Bani Khaddash", "Bani Khaddash", NULL, 191, 0, 1, NULL, "33.25", "10.2"),
("Bani Khallad", "Bani Khallad", "Bani Khallad", NULL, 191, 0, 1, NULL, "36.6478364", "10.5915072"),
("Banbalah", "Banbalah", "Banbalah", NULL, 191, 0, 1, NULL, "36.5499", "9.4422664"),
("Beni Khiar", "Beni Khiar", "Beni Khiar", NULL, 191, 0, 1, NULL, "36.4596214", "10.7830826"),
("Bin Qirdan", "Bin Qirdan", "Bin Qirdan", NULL, 191, 0, 1, NULL, "33.1431887", "11.2183781"),
("Bir Ali Bin Khalifah", "Bir Ali Bin Khalifah", "Bir Ali Bin Khalifah", NULL, 191, 0, 1, NULL, "34.733333", "10.1"),
("Bir al Hufayy", "Bir al Hufayy", "Bir al Hufayy", NULL, 191, 0, 1, NULL, "35.674707", "10.8761941"),
("Chebba", "Chebba", "Chebba", NULL, 191, 0, 1, NULL, "35.23369", "11.1107854");
