
Click here to see more details and book Sheraton Airport . You see photos, situation, room facilities, hotel installations, entertainment facilities and payment methods Sheraton Ai ...
select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497859581 and from_important=1 and keops.geoplaces_cities_distances.city_id=keops.geoplaces.id order by en ascArray ( )
Array ( [0] => Array ( [id] => 497882396 [en] => Aachen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137558 [distance] => 483.102257182821 ) [1] => Array ( [id] => 497860096 [en] => Augsburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137540 [distance] => 52.333012390231 ) [2] => Array ( [id] => 497885435 [en] => Berlin [important_3] => 1 [asc_3] => 536 [asc_4] => 135381 [asc_5] => 137526 [distance] => 492.154889278935 ) [3] => Array ( [id] => 497884833 [en] => Bielefeld [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137522 [distance] => 469.409707981219 ) [4] => Array ( [id] => 497884054 [en] => Bochum [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137517 [distance] => 473.878868586278 ) [5] => Array ( [id] => 497882258 [en] => Bonn [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137515 [distance] => 422.581076462917 ) [6] => Array ( [id] => 497884125 [en] => Bottrop [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137512 [distance] => 490.848777731039 ) [7] => Array ( [id] => 497886019 [en] => Bremen [important_3] => 1 [asc_3] => 536 [asc_4] => 135379 [asc_5] => 137508 [distance] => 567.351371585311 ) [8] => Array ( [id] => 497886561 [en] => Bremerhaven [important_3] => 1 [asc_3] => 536 [asc_4] => 135379 [asc_5] => 137507 [distance] => 621.603269947912 ) [9] => Array ( [id] => 497885135 [en] => Brunswick [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137510 [distance] => 449.123399728225 ) [10] => Array ( [id] => 497882670 [en] => Chemnitz [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137502 [distance] => 298.253096999366 ) [11] => Array ( [id] => 497882972 [en] => Cologne [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137380 [distance] => 445.077608014748 ) [12] => Array ( [id] => 497875879 [en] => Darmstadt [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137492 [distance] => 277.492285826382 ) [13] => Array ( [id] => 497884107 [en] => Dortmund [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137477 [distance] => 463.346555518780 ) [14] => Array ( [id] => 497883250 [en] => Dresden [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137476 [distance] => 343.639448315059 ) [15] => Array ( [id] => 497883967 [en] => Duisburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137475 [distance] => 491.989561480149 ) [16] => Array ( [id] => 497883634 [en] => Dusseldorf [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137473 [distance] => 475.662874972899 ) [17] => Array ( [id] => 497883100 [en] => Erfurt [important_3] => 1 [asc_3] => 536 [asc_4] => 135368 [asc_5] => 137461 [distance] => 302.904399652634 ) [18] => Array ( [id] => 497884026 [en] => Essen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137458 [distance] => 482.697730664247 ) [19] => Array ( [id] => 497878130 [en] => Frankfurt [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137451 [distance] => 293.373462625421 ) [20] => Array ( [id] => 497857323 [en] => Freiburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137449 [distance] => 279.469666354851 ) [21] => Array ( [id] => 497871764 [en] => Furth [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137442 [distance] => 139.628582855857 ) [22] => Array ( [id] => 497884106 [en] => Gelsenkirchen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137440 [distance] => 480.584360131277 ) [23] => Array ( [id] => 497884126 [en] => Gottingen [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137431 [distance] => 379.554092696047 ) [24] => Array ( [id] => 497883852 [en] => Hagen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137423 [distance] => 452.651988006910 ) [25] => Array ( [id] => 497884072 [en] => Halle [important_3] => 1 [asc_3] => 536 [asc_4] => 135370 [asc_5] => 137421 [distance] => 355.681653327881 ) [26] => Array ( [id] => 497886566 [en] => Hamburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135378 [asc_5] => 137420 [distance] => 593.695613035075 ) [27] => Array ( [id] => 497884338 [en] => Hamm [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137418 [distance] => 463.192721756956 ) [28] => Array ( [id] => 497885289 [en] => Hanover [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137417 [distance] => 475.621431139973 ) [29] => Array ( [id] => 497871030 [en] => Heidelberg [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137413 [distance] => 246.548033151595 ) [30] => Array ( [id] => 497867712 [en] => Heilbronn [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137411 [distance] => 197.884456727898 ) [31] => Array ( [id] => 497884148 [en] => Herne [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137407 [distance] => 478.290214092217 ) [32] => Array ( [id] => 497863649 [en] => Ingolstadt [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137394 [distance] => 54.655671254121 ) [33] => Array ( [id] => 497866051 [en] => Karlsruhe [important_3] => 1 [asc_3] => 536 [asc_4] => 135383 [asc_5] => 137389 [distance] => 247.270509940100 ) [34] => Array ( [id] => 497883777 [en] => Kassel [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137388 [distance] => 369.325271885637 ) [35] => Array ( [id] => 497887849 [en] => Kiel [important_3] => 1 [asc_3] => 536 [asc_4] => 135369 [asc_5] => 137384 [distance] => 678.172858063810 ) [36] => Array ( [id] => 497883796 [en] => Krefeld [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137377 [distance] => 494.799089419772 ) [37] => Array ( [id] => 497883839 [en] => Leipzig [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137348 [distance] => 345.159510157074 ) [38] => Array ( [id] => 497883209 [en] => Leverkusen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137346 [distance] => 450.498028244961 ) [39] => Array ( [id] => 497887168 [en] => Lubeck [important_3] => 1 [asc_3] => 536 [asc_4] => 135369 [asc_5] => 137339 [distance] => 623.813011351643 ) [testArray] => test )