select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497918903 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.211622109349 ) [1] => Array ( [id] => 497922296 [en] => Allunhari [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 162.446240456946 ) [2] => Array ( [id] => 497919560 [en] => Baja Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 182.296563572488 ) [3] => Array ( [id] => 497924927 [en] => Bakau [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 103.379710187548 ) [4] => Array ( [id] => 183432 [en] => Banjul [important_3] => 1 [asc_3] => 461 [asc_4] => 135090 [asc_5] => 498105329 [distance] => 93.928928040130 ) [5] => Array ( [id] => 497919293 [en] => Banjulunding [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 91.918164101124 ) [6] => Array ( [id] => 497924876 [en] => Bansang [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 117.967927464179 ) [7] => Array ( [id] => 497924928 [en] => Barra [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 90.428093705892 ) [8] => Array ( [id] => 497924733 [en] => Basse Santa Su [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 164.782180700938 ) [9] => Array ( [id] => 497919320 [en] => Berending [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 79.190143382150 ) [10] => Array ( [id] => 497919291 [en] => Bijilo [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 108.781338849704 ) [11] => Array ( [id] => 497924709 [en] => Brikama [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 104.128145407607 ) [12] => Array ( [id] => 497919222 [en] => Brikama Ba [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136998 [distance] => 84.022852260608 ) [13] => Array ( [id] => 497924848 [en] => Brufut [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 113.901102017822 ) [14] => Array ( [id] => 497919292 [en] => Busumbala [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 100.341633631895 ) [15] => Array ( [id] => 497919394 [en] => Bwiam [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137003 [distance] => 51.384437889985 ) [16] => Array ( [id] => 497919741 [en] => Dampha Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 170.334773370591 ) [17] => Array ( [id] => 497919353 [en] => Dasilameh [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137002 [distance] => 18.829055731556 ) [18] => Array ( [id] => 497924697 [en] => Demba Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 161.727183621728 ) [19] => Array ( [id] => 497924817 [en] => Diabugu [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137009 [distance] => 145.470376167362 ) [20] => Array ( [id] => 497919738 [en] => Dingiri [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 185.064751985629 ) [21] => Array ( [id] => 497924897 [en] => Essau [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 87.365246251761 ) [22] => Array ( [id] => 497919316 [en] => Faraba Banta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 90.331025503716 ) [23] => Array ( [id] => 497925012 [en] => Farafenni [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136988 [distance] => 13.928676888329 ) [24] => Array ( [id] => 497919257 [en] => Farato [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 103.263729494156 ) [25] => Array ( [id] => 497918827 [en] => Fass Chaho [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136987 [distance] => 74.278257097546 ) [26] => Array ( [id] => 497918954 [en] => Fass Njaga Choi [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 74.751121320424 ) [27] => Array ( [id] => 497919734 [en] => Gambisara [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 154.374246102518 ) [28] => Array ( [id] => 497922295 [en] => Garawoll [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 194.606362484215 ) [29] => Array ( [id] => 497924668 [en] => Gunjur [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 115.092192535035 ) [30] => Array ( [id] => 497924998 [en] => Janjanbureh [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136997 [distance] => 104.335042162898 ) [31] => Array ( [id] => 497925067 [en] => Jarreng [important_3] => 1 [asc_3] => 461 [asc_4] => 135087 [asc_5] => 136995 [distance] => 60.654120022877 ) [32] => Array ( [id] => 497919307 [en] => Kafuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 87.532291427701 ) [33] => Array ( [id] => 497919250 [en] => Kartong [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 121.729653979334 ) [34] => Array ( [id] => 497924930 [en] => Kerewan [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136990 [distance] => 39.836443200574 ) [35] => Array ( [id] => 497924925 [en] => Koina [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 201.756410613450 ) [36] => Array ( [id] => 497919282 [en] => Kunkujang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 114.659115049199 ) [37] => Array ( [id] => 497925096 [en] => Kuntaur [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136985 [distance] => 94.294278673457 ) [38] => Array ( [id] => 497924784 [en] => Lamin [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 78.810520802459 ) [39] => Array ( [id] => 497915222 [en] => Madiana [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 110.001391593454 ) [40] => Array ( [id] => 497919277 [en] => Mandinari [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 95.375154348901 ) [41] => Array ( [id] => 497919609 [en] => Missira Ba Mariama [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137010 [distance] => 195.482575297384 ) [42] => Array ( [id] => 497918919 [en] => Ndugu Kebbeh [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136989 [distance] => 63.192138592206 ) [43] => Array ( [id] => 497919275 [en] => Nema Kunku [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 75.710471963709 ) [44] => Array ( [id] => 497919695 [en] => Numuyel [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 154.816451527013 ) [45] => Array ( [id] => 497919301 [en] => Pirang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137001 [distance] => 91.105123010179 ) [46] => Array ( [id] => 497924689 [en] => Sabi [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137011 [distance] => 171.493608449810 ) [47] => Array ( [id] => 497922293 [en] => Salikenne [important_3] => 1 [asc_3] => 461 [asc_4] => 135085 [asc_5] => 136992 [distance] => 25.528629392920 ) [48] => Array ( [id] => 497925043 [en] => Sami [important_3] => 1 [asc_3] => 461 [asc_4] => 135084 [asc_5] => 136983 [distance] => 58.013549786908 ) [49] => Array ( [id] => 497922294 [en] => Sanyang [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 115.841409861784 ) [50] => Array ( [id] => 497924885 [en] => Serre Kunda [important_3] => 1 [asc_3] => 461 [asc_4] => 135086 [asc_5] => 136993 [distance] => 102.647284107217 ) [51] => Array ( [id] => 497919452 [en] => Sibanor [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137007 [distance] => 61.810501222333 ) [52] => Array ( [id] => 497919233 [en] => Siffoe [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 110.945939839006 ) [53] => Array ( [id] => 497924871 [en] => Soma [important_3] => 1 [asc_3] => 461 [asc_4] => 135083 [asc_5] => 136979 [distance] => 23.468572835402 ) [54] => Array ( [id] => 497924679 [en] => Somita [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137005 [distance] => 70.714058835233 ) [55] => Array ( [id] => 497924826 [en] => Sukuta [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 106.556924674926 ) [56] => Array ( [id] => 497924943 [en] => Sutukoba [important_3] => 1 [asc_3] => 461 [asc_4] => 135089 [asc_5] => 137008 [distance] => 185.474708606658 ) [57] => Array ( [id] => 497922292 [en] => Tanji [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 116.048383045901 ) [58] => Array ( [id] => 497919230 [en] => Tujereng [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 136999 [distance] => 117.385044172775 ) [59] => Array ( [id] => 497922291 [en] => Wellingara [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 44.854572124774 ) [60] => Array ( [id] => 497919268 [en] => Yundum [important_3] => 1 [asc_3] => 461 [asc_4] => 135088 [asc_5] => 137000 [distance] => 103.507386421999 ) [testArray] => test )