---sssss-----SELECT DISTINCT CONTTRANS.TRANSLATION AS LANDX, GEOGRAPHICUNIT_LANG.TRANSLATION AS STADTX FROM top_jbt_prod.GEOGRAPHICUNIT_LANG CONTTRANS, top_jbt_prod.GEOGRAPHIC_UNIT_ASSOC CONT, top_jbt_prod.SERVICEDATA , top_jbt_prod.SERVICE_GROUP_VW , top_jbt_prod.PACKAGE_VW , top_jbt_prod.PACKAGE_GROUP_VW , top_jbt_prod.SERVICESTARTINGPOINT_ASSOC , top_jbt_prod.GEOGRAPHICUNIT_LANG , top_jbt_prod.GEOGRAPHIC_UNIT_ASSOC , top_jbt_prod.GEOGRAPHIC_UNIT_ASSOC LAND WHERE (SERVICESTARTINGPOINT_ASSOC.S_STARTINGPOINT_ID = SERVICEDATA.ID) AND(SERVICESTARTINGPOINT_ASSOC.S_STARTGEOUNIT_ID = GEOGRAPHIC_UNIT_ASSOC.CHILDREN_GEOUNIT_ID) AND(GEOGRAPHIC_UNIT_ASSOC.PARENTS_GEOUNIT_ID = LAND.CHILDREN_GEOUNIT_ID) AND(LAND.PARENTS_GEOUNIT_ID = GEOGRAPHICUNIT_LANG.DATA_ID) AND(LAND.PARENTS_GEOUNIT_ID = CONT.CHILDREN_GEOUNIT_ID) AND(CONT.PARENTS_GEOUNIT_ID = CONTTRANS.DATA_ID) AND(SERVICEDATA.CODE = SERVICE_GROUP_VW.SERVICE(+)) AND(SERVICEDATA.CODE = PACKAGE_VW.SERVICE_CODE(+)) AND(PACKAGE_VW.PACK_CODE = PACKAGE_GROUP_VW.PACKAGECODE(+)) AND(SERVICEDATA.CATALOG_ID = 2803) AND (SERVICEDATA.SERVICECLASS = 2) AND (GEOGRAPHICUNIT_LANG.LANGUAGE_CODE = 'de') AND (CONTTRANS.LANGUAGE_CODE = 'de') AND (SERVICEDATA.CODECMS <> 'N' OR SERVICEDATA.CODECMS Is Null) AND (SERVICE_GROUP_VW.SERVICEGRP = 'STUDGEF' or PACKAGE_GROUP_VW.PACKAGEGRP = 'STUDGEF' ) AND PACKAGE_VW.VALID_FROM>TO_DATE('31.12.2016','DD.MM.YYYY') ORDER BY CONTTRANS.TRANSLATION ASC, GEOGRAPHICUNIT_LANG.TRANSLATION ASC
jumbo touristik - Österreichs Fernreise-Spezialist - Nordamerika - Nordamerika -
jumbo gruppe - Österreichs Spezialisten für Reisen nach Asien Thailand Bali Dubai Orient Südamerika Südafrika Kenia Mauritius Seychellen Malediven

 

 

 
 
Nordamerika - Nordamerika - - Rundreise(n)
Studienreisen
Fernreise Kataloge
Sonderangebote

Geführte Studienreisen
Ö1 Studienreisen
 
 
Kanada
Vereinigte Staaten von Amerika
 USA | Sehnsuchtsziel Alaska

pro Person ab 2.432,-
Reiseverlauf: Alaska - Anchorage - Denali Nationalpark - Fairbanks - Valdez - Whittier - Seaward - Homer
 USA | New York City Kulturreise

pro Person ab 1.280,-
Reiseverlauf: New York
 USA Transkontinental | Zug-Erlebnisreise

pro Person ab 5.520,-
Reiseverlauf: New York - Washington - Chicago - Rocky Mountains - Colorado River - Monument Valley - Grand Canyon - Los Angeles - Beverly Hills - Hollywood - San Francisco
 USA | Der Wilde Westen, Metropolen & Nationalparks

pro Person ab 2.690,-
Reiseverlauf: Los Angeles - Beverly Hills - Palm Springs - Las Vegas - San Francisco - Monterey - Santa Barbara - Santa Monica
 USA | Die legendären Südstaaten

pro Person ab 3.190,-
Reiseverlauf: OE1 - Houston - Lafayette - New Orleans - Baton Rouge - Natchez - Vicksburg - Memphis - Nashville - Atlanta
 USA & KANADA | Der historische Osten

pro Person ab 2.880,-
Reiseverlauf: New York - Philadelphia - Lancaster - Washington - Toronto - Montreal - New Hampshire - Salem - Boston - Cape Cod