Array
(
[0] => Array
(
[id] => 92893
[en] => Aalst
)
[1] => Array
(
[id] => 92995
[en] => Aarschot
)
[2] => Array
(
[id] => 93241
[en] => Ans
)
[3] => Array
(
[id] => 92818
[en] => Antwerp
)
[4] => Array
(
[id] => 93313
[en] => Arlon
)
[5] => Array
(
[id] => 92961
[en] => Asse
)
[6] => Array
(
[id] => 93151
[en] => Ath
)
[7] => Array
(
[id] => 93029
[en] => Beringen
)
[8] => Array
(
[id] => 92951
[en] => Beveren
)
[9] => Array
(
[id] => 93060
[en] => Bilzen
)
[10] => Array
(
[id] => 93198
[en] => Binche
)
[11] => Array
(
[id] => 92822
[en] => Brasschaat
)
[12] => Array
(
[id] => 92823
[en] => Brecht
)
[13] => Array
(
[id] => 93429
[en] => Brussels
)
[14] => Array
(
[id] => 93161
[en] => Charleroi
)
[15] => Array
(
[id] => 93162
[en] => Chatelet
)
[16] => Array
(
[id] => 93163
[en] => Courcelles
)
[17] => Array
(
[id] => 92921
[en] => Deinze
)
[18] => Array
(
[id] => 92905
[en] => Dendermonde
)
[19] => Array
(
[id] => 92964
[en] => Dilbeek
)
[20] => Array
(
[id] => 92923
[en] => Evergem
)
[21] => Array
(
[id] => 92865
[en] => Geel
)
[22] => Array
(
[id] => 93031
[en] => Genk
)
[23] => Array
(
[id] => 92896
[en] => Geraardsbergen
)
[24] => Array
(
[id] => 92968
[en] => Grimbergen
)
[25] => Array
(
[id] => 92969
[en] => Halle
)
[26] => Array
(
[id] => 93098
[en] => Harelbeke
)
[27] => Array
(
[id] => 93035
[en] => Hasselt
)
[28] => Array
(
[id] => 92851
[en] => Heist-op-den-berg
)
[29] => Array
(
[id] => 93254
[en] => Herstal
)
[30] => Array
(
[id] => 93037
[en] => Heusden-zolder
)
[31] => Array
(
[id] => 93051
[en] => Houthalen-helchteren
)
[32] => Array
(
[id] => 93116
[en] => Izegem
)
[33] => Array
(
[id] => 93085
[en] => Knokke-heist
)
[34] => Array
(
[id] => 93099
[en] => Kortrijk
)
[35] => Array
(
[id] => 93191
[en] => La Louviere
)
[36] => Array
(
[id] => 93014
[en] => Leuven
)
[37] => Array
(
[id] => 93256
[en] => Liege
)
[38] => Array
(
[id] => 92852
[en] => Lier
)
[39] => Array
(
[id] => 92953
[en] => Lokeren
)
[40] => Array
(
[id] => 93053
[en] => Lommel
)
[41] => Array
(
[id] => 93067
[en] => Maasmechelen
)
[42] => Array
(
[id] => 92853
[en] => Mechelen
)
[43] => Array
(
[id] => 93102
[en] => Menen
)
[44] => Array
(
[id] => 92877
[en] => Mol
)
[45] => Array
(
[id] => 93181
[en] => Mons
)
[46] => Array
(
[id] => 93187
[en] => Mouscron
)
[47] => Array
(
[id] => 93386
[en] => Namur
)
[48] => Array
(
[id] => 92900
[en] => Ninove
)
[49] => Array
(
[id] => 93112
[en] => Ostend
)
[50] => Array
(
[id] => 93416
[en] => Ottignies-louvain-la-neuve
)
[51] => Array
(
[id] => 92946
[en] => Oudenaarde
)
[52] => Array
(
[id] => 93120
[en] => Roeselare
)
[53] => Array
(
[id] => 93389
[en] => Sambreville
)
[54] => Array
(
[id] => 92839
[en] => Schoten
)
[55] => Array
(
[id] => 93260
[en] => Seraing
)
[56] => Array
(
[id] => 92955
[en] => Sint-niklaas
)
[57] => Array
(
[id] => 92987
[en] => Sint-pieters-leeuw
)
[58] => Array
(
[id] => 93042
[en] => Sint-truiden
)
[59] => Array
(
[id] => 93022
[en] => Tienen
)
[60] => Array
(
[id] => 93069
[en] => Tongeren
)
[61] => Array
(
[id] => 93219
[en] => Tournai
)
[62] => Array
(
[id] => 92883
[en] => Turnhout
)
[63] => Array
(
[id] => 93291
[en] => Verviers
)
[64] => Array
(
[id] => 92990
[en] => Vilvoorde
)
[65] => Array
(
[id] => 93104
[en] => Waregem
)
[66] => Array
(
[id] => 93424
[en] => Waterloo
)
[67] => Array
(
[id] => 93425
[en] => Wavre
)
[68] => Array
(
[id] => 93105
[en] => Wevelgem
)
[69] => Array
(
[id] => 92993
[en] => Zaventem
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=498090226 and other_city_id in (92893,92995,93241,92818,93313,92961,93151,93029,92951,93060,93198,92822,92823,93429,93161,93162,93163,92921,92905,92964,92923,92865,93031,92896,92968,92969,93098,93035,92851,93254,93037,93051,93116,93085,93099,93191,93014,93256,92852,92953,93053,93067,92853,93102,92877,93181,93187,93386,92900,93112,93416,92946,93120,93389,92839,93260,92955,92987,93042,93022,93069,93219,92883,93291,92990,93104,93424,93425,93105,92993)Array
(
[0] => Array
(
[id] => 93085
[distance] => 16.49
)
)