Array
(
[0] => Array
(
[id] => 30114
[en] => Acerra
)
[1] => Array
(
[id] => 35430
[en] => Acireale
)
[2] => Array
(
[id] => 30115
[en] => Afragola
)
[3] => Array
(
[id] => 34732
[en] => Altamura
)
[4] => Array
(
[id] => 34769
[en] => Andria
)
[5] => Array
(
[id] => 31168
[en] => Anzio
)
[6] => Array
(
[id] => 31044
[en] => Aprilia
)
[7] => Array
(
[id] => 30015
[en] => Aversa
)
[8] => Array
(
[id] => 35603
[en] => Bagheria
)
[9] => Array
(
[id] => 34770
[en] => Barletta
)
[10] => Array
(
[id] => 30219
[en] => Battipaglia
)
[11] => Array
(
[id] => 34771
[en] => Bisceglie
)
[12] => Array
(
[id] => 34735
[en] => Bitonto
)
[13] => Array
(
[id] => 36056
[en] => Bolzano
)
[14] => Array
(
[id] => 33022
[en] => Busto Arsizio
)
[15] => Array
(
[id] => 30489
[en] => Carpi
)
[16] => Array
(
[id] => 35917
[en] => Carrara
)
[17] => Array
(
[id] => 30130
[en] => Casalnuovo Di Napoli
)
[18] => Array
(
[id] => 30136
[en] => Casoria
)
[19] => Array
(
[id] => 30137
[en] => Castellammare Di Stabia
)
[20] => Array
(
[id] => 34817
[en] => Cerignola
)
[21] => Array
(
[id] => 30454
[en] => Cesena
)
[22] => Array
(
[id] => 36909
[en] => Chioggia
)
[23] => Array
(
[id] => 32581
[en] => Cinisello Balsamo
)
[24] => Array
(
[id] => 31195
[en] => Civitavecchia
)
[25] => Array
(
[id] => 34339
[en] => Collegno
)
[26] => Array
(
[id] => 34743
[en] => Corato
)
[27] => Array
(
[id] => 30144
[en] => Ercolano
)
[28] => Array
(
[id] => 30647
[en] => Faenza
)
[29] => Array
(
[id] => 33330
[en] => Fano
)
[30] => Array
(
[id] => 31201
[en] => Fiumicino
)
[31] => Array
(
[id] => 498006716
[en] => Florence
)
[32] => Array
(
[id] => 36422
[en] => Foligno
)
[33] => Array
(
[id] => 33066
[en] => Gallarate
)
[34] => Array
(
[id] => 35410
[en] => Gela
)
[35] => Array
(
[id] => 498028036
[en] => Génova
)
[36] => Array
(
[id] => 30148
[en] => Giugliano In Campania
)
[37] => Array
(
[id] => 30393
[en] => Imola
)
[38] => Array
(
[id] => 29442
[en] => Lamezia Terme
)
[39] => Array
(
[id] => 32605
[en] => Legnano
)
[40] => Array
(
[id] => 34825
[en] => Manfredonia
)
[41] => Array
(
[id] => 35722
[en] => Marsala
)
[42] => Array
(
[id] => 34969
[en] => Martina Franca
)
[43] => Array
(
[id] => 35924
[en] => Massa
)
[44] => Array
(
[id] => 35723
[en] => Mazara Del Vallo
)
[45] => Array
(
[id] => 498082139
[en] => Milan
)
[46] => Array
(
[id] => 35455
[en] => Misterbianco
)
[47] => Array
(
[id] => 35685
[en] => Modica
)
[48] => Array
(
[id] => 34751
[en] => Molfetta
)
[49] => Array
(
[id] => 34405
[en] => Moncalieri
)
[50] => Array
(
[id] => 34752
[en] => Monopoli
)
[51] => Array
(
[id] => 32710
[en] => Monza
)
[52] => Array
(
[id] => 498082143
[en] => Napoli
)
[53] => Array
(
[id] => 34413
[en] => Nichelino
)
[54] => Array
(
[id] => 35196
[en] => Olbia
)
[55] => Array
(
[id] => 498082150
[en] => Palermo
)
[56] => Array
(
[id] => 33361
[en] => Pesaro
)
[57] => Array
(
[id] => 31246
[en] => Pomezia
)
[58] => Array
(
[id] => 30173
[en] => Portici
)
[59] => Array
(
[id] => 30174
[en] => Pozzuoli
)
[60] => Array
(
[id] => 32640
[en] => Rho
)
[61] => Array
(
[id] => 34468
[en] => Rivoli
)
[62] => Array
(
[id] => 498005754
[en] => Rome
)
[63] => Array
(
[id] => 34845
[en] => San Severo
)
[64] => Array
(
[id] => 30342
[en] => Scafati
)
[65] => Array
(
[id] => 35811
[en] => Scandicci
)
[66] => Array
(
[id] => 32657
[en] => Sesto San Giovanni
)
[67] => Array
(
[id] => 31074
[en] => Terracina
)
[68] => Array
(
[id] => 31271
[en] => Tivoli
)
[69] => Array
(
[id] => 30198
[en] => Torre Del Greco
)
[70] => Array
(
[id] => 34777
[en] => Trani
)
[71] => Array
(
[id] => 498082826
[en] => Turin
)
[72] => Array
(
[id] => 31278
[en] => Velletri
)
[73] => Array
(
[id] => 498082293
[en] => Venice
)
[74] => Array
(
[id] => 35908
[en] => Viareggio
)
[75] => Array
(
[id] => 32903
[en] => Vigevano
)
[76] => Array
(
[id] => 35690
[en] => Vittoria
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=34367 and other_city_id in (30114,35430,30115,34732,34769,31168,31044,30015,35603,34770,30219,34771,34735,36056,33022,30489,35917,30130,30136,30137,34817,30454,36909,32581,31195,34339,34743,30144,30647,33330,31201,498006716,36422,33066,35410,498028036,30148,30393,29442,32605,34825,35722,34969,35924,35723,498082139,35455,35685,34751,34405,34752,32710,498082143,34413,35196,498082150,33361,31246,30173,30174,32640,34468,498005754,34845,30342,35811,32657,31074,31271,30198,34777,498082826,31278,498082293,35908,32903,35690)Array
(
)