SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_INTINFO LIKE '%Special KA%'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'BORDGUTHAB + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'BORDGUTHABEN + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'CATCH + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'CATCH + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'CATCH OF THE WEEK'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FLASH + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FLASH + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FLASH SALE'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRUEHB BORDGUTHAB + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRUEHB + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRÜHBUCHER'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRÜHBUCHER + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRÜHBUCHER BORDGUTHABEN'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRÜHBUCHER BORDGUTHABEN + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRÜHBUCHER WITH'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'FRÜHBUCHER WITH + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'HOLIDAY BREAKS'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'HOLIDAY BREAKS + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'LAST BER + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'LAST BER + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'LAST + EASY'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'LAST + PREMIUM'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'LAST MINUTE SALE'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'LAST MINUTE SALE BER'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'MSC Special KA'SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'SPECIAL'
SELECT TERMINPOS_XML_PMODEL, TERMINPOS_AMENITY_NAME, TERMINPOS_AMENITY_CHARGE, TERMINPOS_AMENITY_CODE, TERMINPOS_DISCOUNT_CODE,
TERMINPOS_DISCOUNT_VALUE, TERMINPOS_ID, TERMINPOS_SPECIAL_LANG, TERMINPOS_AGID, TERMINPOS_XML_PMODEL, TERMINPOS_DATUM_ABF, TERMINPOS_DATUM_ANK, TERMINPOS_MINPREIS,
TERMINPOS_DATUM_BOL, TERMINPOS_DATUM_EOL, TERMINPOS_PREISMODELL, TERMINPOS_PROVISION_ANZEIGEN, TERMINPOS_SUPERSTICKER, TERMINPOS_INTINFO, TERMINPOS_PREISINFO,
TERMINPOS_IDENTCODE,TERMINPOS_1PBLOCKED, TERMINPOS_2PONLY,TERMINPOS_2PMAX,TERMINPOS_3PMAX,TERMINPOS_4PMAX, TERMINPOS_MAX_KIDS, TERMINPOS_AP1_SPECIAL,
TERMINPOS_AP1_DATUM_START, TERMINPOS_AP1_DATUM_ENDE, TERMINPOS_AP1_VALUE, TERMINPOS_AP1_EINHEIT, TERMINPOS_AP1_PREISINFO, TERMINPOS_AP2_SPECIAL, TERMINPOS_AP2_DATUM_START,
TERMINPOS_AP2_DATUM_ENDE, TERMINPOS_AP2_VALUE, TERMINPOS_AP2_EINHEIT, TERMINPOS_AP2_PREISINFO, TERMINPOS_MANDATORY_TRANS, TERMINPOS_OPTION, TERMINPOS_ICO_FLUG,
TERMINPOS_ICO_BUS, TERMINPOS_ICO_BAHN, TERMINPOS_ICO_GETR, TERMINPOS_ICO_BGH, TERMINPOS_ICO_ALLINCLUSIVE, TERMINPOS_ICO_INTERNET, TERMINPOS_ICO_BIRTHDAY,
TERMINPOS_ICO_WEDDING, TERMINPOS_ICO_EXPEDITION, TERMINPOS_ICO_AUSFLUG, TERMINPOS_ICO_HOTEL, TERMINPOS_ICO_FRUEH, TERMINPOS_ICO_SPECIAL, TERMINPOS_KAT_LUXUS,
TERMINPOS_KAT_SINGLE, TERMINPOS_KAT_RAD, TERMINPOS_KAT_GOURMET, TERMINPOS_KAT_GOLF, TERMINPOS_KAT_XMAS, TERMINPOS_KAT_FAMILY, TERMINPOS_KAT_LASTMINUTE, TERMINPOS_KAT_WELTREISE
from `WS_ANG_TERMINPOS` where `WS_ANG_TERMINPOS`.`TERMINPOS_ID` = '2551710'
Innenkabinen
Außenkabinen
Balkonkabinen
Suiten
Eingeschlossene Leistungen
- Vollpension an Bord, bestehend aus Frühstück, Mittagessen, Tee und Imbiss am Nachmittag, Abendessen
- Getränkestation mit Kaffee, Tee und Wasser im Buffetrestaurant
- Benutzung aller Bordeinrichtungen im Passagierbereich
- Veranstaltungen und Unterhaltungsprogramm
- Deutschsprachige Bordbetreuung
- Ein- und Ausschiffungsgebühren
- Kinderbetreuung von 3-17 Jahre
- Hotel Servicegebühren
- Gepäcktransport bei Ein- und Ausschiffung
- Alle Steuern und Gebühren
Nicht eingeschlossene Leistungen
SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'SPECIAL + EASY'
SELECT TERMINPOS_XML_PMODEL, TERMINPOS_AMENITY_NAME, TERMINPOS_AMENITY_CHARGE, TERMINPOS_AMENITY_CODE, TERMINPOS_DISCOUNT_CODE,
TERMINPOS_DISCOUNT_VALUE, TERMINPOS_ID, TERMINPOS_SPECIAL_LANG, TERMINPOS_AGID, TERMINPOS_XML_PMODEL, TERMINPOS_DATUM_ABF, TERMINPOS_DATUM_ANK, TERMINPOS_MINPREIS,
TERMINPOS_DATUM_BOL, TERMINPOS_DATUM_EOL, TERMINPOS_PREISMODELL, TERMINPOS_PROVISION_ANZEIGEN, TERMINPOS_SUPERSTICKER, TERMINPOS_INTINFO, TERMINPOS_PREISINFO,
TERMINPOS_IDENTCODE,TERMINPOS_1PBLOCKED, TERMINPOS_2PONLY,TERMINPOS_2PMAX,TERMINPOS_3PMAX,TERMINPOS_4PMAX, TERMINPOS_MAX_KIDS, TERMINPOS_AP1_SPECIAL,
TERMINPOS_AP1_DATUM_START, TERMINPOS_AP1_DATUM_ENDE, TERMINPOS_AP1_VALUE, TERMINPOS_AP1_EINHEIT, TERMINPOS_AP1_PREISINFO, TERMINPOS_AP2_SPECIAL, TERMINPOS_AP2_DATUM_START,
TERMINPOS_AP2_DATUM_ENDE, TERMINPOS_AP2_VALUE, TERMINPOS_AP2_EINHEIT, TERMINPOS_AP2_PREISINFO, TERMINPOS_MANDATORY_TRANS, TERMINPOS_OPTION, TERMINPOS_ICO_FLUG,
TERMINPOS_ICO_BUS, TERMINPOS_ICO_BAHN, TERMINPOS_ICO_GETR, TERMINPOS_ICO_BGH, TERMINPOS_ICO_ALLINCLUSIVE, TERMINPOS_ICO_INTERNET, TERMINPOS_ICO_BIRTHDAY,
TERMINPOS_ICO_WEDDING, TERMINPOS_ICO_EXPEDITION, TERMINPOS_ICO_AUSFLUG, TERMINPOS_ICO_HOTEL, TERMINPOS_ICO_FRUEH, TERMINPOS_ICO_SPECIAL, TERMINPOS_KAT_LUXUS,
TERMINPOS_KAT_SINGLE, TERMINPOS_KAT_RAD, TERMINPOS_KAT_GOURMET, TERMINPOS_KAT_GOLF, TERMINPOS_KAT_XMAS, TERMINPOS_KAT_FAMILY, TERMINPOS_KAT_LASTMINUTE, TERMINPOS_KAT_WELTREISE
from `WS_ANG_TERMINPOS` where `WS_ANG_TERMINPOS`.`TERMINPOS_ID` = '2568884'
- Inklusive Bordguthaben
- All-Inclusive
TMID: 2568884
Innenkabinen
Außenkabinen
Balkonkabinen
Suiten
Eingeschlossene Leistungen
- Vollpension an Bord, bestehend aus Frühstück, Mittagessen, Tee und Imbiss am Nachmittag, Abendessen
- All Inclusive Getränkepaket Easy weitere Informationen
- Getränkestation mit Kaffee, Tee und Wasser im Buffetrestaurant
- Benutzung aller Bordeinrichtungen im Passagierbereich
- Veranstaltungen und Unterhaltungsprogramm
- Deutschsprachige Bordbetreuung
- Ein- und Ausschiffungsgebühren
- Kinderbetreuung von 3-17 Jahre
- Hotel Servicegebühren
- Gepäcktransport bei Ein- und Ausschiffung
- Alle Steuern und Gebühren
Nicht eingeschlossene Leistungen
SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'SPECIAL + PREMIUM'
SELECT TERMINPOS_XML_PMODEL, TERMINPOS_AMENITY_NAME, TERMINPOS_AMENITY_CHARGE, TERMINPOS_AMENITY_CODE, TERMINPOS_DISCOUNT_CODE,
TERMINPOS_DISCOUNT_VALUE, TERMINPOS_ID, TERMINPOS_SPECIAL_LANG, TERMINPOS_AGID, TERMINPOS_XML_PMODEL, TERMINPOS_DATUM_ABF, TERMINPOS_DATUM_ANK, TERMINPOS_MINPREIS,
TERMINPOS_DATUM_BOL, TERMINPOS_DATUM_EOL, TERMINPOS_PREISMODELL, TERMINPOS_PROVISION_ANZEIGEN, TERMINPOS_SUPERSTICKER, TERMINPOS_INTINFO, TERMINPOS_PREISINFO,
TERMINPOS_IDENTCODE,TERMINPOS_1PBLOCKED, TERMINPOS_2PONLY,TERMINPOS_2PMAX,TERMINPOS_3PMAX,TERMINPOS_4PMAX, TERMINPOS_MAX_KIDS, TERMINPOS_AP1_SPECIAL,
TERMINPOS_AP1_DATUM_START, TERMINPOS_AP1_DATUM_ENDE, TERMINPOS_AP1_VALUE, TERMINPOS_AP1_EINHEIT, TERMINPOS_AP1_PREISINFO, TERMINPOS_AP2_SPECIAL, TERMINPOS_AP2_DATUM_START,
TERMINPOS_AP2_DATUM_ENDE, TERMINPOS_AP2_VALUE, TERMINPOS_AP2_EINHEIT, TERMINPOS_AP2_PREISINFO, TERMINPOS_MANDATORY_TRANS, TERMINPOS_OPTION, TERMINPOS_ICO_FLUG,
TERMINPOS_ICO_BUS, TERMINPOS_ICO_BAHN, TERMINPOS_ICO_GETR, TERMINPOS_ICO_BGH, TERMINPOS_ICO_ALLINCLUSIVE, TERMINPOS_ICO_INTERNET, TERMINPOS_ICO_BIRTHDAY,
TERMINPOS_ICO_WEDDING, TERMINPOS_ICO_EXPEDITION, TERMINPOS_ICO_AUSFLUG, TERMINPOS_ICO_HOTEL, TERMINPOS_ICO_FRUEH, TERMINPOS_ICO_SPECIAL, TERMINPOS_KAT_LUXUS,
TERMINPOS_KAT_SINGLE, TERMINPOS_KAT_RAD, TERMINPOS_KAT_GOURMET, TERMINPOS_KAT_GOLF, TERMINPOS_KAT_XMAS, TERMINPOS_KAT_FAMILY, TERMINPOS_KAT_LASTMINUTE, TERMINPOS_KAT_WELTREISE
from `WS_ANG_TERMINPOS` where `WS_ANG_TERMINPOS`.`TERMINPOS_ID` = '2568886'
- Inklusive Bordguthaben
- All-Inclusive
TMID: 2568886
Innenkabinen
Außenkabinen
Balkonkabinen
Suiten
Eingeschlossene Leistungen
- Vollpension an Bord, bestehend aus Frühstück, Mittagessen, Tee und Imbiss am Nachmittag, Abendessen
- All Inclusive Getränkepaket Premium Extra weitere Informationen
- Getränkestation mit Kaffee, Tee und Wasser im Buffetrestaurant
- Benutzung aller Bordeinrichtungen im Passagierbereich
- Veranstaltungen und Unterhaltungsprogramm
- Deutschsprachige Bordbetreuung
- Ein- und Ausschiffungsgebühren
- Kinderbetreuung von 3-17 Jahre
- Hotel Servicegebühren
- Gepäcktransport bei Ein- und Ausschiffung
- Alle Steuern und Gebühren
Nicht eingeschlossene Leistungen
SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'OSTER + EASY'
SELECT TERMINPOS_XML_PMODEL, TERMINPOS_AMENITY_NAME, TERMINPOS_AMENITY_CHARGE, TERMINPOS_AMENITY_CODE, TERMINPOS_DISCOUNT_CODE,
TERMINPOS_DISCOUNT_VALUE, TERMINPOS_ID, TERMINPOS_SPECIAL_LANG, TERMINPOS_AGID, TERMINPOS_XML_PMODEL, TERMINPOS_DATUM_ABF, TERMINPOS_DATUM_ANK, TERMINPOS_MINPREIS,
TERMINPOS_DATUM_BOL, TERMINPOS_DATUM_EOL, TERMINPOS_PREISMODELL, TERMINPOS_PROVISION_ANZEIGEN, TERMINPOS_SUPERSTICKER, TERMINPOS_INTINFO, TERMINPOS_PREISINFO,
TERMINPOS_IDENTCODE,TERMINPOS_1PBLOCKED, TERMINPOS_2PONLY,TERMINPOS_2PMAX,TERMINPOS_3PMAX,TERMINPOS_4PMAX, TERMINPOS_MAX_KIDS, TERMINPOS_AP1_SPECIAL,
TERMINPOS_AP1_DATUM_START, TERMINPOS_AP1_DATUM_ENDE, TERMINPOS_AP1_VALUE, TERMINPOS_AP1_EINHEIT, TERMINPOS_AP1_PREISINFO, TERMINPOS_AP2_SPECIAL, TERMINPOS_AP2_DATUM_START,
TERMINPOS_AP2_DATUM_ENDE, TERMINPOS_AP2_VALUE, TERMINPOS_AP2_EINHEIT, TERMINPOS_AP2_PREISINFO, TERMINPOS_MANDATORY_TRANS, TERMINPOS_OPTION, TERMINPOS_ICO_FLUG,
TERMINPOS_ICO_BUS, TERMINPOS_ICO_BAHN, TERMINPOS_ICO_GETR, TERMINPOS_ICO_BGH, TERMINPOS_ICO_ALLINCLUSIVE, TERMINPOS_ICO_INTERNET, TERMINPOS_ICO_BIRTHDAY,
TERMINPOS_ICO_WEDDING, TERMINPOS_ICO_EXPEDITION, TERMINPOS_ICO_AUSFLUG, TERMINPOS_ICO_HOTEL, TERMINPOS_ICO_FRUEH, TERMINPOS_ICO_SPECIAL, TERMINPOS_KAT_LUXUS,
TERMINPOS_KAT_SINGLE, TERMINPOS_KAT_RAD, TERMINPOS_KAT_GOURMET, TERMINPOS_KAT_GOLF, TERMINPOS_KAT_XMAS, TERMINPOS_KAT_FAMILY, TERMINPOS_KAT_LASTMINUTE, TERMINPOS_KAT_WELTREISE
from `WS_ANG_TERMINPOS` where `WS_ANG_TERMINPOS`.`TERMINPOS_ID` = '2594485'
- Inklusive Bordguthaben
- All-Inclusive
TMID: 2594485
Innenkabinen
Außenkabinen
Balkonkabinen
Eingeschlossene Leistungen
- Vollpension an Bord, bestehend aus Frühstück, Mittagessen, Tee und Imbiss am Nachmittag, Abendessen
- All Inclusive Getränkepaket Easy weitere Informationen
- Getränkestation mit Kaffee, Tee und Wasser im Buffetrestaurant
- Benutzung aller Bordeinrichtungen im Passagierbereich
- Veranstaltungen und Unterhaltungsprogramm
- Deutschsprachige Bordbetreuung
- Ein- und Ausschiffungsgebühren
- Kinderbetreuung von 3-17 Jahre
- Hotel Servicegebühren
- Gepäcktransport bei Ein- und Ausschiffung
- Alle Steuern und Gebühren
Nicht eingeschlossene Leistungen
SELECT TERMINPOS_ID FROM WS_ANG_TERMINPOS WHERE TERMINPOS_AGID = '170404'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_EOL` >= '2026-04-01'
and `WS_ANG_TERMINPOS`.`TERMINPOS_DATUM_BOL` <= '2026-04-01'
and TERMINPOS_CAMPAIGN = 'OSTER SPECIAL'
SELECT TERMINPOS_XML_PMODEL, TERMINPOS_AMENITY_NAME, TERMINPOS_AMENITY_CHARGE, TERMINPOS_AMENITY_CODE, TERMINPOS_DISCOUNT_CODE,
TERMINPOS_DISCOUNT_VALUE, TERMINPOS_ID, TERMINPOS_SPECIAL_LANG, TERMINPOS_AGID, TERMINPOS_XML_PMODEL, TERMINPOS_DATUM_ABF, TERMINPOS_DATUM_ANK, TERMINPOS_MINPREIS,
TERMINPOS_DATUM_BOL, TERMINPOS_DATUM_EOL, TERMINPOS_PREISMODELL, TERMINPOS_PROVISION_ANZEIGEN, TERMINPOS_SUPERSTICKER, TERMINPOS_INTINFO, TERMINPOS_PREISINFO,
TERMINPOS_IDENTCODE,TERMINPOS_1PBLOCKED, TERMINPOS_2PONLY,TERMINPOS_2PMAX,TERMINPOS_3PMAX,TERMINPOS_4PMAX, TERMINPOS_MAX_KIDS, TERMINPOS_AP1_SPECIAL,
TERMINPOS_AP1_DATUM_START, TERMINPOS_AP1_DATUM_ENDE, TERMINPOS_AP1_VALUE, TERMINPOS_AP1_EINHEIT, TERMINPOS_AP1_PREISINFO, TERMINPOS_AP2_SPECIAL, TERMINPOS_AP2_DATUM_START,
TERMINPOS_AP2_DATUM_ENDE, TERMINPOS_AP2_VALUE, TERMINPOS_AP2_EINHEIT, TERMINPOS_AP2_PREISINFO, TERMINPOS_MANDATORY_TRANS, TERMINPOS_OPTION, TERMINPOS_ICO_FLUG,
TERMINPOS_ICO_BUS, TERMINPOS_ICO_BAHN, TERMINPOS_ICO_GETR, TERMINPOS_ICO_BGH, TERMINPOS_ICO_ALLINCLUSIVE, TERMINPOS_ICO_INTERNET, TERMINPOS_ICO_BIRTHDAY,
TERMINPOS_ICO_WEDDING, TERMINPOS_ICO_EXPEDITION, TERMINPOS_ICO_AUSFLUG, TERMINPOS_ICO_HOTEL, TERMINPOS_ICO_FRUEH, TERMINPOS_ICO_SPECIAL, TERMINPOS_KAT_LUXUS,
TERMINPOS_KAT_SINGLE, TERMINPOS_KAT_RAD, TERMINPOS_KAT_GOURMET, TERMINPOS_KAT_GOLF, TERMINPOS_KAT_XMAS, TERMINPOS_KAT_FAMILY, TERMINPOS_KAT_LASTMINUTE, TERMINPOS_KAT_WELTREISE
from `WS_ANG_TERMINPOS` where `WS_ANG_TERMINPOS`.`TERMINPOS_ID` = '2594489'
Innenkabinen
Außenkabinen
Balkonkabinen
Eingeschlossene Leistungen
- Vollpension an Bord, bestehend aus Frühstück, Mittagessen, Tee und Imbiss am Nachmittag, Abendessen
- Getränkestation mit Kaffee, Tee und Wasser im Buffetrestaurant
- Benutzung aller Bordeinrichtungen im Passagierbereich
- Veranstaltungen und Unterhaltungsprogramm
- Deutschsprachige Bordbetreuung
- Ein- und Ausschiffungsgebühren
- Kinderbetreuung von 3-17 Jahre
- Hotel Servicegebühren
- Gepäcktransport bei Ein- und Ausschiffung
- Alle Steuern und Gebühren
Nicht eingeschlossene Leistungen
