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 = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFR') and ( s.ShipCode = 'CO' or s.ShipCode = 'EP' or s.ShipCode = 'AP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU' or s.ShipCode = 'SA' or s.ShipCode = 'SP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2021' and s.SailDate <= '30/04/2021') OR (s.SailDate >= '01/05/2021' and s.SailDate <= '31/05/2021') OR (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') OR (s.SailDate >= '01/10/2021' and s.SailDate <= '31/10/2021') ) and s.PackageId = 'ANG07A' 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

5

Notti

Alaska
Coral Princess

Partenza Selezionata

                19 MAG 2021

€506

A partire da:

€ 219

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Whittier                      

Vancouver                      | Cruising | Icy Strait Point               | Juneau                         | Skagway                        | Glacier...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| MAG
19

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 = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFR') and ( s.ShipCode = 'CO' or s.ShipCode = 'EP' or s.ShipCode = 'AP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU' or s.ShipCode = 'SA' or s.ShipCode = 'SP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2021' and s.SailDate <= '30/04/2021') OR (s.SailDate >= '01/05/2021' and s.SailDate <= '31/05/2021') OR (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') OR (s.SailDate >= '01/10/2021' and s.SailDate <= '31/10/2021') ) and s.PackageId = 'AWG070' 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

2

Notti

Alaska
Coral Princess

Partenza Selezionata

                26 MAG 2021

€568

A partire da:

€ 213

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Whittier                       a Vancouver                     

Whittier                       | Hubbard Glacier | Glacier Bay                    | Skagway                        | Juneau                         | ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| MAG
26

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 = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFR') and ( s.ShipCode = 'CO' or s.ShipCode = 'EP' or s.ShipCode = 'AP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU' or s.ShipCode = 'SA' or s.ShipCode = 'SP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2021' and s.SailDate <= '30/04/2021') OR (s.SailDate >= '01/05/2021' and s.SailDate <= '31/05/2021') OR (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') OR (s.SailDate >= '01/10/2021' and s.SailDate <= '31/10/2021') ) 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

Alaska
Grand Princess

Partenza Selezionata

                18 SET 2021

€482

A partire da:

€ 201

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
2021
| SET
18

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

Passeggeri
Destinazioni

Alaska

Navi

Coral Princess

Grand Princess

Royal Princess

Periodo

2021

2022

2023

MAG

MAG

GIU

GIU

LUG

LUG

AGO

AGO

SET

SET

Durata

1 - 5 Giorni

6 - 8 Giorni

Porto d'imbarco

Vancouver                     

Whittier