Array
(
[0] => Array
(
[id] => 179733
[en] => Aketi
)
[1] => Array
(
[id] => 178768
[en] => Bandundu
)
[2] => Array
(
[id] => 179458
[en] => Basoko
)
[3] => Array
(
[id] => 179348
[en] => Beni
)
[4] => Array
(
[id] => 179683
[en] => Binga
)
[5] => Array
(
[id] => 179234
[en] => Boende
)
[6] => Array
(
[id] => 178940
[en] => Bolobo
)
[7] => Array
(
[id] => 178311
[en] => Boma
)
[8] => Array
(
[id] => 179932
[en] => Bondo
)
[9] => Array
(
[id] => 177398
[en] => Bukama
)
[10] => Array
(
[id] => 178904
[en] => Bukavu
)
[11] => Array
(
[id] => 178516
[en] => Bulungu
)
[12] => Array
(
[id] => 179642
[en] => Bumba
)
[13] => Array
(
[id] => 179519
[en] => Bunia
)
[14] => Array
(
[id] => 179841
[en] => Businga
)
[15] => Array
(
[id] => 179750
[en] => Buta
)
[16] => Array
(
[id] => 179276
[en] => Butembo
)
[17] => Array
(
[id] => 178363
[en] => Demba
)
[18] => Array
(
[id] => 178076
[en] => Gandajika
)
[19] => Array
(
[id] => 180027
[en] => Gbadolite
)
[20] => Array
(
[id] => 179826
[en] => Gemena
)
[21] => Array
(
[id] => 179010
[en] => Goma
)
[22] => Array
(
[id] => 178549
[en] => Ilebo
)
[23] => Array
(
[id] => 178969
[en] => Inongo
)
[24] => Array
(
[id] => 179737
[en] => Isiro
)
[25] => Array
(
[id] => 178284
[en] => Kabalo
)
[26] => Array
(
[id] => 178912
[en] => Kabare
)
[27] => Array
(
[id] => 178259
[en] => Kabinda
)
[28] => Array
(
[id] => 178299
[en] => Kalemie
)
[29] => Array
(
[id] => 178903
[en] => Kalima
)
[30] => Array
(
[id] => 177157
[en] => Kambove
)
[31] => Array
(
[id] => 177484
[en] => Kamina
)
[32] => Array
(
[id] => 178699
[en] => Kampene
)
[33] => Array
(
[id] => 178305
[en] => Kananga
)
[34] => Array
(
[id] => 177768
[en] => Kaniama
)
[35] => Array
(
[id] => 178510
[en] => Kasangulu
)
[36] => Array
(
[id] => 178527
[en] => Kasongo
)
[37] => Array
(
[id] => 178157
[en] => Kasongolunda
)
[38] => Array
(
[id] => 178484
[en] => Kenge
)
[39] => Array
(
[id] => 178452
[en] => Kikwit
)
[40] => Array
(
[id] => 178827
[en] => Kindu
)
[41] => Array
(
[id] => 178550
[en] => Kinshasa
)
[42] => Array
(
[id] => 176985
[en] => Kipushi
)
[43] => Array
(
[id] => 179355
[en] => Kisangani
)
[44] => Array
(
[id] => 177191
[en] => Kolwezi
)
[45] => Array
(
[id] => 178384
[en] => Kongolo
)
[46] => Array
(
[id] => 179901
[en] => Libenge
)
[47] => Array
(
[id] => 177139
[en] => Likasi
)
[48] => Array
(
[id] => 179632
[en] => Lisala
)
[49] => Array
(
[id] => 178718
[en] => Lodja
)
[50] => Array
(
[id] => 178383
[en] => Lubao
)
[51] => Array
(
[id] => 177010
[en] => Lubumbashi
)
[52] => Array
(
[id] => 178390
[en] => Luebo
)
[53] => Array
(
[id] => 178458
[en] => Lusambo
)
[54] => Array
(
[id] => 178612
[en] => Mangai
)
[55] => Array
(
[id] => 177856
[en] => Manono
)
[56] => Array
(
[id] => 178318
[en] => Matadi
)
[57] => Array
(
[id] => 179262
[en] => Mbandaka
)
[58] => Array
(
[id] => 178403
[en] => Mbanzangungu
)
[59] => Array
(
[id] => 178258
[en] => Mbujimayi
)
[60] => Array
(
[id] => 177932
[en] => Moba
)
[61] => Array
(
[id] => 178811
[en] => Mushie
)
[62] => Array
(
[id] => 178480
[en] => Mweka
)
[63] => Array
(
[id] => 177956
[en] => Mweneditu
)
[64] => Array
(
[id] => 178861
[en] => Nioki
)
[65] => Array
(
[id] => 178457
[en] => Tshela
)
[66] => Array
(
[id] => 178178
[en] => Tshikapa
)
[67] => Array
(
[id] => 178749
[en] => Uvira
)
[68] => Array
(
[id] => 179787
[en] => Watsa
)
[69] => Array
(
[id] => 179391
[en] => Yangambi
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=179901 and other_city_id in (179733,178768,179458,179348,179683,179234,178940,178311,179932,177398,178904,178516,179642,179519,179841,179750,179276,178363,178076,180027,179826,179010,178549,178969,179737,178284,178912,178259,178299,178903,177157,177484,178699,178305,177768,178510,178527,178157,178484,178452,178827,178550,176985,179355,177191,178384,179901,177139,179632,178718,178383,177010,178390,178458,178612,177856,178318,179262,178403,178258,177932,178811,178480,177956,178861,178457,178178,178749,179787,179391)Array
(
[0] => Array
(
[id] => 179901
[distance] => 0.00
)
)