SELECT s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode,p.italiano AS PortName, s.PackageId As ItineraryCode, iti.Nnoches As Nnoches, z.italiano as Destino, r.Destino AS ZonaRegion FROM PrincessPricingFeedEur s, ZonasAPI z, PuertosAPI p,BarcosAPI b, RelacionSubregionRegion AS r, PrincessItineraryEUR as iti WHERE s.SubRegion = z.Region and p.Code = s.DeparturePortCode and b.ShipCode = s.ShipCode and r.REGION = s.RegionCode AND s.BrandCode = 'PCL' and iti.PackageId=s.PackageId and ( s.RegionCode='ALCAN' ) and ( s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'SA' or s.ShipCode = 'XP' or s.ShipCode = 'AP' or s.ShipCode = 'KP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2023' and s.SailDate <= '30/04/2023') OR (s.SailDate >= '01/05/2023' and s.SailDate <= '31/05/2023') OR (s.SailDate >= '01/06/2023' and s.SailDate <= '30/06/2023') OR (s.SailDate >= '01/07/2023' and s.SailDate <= '31/07/2023') OR (s.SailDate >= '01/08/2023' and s.SailDate <= '31/08/2023') OR (s.SailDate >= '01/09/2023' and s.SailDate <= '30/09/2023') OR (s.SailDate >= '01/10/2023' and s.SailDate <= '31/10/2023') ) and s.PackageId = 'HVH10B' GROUP BY s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode, p.italiano, iti.Nnoches, z.italiano, r.Destino ORDER BY s.PackageId

10

Notti

Pacific Coastal And Honolulu
Majestic Princess

Partenza Selezionata

                3 OTT 2023

€617

A partire da:

€ 195

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Honolulu                      

Vancouver                      | Victoria                       | Cruising | Cruising | Los Angeles                    | Los Angeles                  ...

Ordine dei porti soggetto a variazione

Date di partenza
2023
| OTT
3

Mostra tutte le date di partenza e le tipologie di sistemazione disponibili

SELECT s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode,p.italiano AS PortName, s.PackageId As ItineraryCode, iti.Nnoches As Nnoches, z.italiano as Destino, r.Destino AS ZonaRegion FROM PrincessPricingFeedEur s, ZonasAPI z, PuertosAPI p,BarcosAPI b, RelacionSubregionRegion AS r, PrincessItineraryEUR as iti WHERE s.SubRegion = z.Region and p.Code = s.DeparturePortCode and b.ShipCode = s.ShipCode and r.REGION = s.RegionCode AND s.BrandCode = 'PCL' and iti.PackageId=s.PackageId and ( s.RegionCode='ALCAN' ) and ( s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'SA' or s.ShipCode = 'XP' or s.ShipCode = 'AP' or s.ShipCode = 'KP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2023' and s.SailDate <= '30/04/2023') OR (s.SailDate >= '01/05/2023' and s.SailDate <= '31/05/2023') OR (s.SailDate >= '01/06/2023' and s.SailDate <= '30/06/2023') OR (s.SailDate >= '01/07/2023' and s.SailDate <= '31/07/2023') OR (s.SailDate >= '01/08/2023' and s.SailDate <= '31/08/2023') OR (s.SailDate >= '01/09/2023' and s.SailDate <= '30/09/2023') OR (s.SailDate >= '01/10/2023' and s.SailDate <= '31/10/2023') ) and s.PackageId = 'LVL06A' GROUP BY s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode, p.italiano, iti.Nnoches, z.italiano, r.Destino ORDER BY s.PackageId

6

Notti

Pacific Coast Wine & Food Experience
Discovery Princess

Partenza Selezionata

                1 OTT 2023

€336

A partire da:

€ 205

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Los Angeles                   

Vancouver                      | Vancouver                      | Victoria                       | Cruising | San Francisco                  | San Fra...

Ordine dei porti soggetto a variazione

Date di partenza
2023
| OTT
1

Mostra tutte le date di partenza e le tipologie di sistemazione disponibili

SELECT s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode,p.italiano AS PortName, s.PackageId As ItineraryCode, iti.Nnoches As Nnoches, z.italiano as Destino, r.Destino AS ZonaRegion FROM PrincessPricingFeedEur s, ZonasAPI z, PuertosAPI p,BarcosAPI b, RelacionSubregionRegion AS r, PrincessItineraryEUR as iti WHERE s.SubRegion = z.Region and p.Code = s.DeparturePortCode and b.ShipCode = s.ShipCode and r.REGION = s.RegionCode AND s.BrandCode = 'PCL' and iti.PackageId=s.PackageId and ( s.RegionCode='ALCAN' ) and ( s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'SA' or s.ShipCode = 'XP' or s.ShipCode = 'AP' or s.ShipCode = 'KP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2023' and s.SailDate <= '30/04/2023') OR (s.SailDate >= '01/05/2023' and s.SailDate <= '31/05/2023') OR (s.SailDate >= '01/06/2023' and s.SailDate <= '30/06/2023') OR (s.SailDate >= '01/07/2023' and s.SailDate <= '31/07/2023') OR (s.SailDate >= '01/08/2023' and s.SailDate <= '31/08/2023') OR (s.SailDate >= '01/09/2023' and s.SailDate <= '30/09/2023') OR (s.SailDate >= '01/10/2023' and s.SailDate <= '31/10/2023') ) and s.PackageId = 'LVL07B' GROUP BY s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode, p.italiano, iti.Nnoches, z.italiano, r.Destino ORDER BY s.PackageId

7

Notti

Pacific Coast Wine & Food Experience
Sapphire Princess

Partenza Selezionata

                8 OTT 2023

€379

A partire da:

€ 283

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Los Angeles                   

Vancouver                      | Victoria                       | Astoria                        | Cruising | San Francisco                  | Cruisin...

Ordine dei porti soggetto a variazione

Date di partenza
2023
| OTT
8

Mostra tutte le date di partenza e le tipologie di sistemazione disponibili

Passeggeri
Destinazioni

Alaska

Navi

Discovery Princess

Majestic Princess

Sapphire Princess

Periodo

2023

2024

2025

OTT

APR

MAG

MAG

GIU

GIU

LUG

LUG

AGO

AGO

SET

SET

Durata

6 - 8 Giorni

9 - 15 Giorni

Porto d'imbarco

Vancouver