select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497915694 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] => 522.283318761827
)
[1] => Array
(
[id] => 497890555
[en] => Albacete
[important_3] => 1
[asc_3] => 560
[asc_4] => 135210
[asc_5] => 137864
[distance] => 458.677023425799
)
[2] => Array
(
[id] => 497891834
[en] => Alcala De Henares
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 315.841068924524
)
[3] => Array
(
[id] => 497890174
[en] => Alicante
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137866
[distance] => 545.629178372725
)
[4] => Array
(
[id] => 497889518
[en] => Almeria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137863
[distance] => 700.923980982165
)
[5] => Array
(
[id] => 497890460
[en] => Badajoz
[important_3] => 1
[asc_3] => 560
[asc_4] => 135206
[asc_5] => 137860
[distance] => 630.776125958151
)
[6] => Array
(
[id] => 497893457
[en] => Badalona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 393.681142817211
)
[7] => Array
(
[id] => 497893369
[en] => Barcelona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 400.275913444919
)
[8] => Array
(
[id] => 497890260
[en] => Benidorm
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137866
[distance] => 531.565728460165
)
[9] => Array
(
[id] => 497897871
[en] => Bilbao
[important_3] => 1
[asc_3] => 560
[asc_4] => 135200
[asc_5] => 137820
[distance] => 78.431081264860
)
[10] => Array
(
[id] => 497895273
[en] => Burgos
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137857
[distance] => 164.192140006376
)
[11] => Array
(
[id] => 497890782
[en] => Caceres
[important_3] => 1
[asc_3] => 560
[asc_4] => 135206
[asc_5] => 137856
[distance] => 547.853668098912
)
[12] => Array
(
[id] => 497889426
[en] => Cadiz
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137855
[distance] => 820.186513039658
)
[13] => Array
(
[id] => 497891226
[en] => Castello
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137853
[distance] => 385.658575538775
)
[14] => Array
(
[id] => 497890012
[en] => Cordoba
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137851
[distance] => 628.983612902486
)
[15] => Array
(
[id] => 497890481
[en] => Eivissa
[important_3] => 1
[asc_3] => 560
[asc_4] => 135213
[asc_5] => 497999202
[distance] => 548.376783528043
)
[16] => Array
(
[id] => 497899247
[en] => Gijon
[important_3] => 1
[asc_3] => 560
[asc_4] => 135214
[asc_5] => 137862
[distance] => 301.983897571212
)
[17] => Array
(
[id] => 497894491
[en] => Girona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137849
[distance] => 412.235195070962
)
[18] => Array
(
[id] => 497889666
[en] => Granada
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137848
[distance] => 676.051842847852
)
[19] => Array
(
[id] => 497889723
[en] => Huelva
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137845
[distance] => 777.007489279997
)
[20] => Array
(
[id] => 497889988
[en] => Jaen
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137843
[distance] => 614.942511328127
)
[21] => Array
(
[id] => 497889456
[en] => Jerez de la Frontera
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137855
[distance] => 799.020012698048
)
[22] => Array
(
[id] => 497931423
[en] => Las Palmas de Gran Canaria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135212
[asc_5] => 137841
[distance] => 2060.446036087534
)
[23] => Array
(
[id] => 497895917
[en] => Leon
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137840
[distance] => 298.716724631871
)
[24] => Array
(
[id] => 497893757
[en] => Lleida
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137839
[distance] => 271.778392099726
)
[25] => Array
(
[id] => 497895571
[en] => Logrono
[important_3] => 1
[asc_3] => 560
[asc_4] => 135204
[asc_5] => 137842
[distance] => 81.943639584859
)
[26] => Array
(
[id] => 497896918
[en] => Lugo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137838
[distance] => 453.450805779109
)
[27] => Array
(
[id] => 497891732
[en] => Madrid
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 325.543972444226
)
[28] => Array
(
[id] => 497889465
[en] => Malaga
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137836
[distance] => 741.825185213428
)
[29] => Array
(
[id] => 497889425
[en] => Marbella
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137836
[distance] => 775.160545248894
)
[30] => Array
(
[id] => 497893609
[en] => Mataro
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 403.549221918938
)
[31] => Array
(
[id] => 497891610
[en] => Mostoles
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 349.467495725868
)
[32] => Array
(
[id] => 497890033
[en] => Murcia
[important_3] => 1
[asc_3] => 560
[asc_4] => 135201
[asc_5] => 137834
[distance] => 576.460412356774
)
[33] => Array
(
[id] => 497895213
[en] => Ourense
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137833
[distance] => 489.179526954340
)
[34] => Array
(
[id] => 497898362
[en] => Oviedo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135214
[asc_5] => 137862
[distance] => 313.005098669873
)
[35] => Array
(
[id] => 497890856
[en] => Palma de Mallorca
[important_3] => 1
[asc_3] => 560
[asc_4] => 135213
[asc_5] => 497999200
[distance] => 552.477751946283
)
[36] => Array
(
[id] => 497896412
[en] => Pamplona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135150
[asc_5] => 137868
[distance] => 43.099686378887
)
[37] => Array
(
[id] => 497892589
[en] => Salamanca
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137830
[distance] => 387.631217806574
)
[38] => Array
(
[id] => 497892843
[en] => Salou
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137825
[distance] => 343.228237463369
)
[39] => Array
(
[id] => 497931588
[en] => Santa Cruz De Tenerife
[important_3] => 1
[asc_3] => 560
[asc_4] => 135212
[asc_5] => 137829
[distance] => 2070.141770824011
)
[40] => Array
(
[id] => 497898957
[en] => Santander
[important_3] => 1
[asc_3] => 560
[asc_4] => 135211
[asc_5] => 137854
[distance] => 152.364812049449
)
[41] => Array
(
[id] => 497896547
[en] => Santiago De Compostela
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137867
[distance] => 534.147545673049
)
[42] => Array
(
[id] => 497889843
[en] => Seville
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137827
[distance] => 721.179269868494
)
[43] => Array
(
[id] => 497892899
[en] => Tarragona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137825
[distance] => 346.510477432779
)
[44] => Array
(
[id] => 497891110
[en] => Toledo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135210
[asc_5] => 137823
[distance] => 401.152144760120
)
[45] => Array
(
[id] => 497890796
[en] => Valencia
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137822
[distance] => 426.351536196633
)
[46] => Array
(
[id] => 497893813
[en] => Valladolid
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137821
[distance] => 279.842202823461
)
[47] => Array
(
[id] => 497894944
[en] => Vigo
[important_3] => 1
[asc_3] => 560
[asc_4] => 135205
[asc_5] => 137831
[distance] => 559.296380110111
)
[48] => Array
(
[id] => 497896481
[en] => Vitoria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135200
[asc_5] => 137865
[distance] => 64.019852489970
)
[49] => Array
(
[id] => 497893824
[en] => Zaragoza
[important_3] => 1
[asc_3] => 560
[asc_4] => 135215
[asc_5] => 137818
[distance] => 186.701384089102
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه