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 = '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 = '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
Enchanted Princess

Partenza Selezionata

                2 OTT 2021

€1.697

A partire da:

€ 111

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
2021
| OTT
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 = '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 = 'ERB07A' 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
Enchanted Princess

Partenza Selezionata

                25 SET 2021

€536

A partire da:

€ 87

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Napoli | Cruising | Kotor                          | Cruising | Ajaccio | Tolone | Barcellona

Ordine dei porti soggetto a variazione

Date di partenza
2021
| SET
25

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 = 'ERB11A' 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
Enchanted Princess

Partenza Selezionata

                13 OTT 2021

€1.697

A partire da:

€ 132

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Cruising | Cruising | Atene | Kusadasi                       | Santorini                      | Mykonos                      ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| OTT
13

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 = '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
Enchanted Princess

Partenza Selezionata

                4 NOV 2021

€1.619

A partire da:

€ 128

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Cruising | Kotor                          | Dubrovnik                      | Cruising | Atene | Mykonos                      ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| NOV
4

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 = 'ERB14B' 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
Enchanted Princess

Partenza Selezionata

                18 SET 2021

€1.027

A partire da:

€ 222

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Cruising | Kotor                          | Corfu                          | Valletta                       | Messina        ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| SET
18

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 = 'ERR07A' 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
Enchanted Princess

Partenza Selezionata

                22 MAG 2021

€552

A partire da:

€ 87

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Cruising | Kotor                          | Corfu                          | Katakolon                      | Messina        ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| MAG
22

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 = 'ERR07B' 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
Enchanted Princess

Partenza Selezionata

                3 LUG 2021

€662

A partire da:

€ 95

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Cruising | Corfu                          | Kotor                          | Cruising | Messina                        | Napo...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| LUG
3

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 = 'ERR07C' 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
Enchanted Princess

Partenza Selezionata

                29 MAG 2021

€552

A partire da:

€ 87

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Ajaccio | Cruising | Gibilterra | Cruising | Marsiglia | Livorno      | Civitavecchia         

Ordine dei porti soggetto a variazione

Date di partenza
2021
| MAG
29

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 = 'ERR14A' 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
Enchanted Princess

Partenza Selezionata

                29 MAG 2021

€1.159

A partire da:

€ 226

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Ajaccio | Cruising | Gibilterra | Cruising | Marsiglia | Livorno      | Civitavecchia          | Napoli | Messina            ...

Ordine dei porti soggetto a variazione

Date di partenza
2021
| MAG
29

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 = '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

 DI 2 
1
 PAGINA 

Passeggeri
Destinazioni

Europa - Mediterraneo

Navi

Enchanted Princess

Island Princess

Periodo

2021

2022

2023

MAG

OTT

GIU

NOV

LUG

AGO

SET

OTT

NOV

Durata

6 - 8 Giorni

9 - 15 Giorni

Porto d'imbarco

Barcellona

Civitavecchia