select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497924843 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] => 298.526313422796 ) [1] => Array ( [id] => 497922296 [en] => Allunhari [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 39.026863586524 ) [2] => Array ( [id] => 497919560 [en] => Baja Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 18.109004242720 ) [3] => Array ( [id] => 497924927 [en] => Bakau [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 301.880433811986 ) [4] => Array ( [id] => 183432 [en] => Banjul [important_3] => 1 [asc_3] => 461 [asc_4] => 135090 [asc_5] => 498105329 [distance] => 292.076386504527 ) [5] => Array ( [id] => 497919293 [en] => Banjulunding [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 289.954241471546 ) [6] => Array ( [id] => 497924876 [en] => Bansang [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 81.185163568988 ) [7] => Array ( [id] => 497924928 [en] => Barra [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 288.911046845790 ) [8] => Array ( [id] => 497924733 [en] => Basse Santa Su [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 37.076215476463 ) [9] => Array ( [id] => 497919320 [en] => Berending [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 277.642473848542 ) [10] => Array ( [id] => 497919291 [en] => Bijilo [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 306.476895112765 ) [11] => Array ( [id] => 497924709 [en] => Brikama [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 298.898530565162 ) [12] => Array ( [id] => 497919222 [en] => Brikama Ba [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 115.393559317812 ) [13] => Array ( [id] => 497924848 [en] => Brufut [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 311.501079933054 ) [14] => Array ( [id] => 497919292 [en] => Busumbala [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 295.719879996226 ) [15] => Array ( [id] => 497919394 [en] => Bwiam [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137003 [distance] => 237.229584285856 ) [16] => Array ( [id] => 497919741 [en] => Dampha Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 30.382351256197 ) [17] => Array ( [id] => 497919353 [en] => Dasilameh [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 180.902142888610 ) [18] => Array ( [id] => 497924697 [en] => Demba Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 43.367815238089 ) [19] => Array ( [id] => 497924817 [en] => Diabugu [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137009 [distance] => 54.129072312149 ) [20] => Array ( [id] => 497919738 [en] => Dingiri [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 18.949069050939 ) [21] => Array ( [id] => 497924897 [en] => Essau [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 285.611469476214 ) [22] => Array ( [id] => 497919316 [en] => Faraba Banta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 283.814965632383 ) [23] => Array ( [id] => 497925012 [en] => Farafenni [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136988 [distance] => 185.855166401171 ) [24] => Array ( [id] => 497919257 [en] => Farato [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 298.912691742113 ) [25] => Array ( [id] => 497918827 [en] => Fass Chaho [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136987 [distance] => 273.286962192471 ) [26] => Array ( [id] => 497918954 [en] => Fass Njaga Choi [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 273.759208203666 ) [27] => Array ( [id] => 497919734 [en] => Gambisara [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 51.250919745824 ) [28] => Array ( [id] => 497922295 [en] => Garawoll [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 4.524622181452 ) [29] => Array ( [id] => 497924668 [en] => Gunjur [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 308.109812514806 ) [30] => Array ( [id] => 497924998 [en] => Janjanbureh [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136997 [distance] => 95.538723095852 ) [31] => Array ( [id] => 497925067 [en] => Jarreng [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136995 [distance] => 140.529241592670 ) [32] => Array ( [id] => 497919307 [en] => Kafuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 278.565346561529 ) [33] => Array ( [id] => 497919250 [en] => Kartong [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 311.608479543633 ) [34] => Array ( [id] => 497924930 [en] => Kerewan [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136990 [distance] => 238.121941994418 ) [35] => Array ( [id] => 497924925 [en] => Koina [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 9.468328642864 ) [36] => Array ( [id] => 497919282 [en] => Kunkujang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 308.276680090842 ) [37] => Array ( [id] => 497925096 [en] => Kuntaur [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136985 [distance] => 108.484219289386 ) [38] => Array ( [id] => 497924784 [en] => Lamin [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 274.789777992183 ) [39] => Array ( [id] => 497915222 [en] => Madiana [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 306.431427419525 ) [40] => Array ( [id] => 497919277 [en] => Mandinari [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 292.036166334011 ) [41] => Array ( [id] => 497919609 [en] => Missira Ba Mariama [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 8.161952194847 ) [42] => Array ( [id] => 497918919 [en] => Ndugu Kebbeh [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 262.099088853411 ) [43] => Array ( [id] => 497919275 [en] => Nema Kunku [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 272.761082163543 ) [44] => Array ( [id] => 497919695 [en] => Numuyel [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 48.636384507243 ) [45] => Array ( [id] => 497919301 [en] => Pirang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 285.036487928668 ) [46] => Array ( [id] => 497924689 [en] => Sabi [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 35.132743490420 ) [47] => Array ( [id] => 497922293 [en] => Salikenne [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136992 [distance] => 223.468030135549 ) [48] => Array ( [id] => 497925043 [en] => Sami [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136983 [distance] => 141.975680199646 ) [49] => Array ( [id] => 497922294 [en] => Sanyang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 310.412273844428 ) [50] => Array ( [id] => 497924885 [en] => Serre Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 300.709618457507 ) [51] => Array ( [id] => 497919452 [en] => Sibanor [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137007 [distance] => 249.440428734853 ) [52] => Array ( [id] => 497919233 [en] => Siffoe [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 303.265444765694 ) [53] => Array ( [id] => 497924871 [en] => Soma [important_3] => 1 [asc_3] => 461 [asc_4] => 135083 [asc_5] => 136979 [distance] => 178.487445659121 ) [54] => Array ( [id] => 497924679 [en] => Somita [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137005 [distance] => 260.455243987043 ) [55] => Array ( [id] => 497924826 [en] => Sukuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 303.934341084379 ) [56] => Array ( [id] => 497924943 [en] => Sutukoba [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 17.088800011524 ) [57] => Array ( [id] => 497922292 [en] => Tanji [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 312.789671783204 ) [58] => Array ( [id] => 497919230 [en] => Tujereng [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 313.491983975289 ) [59] => Array ( [id] => 497922291 [en] => Wellingara [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 155.086493018667 ) [60] => Array ( [id] => 497919268 [en] => Yundum [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 299.624182964677 ) [testArray] => test )