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 = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (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') ) and s.PackageId = 'EFS07A' 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

Europa - Nord Europa
Regal Princess

Partenza Selezionata

                30 SET 2021

€510

A partire da:

€ 78

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | La Rochelle                    | Bilbao                         | La Coruna                      | Cruising | St Peter Port ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| SET
30

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

Passeggeri
Destinazioni

Europa - Nord Europa

Navi

Regal Princess

Periodo

2021

2022

2023

SET

GIU

OTT

LUG

NOV

AGO

SET

OTT

Durata

6 - 8 Giorni

Porto d'imbarco

Southampton