SELECT bc.strike_price,bl.reff_code,bc.basepoke_id,bc.offer_short_summery,bl.ship_id,bc.cruise_id,bc.offer_title,bc.cruise_nights,bc.offer_price,bc.departure_date FROM tbk_basepoke_list as bl INNER JOIN tbk_basepoke_cruises as bc ON bl.id = bc.basepoke_id WHERE bc.offer_start_date < curdate() and bc.offer_end_date > curdate() and bc.departure_date > '2020-02-22 05:56:16' AND bl.basepoke_status = 1 AND bc.base_cruise_status = 1 GROUP BY bc.basepoke_id ORDER BY departure_date ASC LIMIT 0,9
  • First
  • Previous
  • 1
  • Next
  • Last
MSC Divina - 30th April 2020 COMPLIMENTARY CABIN UPGRADE INCLUDED!
ship - MSC Divina
7 Nights
From €1,069 pp
30 April 2020
itinerary - Naples, Italy | Livorno (Florence/Pisa) | Genoa | Marseille | Barcelona | Ibiza | AT SEA | Naples, Italy
Quote Ref: 61110
MSC Orchestra - 6th June 2020 - COMPLIMENTARY CABIN UPGRADE INCLUDED!
ship - MSC Orchestra
7 Nights
From €1,239 pp
6 June 2020
itinerary - Venice, Italy | Bari | Katakolon (Olympia) | Mykonos | Piraeus (Athens) | Sarande | Dubrovnik | Venice, Italy
Quote Ref: 64638
MSC Divina - 22nd June 2020 COMPLIMENTARY CABIN UPGRADE INCLUDED!
ship - MSC Divina
7 Nights
From €1,129 pp
22 June 2020
itinerary - Barcelona, Spain | Ibiza | AT SEA | Naples | Livorno (Florence/Pisa) | Genoa | Marseille | Barcelona, Spain
Quote Ref: 38542
FlyCruise - MSC Seaview - COMPLIMENTARY CABIN UPGRADE INCLUDED!
ship - MSC Seaview
7 Nights
From €1,319 pp
26 September 2020
itinerary - Barcelona, Spain | Ajaccio | Genoa | La Spezia (Cinque Terre) | Civitavecchia (Rome) | Cannes | Palma de Mallorca | Barcelona | Civitavecchia (Rome), Italy
Quote Ref: 24124
  • First
  • Previous
  • 1
  • Next
  • Last