select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497918570 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] => 70.821504129941 ) [1] => Array ( [id] => 497922296 [en] => Allunhari [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 193.832176843332 ) [2] => Array ( [id] => 497919560 [en] => Baja Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 213.763136732826 ) [3] => Array ( [id] => 497924927 [en] => Bakau [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 72.220534612338 ) [4] => Array ( [id] => 183432 [en] => Banjul [important_3] => 1 [asc_3] => 461 [asc_4] => 135090 [asc_5] => 498105329 [distance] => 63.053500835005 ) [5] => Array ( [id] => 497919293 [en] => Banjulunding [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 61.138600237797 ) [6] => Array ( [id] => 497924876 [en] => Bansang [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 149.429952076508 ) [7] => Array ( [id] => 497924928 [en] => Barra [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 59.336890846667 ) [8] => Array ( [id] => 497924733 [en] => Basse Santa Su [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 196.161485157306 ) [9] => Array ( [id] => 497919320 [en] => Berending [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 48.199615060763 ) [10] => Array ( [id] => 497919291 [en] => Bijilo [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 78.082003995562 ) [11] => Array ( [id] => 497924709 [en] => Brikama [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 75.282455362741 ) [12] => Array ( [id] => 497919222 [en] => Brikama Ba [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 115.453922127117 ) [13] => Array ( [id] => 497924848 [en] => Brufut [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 83.219414161708 ) [14] => Array ( [id] => 497919292 [en] => Busumbala [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 71.213644989407 ) [15] => Array ( [id] => 497919394 [en] => Bwiam [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137003 [distance] => 37.359883530671 ) [16] => Array ( [id] => 497919741 [en] => Dampha Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 201.761229883313 ) [17] => Array ( [id] => 497919353 [en] => Dasilameh [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 49.939575075228 ) [18] => Array ( [id] => 497924697 [en] => Demba Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 192.978186736609 ) [19] => Array ( [id] => 497924817 [en] => Diabugu [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137009 [distance] => 176.910972983656 ) [20] => Array ( [id] => 497919738 [en] => Dingiri [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 216.467307582981 ) [21] => Array ( [id] => 497924897 [en] => Essau [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 56.471093818350 ) [22] => Array ( [id] => 497919316 [en] => Faraba Banta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 62.845701072541 ) [23] => Array ( [id] => 497925012 [en] => Farafenni [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136988 [distance] => 44.950559324615 ) [24] => Array ( [id] => 497919257 [en] => Farato [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 73.895049382339 ) [25] => Array ( [id] => 497918827 [en] => Fass Chaho [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136987 [distance] => 42.824575829882 ) [26] => Array ( [id] => 497918954 [en] => Fass Njaga Choi [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 43.297681217248 ) [27] => Array ( [id] => 497919734 [en] => Gambisara [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 185.552448576035 ) [28] => Array ( [id] => 497922295 [en] => Garawoll [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 226.083489701443 ) [29] => Array ( [id] => 497924668 [en] => Gunjur [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 86.960525402059 ) [30] => Array ( [id] => 497924998 [en] => Janjanbureh [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136997 [distance] => 135.736481751785 ) [31] => Array ( [id] => 497925067 [en] => Jarreng [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136995 [distance] => 91.654012411010 ) [32] => Array ( [id] => 497919307 [en] => Kafuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 61.943051796183 ) [33] => Array ( [id] => 497919250 [en] => Kartong [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 95.045462332780 ) [34] => Array ( [id] => 497924930 [en] => Kerewan [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136990 [distance] => 11.096494027229 ) [35] => Array ( [id] => 497924925 [en] => Koina [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 233.214660958216 ) [36] => Array ( [id] => 497919282 [en] => Kunkujang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 86.207904222982 ) [37] => Array ( [id] => 497925096 [en] => Kuntaur [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136985 [distance] => 125.307702660581 ) [38] => Array ( [id] => 497924784 [en] => Lamin [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 49.959026880112 ) [39] => Array ( [id] => 497915222 [en] => Madiana [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 80.038530984186 ) [40] => Array ( [id] => 497919277 [en] => Mandinari [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 65.510029879031 ) [41] => Array ( [id] => 497919609 [en] => Missira Ba Mariama [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 226.932269861551 ) [42] => Array ( [id] => 497918919 [en] => Ndugu Kebbeh [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 31.860956585849 ) [43] => Array ( [id] => 497919275 [en] => Nema Kunku [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 46.037618115717 ) [44] => Array ( [id] => 497919695 [en] => Numuyel [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 186.095351569933 ) [45] => Array ( [id] => 497919301 [en] => Pirang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 63.269110370994 ) [46] => Array ( [id] => 497924689 [en] => Sabi [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 202.760094948125 ) [47] => Array ( [id] => 497922293 [en] => Salikenne [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136992 [distance] => 10.485648110410 ) [48] => Array ( [id] => 497925043 [en] => Sami [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136983 [distance] => 89.278550027234 ) [49] => Array ( [id] => 497922294 [en] => Sanyang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 86.834627463195 ) [50] => Array ( [id] => 497924885 [en] => Serre Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 71.766558792543 ) [51] => Array ( [id] => 497919452 [en] => Sibanor [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137007 [distance] => 42.679760477126 ) [52] => Array ( [id] => 497919233 [en] => Siffoe [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 83.333444996166 ) [53] => Array ( [id] => 497924871 [en] => Soma [important_3] => 1 [asc_3] => 461 [asc_4] => 135083 [asc_5] => 136979 [distance] => 53.392518576238 ) [54] => Array ( [id] => 497924679 [en] => Somita [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137005 [distance] => 47.957400561580 ) [55] => Array ( [id] => 497924826 [en] => Sukuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 76.068903428287 ) [56] => Array ( [id] => 497924943 [en] => Sutukoba [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 216.923311893987 ) [57] => Array ( [id] => 497922292 [en] => Tanji [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 85.831283880029 ) [58] => Array ( [id] => 497919230 [en] => Tujereng [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 87.503536746414 ) [59] => Array ( [id] => 497922291 [en] => Wellingara [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 76.069751222214 ) [60] => Array ( [id] => 497919268 [en] => Yundum [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 73.841560770163 ) [testArray] => test )