---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 - Asien - Asien -
jumbo gruppe - Österreichs Spezialisten für Reisen nach Asien Thailand Bali Dubai Orient Südamerika Südafrika Kenia Mauritius Seychellen Malediven

 

 

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

Geführte Studienreisen
Ö1 Studienreisen
 
 
Bhutan
China
Hongkong
Indien
Indonesien
Japan
Kasachstan
Kirgistan
Laos
Malaysien
Mongolei
Myanmar
Nepal
Singapur
Sri Lanka
Südkorea
Taiwan
Thailand
Turkmenistan
Vietnam
Australien
 ASIENS VERBORGENE SCHÄTZE | Vom Hochland Nordvietnams über Laos nach Nordthailand

pro Person ab 3.720,-
Reiseverlauf: Hanoi - Sapa - Lao - Luang Prabang - Mekong - Chiang Rai
 Anschlussreise Laos Privat

pro Person ab 576,-
Reiseverlauf: Laos - Vientiane - Luang Prabang
 INDOCHINA | Buchten und Tempel

pro Person ab 1.535,-
Reiseverlauf: Hanoi - Halong Bucht - Hoi An - Danang - Hue - Saigon - Phnom Penh - Siem Reap - Angkor
 VIETNAM & KAMBODSCHA | Das Lächeln der Khmer

pro Person ab 2.820,-
Reiseverlauf: Hanoi - Halong Bucht - Da Nang - Hoi An - My Son - Hue - Saigon - Angkor Wat - Phnom Penh