
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Limbe", "Limbe", "Limbe", NULL, 170, 0, 1, NULL, "-15.8074399", "35.0525005"),
("Blantyre", "Blantyre", "Blantyre", NULL, 170, 0, 1, NULL, "-15.7862543", "35.0035694"),
("Zomba", "Zomba", "Zomba", NULL, 170, 0, 1, NULL, "-15.3863208", "35.3268273"),
("Lilongwe", "Lilongwe", "Lilongwe", NULL, 170, 0, 1, NULL, "-13.9875107", "33.768144"),
("Mzuzu", "Mzuzu", "Mzuzu", NULL, 170, 0, 1, NULL, "-11.4607518", "34.0226422"),
("Balaka", "Balaka", "Balaka", NULL, 170, 0, 1, NULL, "-14.9876054", "34.9561748"),
("Chikwawa", "Chikwawa", "Chikwawa", NULL, 170, 0, 1, NULL, "-16.0437784", "34.8016945"),
("Chipoka", "Chipoka", "Chipoka", NULL, 170, 0, 1, NULL, "-13.9932843", "34.5112934"),
("Chiradzulu", "Chiradzulu", "Chiradzulu", NULL, 170, 0, 1, NULL, "-15.6759485", "35.1406293"),
("Chitipa", "Chitipa", "Chitipa", NULL, 170, 0, 1, NULL, "-9.7037655", "33.2700253"),
("Dedza", "Dedza", "Dedza", NULL, 170, 0, 1, NULL, "-14.3816618", "34.3254842"),
("Dowa", "Dowa", "Dowa", NULL, 170, 0, 1, NULL, "-13.6514687", "33.9359756"),
("Karonga", "Karonga", "Karonga", NULL, 170, 0, 1, NULL, "-9.952536", "33.9248222"),
("Kasungu", "Kasungu", "Kasungu", NULL, 170, 0, 1, NULL, "-13.0356794", "33.4719832"),
("Livingstonia", "Livingstonia", "Livingstonia", NULL, 170, 0, 1, NULL, "-10.6028492", "34.1058963"),
("Liwonde", "Liwonde", "Liwonde", NULL, 170, 0, 1, NULL, "-15.0695237", "35.2313307"),
("Luchenza", "Luchenza", "Luchenza", NULL, 170, 0, 1, NULL, "-16.0100923", "35.3082117"),
("Machinga", "Machinga", "Machinga", NULL, 170, 0, 1, NULL, "-15.1699934", "35.2999779"),
("Mangochi", "Mangochi", "Mangochi", NULL, 170, 0, 1, NULL, "-14.4861733", "35.253304"),
("Mchinji", "Mchinji", "Mchinji", NULL, 170, 0, 1, NULL, "-13.8000058", "32.8930441"),
("Monkey Bay", "Monkey Bay", "Monkey Bay", NULL, 170, 0, 1, NULL, "-14.0821483", "34.9148236"),
("Mponela", "Mponela", "Mponela", NULL, 170, 0, 1, NULL, "-13.5319974", "33.7350084"),
("Mulanje", "Mulanje", "Mulanje", NULL, 170, 0, 1, NULL, "-16.0252339", "35.5083136"),
("Mwanza", "Mwanza", "Mwanza", NULL, 170, 0, 1, NULL, "-15.5997929", "34.5140637"),
("Mzimba", "Mzimba", "Mzimba", NULL, 170, 0, 1, NULL, "-11.8991825", "33.5923941"),
("Nkhata Bay", "Nkhata Bay", "Nkhata Bay", NULL, 170, 0, 1, NULL, "-11.6085556", "34.2949409"),
("Nkhotakota", "Nkhotakota", "Nkhotakota", NULL, 170, 0, 1, NULL, "-12.9316863", "34.2810541"),
("Nsanje", "Nsanje", "Nsanje", NULL, 170, 0, 1, NULL, "-16.9205934", "35.253304"),
("Ntcheu", "Ntcheu", "Ntcheu", NULL, 170, 0, 1, NULL, "-14.8219765", "34.6358702"),
("Ntchisi", "Ntchisi", "Ntchisi", NULL, 170, 0, 1, NULL, "-13.2841992", "33.8857747"),
("Phalombe", "Phalombe", "Phalombe", NULL, 170, 0, 1, NULL, "-15.7633303", "35.6587503"),
("Rumphi", "Rumphi", "Rumphi", NULL, 170, 0, 1, NULL, "-11.0171949", "33.8550829"),
("Salima", "Salima", "Salima", NULL, 170, 0, 1, NULL, "-13.7795533", "34.458641"),
("Thyolo", "Thyolo", "Thyolo", NULL, 170, 0, 1, NULL, "-16.069257", "35.1406293");
