select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497942212 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by en ascArray ( )
Array ( [0] => Array ( [id] => 497953252 [en] => Anaheim [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138096 [distance] => 2516.011280504087 ) [1] => Array ( [id] => 497955162 [en] => Anchorage [important_3] => 1 [asc_3] => 599 [asc_4] => 136053 [asc_5] => 137869 [distance] => 4361.081899257387 ) [2] => Array ( [id] => 497978725 [en] => Arlington [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140469 [distance] => 1161.134678594992 ) [3] => Array ( [id] => 497948949 [en] => Atlanta [important_3] => 1 [asc_3] => 599 [asc_4] => 136062 [asc_5] => 138263 [distance] => 1078.491904547982 ) [4] => Array ( [id] => 497978751 [en] => Austin [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140391 [distance] => 1446.486128898295 ) [5] => Array ( [id] => 497953200 [en] => Bakersfield [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138055 [distance] => 2532.496017690161 ) [6] => Array ( [id] => 497937479 [en] => Baltimore [important_3] => 1 [asc_3] => 599 [asc_4] => 136072 [asc_5] => 139071 [distance] => 1245.221548282568 ) [7] => Array ( [id] => 497936798 [en] => Boston [important_3] => 1 [asc_3] => 599 [asc_4] => 136073 [asc_5] => 139044 [distance] => 1636.371862761298 ) [8] => Array ( [id] => 497965061 [en] => Buffalo [important_3] => 1 [asc_3] => 599 [asc_4] => 136084 [asc_5] => 139848 [distance] => 995.400557746869 ) [9] => Array ( [id] => 497954845 [en] => Chandler [important_3] => 1 [asc_3] => 599 [asc_4] => 136054 [asc_5] => 138047 [distance] => 2068.490591409023 ) [10] => Array ( [id] => 497967971 [en] => Charlotte [important_3] => 1 [asc_3] => 599 [asc_4] => 136085 [asc_5] => 139527 [distance] => 1157.570151275642 ) [11] => Array ( [id] => 497983145 [en] => Chesapeake [important_3] => 1 [asc_3] => 599 [asc_4] => 136098 [asc_5] => 0 [distance] => 1388.504083941037 ) [12] => Array ( [id] => 497947023 [en] => Chicago [important_3] => 1 [asc_3] => 599 [asc_4] => 136065 [asc_5] => 138575 [distance] => 271.837878470318 ) [13] => Array ( [id] => 497952915 [en] => Chula Vista [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138091 [distance] => 2520.457564480461 ) [14] => Array ( [id] => 497970127 [en] => Cincinnati [important_3] => 1 [asc_3] => 599 [asc_4] => 136087 [asc_5] => 139914 [distance] => 629.486559418934 ) [15] => Array ( [id] => 497970139 [en] => Cleveland [important_3] => 1 [asc_3] => 599 [asc_4] => 136087 [asc_5] => 139916 [distance] => 771.019346294474 ) [16] => Array ( [id] => 497951069 [en] => Colorado Springs [important_3] => 1 [asc_3] => 599 [asc_4] => 136057 [asc_5] => 138123 [distance] => 1224.283306195679 ) [17] => Array ( [id] => 497970165 [en] => Columbus [important_3] => 1 [asc_3] => 599 [asc_4] => 136087 [asc_5] => 139917 [distance] => 704.278773110094 ) [18] => Array ( [id] => 497979252 [en] => Dallas [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140448 [distance] => 1142.792659415739 ) [19] => Array ( [id] => 497956123 [en] => Detroit [important_3] => 1 [asc_3] => 599 [asc_4] => 136074 [asc_5] => 139112 [distance] => 648.921704757539 ) [20] => Array ( [id] => 497979396 [en] => El Paso [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140459 [distance] => 1773.407203323032 ) [21] => Array ( [id] => 497944398 [en] => Fort Wayne [important_3] => 1 [asc_3] => 599 [asc_4] => 136066 [asc_5] => 138686 [distance] => 649.071001975292 ) [22] => Array ( [id] => 497979532 [en] => Fort Worth [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140469 [distance] => 1180.112698670095 ) [23] => Array ( [id] => 497952608 [en] => Fresno [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138063 [distance] => 2531.754201426059 ) [24] => Array ( [id] => 497954763 [en] => Glendale [important_3] => 1 [asc_3] => 599 [asc_4] => 136054 [asc_5] => 138047 [distance] => 1200.864133467551 ) [25] => Array ( [id] => 497968289 [en] => Greensboro [important_3] => 1 [asc_3] => 599 [asc_4] => 136085 [asc_5] => 139545 [distance] => 1165.776857298996 ) [26] => Array ( [id] => 497962516 [en] => Henderson [important_3] => 1 [asc_3] => 599 [asc_4] => 136080 [asc_5] => 139831 [distance] => 2171.510977793828 ) [27] => Array ( [id] => 497949602 [en] => Hialeah [important_3] => 1 [asc_3] => 599 [asc_4] => 136061 [asc_5] => 138225 [distance] => 2042.164799757037 ) [28] => Array ( [id] => 497948061 [en] => Honolulu [important_3] => 1 [asc_3] => 599 [asc_4] => 136063 [asc_5] => 138414 [distance] => 6568.138384663925 ) [29] => Array ( [id] => 497979795 [en] => Houston [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140502 [distance] => 1414.516849746485 ) [30] => Array ( [id] => 497944204 [en] => Indianapolis [important_3] => 1 [asc_3] => 599 [asc_4] => 136066 [asc_5] => 138696 [distance] => 472.487485591724 ) [31] => Array ( [id] => 497949548 [en] => Jacksonville [important_3] => 1 [asc_3] => 599 [asc_4] => 136061 [asc_5] => 138213 [distance] => 1538.911047876147 ) [32] => Array ( [id] => 497963462 [en] => Jersey City [important_3] => 1 [asc_3] => 599 [asc_4] => 136082 [asc_5] => 139777 [distance] => 1420.096073278086 ) [33] => Array ( [id] => 497980040 [en] => Laredo [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140520 [distance] => 1786.506235670783 ) [34] => Array ( [id] => 497962544 [en] => Las Vegas [important_3] => 1 [asc_3] => 599 [asc_4] => 136080 [asc_5] => 139831 [distance] => 2181.059000864068 ) [35] => Array ( [id] => 497940017 [en] => Lexington [important_3] => 1 [asc_3] => 599 [asc_4] => 136069 [asc_5] => 138922 [distance] => 705.576835874834 ) [36] => Array ( [id] => 497962022 [en] => Lincoln [important_3] => 1 [asc_3] => 599 [asc_4] => 136079 [asc_5] => 139715 [distance] => 494.981377085827 ) [37] => Array ( [id] => 497952246 [en] => Long Beach [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138069 [distance] => 2547.225442323920 ) [38] => Array ( [id] => 497952235 [en] => Los Angeles [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138069 [distance] => 2526.770810403076 ) [39] => Array ( [id] => 497939979 [en] => Louisville [important_3] => 1 [asc_3] => 599 [asc_4] => 136069 [asc_5] => 138926 [distance] => 609.600274354070 ) [40] => Array ( [id] => 497986955 [en] => Madison [important_3] => 1 [asc_3] => 599 [asc_4] => 136101 [asc_5] => 140844 [distance] => 175.967153988539 ) [41] => Array ( [id] => 497978363 [en] => Memphis [important_3] => 1 [asc_3] => 599 [asc_4] => 136094 [asc_5] => 140347 [distance] => 768.309545572250 ) [42] => Array ( [id] => 497954662 [en] => Mesa [important_3] => 1 [asc_3] => 599 [asc_4] => 136054 [asc_5] => 138047 [distance] => 2060.846263632000 ) [43] => Array ( [id] => 497949414 [en] => Miami [important_3] => 1 [asc_3] => 599 [asc_4] => 136061 [asc_5] => 138225 [distance] => 2054.513198857348 ) [44] => Array ( [id] => 497987012 [en] => Milwaukee [important_3] => 1 [asc_3] => 599 [asc_4] => 136101 [asc_5] => 140851 [distance] => 272.937904798022 ) [45] => Array ( [id] => 497957796 [en] => Minneapolis [important_3] => 1 [asc_3] => 599 [asc_4] => 136075 [asc_5] => 139223 [distance] => 379.887553021855 ) [46] => Array ( [id] => 497952124 [en] => Modesto [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138076 [distance] => 2599.978288425133 ) [47] => Array ( [id] => 497978401 [en] => Nashville [important_3] => 1 [asc_3] => 599 [asc_4] => 136094 [asc_5] => 140351 [distance] => 739.701707579621 ) [48] => Array ( [id] => 497938457 [en] => New Orleans [important_3] => 1 [asc_3] => 599 [asc_4] => 136070 [asc_5] => 139023 [distance] => 1339.338145884129 ) [49] => Array ( [id] => 497963658 [en] => Newark [important_3] => 1 [asc_3] => 599 [asc_4] => 136082 [asc_5] => 139782 [distance] => 1405.474080285941 ) [50] => Array ( [id] => 497962588 [en] => North Las Vegas [important_3] => 1 [asc_3] => 599 [asc_4] => 136080 [asc_5] => 139831 [distance] => 2171.766433514380 ) [51] => Array ( [id] => 497951995 [en] => Oakland [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138079 [distance] => 2695.314682078977 ) [52] => Array ( [id] => 497962136 [en] => Omaha [important_3] => 1 [asc_3] => 599 [asc_4] => 136079 [asc_5] => 139726 [distance] => 427.260792626553 ) [53] => Array ( [id] => 497949322 [en] => Orlando [important_3] => 1 [asc_3] => 599 [asc_4] => 136061 [asc_5] => 138232 [distance] => 1730.780313867217 ) [54] => Array ( [id] => 497975307 [en] => Philadelphia [important_3] => 1 [asc_3] => 599 [asc_4] => 136090 [asc_5] => 140144 [distance] => 1342.209106147896 ) [55] => Array ( [id] => 497954611 [en] => Phoenix [important_3] => 1 [asc_3] => 599 [asc_4] => 136054 [asc_5] => 138047 [distance] => 2078.726933685210 ) [56] => Array ( [id] => 497975338 [en] => Pittsburgh [important_3] => 1 [asc_3] => 599 [asc_4] => 136090 [asc_5] => 140145 [distance] => 930.209285892381 ) [57] => Array ( [id] => 497980627 [en] => Plano [important_3] => 1 [asc_3] => 599 [asc_4] => 136095 [asc_5] => 140539 [distance] => 986.892699165997 ) [58] => Array ( [id] => 497972662 [en] => Portland [important_3] => 1 [asc_3] => 599 [asc_4] => 136089 [asc_5] => 140091 [distance] => 2561.136654106849 ) [59] => Array ( [id] => 497968789 [en] => Raleigh [important_3] => 1 [asc_3] => 599 [asc_4] => 136085 [asc_5] => 139580 [distance] => 1268.065040775970 ) [60] => Array ( [id] => 497951738 [en] => Riverside [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138086 [distance] => 2473.892506700821 ) [61] => Array ( [id] => 497951699 [en] => Sacramento [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138087 [distance] => 2608.186067482795 ) [62] => Array ( [id] => 497960852 [en] => Saint Louis [important_3] => 1 [asc_3] => 599 [asc_4] => 136077 [asc_5] => 139280 [distance] => 376.351941426318 ) [63] => Array ( [id] => 497949194 [en] => Saint Petersburg [important_3] => 1 [asc_3] => 599 [asc_4] => 136061 [asc_5] => 138199 [distance] => 1750.151524213633 ) [64] => Array ( [id] => 497951682 [en] => San Diego [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138091 [distance] => 2522.251374141713 ) [65] => Array ( [id] => 497951670 [en] => San Jose [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138093 [distance] => 2683.142941980954 ) [66] => Array ( [id] => 497951642 [en] => Santa Ana [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138096 [distance] => 2522.085505635602 ) [67] => Array ( [id] => 497954552 [en] => Scottsdale [important_3] => 1 [asc_3] => 599 [asc_4] => 136054 [asc_5] => 138047 [distance] => 2063.872084994385 ) [68] => Array ( [id] => 497985030 [en] => Seattle [important_3] => 1 [asc_3] => 599 [asc_4] => 136099 [asc_5] => 140798 [distance] => 2535.771687496589 ) [69] => Array ( [id] => 497951501 [en] => Stockton [important_3] => 1 [asc_3] => 599 [asc_4] => 136056 [asc_5] => 138101 [distance] => 2612.413328179889 ) [70] => Array ( [id] => 497949104 [en] => Tampa [important_3] => 1 [asc_3] => 599 [asc_4] => 136061 [asc_5] => 138247 [distance] => 1739.830815694026 ) [71] => Array ( [id] => 497971360 [en] => Toledo [important_3] => 1 [asc_3] => 599 [asc_4] => 136087 [asc_5] => 139969 [distance] => 612.373255037144 ) [72] => Array ( [id] => 497954474 [en] => Tucson [important_3] => 1 [asc_3] => 599 [asc_4] => 136054 [asc_5] => 138051 [distance] => 2075.893292629869 ) [73] => Array ( [id] => 497984119 [en] => Virginia Beach [important_3] => 1 [asc_3] => 599 [asc_4] => 136098 [asc_5] => 0 [distance] => 1406.219705745628 ) [74] => Array ( [id] => 497949949 [en] => Washington [important_3] => 1 [asc_3] => 599 [asc_4] => 136060 [asc_5] => 138183 [distance] => 1226.365470920156 ) [75] => Array ( [id] => 497940947 [en] => Wichita [important_3] => 1 [asc_3] => 599 [asc_4] => 136068 [asc_5] => 138856 [distance] => 723.679084039015 ) [testArray] => test )