select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497924941 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by en ascArray ( )
Array
(
[0] => Array
(
[id] => 497924827
[en] => Abuko
[important_3] => 1
[asc_3] => 461
[asc_4] => 135086
[asc_5] => 136993
[distance] => 217.644450500329
)
[1] => Array
(
[id] => 497922296
[en] => Allunhari
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 47.724605570860
)
[2] => Array
(
[id] => 497919560
[en] => Baja Kunda
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137008
[distance] => 64.899616437898
)
[3] => Array
(
[id] => 497924927
[en] => Bakau
[important_3] => 1
[asc_3] => 461
[asc_4] => 135086
[asc_5] => 136993
[distance] => 220.565735804794
)
[4] => Array
(
[id] => 183432
[en] => Banjul
[important_3] => 1
[asc_3] => 461
[asc_4] => 135090
[asc_5] => 498105329
[distance] => 210.892406713345
)
[5] => Array
(
[id] => 497919293
[en] => Banjulunding
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 208.807497547219
)
[6] => Array
(
[id] => 497924876
[en] => Bansang
[important_3] => 1
[asc_3] => 461
[asc_4] => 135087
[asc_5] => 136998
[distance] => 7.783251041859
)
[7] => Array
(
[id] => 497924928
[en] => Barra
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136989
[distance] => 207.591688973903
)
[8] => Array
(
[id] => 497924733
[en] => Basse Santa Su
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 50.099252059014
)
[9] => Array
(
[id] => 497919320
[en] => Berending
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137001
[distance] => 196.322428928277
)
[10] => Array
(
[id] => 497919291
[en] => Bijilo
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 225.481663427553
)
[11] => Array
(
[id] => 497924709
[en] => Brikama
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137002
[distance] => 218.786225676593
)
[12] => Array
(
[id] => 497919222
[en] => Brikama Ba
[important_3] => 1
[asc_3] => 461
[asc_4] => 135087
[asc_5] => 136998
[distance] => 33.532085322443
)
[13] => Array
(
[id] => 497924848
[en] => Brufut
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 230.549376655919
)
[14] => Array
(
[id] => 497919292
[en] => Busumbala
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 215.416993783716
)
[15] => Array
(
[id] => 497919394
[en] => Bwiam
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137003
[distance] => 158.194130803378
)
[16] => Array
(
[id] => 497919741
[en] => Dampha Kunda
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 54.537165633444
)
[17] => Array
(
[id] => 497919353
[en] => Dasilameh
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137002
[distance] => 99.102238189000
)
[18] => Array
(
[id] => 497924697
[en] => Demba Kunda
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 49.622428206414
)
[19] => Array
(
[id] => 497924817
[en] => Diabugu
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137009
[distance] => 30.149235868705
)
[20] => Array
(
[id] => 497919738
[en] => Dingiri
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 69.427603600599
)
[21] => Array
(
[id] => 497924897
[en] => Essau
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136989
[distance] => 204.380930488337
)
[22] => Array
(
[id] => 497919316
[en] => Faraba Banta
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137001
[distance] => 203.949110380701
)
[23] => Array
(
[id] => 497925012
[en] => Farafenni
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136988
[distance] => 104.068592281992
)
[24] => Array
(
[id] => 497919257
[en] => Farato
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 218.546378188502
)
[25] => Array
(
[id] => 497918827
[en] => Fass Chaho
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136987
[distance] => 191.676323609672
)
[26] => Array
(
[id] => 497918954
[en] => Fass Njaga Choi
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136989
[distance] => 192.149201685774
)
[27] => Array
(
[id] => 497919734
[en] => Gambisara
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 44.356546137503
)
[28] => Array
(
[id] => 497922295
[en] => Garawoll
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137010
[distance] => 77.382896330080
)
[29] => Array
(
[id] => 497924668
[en] => Gunjur
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 228.552367158367
)
[30] => Array
(
[id] => 497924998
[en] => Janjanbureh
[important_3] => 1
[asc_3] => 461
[asc_4] => 135087
[asc_5] => 136997
[distance] => 14.113768547170
)
[31] => Array
(
[id] => 497925067
[en] => Jarreng
[important_3] => 1
[asc_3] => 461
[asc_4] => 135087
[asc_5] => 136995
[distance] => 58.820908623993
)
[32] => Array
(
[id] => 497919307
[en] => Kafuta
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137001
[distance] => 199.261797509958
)
[33] => Array
(
[id] => 497919250
[en] => Kartong
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 232.959378622118
)
[34] => Array
(
[id] => 497924930
[en] => Kerewan
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136990
[distance] => 156.776839212072
)
[35] => Array
(
[id] => 497924925
[en] => Koina
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137010
[distance] => 84.364172754759
)
[36] => Array
(
[id] => 497919282
[en] => Kunkujang
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 228.549106246018
)
[37] => Array
(
[id] => 497925096
[en] => Kuntaur
[important_3] => 1
[asc_3] => 461
[asc_4] => 135084
[asc_5] => 136985
[distance] => 29.044358114851
)
[38] => Array
(
[id] => 497924784
[en] => Lamin
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 194.210657604548
)
[39] => Array
(
[id] => 497915222
[en] => Madiana
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 225.857005865598
)
[40] => Array
(
[id] => 497919277
[en] => Mandinari
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 211.340692874110
)
[41] => Array
(
[id] => 497919609
[en] => Missira Ba Mariama
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137010
[distance] => 78.929056798691
)
[42] => Array
(
[id] => 497918919
[en] => Ndugu Kebbeh
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136989
[distance] => 180.561484381924
)
[43] => Array
(
[id] => 497919275
[en] => Nema Kunku
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 191.879190061371
)
[44] => Array
(
[id] => 497919695
[en] => Numuyel
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 42.789639119629
)
[45] => Array
(
[id] => 497919301
[en] => Pirang
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137001
[distance] => 205.063701685351
)
[46] => Array
(
[id] => 497924689
[en] => Sabi
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137011
[distance] => 58.486810522880
)
[47] => Array
(
[id] => 497922293
[en] => Salikenne
[important_3] => 1
[asc_3] => 461
[asc_4] => 135085
[asc_5] => 136992
[distance] => 142.137329243620
)
[48] => Array
(
[id] => 497925043
[en] => Sami
[important_3] => 1
[asc_3] => 461
[asc_4] => 135084
[asc_5] => 136983
[distance] => 60.116154204704
)
[49] => Array
(
[id] => 497922294
[en] => Sanyang
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 230.419256299679
)
[50] => Array
(
[id] => 497924885
[en] => Serre Kunda
[important_3] => 1
[asc_3] => 461
[asc_4] => 135086
[asc_5] => 136993
[distance] => 219.570508713151
)
[51] => Array
(
[id] => 497919452
[en] => Sibanor
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137007
[distance] => 170.397453188009
)
[52] => Array
(
[id] => 497919233
[en] => Siffoe
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 223.867873213275
)
[53] => Array
(
[id] => 497924871
[en] => Soma
[important_3] => 1
[asc_3] => 461
[asc_4] => 135083
[asc_5] => 136979
[distance] => 97.630350401573
)
[54] => Array
(
[id] => 497924679
[en] => Somita
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137005
[distance] => 181.191578795908
)
[55] => Array
(
[id] => 497924826
[en] => Sukuta
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 223.044501176119
)
[56] => Array
(
[id] => 497924943
[en] => Sutukoba
[important_3] => 1
[asc_3] => 461
[asc_4] => 135089
[asc_5] => 137008
[distance] => 68.113774065545
)
[57] => Array
(
[id] => 497922292
[en] => Tanji
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 232.134430784198
)
[58] => Array
(
[id] => 497919230
[en] => Tujereng
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 136999
[distance] => 233.043471237598
)
[59] => Array
(
[id] => 497922291
[en] => Wellingara
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 73.225209779443
)
[60] => Array
(
[id] => 497919268
[en] => Yundum
[important_3] => 1
[asc_3] => 461
[asc_4] => 135088
[asc_5] => 137000
[distance] => 219.121620541443
)
[testArray] => test
)
European euro
Saudi riyal
UAE dirham
United States dollar
Español
English
العربيه