
Cities near to Oberpframmern
Distances between Oberpframmern and Important Cities in Germany
Visit our sponsors
select other_city_id as id, distance, keops.geoplaces_cities_distances.important_3 , en from keops.geoplaces_cities_distances, keops.geoplaces where city_id=497857533 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] => 514.964279432020 ) [1] => Array ( [id] => 497860096 [en] => Augsburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135382 [asc_5] => 137540 [distance] => 78.621547119825 ) [2] => Array ( [id] => 497885435 [en] => Berlin [important_3] => 1 [asc_3] => 536 [asc_4] => 135381 [asc_5] => 137526 [distance] => 516.482059566010 ) [3] => Array ( [id] => 497884833 [en] => Bielefeld [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137522 [distance] => 503.889685686673 ) [4] => Array ( [id] => 497884054 [en] => Bochum [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137517 [distance] => 507.899296744087 ) [5] => Array ( [id] => 497882258 [en] => Bonn [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137515 [distance] => 455.425064195136 ) [6] => Array ( [id] => 497884125 [en] => Bottrop [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137512 [distance] => 524.747699817639 ) [7] => Array ( [id] => 497886019 [en] => Bremen [important_3] => 1 [asc_3] => 536 [asc_4] => 135379 [asc_5] => 137508 [distance] => 601.328525358027 ) [8] => Array ( [id] => 497886561 [en] => Bremerhaven [important_3] => 1 [asc_3] => 536 [asc_4] => 135379 [asc_5] => 137507 [distance] => 655.530096199492 ) [9] => Array ( [id] => 497885135 [en] => Brunswick [important_3] => 1 [asc_3] => 536 [asc_4] => 135375 [asc_5] => 137510 [distance] => 481.663311798931 ) [10] => Array ( [id] => 497882670 [en] => Chemnitz [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137502 [distance] => 322.400856172077 ) [11] => Array ( [id] => 497882972 [en] => Cologne [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137380 [distance] => 478.215978704927 ) [12] => Array ( [id] => 497875879 [en] => Darmstadt [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137492 [distance] => 310.178541496084 ) [13] => Array ( [id] => 497884107 [en] => Dortmund [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137477 [distance] => 497.550038874670 ) [14] => Array ( [id] => 497883250 [en] => Dresden [important_3] => 1 [asc_3] => 536 [asc_4] => 135371 [asc_5] => 137476 [distance] => 364.246338281194 ) [15] => Array ( [id] => 497883967 [en] => Duisburg [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137475 [distance] => 525.654324514769 ) [16] => Array ( [id] => 497883634 [en] => Dusseldorf [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137473 [distance] => 509.106850646300 ) [17] => Array ( [id] => 497883100 [en] => Erfurt [important_3] => 1 [asc_3] => 536 [asc_4] => 135368 [asc_5] => 137461 [distance] => 335.116823051800 ) [18] => Array ( [id] => 497884026 [en] => Essen [important_3] => 1 [asc_3] => 536 [asc_4] => 135374 [asc_5] => 137458 [distance] => 516.581024168836 ) [19] => Array ( [id] => 497878130 [en] => Frankfurt [important_3] => 1 [asc_3] => 536 [asc_4] => 135377 [asc_5] => 137451 [distance] => 326.805943667113 ) [testArray] => test )