Array
(
[0] => Array
(
[id] => 497924827
[en] => Abuko
)
[1] => Array
(
[id] => 497922296
[en] => Allunhari
)
[2] => Array
(
[id] => 497919560
[en] => Baja Kunda
)
[3] => Array
(
[id] => 497924927
[en] => Bakau
)
[4] => Array
(
[id] => 183432
[en] => Banjul
)
[5] => Array
(
[id] => 497919293
[en] => Banjulunding
)
[6] => Array
(
[id] => 497924876
[en] => Bansang
)
[7] => Array
(
[id] => 497924928
[en] => Barra
)
[8] => Array
(
[id] => 497924733
[en] => Basse Santa Su
)
[9] => Array
(
[id] => 497919320
[en] => Berending
)
[10] => Array
(
[id] => 497919291
[en] => Bijilo
)
[11] => Array
(
[id] => 497924709
[en] => Brikama
)
[12] => Array
(
[id] => 497919222
[en] => Brikama Ba
)
[13] => Array
(
[id] => 497924848
[en] => Brufut
)
[14] => Array
(
[id] => 497919292
[en] => Busumbala
)
[15] => Array
(
[id] => 497919394
[en] => Bwiam
)
[16] => Array
(
[id] => 497919741
[en] => Dampha Kunda
)
[17] => Array
(
[id] => 497919353
[en] => Dasilameh
)
[18] => Array
(
[id] => 497924697
[en] => Demba Kunda
)
[19] => Array
(
[id] => 497924817
[en] => Diabugu
)
[20] => Array
(
[id] => 497919738
[en] => Dingiri
)
[21] => Array
(
[id] => 497924897
[en] => Essau
)
[22] => Array
(
[id] => 497919316
[en] => Faraba Banta
)
[23] => Array
(
[id] => 497925012
[en] => Farafenni
)
[24] => Array
(
[id] => 497919257
[en] => Farato
)
[25] => Array
(
[id] => 497918827
[en] => Fass Chaho
)
[26] => Array
(
[id] => 497918954
[en] => Fass Njaga Choi
)
[27] => Array
(
[id] => 497919734
[en] => Gambisara
)
[28] => Array
(
[id] => 497922295
[en] => Garawoll
)
[29] => Array
(
[id] => 497924668
[en] => Gunjur
)
[30] => Array
(
[id] => 497919253
[en] => Jambajeli
)
[31] => Array
(
[id] => 497924998
[en] => Janjanbureh
)
[32] => Array
(
[id] => 497925067
[en] => Jarreng
)
[33] => Array
(
[id] => 497919307
[en] => Kafuta
)
[34] => Array
(
[id] => 497919250
[en] => Kartong
)
[35] => Array
(
[id] => 497919341
[en] => Kembujeh
)
[36] => Array
(
[id] => 497924930
[en] => Kerewan
)
[37] => Array
(
[id] => 497919285
[en] => Kerr Seringe Ngaga
)
[38] => Array
(
[id] => 497919340
[en] => Kitty
)
[39] => Array
(
[id] => 497924925
[en] => Koina
)
[40] => Array
(
[id] => 497919718
[en] => Kularr
)
[41] => Array
(
[id] => 497919282
[en] => Kunkujang
)
[42] => Array
(
[id] => 497925096
[en] => Kuntaur
)
[43] => Array
(
[id] => 497924784
[en] => Lamin
)
[44] => Array
(
[id] => 497915222
[en] => Madiana
)
[45] => Array
(
[id] => 497919181
[en] => Madina Umfally
)
[46] => Array
(
[id] => 497919277
[en] => Mandinari
)
[47] => Array
(
[id] => 497919609
[en] => Missira Ba Mariama
)
[48] => Array
(
[id] => 497918919
[en] => Ndugu Kebbeh
)
[49] => Array
(
[id] => 497919275
[en] => Nema Kunku
)
[50] => Array
(
[id] => 497919695
[en] => Numuyel
)
[51] => Array
(
[id] => 497919301
[en] => Pirang
)
[52] => Array
(
[id] => 497924689
[en] => Sabi
)
[53] => Array
(
[id] => 497922293
[en] => Salikenne
)
[54] => Array
(
[id] => 497925043
[en] => Sami
)
[55] => Array
(
[id] => 497922294
[en] => Sanyang
)
[56] => Array
(
[id] => 497924885
[en] => Serre Kunda
)
[57] => Array
(
[id] => 497919452
[en] => Sibanor
)
[58] => Array
(
[id] => 497919233
[en] => Siffoe
)
[59] => Array
(
[id] => 497919274
[en] => Sinchu Alagi
)
[60] => Array
(
[id] => 497919273
[en] => Sinchu Dula Balia
)
[61] => Array
(
[id] => 497919272
[en] => Sinchu Sori
)
[62] => Array
(
[id] => 497924871
[en] => Soma
)
[63] => Array
(
[id] => 497924679
[en] => Somita
)
[64] => Array
(
[id] => 497924826
[en] => Sukuta
)
[65] => Array
(
[id] => 497924943
[en] => Sutukoba
)
[66] => Array
(
[id] => 497922292
[en] => Tanji
)
[67] => Array
(
[id] => 497919230
[en] => Tujereng
)
[68] => Array
(
[id] => 497922291
[en] => Wellingara
)
[69] => Array
(
[id] => 497919268
[en] => Yundum
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=497924938 and other_city_id in (497924827,497922296,497919560,497924927,183432,497919293,497924876,497924928,497924733,497919320,497919291,497924709,497919222,497924848,497919292,497919394,497919741,497919353,497924697,497924817,497919738,497924897,497919316,497925012,497919257,497918827,497918954,497919734,497922295,497924668,497919253,497924998,497925067,497919307,497919250,497919341,497924930,497919285,497919340,497924925,497919718,497919282,497925096,497924784,497915222,497919181,497919277,497919609,497918919,497919275,497919695,497919301,497924689,497922293,497925043,497922294,497924885,497919452,497919233,497919274,497919273,497919272,497924871,497924679,497924826,497924943,497922292,497919230,497922291,497919268)Array
(
[0] => Array
(
[id] => 497919609
[distance] => 103.30
)
[1] => Array
(
[id] => 497922293
[distance] => 117.27
)
[2] => Array
(
[id] => 497922295
[distance] => 102.10
)
[3] => Array
(
[id] => 497924925
[distance] => 109.23
)
)