select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , es from keops.geoplaces_cities_distances, keops.geoplaces where (city_id=497898732 or other_city_id=497898732 )and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by es asc
Array ( [0] => Array ( [id] => 497899313 [es] => Aix-en-provence [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136948 [distance] => 477.724248804687 ) [1] => Array ( [id] => 497876155 [es] => Amiens [important_3] => 1 [asc_3] => 535 [asc_4] => 132868 [asc_5] => 136877 [distance] => 750.947460103286 ) [2] => Array ( [id] => 497854122 [es] => Angers [important_3] => 1 [asc_3] => 535 [asc_4] => 132869 [asc_5] => 136901 [distance] => 451.452778915872 ) [3] => Array ( [id] => 497899578 [es] => Antibes [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136956 [distance] => 612.980612440922 ) [4] => Array ( [id] => 497865372 [es] => Argenteuil [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136872 [distance] => 648.389414575013 ) [5] => Array ( [id] => 497865017 [es] => Asnières-sur-seine [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136916 [distance] => 646.508363108920 ) [6] => Array ( [id] => 497865081 [es] => Aubervilliers [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136878 [distance] => 650.119480731512 ) [7] => Array ( [id] => 497865554 [es] => Aulnay-sous-bois [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136878 [distance] => 656.905467342298 ) [8] => Array ( [id] => 497900970 [es] => Avignon [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136870 [distance] => 429.453967592907 ) [9] => Array ( [id] => 497912856 [es] => Besançon [important_3] => 1 [asc_3] => 535 [asc_4] => 132877 [asc_5] => 136935 [distance] => 661.844861293075 ) [10] => Array ( [id] => 497898454 [es] => Béziers [important_3] => 1 [asc_3] => 535 [asc_4] => 132874 [asc_5] => 136915 [distance] => 298.256223540940 ) [11] => Array ( [id] => 497903755 [es] => Bordeaux [important_3] => 1 [asc_3] => 535 [asc_4] => 132885 [asc_5] => 136927 [distance] => 158.090338487695 ) [12] => Array ( [id] => 497864200 [es] => Boulogne-billancourt [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136916 [distance] => 636.897394275623 ) [13] => Array ( [id] => 497912125 [es] => Bourges [important_3] => 1 [asc_3] => 535 [asc_4] => 132880 [asc_5] => 136943 [distance] => 464.766647414812 ) [14] => Array ( [id] => 497860362 [es] => Brest [important_3] => 1 [asc_3] => 535 [asc_4] => 132881 [asc_5] => 136930 [distance] => 633.911975937970 ) [15] => Array ( [id] => 497868327 [es] => Caen [important_3] => 1 [asc_3] => 535 [asc_4] => 132883 [asc_5] => 136947 [distance] => 641.628234853304 ) [16] => Array ( [id] => 497882966 [es] => Calais [important_3] => 1 [asc_3] => 535 [asc_4] => 132870 [asc_5] => 136888 [distance] => 855.605220705145 ) [17] => Array ( [id] => 497899393 [es] => Cannes [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136956 [distance] => 604.999177334415 ) [18] => Array ( [id] => 497864039 [es] => Champigny-sur-marne [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136873 [distance] => 642.990796705478 ) [19] => Array ( [id] => 497907300 [es] => Clermont-ferrand [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136887 [distance] => 385.015288258301 ) [testArray] => test )