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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'YP' or s.ShipCode = 'EX' or s.ShipCode = 'IP' or s.ShipCode = 'EP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') ) and s.PackageId = 'EBI10A' 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

Europa - Nord Europa
Emerald Princess

Partenza Selezionata

                30 SET 2022

€583

A partire da:

€ 171

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | St Peter Port (Guernsey)       | Cruising | Dublino, Irlanda | Belfast                        | Greenock (Glasgow)             | Liverp...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| SET
30

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

Passeggeri
Destinazioni

Europa - Nord Europa

Navi

Emerald Princess

Periodo

2022

2023

2024

SET

APR

OTT

MAG

NOV

GIU

LUG

AGO

SET

OTT

NOV

Durata

9 - 15 Giorni

Porto d'imbarco

Southampton