select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497918540 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] => 123.160493709613 ) [1] => Array ( [id] => 497922296 [en] => Allunhari [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 138.380845953041 ) [2] => Array ( [id] => 497919560 [en] => Baja Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 159.186146656863 ) [3] => Array ( [id] => 497924927 [en] => Bakau [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 126.317352305503 ) [4] => Array ( [id] => 183432 [en] => Banjul [important_3] => 1 [asc_3] => 461 [asc_4] => 135090 [asc_5] => 498105329 [distance] => 116.525294001867 ) [5] => Array ( [id] => 497919293 [en] => Banjulunding [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 114.414829695324 ) [6] => Array ( [id] => 497924876 [en] => Bansang [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 94.382577198083 ) [7] => Array ( [id] => 497924928 [en] => Barra [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 113.349898787943 ) [8] => Array ( [id] => 497924733 [en] => Basse Santa Su [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 140.693507810684 ) [9] => Array ( [id] => 497919320 [en] => Berending [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 102.083306841663 ) [10] => Array ( [id] => 497919291 [en] => Bijilo [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 131.023484032560 ) [11] => Array ( [id] => 497924709 [en] => Brikama [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 124.531034498982 ) [12] => Array ( [id] => 497919222 [en] => Brikama Ba [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 61.763307259243 ) [13] => Array ( [id] => 497924848 [en] => Brufut [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 136.080241518104 ) [14] => Array ( [id] => 497919292 [en] => Busumbala [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 121.062064003183 ) [15] => Array ( [id] => 497919394 [en] => Bwiam [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137003 [distance] => 65.793652276779 ) [16] => Array ( [id] => 497919741 [en] => Dampha Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 146.423992359514 ) [17] => Array ( [id] => 497919353 [en] => Dasilameh [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 13.971712033317 ) [18] => Array ( [id] => 497924697 [en] => Demba Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 137.342954754898 ) [19] => Array ( [id] => 497924817 [en] => Diabugu [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137009 [distance] => 121.662511049614 ) [20] => Array ( [id] => 497919738 [en] => Dingiri [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 161.043136342296 ) [21] => Array ( [id] => 497924897 [en] => Essau [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 110.049745301888 ) [22] => Array ( [id] => 497919316 [en] => Faraba Banta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 109.917312535302 ) [23] => Array ( [id] => 497925012 [en] => Farafenni [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136988 [distance] => 16.189245592447 ) [24] => Array ( [id] => 497919257 [en] => Farato [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 124.157885405239 ) [25] => Array ( [id] => 497918827 [en] => Fass Chaho [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136987 [distance] => 98.036666813209 ) [26] => Array ( [id] => 497918954 [en] => Fass Njaga Choi [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 98.506086893703 ) [27] => Array ( [id] => 497919734 [en] => Gambisara [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 129.878919163364 ) [28] => Array ( [id] => 497922295 [en] => Garawoll [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 171.170283034279 ) [29] => Array ( [id] => 497924668 [en] => Gunjur [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 134.675898112535 ) [30] => Array ( [id] => 497924998 [en] => Janjanbureh [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136997 [distance] => 82.082013460914 ) [31] => Array ( [id] => 497925067 [en] => Jarreng [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136995 [distance] => 41.472660111791 ) [32] => Array ( [id] => 497919307 [en] => Kafuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 105.811019062740 ) [33] => Array ( [id] => 497919250 [en] => Kartong [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 139.946029867177 ) [34] => Array ( [id] => 497924930 [en] => Kerewan [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136990 [distance] => 62.593170973813 ) [35] => Array ( [id] => 497924925 [en] => Koina [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 178.711870307316 ) [36] => Array ( [id] => 497919282 [en] => Kunkujang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 134.535274120450 ) [37] => Array ( [id] => 497925096 [en] => Kuntaur [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136985 [distance] => 73.887689372140 ) [38] => Array ( [id] => 497924784 [en] => Lamin [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 99.764888877176 ) [39] => Array ( [id] => 497915222 [en] => Madiana [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 131.393207505388 ) [40] => Array ( [id] => 497919277 [en] => Mandinari [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 116.859222791574 ) [41] => Array ( [id] => 497919609 [en] => Missira Ba Mariama [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 171.681867731720 ) [42] => Array ( [id] => 497918919 [en] => Ndugu Kebbeh [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 86.736511268211 ) [43] => Array ( [id] => 497919275 [en] => Nema Kunku [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 97.392008539332 ) [44] => Array ( [id] => 497919695 [en] => Numuyel [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 130.485945166805 ) [45] => Array ( [id] => 497919301 [en] => Pirang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 110.942347444860 ) [46] => Array ( [id] => 497924689 [en] => Sabi [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 147.134101365726 ) [47] => Array ( [id] => 497922293 [en] => Salikenne [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136992 [distance] => 47.950206261668 ) [48] => Array ( [id] => 497925043 [en] => Sami [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136983 [distance] => 37.660000731592 ) [49] => Array ( [id] => 497922294 [en] => Sanyang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 136.213185382463 ) [50] => Array ( [id] => 497924885 [en] => Serre Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 125.175515743625 ) [51] => Array ( [id] => 497919452 [en] => Sibanor [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137007 [distance] => 77.683354759988 ) [52] => Array ( [id] => 497919233 [en] => Siffoe [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 130.154451822680 ) [53] => Array ( [id] => 497924871 [en] => Soma [important_3] => 1 [asc_3] => 461 [asc_4] => 135083 [asc_5] => 136979 [distance] => 3.844779393045 ) [54] => Array ( [id] => 497924679 [en] => Somita [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137005 [distance] => 87.984626408508 ) [55] => Array ( [id] => 497924826 [en] => Sukuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 128.562325436354 ) [56] => Array ( [id] => 497924943 [en] => Sutukoba [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 162.546023162534 ) [57] => Array ( [id] => 497922292 [en] => Tanji [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 137.653799720422 ) [58] => Array ( [id] => 497919230 [en] => Tujereng [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 138.610855282576 ) [59] => Array ( [id] => 497922291 [en] => Wellingara [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 25.956079158417 ) [60] => Array ( [id] => 497919268 [en] => Yundum [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 124.681265804950 ) [testArray] => test )