Array
(
[0] => Array
(
[id] => 497899313
[en] => Aix-en-provence
)
[1] => Array
(
[id] => 497876155
[en] => Amiens
)
[2] => Array
(
[id] => 497854122
[en] => Angers
)
[3] => Array
(
[id] => 497899578
[en] => Antibes
)
[4] => Array
(
[id] => 497865372
[en] => Argenteuil
)
[5] => Array
(
[id] => 497865017
[en] => Asnieres-sur-seine
)
[6] => Array
(
[id] => 497865081
[en] => Aubervilliers
)
[7] => Array
(
[id] => 497865554
[en] => Aulnay-sous-bois
)
[8] => Array
(
[id] => 497900970
[en] => Avignon
)
[9] => Array
(
[id] => 497912856
[en] => Besancon
)
[10] => Array
(
[id] => 497898454
[en] => Beziers
)
[11] => Array
(
[id] => 497903755
[en] => Bordeaux
)
[12] => Array
(
[id] => 497864200
[en] => Boulogne-billancourt
)
[13] => Array
(
[id] => 497912125
[en] => Bourges
)
[14] => Array
(
[id] => 497860362
[en] => Brest
)
[15] => Array
(
[id] => 497868327
[en] => Caen
)
[16] => Array
(
[id] => 497882966
[en] => Calais
)
[17] => Array
(
[id] => 497899393
[en] => Cannes
)
[18] => Array
(
[id] => 497864039
[en] => Champigny-sur-marne
)
[19] => Array
(
[id] => 497907300
[en] => Clermont-ferrand
)
[20] => Array
(
[id] => 497857965
[en] => Colmar
)
[21] => Array
(
[id] => 497865260
[en] => Colombes
)
[22] => Array
(
[id] => 497864893
[en] => Courbevoie
)
[23] => Array
(
[id] => 497863808
[en] => Creteil
)
[24] => Array
(
[id] => 497853399
[en] => Dijon
)
[25] => Array
(
[id] => 497883206
[en] => Dunkirk
)
[26] => Array
(
[id] => 497904934
[en] => Grenoble
)
[27] => Array
(
[id] => 497864201
[en] => Issy-les-moulineaux
)
[28] => Array
(
[id] => 497910606
[en] => La Roche-sur-yon
)
[29] => Array
(
[id] => 497908849
[en] => La Rochelle
)
[30] => Array
(
[id] => 497871855
[en] => Le Havre
)
[31] => Array
(
[id] => 497857353
[en] => Le Mans
)
[32] => Array
(
[id] => 497864894
[en] => Levallois-perret
)
[33] => Array
(
[id] => 497881779
[en] => Lille
)
[34] => Array
(
[id] => 497907497
[en] => Limoges
)
[35] => Array
(
[id] => 497907214
[en] => Lyon
)
[36] => Array
(
[id] => 497898186
[en] => Marseille
)
[37] => Array
(
[id] => 497903823
[en] => Merignac
)
[38] => Array
(
[id] => 497867427
[en] => Metz
)
[39] => Array
(
[id] => 497899581
[en] => Montpellier
)
[40] => Array
(
[id] => 497864495
[en] => Montreuil
)
[41] => Array
(
[id] => 497855804
[en] => Mulhouse
)
[42] => Array
(
[id] => 497862908
[en] => Nancy
)
[43] => Array
(
[id] => 497864892
[en] => Nanterre
)
[44] => Array
(
[id] => 497912775
[en] => Nantes
)
[45] => Array
(
[id] => 497900010
[en] => Nice
)
[46] => Array
(
[id] => 497900546
[en] => Nimes
)
[47] => Array
(
[id] => 497864378
[en] => Noisy-le-grand
)
[48] => Array
(
[id] => 497856710
[en] => Orleans
)
[49] => Array
(
[id] => 497864493
[en] => Paris
)
[50] => Array
(
[id] => 497898127
[en] => Pau
)
[51] => Array
(
[id] => 497896177
[en] => Perpignan
)
[52] => Array
(
[id] => 497910334
[en] => Poitiers
)
[53] => Array
(
[id] => 497869020
[en] => Reims
)
[54] => Array
(
[id] => 497858124
[en] => Rennes
)
[55] => Array
(
[id] => 497882049
[en] => Roubaix
)
[56] => Array
(
[id] => 497871293
[en] => Rouen
)
[57] => Array
(
[id] => 497864821
[en] => Rueil-malmaison
)
[58] => Array
(
[id] => 497865373
[en] => Saint-denis
)
[59] => Array
(
[id] => 497905855
[en] => Saint-Etienne
)
[60] => Array
(
[id] => 497863866
[en] => Saint-maur-des-fosses
)
[61] => Array
(
[id] => 497853112
[en] => Saint-nazaire
)
[62] => Array
(
[id] => 497862034
[en] => Strasbourg
)
[63] => Array
(
[id] => 497897426
[en] => Toulon
)
[64] => Array
(
[id] => 497899617
[en] => Toulouse
)
[65] => Array
(
[id] => 497882170
[en] => Tourcoing
)
[66] => Array
(
[id] => 497853630
[en] => Tours
)
[67] => Array
(
[id] => 497863967
[en] => Versailles
)
[68] => Array
(
[id] => 497907262
[en] => Villeurbanne
)
[69] => Array
(
[id] => 497863807
[en] => Vitry-sur-seine
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=497910115 and other_city_id in (497899313,497876155,497854122,497899578,497865372,497865017,497865081,497865554,497900970,497912856,497898454,497903755,497864200,497912125,497860362,497868327,497882966,497899393,497864039,497907300,497857965,497865260,497864893,497863808,497853399,497883206,497904934,497864201,497910606,497908849,497871855,497857353,497864894,497881779,497907497,497907214,497898186,497903823,497867427,497899581,497864495,497855804,497862908,497864892,497912775,497900010,497900546,497864378,497856710,497864493,497898127,497896177,497910334,497869020,497858124,497882049,497871293,497864821,497865373,497905855,497863866,497853112,497862034,497897426,497899617,497882170,497853630,497863967,497907262,497863807)Array
(
)