Array
(
[0] => Array
(
[id] => 190296
[en] => Acin
)
[1] => Array
(
[id] => 154180
[en] => Andarab
)
[2] => Array
(
[id] => 155176
[en] => Andhvoy
)
[3] => Array
(
[id] => 155177
[en] => Aqcah
)
[4] => Array
(
[id] => 190668
[en] => Asadabad
)
[5] => Array
(
[id] => 190400
[en] => Awbeh
)
[6] => Array
(
[id] => 154669
[en] => Aybak
)
[7] => Array
(
[id] => 154589
[en] => Baglan
)
[8] => Array
(
[id] => 190437
[en] => Bagrami
)
[9] => Array
(
[id] => 189938
[en] => Bagran
)
[10] => Array
(
[id] => 155041
[en] => Balkh
)
[11] => Array
(
[id] => 190624
[en] => Bamiyan
)
[12] => Array
(
[id] => 155392
[en] => Cah Ab
)
[13] => Array
(
[id] => 153784
[en] => Carikar
)
[14] => Array
(
[id] => 154482
[en] => Darzi Ab
)
[15] => Array
(
[id] => 155271
[en] => Dast-e Arca
)
[16] => Array
(
[id] => 154780
[en] => Dawlatabad
)
[17] => Array
(
[id] => 155197
[en] => Dawlatabad
)
[18] => Array
(
[id] => 155301
[en] => Emam Saheb
)
[19] => Array
(
[id] => 190521
[en] => Eslam Qal'eh
)
[20] => Array
(
[id] => 189578
[en] => Farah
)
[21] => Array
(
[id] => 154895
[en] => Farhar
)
[22] => Array
(
[id] => 155272
[en] => Fayzabad
)
[23] => Array
(
[id] => 190105
[en] => Gardez
)
[24] => Array
(
[id] => 190083
[en] => Gazni
)
[25] => Array
(
[id] => 189163
[en] => Geresk
)
[26] => Array
(
[id] => 190374
[en] => Gurian
)
[27] => Array
(
[id] => 154974
[en] => Hanabad
)
[28] => Array
(
[id] => 155311
[en] => Hazart Imam
)
[29] => Array
(
[id] => 190383
[en] => Herat
)
[30] => Array
(
[id] => 190354
[en] => Hugyani
)
[31] => Array
(
[id] => 155254
[en] => Hwajeh Gar
)
[32] => Array
(
[id] => 153844
[en] => Jabal-os-saraj
)
[33] => Array
(
[id] => 190417
[en] => Jalalabad
)
[34] => Array
(
[id] => 155127
[en] => Jurm
)
[35] => Array
(
[id] => 190460
[en] => Kabul
)
[36] => Array
(
[id] => 190436
[en] => Karuh
)
[37] => Array
(
[id] => 154983
[en] => Kholm
)
[38] => Array
(
[id] => 190008
[en] => Khowst
)
[39] => Array
(
[id] => 190514
[en] => Kuhestan
)
[40] => Array
(
[id] => 189995
[en] => Kusk
)
[41] => Array
(
[id] => 189061
[en] => Laskar Gah
)
[42] => Array
(
[id] => 154446
[en] => Maymanah
)
[43] => Array
(
[id] => 154991
[en] => Mazar-e Sarif
)
[44] => Array
(
[id] => 190329
[en] => Nader Sah Kawt
)
[45] => Array
(
[id] => 154541
[en] => Nahrin
)
[46] => Array
(
[id] => 190486
[en] => Pagman
)
[47] => Array
(
[id] => 154461
[en] => Pol-e Humri
)
[48] => Array
(
[id] => 155206
[en] => Qal'eh-ye Zal
)
[49] => Array
(
[id] => 190734
[en] => Qal'ehye Naw
)
[50] => Array
(
[id] => 189369
[en] => Qalate Gilzay
)
[51] => Array
(
[id] => 189070
[en] => Qandahar
)
[52] => Array
(
[id] => 190636
[en] => Qarabag
)
[53] => Array
(
[id] => 190708
[en] => Qarabag
)
[54] => Array
(
[id] => 155216
[en] => Qarchi Gak
)
[55] => Array
(
[id] => 155393
[en] => Qarqin
)
[56] => Array
(
[id] => 155023
[en] => Qunduz
)
[57] => Array
(
[id] => 155264
[en] => Rostaq
)
[58] => Array
(
[id] => 154346
[en] => Sang-e Carak
)
[59] => Array
(
[id] => 154645
[en] => Sar-e Pul
)
[60] => Array
(
[id] => 190503
[en] => Sarawbi
)
[61] => Array
(
[id] => 154959
[en] => Shibarghan
)
[62] => Array
(
[id] => 189999
[en] => Sindand
)
[63] => Array
(
[id] => 154722
[en] => Sulgara
)
[64] => Array
(
[id] => 155024
[en] => Taloqan
)
[65] => Array
(
[id] => 155270
[en] => Tas Gozar
)
[66] => Array
(
[id] => 153902
[en] => Tawragudi
)
[67] => Array
(
[id] => 190490
[en] => Tir Pol
)
[68] => Array
(
[id] => 188927
[en] => Zaranj
)
[69] => Array
(
[id] => 190375
[en] => Zendejan
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=189343 and other_city_id in (190296,154180,155176,155177,190668,190400,154669,154589,190437,189938,155041,190624,155392,153784,154482,155271,154780,155197,155301,190521,189578,154895,155272,190105,190083,189163,190374,154974,155311,190383,190354,155254,153844,190417,155127,190460,190436,154983,190008,190514,189995,189061,154446,154991,190329,154541,190486,154461,155206,190734,189369,189070,190636,190708,155216,155393,155023,155264,154346,154645,190503,154959,189999,154722,155024,155270,153902,190490,188927,190375)Array
(
[0] => Array
(
[id] => 153902
[distance] => 422.83
)
[1] => Array
(
[id] => 154346
[distance] => 446.04
)
[2] => Array
(
[id] => 154446
[distance] => 429.22
)
[3] => Array
(
[id] => 154482
[distance] => 438.02
)
[4] => Array
(
[id] => 154645
[distance] => 472.59
)
[5] => Array
(
[id] => 154780
[distance] => 482.63
)
[6] => Array
(
[id] => 188927
[distance] => 297.79
)
[7] => Array
(
[id] => 189061
[distance] => 69.42
)
[8] => Array
(
[id] => 189070
[distance] => 96.79
)
[9] => Array
(
[id] => 189163
[distance] => 36.25
)
[10] => Array
(
[id] => 189369
[distance] => 195.04
)
[11] => Array
(
[id] => 189578
[distance] => 258.29
)
[12] => Array
(
[id] => 189938
[distance] => 112.95
)
[13] => Array
(
[id] => 189995
[distance] => 300.40
)
[14] => Array
(
[id] => 189999
[distance] => 284.53
)
[15] => Array
(
[id] => 190008
[distance] => 497.56
)
[16] => Array
(
[id] => 190083
[distance] => 374.96
)
[17] => Array
(
[id] => 190105
[distance] => 444.83
)
[18] => Array
(
[id] => 190374
[distance] => 401.00
)
[19] => Array
(
[id] => 190375
[distance] => 381.82
)
[20] => Array
(
[id] => 190383
[distance] => 352.94
)
[21] => Array
(
[id] => 190400
[distance] => 301.58
)
[22] => Array
(
[id] => 190436
[distance] => 339.64
)
[23] => Array
(
[id] => 190437
[distance] => 493.38
)
[24] => Array
(
[id] => 190460
[distance] => 488.02
)
[25] => Array
(
[id] => 190486
[distance] => 474.39
)
[26] => Array
(
[id] => 190490
[distance] => 433.40
)
[27] => Array
(
[id] => 190514
[distance] => 443.29
)
[28] => Array
(
[id] => 190521
[distance] => 452.51
)
[29] => Array
(
[id] => 190624
[distance] => 395.24
)
[30] => Array
(
[id] => 190708
[distance] => 426.12
)
[31] => Array
(
[id] => 190734
[distance] => 360.87
)
)