DI 2 
1
 PAGINA 

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EAB07B' 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 - Mediterraneo
Regal Princess

Partenza Selezionata

                9 APR 2022

€755

A partire da:

€ 99

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Atene a Barcellona

Atene | Santorini                      | Cruising | Kotor                          | Messina                        | Napoli | Cruising | Barcellona

Ordine dei porti soggetto a variazione

Date di partenza
2022
| APR
9

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EAR14A' 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
Regal Princess

Partenza Selezionata

                14 MAG 2022

€1.471

A partire da:

€ 148

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Atene a Civitavecchia         

Atene | Santorini                      | Cruising | Kotor                          | Messina                        | Napoli | Cruising | Barcellona |...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| MAG
14

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EBA14A' 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
Regal Princess

Partenza Selezionata

                26 MAR 2022

€1.471

A partire da:

€ 185

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Atene

Barcellona | Cruising | Gibilterra | Cruising | Marsiglia | Genova                          | Livorno      | Civitavecchia          | Napoli | Cruisin...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| MAR
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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EBR11A' 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

11

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                6 NOV 2022

€1.448

A partire da:

€ 111

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Civitavecchia         

Barcellona | Tolone | Livorno      | Cruising | Cruising | Kotor                          | Dubrovnik                      | Corfu                    ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| NOV
6

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EBR11B' 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

11

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                15 OTT 2022

€1.526

A partire da:

€ 115

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Civitavecchia         

Barcellona | Marsiglia | Livorno      | Cruising | Valletta                       | Cruising | Kotor                          | Corfu                 ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| OTT
15

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EMM07A' 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 - Mediterraneo
Regal Princess

Partenza Selezionata

                26 MAR 2022

€755

A partire da:

€ 99

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Civitavecchia         

Barcellona | Cruising | Gibilterra | Cruising | Marsiglia | Genova                          | Livorno      | Civitavecchia         

Ordine dei porti soggetto a variazione

Date di partenza
2022
| MAR
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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'ERA07E' 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 - Mediterraneo
Regal Princess

Partenza Selezionata

                2 APR 2022

€755

A partire da:

€ 107

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Atene

Civitavecchia          | Napoli | Cruising | Heraklion             | Kusadasi                       | Istanbul                       | Mykonos        ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| APR
2

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'ERB11C' 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

11

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                26 OTT 2022

€1.448

A partire da:

€ 189

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Cruising | Kotor                          | Cruising | Atene | Kusadasi                       | Mykonos                      ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| OTT
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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'ERB14A' 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
Regal Princess

Partenza Selezionata

                2 APR 2022

€1.471

A partire da:

€ 177

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Napoli | Cruising | Heraklion             | Kusadasi                       | Istanbul                       | Mykonos        ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| APR
2

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 = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (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') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'ERR14C' 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 2022

€2.219

A partire da:

€ 173

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Cruising | Katakolon                      | Atene | Kusadasi                       | Cruising | Ashdod | Haifa      | Limasso...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| OTT
31

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

 DI 2 
1
 PAGINA 

Passeggeri
Destinazioni

Europa - Mediterraneo

Navi

Island Princess

Regal Princess

Periodo

2021

2022

2023

MAR

NOV

APR

DIC

MAG

GIU

LUG

AGO

SET

OTT

NOV

Durata

6 - 8 Giorni

9 - 15 Giorni

Porto d'imbarco

Atene

Barcellona

Civitavecchia