select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497898098 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] => 505.571705186231
)
[1] => Array
(
[id] => 497890555
[en] => Albacete
[important_3] => 1
[asc_3] => 560
[asc_4] => 135210
[asc_5] => 137864
[distance] => 477.662022395731
)
[2] => Array
(
[id] => 497891834
[en] => Alcala De Henares
[important_3] => 1
[asc_3] => 560
[asc_4] => 135203
[asc_5] => 137837
[distance] => 327.842086989242
)
[3] => Array
(
[id] => 497890174
[en] => Alicante
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137866
[distance] => 567.348175678299
)
[4] => Array
(
[id] => 497889518
[en] => Almeria
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137863
[distance] => 718.622466953545
)
[5] => Array
(
[id] => 497890460
[en] => Badajoz
[important_3] => 1
[asc_3] => 560
[asc_4] => 135206
[asc_5] => 137860
[distance] => 634.003348079101
)
[6] => Array
(
[id] => 497893457
[en] => Badalona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 415.965933370310
)
[7] => Array
(
[id] => 497893369
[en] => Barcelona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137858
[distance] => 422.632810407729
)
[8] => Array
(
[id] => 497890260
[en] => Benidorm
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137866
[distance] => 553.897192832640
)
[9] => Array
(
[id] => 497897871
[en] => Bilbao
[important_3] => 1
[asc_3] => 560
[asc_4] => 135200
[asc_5] => 137820
[distance] => 61.690266414635
)
[10] => Array
(
[id] => 497895273
[en] => Burgos
[important_3] => 1
[asc_3] => 560
[asc_4] => 135209
[asc_5] => 137857
[distance] => 162.141616330847
)
[11] => Array
(
[id] => 497890782
[en] => Caceres
[important_3] => 1
[asc_3] => 560
[asc_4] => 135206
[asc_5] => 137856
[distance] => 550.999113894149
)
[12] => Array
(
[id] => 497889426
[en] => Cadiz
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137855
[distance] => 829.438894807689
)
[13] => Array
(
[id] => 497891226
[en] => Castello
[important_3] => 1
[asc_3] => 560
[asc_4] => 135199
[asc_5] => 137853
[distance] => 409.002041745054
)
[14] => Array
(
[id] => 497890012
[en] => Cordoba
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137851
[distance] => 640.255168618858
)
[15] => Array
(
[id] => 497890481
[en] => Eivissa
[important_3] => 1
[asc_3] => 560
[asc_4] => 135213
[asc_5] => 497999202
[distance] => 572.276842783305
)
[16] => Array
(
[id] => 497899247
[en] => Gijon
[important_3] => 1
[asc_3] => 560
[asc_4] => 135214
[asc_5] => 137862
[distance] => 283.944203089805
)
[17] => Array
(
[id] => 497894491
[en] => Girona
[important_3] => 1
[asc_3] => 560
[asc_4] => 135208
[asc_5] => 137849
[distance] => 432.537456459552
)
[18] => Array
(
[id] => 497889666
[en] => Granada
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137848
[distance] => 691.040841558902
)
[19] => Array
(
[id] => 497889723
[en] => Huelva
[important_3] => 1
[asc_3] => 560
[asc_4] => 135216
[asc_5] => 137845
[distance] => 783.754195740191
)
[testArray] => test
)
Map of Zarautz
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه