Array
(
[0] => Array
(
[id] => 190305
[en] => Abottabad
)
[1] => Array
(
[id] => 188568
[en] => Ahmadpur East
)
[2] => Array
(
[id] => 188773
[en] => Arifwala
)
[3] => Array
(
[id] => 188732
[en] => Bahawalnagar
)
[4] => Array
(
[id] => 188653
[en] => Bahawalpur
)
[5] => Array
(
[id] => 188752
[en] => Burewala
)
[6] => Array
(
[id] => 189886
[en] => Chakwal
)
[7] => Array
(
[id] => 188892
[en] => Chaman
)
[8] => Array
(
[id] => 190308
[en] => Charsadda
)
[9] => Array
(
[id] => 189106
[en] => Chiniot
)
[10] => Array
(
[id] => 188703
[en] => Chishtian Mandi
)
[11] => Array
(
[id] => 188195
[en] => Dadu
)
[12] => Array
(
[id] => 189543
[en] => Daska
)
[13] => Array
(
[id] => 188738
[en] => Dera Ghazi Khan
)
[14] => Array
(
[id] => 189164
[en] => Dera Ismail Khan
)
[15] => Array
(
[id] => 188999
[en] => Faisalabad
)
[16] => Array
(
[id] => 188933
[en] => Gojra
)
[17] => Array
(
[id] => 189406
[en] => Gujranwala
)
[18] => Array
(
[id] => 189712
[en] => Gujrat
)
[19] => Array
(
[id] => 189344
[en] => Hafizabad
)
[20] => Array
(
[id] => 188693
[en] => Hasilpur
)
[21] => Array
(
[id] => 187915
[en] => Hyderabad
)
[22] => Array
(
[id] => 190140
[en] => Islamabad
)
[23] => Array
(
[id] => 188468
[en] => Jacobabad
)
[24] => Array
(
[id] => 188983
[en] => Jaranwala
)
[25] => Array
(
[id] => 188965
[en] => Jhang
)
[26] => Array
(
[id] => 189893
[en] => Jhelum
)
[27] => Array
(
[id] => 188858
[en] => Kamalia
)
[28] => Array
(
[id] => 189270
[en] => Kamoke
)
[29] => Array
(
[id] => 187791
[en] => Karachi
)
[30] => Array
(
[id] => 188929
[en] => Kasur
)
[31] => Array
(
[id] => 188348
[en] => Khairpur
)
[32] => Array
(
[id] => 188461
[en] => Khandh Kot
)
[33] => Array
(
[id] => 188776
[en] => Khanewal
)
[34] => Array
(
[id] => 188510
[en] => Khanpur
)
[35] => Array
(
[id] => 189510
[en] => Khushab
)
[36] => Array
(
[id] => 188400
[en] => Khuzdar
)
[37] => Array
(
[id] => 190106
[en] => Kohat
)
[38] => Array
(
[id] => 188811
[en] => Kot Addu
)
[39] => Array
(
[id] => 189044
[en] => Lahore
)
[40] => Array
(
[id] => 188355
[en] => Larkana
)
[41] => Array
(
[id] => 189718
[en] => Mandi Bahauddin
)
[42] => Array
(
[id] => 190321
[en] => Mardan
)
[43] => Array
(
[id] => 190594
[en] => Mingaora
)
[44] => Array
(
[id] => 187957
[en] => Mirpur Khas
)
[45] => Array
(
[id] => 188759
[en] => Multan
)
[46] => Array
(
[id] => 189147
[en] => Muridke
)
[47] => Array
(
[id] => 188740
[en] => Muzaffargarh
)
[48] => Array
(
[id] => 188107
[en] => Nawabshah
)
[49] => Array
(
[id] => 190254
[en] => Nowshera
)
[50] => Array
(
[id] => 188873
[en] => Okara
)
[51] => Array
(
[id] => 188781
[en] => Pakpattan
)
[52] => Array
(
[id] => 190253
[en] => Peshawar
)
[53] => Array
(
[id] => 188760
[en] => Quetta
)
[54] => Array
(
[id] => 188487
[en] => Rahim Yar Khan
)
[55] => Array
(
[id] => 190107
[en] => Rawalpindi
)
[56] => Array
(
[id] => 188470
[en] => Sadiqabad
)
[57] => Array
(
[id] => 188845
[en] => Sahiwal
)
[58] => Array
(
[id] => 189352
[en] => Sargodha
)
[59] => Array
(
[id] => 189108
[en] => Shekhupura
)
[60] => Array
(
[id] => 188431
[en] => Shikarpur
)
[61] => Array
(
[id] => 189676
[en] => Sialkot
)
[62] => Array
(
[id] => 188388
[en] => Sukkur
)
[63] => Array
(
[id] => 190300
[en] => Swabi
)
[64] => Array
(
[id] => 187999
[en] => Tando Adam
)
[65] => Array
(
[id] => 187938
[en] => Tando Allah Yar
)
[66] => Array
(
[id] => 190161
[en] => Taxila
)
[67] => Array
(
[id] => 188736
[en] => Vihari
)
[68] => Array
(
[id] => 190166
[en] => Wah
)
[69] => Array
(
[id] => 189620
[en] => Wazirabad
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=188232 and other_city_id in (190305,188568,188773,188732,188653,188752,189886,188892,190308,189106,188703,188195,189543,188738,189164,188999,188933,189406,189712,189344,188693,187915,190140,188468,188983,188965,189893,188858,189270,187791,188929,188348,188461,188776,188510,189510,188400,190106,188811,189044,188355,189718,190321,190594,187957,188759,189147,188740,188107,190254,188873,188781,190253,188760,188487,190107,188470,188845,189352,189108,188431,189676,188388,190300,187999,187938,190161,188736,190166,189620)Array
(
[0] => Array
(
[id] => 188195
[distance] => 47.61
)
)