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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'EX' or s.ShipCode = 'XP' or s.ShipCode = 'IP' or s.ShipCode = 'PA') 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') OR (s.SailDate >= '01/11/2021' and s.SailDate <= '30/11/2021') OR (s.SailDate >= '01/12/2021' and s.SailDate <= '31/12/2021') ) and s.PackageId = 'ERR14D' 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

14

Notti

Europa - Mediterraneo
Island Princess

Partenza Selezionata

                31 OTT 2021

€2.313

A partire da:

€ 185

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Cruising | Katakolon                      | Atene | Kusadasi                       | Rodi | Limassol                       | ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| OTT
31

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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'EX' or s.ShipCode = 'XP' or s.ShipCode = 'IP' or s.ShipCode = 'PA') 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') OR (s.SailDate >= '01/11/2021' and s.SailDate <= '30/11/2021') OR (s.SailDate >= '01/12/2021' and s.SailDate <= '31/12/2021') ) and s.PackageId = 'FRF14B' 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

14

Notti

Europa - Mediterraneo
Island Princess

Partenza Selezionata

                28 NOV 2021

€988

A partire da:

€ 95

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Fort Lauderdale               

Civitavecchia          | Cagliari          | Cruising | Malaga                         | Casablanca                     | Cruising | Funchal (Madeira)...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| NOV
28

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

Passeggeri
Destinazioni

Europa - Mediterraneo

Navi

Island Princess

Periodo

2021

2022

2023

OTT

OTT

NOV

NOV

Durata

9 - 15 Giorni

Porto d'imbarco

Civitavecchia