Array
(
[0] => Array
(
[id] => 497888357
[en] => Aabenraa
)
[1] => Array
(
[id] => 497889328
[en] => Aalborg
)
[2] => Array
(
[id] => 172244
[en] => Albertslund
)
[3] => Array
(
[id] => 497889005
[en] => Arhus
)
[4] => Array
(
[id] => 172243
[en] => Ballerup
)
[5] => Array
(
[id] => 497888816
[en] => Birkerod
)
[6] => Array
(
[id] => 172242
[en] => Brondby
)
[7] => Array
(
[id] => 497889371
[en] => Bronderslev
)
[8] => Array
(
[id] => 497888710
[en] => Copenhagen
)
[9] => Array
(
[id] => 497888573
[en] => Esbjerg
)
[10] => Array
(
[id] => 497888796
[en] => Farum
)
[11] => Array
(
[id] => 497888651
[en] => Fredericia
)
[12] => Array
(
[id] => 172240
[en] => Frederiksberg
)
[13] => Array
(
[id] => 497889383
[en] => Frederikshavn
)
[14] => Array
(
[id] => 497888814
[en] => Frederikssund
)
[15] => Array
(
[id] => 497888889
[en] => Frederiksvaerk
)
[16] => Array
(
[id] => 172239
[en] => Gentofte
)
[17] => Array
(
[id] => 172238
[en] => Gladsaxe
)
[18] => Array
(
[id] => 172237
[en] => Glostrup
)
[19] => Array
(
[id] => 497792679
[en] => Grenaa
)
[20] => Array
(
[id] => 497888653
[en] => Greve Strand
)
[21] => Array
(
[id] => 497888443
[en] => Haderslev
)
[22] => Array
(
[id] => 497888698
[en] => Hedehusene
)
[23] => Array
(
[id] => 497888935
[en] => Helsingor
)
[24] => Array
(
[id] => 172236
[en] => Herlev
)
[25] => Array
(
[id] => 497888988
[en] => Herning
)
[26] => Array
(
[id] => 497888871
[en] => Hillerod
)
[27] => Array
(
[id] => 497889384
[en] => Hjorring
)
[28] => Array
(
[id] => 497888742
[en] => Holbaek
)
[29] => Array
(
[id] => 497889091
[en] => Holstebro
)
[30] => Array
(
[id] => 497888836
[en] => Horsens
)
[31] => Array
(
[id] => 497888850
[en] => Horsholm
)
[32] => Array
(
[id] => 497888989
[en] => Ikast
)
[33] => Array
(
[id] => 497888673
[en] => Ishoj
)
[34] => Array
(
[id] => 497888726
[en] => Kalundborg
)
[35] => Array
(
[id] => 497888572
[en] => Koge
)
[36] => Array
(
[id] => 497888604
[en] => Kolding
)
[37] => Array
(
[id] => 497888499
[en] => Korsor
)
[38] => Array
(
[id] => 497888839
[en] => Lillerod
)
[39] => Array
(
[id] => 497888600
[en] => Middelfart
)
[40] => Array
(
[id] => 497888439
[en] => Naestved
)
[41] => Array
(
[id] => 497888265
[en] => Nakskov
)
[42] => Array
(
[id] => 497889331
[en] => Norresundby
)
[43] => Array
(
[id] => 497888799
[en] => Nyborg
)
[44] => Array
(
[id] => 497792680
[en] => Nykobing
)
[45] => Array
(
[id] => 497888535
[en] => Odense
)
[46] => Array
(
[id] => 497888794
[en] => Olstykke St.
)
[47] => Array
(
[id] => 497889154
[en] => Randers
)
[48] => Array
(
[id] => 497888568
[en] => Ringsted
)
[49] => Array
(
[id] => 497888384
[en] => Ronne
)
[50] => Array
(
[id] => 497888697
[en] => Roskilde
)
[51] => Array
(
[id] => 497889010
[en] => Silkeborg
)
[52] => Array
(
[id] => 497888930
[en] => Skanderborg
)
[53] => Array
(
[id] => 497889196
[en] => Skive
)
[54] => Array
(
[id] => 497888536
[en] => Slagelse
)
[55] => Array
(
[id] => 497888755
[en] => Smorumnedre
)
[56] => Array
(
[id] => 497888626
[en] => Solrod Strand
)
[57] => Array
(
[id] => 497888306
[en] => Sonderborg
)
[58] => Array
(
[id] => 497888367
[en] => Svendborg
)
[59] => Array
(
[id] => 497888699
[en] => Taastrup
)
[60] => Array
(
[id] => 497889146
[en] => Thisted
)
[61] => Array
(
[id] => 497888756
[en] => Vaerlose
)
[62] => Array
(
[id] => 172231
[en] => Vallensbaek
)
[63] => Array
(
[id] => 497888675
[en] => Varde
)
[64] => Array
(
[id] => 497888731
[en] => Vejle
)
[65] => Array
(
[id] => 497889136
[en] => Viborg
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=497888731 and other_city_id in (497888357,497889328,172244,497889005,172243,497888816,172242,497889371,497888710,497888573,497888796,497888651,172240,497889383,497888814,497888889,172239,172238,172237,497792679,497888653,497888443,497888698,497888935,172236,497888988,497888871,497889384,497888742,497889091,497888836,497888850,497888989,497888673,497888726,497888572,497888604,497888499,497888839,497888600,497888439,497888265,497889331,497888799,497792680,497888535,497888794,497889154,497888568,497888384,497888697,497889010,497888930,497889196,497888536,497888755,497888626,497888306,497888367,497888699,497889146,497888756,172231,497888675,497888731,497889136)Array
(
[0] => Array
(
[id] => 497888731
[distance] => 0.00
)
[1] => Array
(
[id] => 497888799
[distance] => 12.23
)
)