Array
(
[0] => Array
(
[id] => 497882396
[en] => Aachen
)
[1] => Array
(
[id] => 497860096
[en] => Augsburg
)
[2] => Array
(
[id] => 497885435
[en] => Berlin
)
[3] => Array
(
[id] => 497884833
[en] => Bielefeld
)
[4] => Array
(
[id] => 497884054
[en] => Bochum
)
[5] => Array
(
[id] => 497882258
[en] => Bonn
)
[6] => Array
(
[id] => 497884125
[en] => Bottrop
)
[7] => Array
(
[id] => 497886019
[en] => Bremen
)
[8] => Array
(
[id] => 497886561
[en] => Bremerhaven
)
[9] => Array
(
[id] => 497885135
[en] => Brunswick
)
[10] => Array
(
[id] => 497882670
[en] => Chemnitz
)
[11] => Array
(
[id] => 497882972
[en] => Cologne
)
[12] => Array
(
[id] => 497875879
[en] => Darmstadt
)
[13] => Array
(
[id] => 497884107
[en] => Dortmund
)
[14] => Array
(
[id] => 497883250
[en] => Dresden
)
[15] => Array
(
[id] => 497883967
[en] => Duisburg
)
[16] => Array
(
[id] => 497883634
[en] => Dusseldorf
)
[17] => Array
(
[id] => 497883100
[en] => Erfurt
)
[18] => Array
(
[id] => 497884026
[en] => Essen
)
[19] => Array
(
[id] => 497878130
[en] => Frankfurt
)
[20] => Array
(
[id] => 497857323
[en] => Freiburg
)
[21] => Array
(
[id] => 497871764
[en] => Furth
)
[22] => Array
(
[id] => 497884106
[en] => Gelsenkirchen
)
[23] => Array
(
[id] => 497884126
[en] => Gottingen
)
[24] => Array
(
[id] => 497883852
[en] => Hagen
)
[25] => Array
(
[id] => 497884072
[en] => Halle
)
[26] => Array
(
[id] => 497886566
[en] => Hamburg
)
[27] => Array
(
[id] => 497884338
[en] => Hamm
)
[28] => Array
(
[id] => 497885289
[en] => Hanover
)
[29] => Array
(
[id] => 497871030
[en] => Heidelberg
)
[30] => Array
(
[id] => 497867712
[en] => Heilbronn
)
[31] => Array
(
[id] => 497884148
[en] => Herne
)
[32] => Array
(
[id] => 497863649
[en] => Ingolstadt
)
[33] => Array
(
[id] => 497866051
[en] => Karlsruhe
)
[34] => Array
(
[id] => 497883777
[en] => Kassel
)
[35] => Array
(
[id] => 497887849
[en] => Kiel
)
[36] => Array
(
[id] => 497883796
[en] => Krefeld
)
[37] => Array
(
[id] => 497883839
[en] => Leipzig
)
[38] => Array
(
[id] => 497883209
[en] => Leverkusen
)
[39] => Array
(
[id] => 497887168
[en] => Lubeck
)
[40] => Array
(
[id] => 497871753
[en] => Ludwigshafen
)
[41] => Array
(
[id] => 497884967
[en] => Magdeburg
)
[42] => Array
(
[id] => 497877176
[en] => Mainz
)
[43] => Array
(
[id] => 497871953
[en] => Mannheim
)
[44] => Array
(
[id] => 497883528
[en] => Monchengladbach
)
[45] => Array
(
[id] => 497883968
[en] => Mulheim
)
[46] => Array
(
[id] => 497858364
[en] => Munich
)
[47] => Array
(
[id] => 497884752
[en] => Munster
)
[48] => Array
(
[id] => 497883529
[en] => Neuss
)
[49] => Array
(
[id] => 497871389
[en] => Nuremberg
)
[50] => Array
(
[id] => 497884025
[en] => Oberhausen
)
[51] => Array
(
[id] => 497877992
[en] => Offenbach
)
[52] => Array
(
[id] => 497886064
[en] => Oldenburg
)
[53] => Array
(
[id] => 497885145
[en] => Osnabruck
)
[54] => Array
(
[id] => 497884410
[en] => Paderborn
)
[55] => Array
(
[id] => 497864831
[en] => Pforzheim
)
[56] => Array
(
[id] => 497885301
[en] => Potsdam
)
[57] => Array
(
[id] => 497866250
[en] => Ratisbon
)
[58] => Array
(
[id] => 497884256
[en] => Recklinghausen
)
[59] => Array
(
[id] => 497883498
[en] => Remscheid
)
[60] => Array
(
[id] => 497861193
[en] => Reutlingen
)
[61] => Array
(
[id] => 497887542
[en] => Rostock
)
[62] => Array
(
[id] => 497869051
[en] => Saarbrucken
)
[63] => Array
(
[id] => 497883497
[en] => Solingen
)
[64] => Array
(
[id] => 497863812
[en] => Stuttgart
)
[65] => Array
(
[id] => 497860494
[en] => Ulm
)
[66] => Array
(
[id] => 497877842
[en] => Wiesbaden
)
[67] => Array
(
[id] => 497885336
[en] => Wolfsburg
)
[68] => Array
(
[id] => 497883676
[en] => Wuppertal
)
[69] => Array
(
[id] => 497875224
[en] => Wurzburg
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=497880740 and other_city_id in (497882396,497860096,497885435,497884833,497884054,497882258,497884125,497886019,497886561,497885135,497882670,497882972,497875879,497884107,497883250,497883967,497883634,497883100,497884026,497878130,497857323,497871764,497884106,497884126,497883852,497884072,497886566,497884338,497885289,497871030,497867712,497884148,497863649,497866051,497883777,497887849,497883796,497883839,497883209,497887168,497871753,497884967,497877176,497871953,497883528,497883968,497858364,497884752,497883529,497871389,497884025,497877992,497886064,497885145,497884410,497864831,497885301,497866250,497884256,497883498,497861193,497887542,497869051,497883497,497863812,497860494,497877842,497885336,497883676,497875224)Array
(
[0] => Array
(
[id] => 497883852
[distance] => 101.72
)
)