select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497924935 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] => 101.182668383467 ) [1] => Array ( [id] => 497922296 [en] => Allunhari [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 161.286776147305 ) [2] => Array ( [id] => 497919560 [en] => Baja Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 181.622766893910 ) [3] => Array ( [id] => 497924927 [en] => Bakau [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 103.800509360206 ) [4] => Array ( [id] => 183432 [en] => Banjul [important_3] => 1 [asc_3] => 461 [asc_4] => 135090 [asc_5] => 498105329 [distance] => 94.174810767601 ) [5] => Array ( [id] => 497919293 [en] => Banjulunding [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 92.115111866746 ) [6] => Array ( [id] => 497924876 [en] => Bansang [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 117.042579478880 ) [7] => Array ( [id] => 497924928 [en] => Barra [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 90.827054378427 ) [8] => Array ( [id] => 497924733 [en] => Basse Santa Su [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 163.609367101487 ) [9] => Array ( [id] => 497919320 [en] => Berending [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 79.559148240022 ) [10] => Array ( [id] => 497919291 [en] => Bijilo [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 108.886095923986 ) [11] => Array ( [id] => 497924709 [en] => Brikama [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 103.526412754157 ) [12] => Array ( [id] => 497919222 [en] => Brikama Ba [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 83.571114772053 ) [13] => Array ( [id] => 497924848 [en] => Brufut [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 113.984382714001 ) [14] => Array ( [id] => 497919292 [en] => Busumbala [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 99.842734271521 ) [15] => Array ( [id] => 497919394 [en] => Bwiam [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137003 [distance] => 48.918643679143 ) [16] => Array ( [id] => 497919741 [en] => Dampha Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 169.266124549633 ) [17] => Array ( [id] => 497919353 [en] => Dasilameh [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 19.615197896080 ) [18] => Array ( [id] => 497924697 [en] => Demba Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 160.360544967865 ) [19] => Array ( [id] => 497924817 [en] => Diabugu [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137009 [distance] => 144.449203102294 ) [20] => Array ( [id] => 497919738 [en] => Dingiri [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 183.936119796628 ) [21] => Array ( [id] => 497924897 [en] => Essau [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 87.643836987090 ) [22] => Array ( [id] => 497919316 [en] => Faraba Banta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 89.432270147239 ) [23] => Array ( [id] => 497925012 [en] => Farafenni [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136988 [distance] => 15.127976092807 ) [24] => Array ( [id] => 497919257 [en] => Farato [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 102.831786510144 ) [25] => Array ( [id] => 497918827 [en] => Fass Chaho [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136987 [distance] => 75.132571537282 ) [26] => Array ( [id] => 497918954 [en] => Fass Njaga Choi [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 75.603654792133 ) [27] => Array ( [id] => 497919734 [en] => Gambisara [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 152.923517425940 ) [28] => Array ( [id] => 497922295 [en] => Garawoll [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 193.788147546464 ) [29] => Array ( [id] => 497924668 [en] => Gunjur [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 114.244512791493 ) [30] => Array ( [id] => 497924998 [en] => Janjanbureh [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136997 [distance] => 103.930293949828 ) [31] => Array ( [id] => 497925067 [en] => Jarreng [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136995 [distance] => 60.928326291209 ) [32] => Array ( [id] => 497919307 [en] => Kafuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 86.236635914644 ) [33] => Array ( [id] => 497919250 [en] => Kartong [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 120.496521820043 ) [34] => Array ( [id] => 497924930 [en] => Kerewan [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136990 [distance] => 40.019621944570 ) [35] => Array ( [id] => 497924925 [en] => Koina [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 201.118100538984 ) [36] => Array ( [id] => 497919282 [en] => Kunkujang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 113.902462160657 ) [37] => Array ( [id] => 497925096 [en] => Kuntaur [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136985 [distance] => 94.435814296828 ) [38] => Array ( [id] => 497924784 [en] => Lamin [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 78.347559956827 ) [39] => Array ( [id] => 497915222 [en] => Madiana [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 109.763503152904 ) [40] => Array ( [id] => 497919277 [en] => Mandinari [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 95.150159251415 ) [41] => Array ( [id] => 497919609 [en] => Missira Ba Mariama [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 194.480166920614 ) [42] => Array ( [id] => 497918919 [en] => Ndugu Kebbeh [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 63.897878202621 ) [43] => Array ( [id] => 497919275 [en] => Nema Kunku [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 75.522933623576 ) [44] => Array ( [id] => 497919695 [en] => Numuyel [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 153.486469441362 ) [45] => Array ( [id] => 497919301 [en] => Pirang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 90.288452922734 ) [46] => Array ( [id] => 497924689 [en] => Sabi [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 170.145910934819 ) [47] => Array ( [id] => 497922293 [en] => Salikenne [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136992 [distance] => 25.408484585867 ) [48] => Array ( [id] => 497925043 [en] => Sami [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136983 [distance] => 57.978856651038 ) [49] => Array ( [id] => 497922294 [en] => Sanyang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 115.248391950527 ) [50] => Array ( [id] => 497924885 [en] => Serre Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 102.872289992676 ) [51] => Array ( [id] => 497919452 [en] => Sibanor [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137007 [distance] => 59.768545506725 ) [52] => Array ( [id] => 497919233 [en] => Siffoe [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 109.976836841789 ) [53] => Array ( [id] => 497924871 [en] => Soma [important_3] => 1 [asc_3] => 461 [asc_4] => 135083 [asc_5] => 136979 [distance] => 20.962434380478 ) [54] => Array ( [id] => 497924679 [en] => Somita [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137005 [distance] => 69.076378111137 ) [55] => Array ( [id] => 497924826 [en] => Sukuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 106.558555286212 ) [56] => Array ( [id] => 497924943 [en] => Sutukoba [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 184.879920681775 ) [57] => Array ( [id] => 497922292 [en] => Tanji [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 115.900415134728 ) [58] => Array ( [id] => 497919230 [en] => Tujereng [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 117.094552789923 ) [59] => Array ( [id] => 497922291 [en] => Wellingara [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 44.979343996730 ) [60] => Array ( [id] => 497919268 [en] => Yundum [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 103.177975231653 ) [testArray] => test )