select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , es from keops.geoplaces_cities_distances, keops.geoplaces where (city_id=497896874 or other_city_id=497896874 )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] => 510.144173595974 ) [1] => Array ( [id] => 497876155 [es] => Amiens [important_3] => 1 [asc_3] => 535 [asc_4] => 132868 [asc_5] => 136877 [distance] => 803.385644826870 ) [2] => Array ( [id] => 497854122 [es] => Angers [important_3] => 1 [asc_3] => 535 [asc_4] => 132869 [asc_5] => 136901 [distance] => 498.609215848846 ) [3] => Array ( [id] => 497899578 [es] => Antibes [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136956 [distance] => 645.711924419562 ) [4] => Array ( [id] => 497865372 [es] => Argenteuil [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136872 [distance] => 701.368169438954 ) [5] => Array ( [id] => 497865017 [es] => Asnières-sur-seine [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136916 [distance] => 699.564731406903 ) [6] => Array ( [id] => 497865081 [es] => Aubervilliers [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136878 [distance] => 703.280091018170 ) [7] => Array ( [id] => 497865554 [es] => Aulnay-sous-bois [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136878 [distance] => 710.145613421686 ) [8] => Array ( [id] => 497900970 [es] => Avignon [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136870 [distance] => 466.501580723706 ) [9] => Array ( [id] => 497912856 [es] => Besançon [important_3] => 1 [asc_3] => 535 [asc_4] => 132877 [asc_5] => 136935 [distance] => 713.829365878846 ) [10] => Array ( [id] => 497898454 [es] => Béziers [important_3] => 1 [asc_3] => 535 [asc_4] => 132874 [asc_5] => 136915 [distance] => 329.055418380633 ) [11] => Array ( [id] => 497903755 [es] => Bordeaux [important_3] => 1 [asc_3] => 535 [asc_4] => 132885 [asc_5] => 136927 [distance] => 205.489010560371 ) [12] => Array ( [id] => 497864200 [es] => Boulogne-billancourt [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136916 [distance] => 689.949170939906 ) [13] => Array ( [id] => 497912125 [es] => Bourges [important_3] => 1 [asc_3] => 535 [asc_4] => 132880 [asc_5] => 136943 [distance] => 518.932096974950 ) [14] => Array ( [id] => 497860362 [es] => Brest [important_3] => 1 [asc_3] => 535 [asc_4] => 132881 [asc_5] => 136930 [distance] => 663.769904687430 ) [15] => Array ( [id] => 497868327 [es] => Caen [important_3] => 1 [asc_3] => 535 [asc_4] => 132883 [asc_5] => 136947 [distance] => 689.171313598657 ) [16] => Array ( [id] => 497882966 [es] => Calais [important_3] => 1 [asc_3] => 535 [asc_4] => 132870 [asc_5] => 136888 [distance] => 906.872095494321 ) [17] => Array ( [id] => 497899393 [es] => Cannes [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136956 [distance] => 637.432003925737 ) [18] => Array ( [id] => 497864039 [es] => Champigny-sur-marne [important_3] => 1 [asc_3] => 535 [asc_4] => 132875 [asc_5] => 136873 [distance] => 696.337990862261 ) [19] => Array ( [id] => 497907300 [es] => Clermont-ferrand [important_3] => 1 [asc_3] => 535 [asc_4] => 0 [asc_5] => 136887 [distance] => 437.582498777913 ) [testArray] => test )