Array
(
[0] => Array
(
[id] => 497870161
[en] => Blansko
)
[1] => Array
(
[id] => 497876308
[en] => Bohumin
)
[2] => Array
(
[id] => 497863524
[en] => Breclav
)
[3] => Array
(
[id] => 497868517
[en] => Brno
)
[4] => Array
(
[id] => 497877129
[en] => Bruntal
)
[5] => Array
(
[id] => 497882056
[en] => Ceska Lipa
)
[6] => Array
(
[id] => 497865879
[en] => Ceske Budejovice
)
[7] => Array
(
[id] => 497874768
[en] => Cesky Tesin
)
[8] => Array
(
[id] => 497877856
[en] => Cheb
)
[9] => Array
(
[id] => 497880692
[en] => Chomutov
)
[10] => Array
(
[id] => 497876775
[en] => Chrudim
)
[11] => Array
(
[id] => 497882489
[en] => Decin
)
[12] => Array
(
[id] => 497874066
[en] => Frydek-mistek
)
[13] => Array
(
[id] => 497875114
[en] => Havirov
)
[14] => Array
(
[id] => 497873140
[en] => Havlickuv Brod
)
[15] => Array
(
[id] => 497864650
[en] => Hodonin
)
[16] => Array
(
[id] => 497878952
[en] => Hradec Kralove
)
[17] => Array
(
[id] => 497872595
[en] => Hranice
)
[18] => Array
(
[id] => 497882303
[en] => Jablonec Nad Nisou
)
[19] => Array
(
[id] => 497870881
[en] => Jihlava
)
[20] => Array
(
[id] => 497867891
[en] => Jindrichuv Hradec
)
[21] => Array
(
[id] => 497880967
[en] => Jirkov
)
[22] => Array
(
[id] => 497880226
[en] => Kadan
)
[23] => Array
(
[id] => 497879092
[en] => Karlovy Vary
)
[24] => Array
(
[id] => 497875790
[en] => Karvina
)
[25] => Array
(
[id] => 497878426
[en] => Kladno
)
[26] => Array
(
[id] => 497870859
[en] => Klatovy
)
[27] => Array
(
[id] => 497877491
[en] => Kolin
)
[28] => Array
(
[id] => 497873128
[en] => Koprivnice
)
[29] => Array
(
[id] => 497877914
[en] => Krnov
)
[30] => Array
(
[id] => 497869763
[en] => Kromeriz
)
[31] => Array
(
[id] => 497876768
[en] => Kutna Hora
)
[32] => Array
(
[id] => 497882496
[en] => Liberec
)
[33] => Array
(
[id] => 497881206
[en] => Litomerice
)
[34] => Array
(
[id] => 497881601
[en] => Litvinov
)
[35] => Array
(
[id] => 497880000
[en] => Louny
)
[36] => Array
(
[id] => 497880030
[en] => Melnik
)
[37] => Array
(
[id] => 497880457
[en] => Mlada Boleslav
)
[38] => Array
(
[id] => 497880995
[en] => Most
)
[39] => Array
(
[id] => 497880473
[en] => Nachod
)
[40] => Array
(
[id] => 497873126
[en] => Novy Jicin
)
[41] => Array
(
[id] => 497873141
[en] => Olomouc
)
[42] => Array
(
[id] => 497876651
[en] => Opava
)
[43] => Array
(
[id] => 497875775
[en] => Orlova
)
[44] => Array
(
[id] => 497875613
[en] => Ostrava
)
[45] => Array
(
[id] => 497868731
[en] => Otrokovice
)
[46] => Array
(
[id] => 497877498
[en] => Pardubice
)
[47] => Array
(
[id] => 497869785
[en] => Pisek
)
[48] => Array
(
[id] => 497874724
[en] => Plzen
)
[49] => Array
(
[id] => 498005731
[en] => Prague
)
[50] => Array
(
[id] => 497871825
[en] => Prerov
)
[51] => Array
(
[id] => 497874207
[en] => Pribram
)
[52] => Array
(
[id] => 497871821
[en] => Prostejov
)
[53] => Array
(
[id] => 497878712
[en] => Sokolov
)
[54] => Array
(
[id] => 497869154
[en] => Strakonice
)
[55] => Array
(
[id] => 497876941
[en] => Sumperk
)
[56] => Array
(
[id] => 497871058
[en] => Tabor
)
[57] => Array
(
[id] => 497881859
[en] => Teplice
)
[58] => Array
(
[id] => 497868716
[en] => Trebic
)
[59] => Array
(
[id] => 497874067
[en] => Trinec
)
[60] => Array
(
[id] => 497881399
[en] => Trutnov
)
[61] => Array
(
[id] => 497867092
[en] => Uherske Hradiste
)
[62] => Array
(
[id] => 497881962
[en] => Usti Nad Labem
)
[63] => Array
(
[id] => 497871835
[en] => Valasske Mezirici
)
[64] => Array
(
[id] => 497870359
[en] => Vsetin
)
[65] => Array
(
[id] => 497869529
[en] => Vyskov
)
[66] => Array
(
[id] => 497879859
[en] => Zatec
)
[67] => Array
(
[id] => 497872593
[en] => Zd'ar Nad Sazavou
)
[68] => Array
(
[id] => 497868914
[en] => Zlin
)
[69] => Array
(
[id] => 497864501
[en] => Znojmo
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=497875239 and other_city_id in (497870161,497876308,497863524,497868517,497877129,497882056,497865879,497874768,497877856,497880692,497876775,497882489,497874066,497875114,497873140,497864650,497878952,497872595,497882303,497870881,497867891,497880967,497880226,497879092,497875790,497878426,497870859,497877491,497873128,497877914,497869763,497876768,497882496,497881206,497881601,497880000,497880030,497880457,497880995,497880473,497873126,497873141,497876651,497875775,497875613,497868731,497877498,497869785,497874724,498005731,497871825,497874207,497871821,497878712,497869154,497876941,497871058,497881859,497868716,497874067,497881399,497867092,497881962,497871835,497870359,497869529,497879859,497872593,497868914,497864501)Array
(
)