Array
(
[0] => Array
(
[id] => 497998248
[en] => Angeles
)
[1] => Array
(
[id] => 497998069
[en] => Antipolo
)
[2] => Array
(
[id] => 497996474
[en] => Bacolod
)
[3] => Array
(
[id] => 497998052
[en] => Bacoor
)
[4] => Array
(
[id] => 497998810
[en] => Baguio
)
[5] => Array
(
[id] => 497997660
[en] => Batangas
)
[6] => Array
(
[id] => 497998055
[en] => Binangonan
)
[7] => Array
(
[id] => 497995850
[en] => Butuan
)
[8] => Array
(
[id] => 497998383
[en] => Cabanatuan
)
[9] => Array
(
[id] => 497996667
[en] => Cadiz
)
[10] => Array
(
[id] => 497995712
[en] => Cagayan
)
[11] => Array
(
[id] => 497998068
[en] => Cainta
)
[12] => Array
(
[id] => 497997967
[en] => Calamba
)
[13] => Array
(
[id] => 497994737
[en] => Caloocan City
)
[14] => Array
(
[id] => 497996335
[en] => Cebu
)
[15] => Array
(
[id] => 497994744
[en] => City Of Makati
)
[16] => Array
(
[id] => 497994742
[en] => City Of Marikina
)
[17] => Array
(
[id] => 497994741
[en] => City Of Muntinlupa
)
[18] => Array
(
[id] => 497994740
[en] => City Of Paranaque
)
[19] => Array
(
[id] => 497994739
[en] => City Of Pasig
)
[20] => Array
(
[id] => 497994738
[en] => City Of Valenzuela
)
[21] => Array
(
[id] => 497995262
[en] => Cotabato
)
[22] => Array
(
[id] => 497994879
[en] => Dadiangas
)
[23] => Array
(
[id] => 497998018
[en] => Dasmarinas
)
[24] => Array
(
[id] => 497995202
[en] => Davao
)
[25] => Array
(
[id] => 497995066
[en] => Digos
)
[26] => Array
(
[id] => 497994719
[en] => General Mariano Alvarez
)
[27] => Array
(
[id] => 497998124
[en] => Guyong
)
[28] => Array
(
[id] => 497998121
[en] => Hagonoy
)
[29] => Array
(
[id] => 497995624
[en] => Iligan
)
[30] => Array
(
[id] => 497996507
[en] => Iloilo
)
[31] => Array
(
[id] => 497998042
[en] => Imus
)
[32] => Array
(
[id] => 497996193
[en] => Kabankalan
)
[33] => Array
(
[id] => 497994963
[en] => Koronadal
)
[34] => Array
(
[id] => 497996343
[en] => Lapu Lapu
)
[35] => Array
(
[id] => 497994736
[en] => Las Pinas
)
[36] => Array
(
[id] => 497997364
[en] => Legazpi
)
[37] => Array
(
[id] => 497997797
[en] => Lipa
)
[38] => Array
(
[id] => 497997800
[en] => Lucena
)
[39] => Array
(
[id] => 497998272
[en] => Mabalacat
)
[40] => Array
(
[id] => 497994735
[en] => Malabon
)
[41] => Array
(
[id] => 497998128
[en] => Malolos
)
[42] => Array
(
[id] => 497994743
[en] => Mandaluyong
)
[43] => Array
(
[id] => 497996342
[en] => Mandaue
)
[44] => Array
(
[id] => 497998074
[en] => Manila
)
[45] => Array
(
[id] => 497995550
[en] => Marawi
)
[46] => Array
(
[id] => 497998098
[en] => Meycauayan
)
[47] => Array
(
[id] => 497998102
[en] => Montalban
)
[48] => Array
(
[id] => 497997572
[en] => Naga
)
[49] => Array
(
[id] => 497994734
[en] => Navotas
)
[50] => Array
(
[id] => 497998116
[en] => Olongapo
)
[51] => Array
(
[id] => 497995496
[en] => Pagadian
)
[52] => Array
(
[id] => 497994733
[en] => Pasay City
)
[53] => Array
(
[id] => 497996058
[en] => Puerto Princesa
)
[54] => Array
(
[id] => 497994731
[en] => Quezon City
)
[55] => Array
(
[id] => 497998208
[en] => San Fernando
)
[56] => Array
(
[id] => 497998115
[en] => San Jose Del Monte
)
[57] => Array
(
[id] => 497998091
[en] => San Mateo
)
[58] => Array
(
[id] => 497997875
[en] => San Pablo
)
[59] => Array
(
[id] => 497998030
[en] => San Pedro
)
[60] => Array
(
[id] => 497998011
[en] => Santa Rosa
)
[61] => Array
(
[id] => 497996854
[en] => Tacloban
)
[62] => Array
(
[id] => 497994729
[en] => Taguig
)
[63] => Array
(
[id] => 497995325
[en] => Tagum
)
[64] => Array
(
[id] => 497996304
[en] => Talisay
)
[65] => Array
(
[id] => 497998372
[en] => Tarlac
)
[66] => Array
(
[id] => 497998067
[en] => Taytay
)
[67] => Array
(
[id] => 497996361
[en] => Toledo
)
[68] => Array
(
[id] => 497999036
[en] => Tuguegarao
)
[69] => Array
(
[id] => 497995111
[en] => Zamboanga
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=497998344 and other_city_id in (497998248,497998069,497996474,497998052,497998810,497997660,497998055,497995850,497998383,497996667,497995712,497998068,497997967,497994737,497996335,497994744,497994742,497994741,497994740,497994739,497994738,497995262,497994879,497998018,497995202,497995066,497994719,497998124,497998121,497995624,497996507,497998042,497996193,497994963,497996343,497994736,497997364,497997797,497997800,497998272,497994735,497998128,497994743,497996342,497998074,497995550,497998098,497998102,497997572,497994734,497998116,497995496,497994733,497996058,497994731,497998208,497998115,497998091,497997875,497998030,497998011,497996854,497994729,497995325,497996304,497998372,497998067,497996361,497999036,497995111)Array
(
)