Array
(
[0] => Array
(
[id] => 14574
[en] => Alberton
)
[1] => Array
(
[id] => 14838
[en] => Barberton
)
[2] => Array
(
[id] => 14575
[en] => Benoni
)
[3] => Array
(
[id] => 14823
[en] => Bethal
)
[4] => Array
(
[id] => 14478
[en] => Bethlehem
)
[5] => Array
(
[id] => 14397
[en] => Bhisho
)
[6] => Array
(
[id] => 14538
[en] => Bloemfontein
)
[7] => Array
(
[id] => 14576
[en] => Boksburg
)
[8] => Array
(
[id] => 14539
[en] => Botshabelo
)
[9] => Array
(
[id] => 14577
[en] => Brakpan
)
[10] => Array
(
[id] => 14853
[en] => Brits
)
[11] => Array
(
[id] => 15140
[en] => Cape Town
)
[12] => Array
(
[id] => 14627
[en] => Carletonville
)
[13] => Array
(
[id] => 14739
[en] => Dundee
)
[14] => Array
(
[id] => 14660
[en] => Durban
)
[15] => Array
(
[id] => 14402
[en] => East London
)
[16] => Array
(
[id] => 14902
[en] => Fochville
)
[17] => Array
(
[id] => 14404
[en] => Fort Beaufort
)
[18] => Array
(
[id] => 14856
[en] => Ga-rankuwa
)
[19] => Array
(
[id] => 15003
[en] => George
)
[20] => Array
(
[id] => 14435
[en] => Graaff Reinet
)
[21] => Array
(
[id] => 14436
[en] => Grahamstown
)
[22] => Array
(
[id] => 14527
[en] => Heilbron
)
[23] => Array
(
[id] => 14567
[en] => Johannesburg
)
[24] => Array
(
[id] => 14514
[en] => Kgotsong
)
[25] => Array
(
[id] => 14925
[en] => Kimberley
)
[26] => Array
(
[id] => 14904
[en] => Klerksdorp
)
[27] => Array
(
[id] => 15007
[en] => Knysna
)
[28] => Array
(
[id] => 14529
[en] => Kroonstad
)
[29] => Array
(
[id] => 14631
[en] => Krugersdorp
)
[30] => Array
(
[id] => 14892
[en] => Lichtenburg
)
[31] => Array
(
[id] => 14863
[en] => Mabopane
)
[32] => Array
(
[id] => 14569
[en] => Midrand
)
[33] => Array
(
[id] => 14895
[en] => Mmabatho
)
[34] => Array
(
[id] => 14844
[en] => Nelspruit
)
[35] => Array
(
[id] => 14654
[en] => Newcastle
)
[36] => Array
(
[id] => 14907
[en] => Orkney
)
[37] => Array
(
[id] => 15032
[en] => Oudtshoorn
)
[38] => Array
(
[id] => 15122
[en] => Paarl
)
[39] => Array
(
[id] => 14531
[en] => Parys
)
[40] => Array
(
[id] => 14794
[en] => Phalaborwa
)
[41] => Array
(
[id] => 14819
[en] => Piet Retief
)
[42] => Array
(
[id] => 14729
[en] => Pietermaritzburg
)
[43] => Array
(
[id] => 14449
[en] => Port Elizabeth
)
[44] => Array
(
[id] => 14705
[en] => Port Shepstone
)
[45] => Array
(
[id] => 14908
[en] => Potchefstroom
)
[46] => Array
(
[id] => 14601
[en] => Pretoria
)
[47] => Array
(
[id] => 14675
[en] => Queensburgh
)
[48] => Array
(
[id] => 14637
[en] => Randfontein
)
[49] => Array
(
[id] => 14759
[en] => Richards Bay
)
[50] => Array
(
[id] => 14869
[en] => Rustenburg
)
[51] => Array
(
[id] => 15111
[en] => Saldanha
)
[52] => Array
(
[id] => 14532
[en] => Sasolburg
)
[53] => Array
(
[id] => 14881
[en] => Schweizer-reneke
)
[54] => Array
(
[id] => 14573
[en] => Soweto
)
[55] => Array
(
[id] => 15124
[en] => Stellenbosch
)
[56] => Array
(
[id] => 14909
[en] => Stilfontein
)
[57] => Array
(
[id] => 14591
[en] => Tembisa
)
[58] => Array
(
[id] => 14454
[en] => Uitenhage
)
[59] => Array
(
[id] => 14938
[en] => Upington
)
[60] => Array
(
[id] => 14609
[en] => Vanderbijlpark
)
[61] => Array
(
[id] => 14610
[en] => Vereeniging
)
[62] => Array
(
[id] => 14534
[en] => Viljoenskroon
)
[63] => Array
(
[id] => 14520
[en] => Virginia
)
[64] => Array
(
[id] => 14766
[en] => Vryheid
)
[65] => Array
(
[id] => 14521
[en] => Welkom
)
[66] => Array
(
[id] => 14638
[en] => Westonaria
)
[67] => Array
(
[id] => 14837
[en] => Witbank
)
[68] => Array
(
[id] => 15041
[en] => Worcester
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=498101030 and other_city_id in (14574,14838,14575,14823,14478,14397,14538,14576,14539,14577,14853,15140,14627,14739,14660,14402,14902,14404,14856,15003,14435,14436,14527,14567,14514,14925,14904,15007,14529,14631,14892,14863,14569,14895,14844,14654,14907,15032,15122,14531,14794,14819,14729,14449,14705,14908,14601,14675,14637,14759,14869,15111,14532,14881,14573,15124,14909,14591,14454,14938,14609,14610,14534,14520,14766,14521,14638,14837,15041)Array
(
)