Array
(
[0] => Array
(
[id] => 497898268
[en] => A Coruna
)
[1] => Array
(
[id] => 497890555
[en] => Albacete
)
[2] => Array
(
[id] => 497891834
[en] => Alcala De Henares
)
[3] => Array
(
[id] => 497890174
[en] => Alicante
)
[4] => Array
(
[id] => 497889518
[en] => Almeria
)
[5] => Array
(
[id] => 497890460
[en] => Badajoz
)
[6] => Array
(
[id] => 497893457
[en] => Badalona
)
[7] => Array
(
[id] => 497893369
[en] => Barcelona
)
[8] => Array
(
[id] => 497890260
[en] => Benidorm
)
[9] => Array
(
[id] => 497897871
[en] => Bilbao
)
[10] => Array
(
[id] => 497895273
[en] => Burgos
)
[11] => Array
(
[id] => 497890782
[en] => Caceres
)
[12] => Array
(
[id] => 497889426
[en] => Cadiz
)
[13] => Array
(
[id] => 497891226
[en] => Castello
)
[14] => Array
(
[id] => 498009663
[en] => Cathedral - Mosque
)
[15] => Array
(
[id] => 497890012
[en] => Cordoba
)
[16] => Array
(
[id] => 498082829
[en] => Costa Blanca
)
[17] => Array
(
[id] => 498082942
[en] => Costa Brava
)
[18] => Array
(
[id] => 498082996
[en] => Costa Cálida
)
[19] => Array
(
[id] => 498082973
[en] => Costa de La Palma
)
[20] => Array
(
[id] => 498082834
[en] => Costa De Almería
)
[21] => Array
(
[id] => 498082947
[en] => Costa de Azahar
)
[22] => Array
(
[id] => 498082998
[en] => Costa de Cantabria
)
[23] => Array
(
[id] => 498082879
[en] => Costa de El Hierro
)
[24] => Array
(
[id] => 498082952
[en] => Costa de Formentera
)
[25] => Array
(
[id] => 498083005
[en] => Costa de Fuerteventura
)
[26] => Array
(
[id] => 498082880
[en] => Costa de Gran Canaria
)
[27] => Array
(
[id] => 498082958
[en] => Costa de Ibiza
)
[28] => Array
(
[id] => 498083008
[en] => Costa De La Gomera
)
[29] => Array
(
[id] => 498082835
[en] => Costa De La Luz
)
[30] => Array
(
[id] => 498082909
[en] => Costa de Lanzarote
)
[31] => Array
(
[id] => 498083014
[en] => Costa De Mallorca
)
[32] => Array
(
[id] => 498082919
[en] => Costa de Menorca
)
[33] => Array
(
[id] => 498082977
[en] => Costa de Tenerife
)
[34] => Array
(
[id] => 498083000
[en] => Costa de Valencia
)
[35] => Array
(
[id] => 498082948
[en] => Costa del Sol
)
[36] => Array
(
[id] => 498082865
[en] => Costa Dorada
)
[37] => Array
(
[id] => 498082950
[en] => Costa Maresme y Garraf
)
[38] => Array
(
[id] => 498082867
[en] => Costa Tropical
)
[39] => Array
(
[id] => 498082951
[en] => Costa Vasca
)
[40] => Array
(
[id] => 498083004
[en] => Costa Verde ( Asturias )
)
[41] => Array
(
[id] => 498083001
[en] => Costas de Galicia
)
[42] => Array
(
[id] => 497890481
[en] => Eivissa
)
[43] => Array
(
[id] => 497899247
[en] => Gijon
)
[44] => Array
(
[id] => 497894491
[en] => Girona
)
[45] => Array
(
[id] => 497889666
[en] => Granada
)
[46] => Array
(
[id] => 497889723
[en] => Huelva
)
[47] => Array
(
[id] => 497889988
[en] => Jaen
)
[48] => Array
(
[id] => 497889456
[en] => Jerez de la Frontera
)
[49] => Array
(
[id] => 497931423
[en] => Las Palmas de Gran Canaria
)
[50] => Array
(
[id] => 497895917
[en] => Leon
)
[51] => Array
(
[id] => 497893757
[en] => Lleida
)
[52] => Array
(
[id] => 497895571
[en] => Logrono
)
[53] => Array
(
[id] => 497896918
[en] => Lugo
)
[54] => Array
(
[id] => 497891732
[en] => Madrid
)
[55] => Array
(
[id] => 497889465
[en] => Malaga
)
[56] => Array
(
[id] => 497889425
[en] => Marbella
)
[57] => Array
(
[id] => 497893609
[en] => Mataro
)
[58] => Array
(
[id] => 498048123
[en] => Medina Azahara
)
[59] => Array
(
[id] => 497891610
[en] => Mostoles
)
[60] => Array
(
[id] => 497890033
[en] => Murcia
)
[61] => Array
(
[id] => 497895213
[en] => Ourense
)
[62] => Array
(
[id] => 497898362
[en] => Oviedo
)
[63] => Array
(
[id] => 497890856
[en] => Palma de Mallorca
)
[64] => Array
(
[id] => 497896412
[en] => Pamplona
)
[65] => Array
(
[id] => 497892589
[en] => Salamanca
)
[66] => Array
(
[id] => 497892843
[en] => Salou
)
[67] => Array
(
[id] => 497931588
[en] => Santa Cruz De Tenerife
)
[68] => Array
(
[id] => 497898957
[en] => Santander
)
[69] => Array
(
[id] => 497896547
[en] => Santiago De Compostela
)
[70] => Array
(
[id] => 497889843
[en] => Seville
)
[71] => Array
(
[id] => 497892899
[en] => Tarragona
)
[72] => Array
(
[id] => 497891110
[en] => Toledo
)
[73] => Array
(
[id] => 497890796
[en] => Valencia
)
[74] => Array
(
[id] => 497893813
[en] => Valladolid
)
[75] => Array
(
[id] => 497894944
[en] => Vigo
)
[76] => Array
(
[id] => 497896481
[en] => Vitoria
)
[77] => Array
(
[id] => 497893824
[en] => Zaragoza
)
)
select other_city_id as id, distance from keops.geoplaces_cities_distances where
city_id=498085254 and other_city_id in (497898268,497890555,497891834,497890174,497889518,497890460,497893457,497893369,497890260,497897871,497895273,497890782,497889426,497891226,498009663,497890012,498082829,498082942,498082996,498082973,498082834,498082947,498082998,498082879,498082952,498083005,498082880,498082958,498083008,498082835,498082909,498083014,498082919,498082977,498083000,498082948,498082865,498082950,498082867,498082951,498083004,498083001,497890481,497899247,497894491,497889666,497889723,497889988,497889456,497931423,497895917,497893757,497895571,497896918,497891732,497889465,497889425,497893609,498048123,497891610,497890033,497895213,497898362,497890856,497896412,497892589,497892843,497931588,497898957,497896547,497889843,497892899,497891110,497890796,497893813,497894944,497896481,497893824)Array
(
)