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

 

 

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

Geführte Studienreisen
Ö1 Studienreisen
 
 
Algerien
Äthiopien
Kenya
Madagaskar
Marokko
Namibia
Südafrika
Sudan
Tunesien
Uganda
Zimbabwe
 SUDAN | Nubische Dörfer und Schwarze Pharaonen

pro Person ab 2.260,-
Reiseverlauf: Khartoum - Omdurman - Naga - Musawarrat - Meroe - Kloster el-Ghazali - Nuri - Kerima - El Kurru - Jebel Barkal - Kerma - Soleb - Sedenga - Insel Sai - Sessebi - Delgo - Tumbus - Alt-Dongola