select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497915699 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by en ascArray ( )
Array
(
[0] => Array
(
[id] => 497898268
[en] => A Coruna
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137867
[distance] => 514.356428679333
)
[1] => Array
(
[id] => 497890555
[en] => Albacete
[important_3] => 1
[asc_3] => 560
[asc_4] => 135210
[asc_5] => 137864
[distance] => 450.472307557673
)
[2] => Array
(
[id] => 497891834
[en] => Alcala De Henares
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 304.763394079099
)
[3] => Array
(
[id] => 497890174
[en] => Alicante
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137866
[distance] => 539.599229865576
)
[4] => Array
(
[id] => 497889518
[en] => Almeria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137863
[distance] => 692.012307641151
)
[5] => Array
(
[id] => 497890460
[en] => Badajoz
[important_3] => 1
[asc_3] => 560
[asc_4] => 135206
[asc_5] => 137860
[distance] => 618.621060718125
)
[6] => Array
(
[id] => 497893457
[en] => Badalona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 397.825707194902
)
[7] => Array
(
[id] => 497893369
[en] => Barcelona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 404.322893548035
)
[8] => Array
(
[id] => 497890260
[en] => Benidorm
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137866
[distance] => 526.227215470656
)
[9] => Array
(
[id] => 497897871
[en] => Bilbao
[important_3] => 1
[asc_3] => 560
[asc_4] => 135200
[asc_5] => 137820
[distance] => 72.089232432136
)
[10] => Array
(
[id] => 497895273
[en] => Burgos
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137857
[distance] => 152.364965573342
)
[11] => Array
(
[id] => 497890782
[en] => Caceres
[important_3] => 1
[asc_3] => 560
[asc_4] => 135206
[asc_5] => 137856
[distance] => 535.695311647583
)
[12] => Array
(
[id] => 497889426
[en] => Cadiz
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137855
[distance] => 808.609512251810
)
[13] => Array
(
[id] => 497891226
[en] => Castello
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137853
[distance] => 381.889900403130
)
[14] => Array
(
[id] => 497890012
[en] => Cordoba
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137851
[distance] => 617.793927294540
)
[15] => Array
(
[id] => 497890481
[en] => Eivissa
[important_3] => 1
[asc_3] => 560
[asc_4] => 135213
[asc_5] => 497999202
[distance] => 546.042101045455
)
[16] => Array
(
[id] => 497899247
[en] => Gijon
[important_3] => 1
[asc_3] => 560
[asc_4] => 135214
[asc_5] => 137862
[distance] => 294.992530615862
)
[17] => Array
(
[id] => 497894491
[en] => Girona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137849
[distance] => 418.365481137231
)
[18] => Array
(
[id] => 497889666
[en] => Granada
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137848
[distance] => 665.957173776799
)
[19] => Array
(
[id] => 497889723
[en] => Huelva
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137845
[distance] => 765.083599563878
)
[20] => Array
(
[id] => 497889988
[en] => Jaen
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137843
[distance] => 604.517781739184
)
[21] => Array
(
[id] => 497889456
[en] => Jerez de la Frontera
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137855
[distance] => 787.470850011118
)
[22] => Array
(
[id] => 497931423
[en] => Las Palmas de Gran Canaria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135212
[asc_5] => 137841
[distance] => 2048.337596827853
)
[23] => Array
(
[id] => 497895917
[en] => Leon
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137840
[distance] => 288.694643402638
)
[24] => Array
(
[id] => 497893757
[en] => Lleida
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137839
[distance] => 273.898356881940
)
[25] => Array
(
[id] => 497895571
[en] => Logrono
[important_3] => 1
[asc_3] => 560
[asc_4] => 135204
[asc_5] => 137842
[distance] => 70.496899858387
)
[26] => Array
(
[id] => 497896918
[en] => Lugo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137838
[distance] => 444.864260438340
)
[27] => Array
(
[id] => 497891732
[en] => Madrid
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 314.288097418947
)
[28] => Array
(
[id] => 497889465
[en] => Malaga
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137836
[distance] => 731.183194683233
)
[29] => Array
(
[id] => 497889425
[en] => Marbella
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137836
[distance] => 764.263006564827
)
[30] => Array
(
[id] => 497893609
[en] => Mataro
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 408.164236901229
)
[31] => Array
(
[id] => 497891610
[en] => Mostoles
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 337.942346932741
)
[32] => Array
(
[id] => 497890033
[en] => Murcia
[important_3] => 1
[asc_3] => 560
[asc_4] => 135201
[asc_5] => 137834
[distance] => 569.269986572102
)
[33] => Array
(
[id] => 497895213
[en] => Ourense
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137833
[distance] => 479.355327780489
)
[34] => Array
(
[id] => 497898362
[en] => Oviedo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135214
[asc_5] => 137862
[distance] => 305.333040255455
)
[35] => Array
(
[id] => 497890856
[en] => Palma de Mallorca
[important_3] => 1
[asc_3] => 560
[asc_4] => 135213
[asc_5] => 497999200
[distance] => 552.986797980616
)
[36] => Array
(
[id] => 497896412
[en] => Pamplona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135150
[asc_5] => 137868
[distance] => 43.592930586152
)
[37] => Array
(
[id] => 497892589
[en] => Salamanca
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137830
[distance] => 375.562725743278
)
[38] => Array
(
[id] => 497892843
[en] => Salou
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137825
[distance] => 344.598367584813
)
[39] => Array
(
[id] => 497931588
[en] => Santa Cruz De Tenerife
[important_3] => 1
[asc_3] => 560
[asc_4] => 135212
[asc_5] => 137829
[distance] => 2057.991947424823
)
[40] => Array
(
[id] => 497898957
[en] => Santander
[important_3] => 1
[asc_3] => 560
[asc_4] => 135211
[asc_5] => 137854
[distance] => 146.537946511290
)
[41] => Array
(
[id] => 497896547
[en] => Santiago De Compostela
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137867
[distance] => 525.381215298731
)
[42] => Array
(
[id] => 497889843
[en] => Seville
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137827
[distance] => 709.519354266254
)
[43] => Array
(
[id] => 497892899
[en] => Tarragona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137825
[distance] => 348.189573139479
)
[44] => Array
(
[id] => 497891110
[en] => Toledo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135210
[asc_5] => 137823
[distance] => 389.738127998000
)
[45] => Array
(
[id] => 497890796
[en] => Valencia
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137822
[distance] => 421.260980319690
)
[46] => Array
(
[id] => 497893813
[en] => Valladolid
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137821
[distance] => 267.838123491730
)
[47] => Array
(
[id] => 497894944
[en] => Vigo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137831
[distance] => 549.507430513626
)
[48] => Array
(
[id] => 497896481
[en] => Vitoria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135200
[asc_5] => 137865
[distance] => 52.423803405338
)
[49] => Array
(
[id] => 497893824
[en] => Zaragoza
[important_3] => 1
[asc_3] => 560
[asc_4] => 135215
[asc_5] => 137818
[distance] => 183.892937674118
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه