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-05-25 00:33:36' 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 - 22nd June 2020 COMPLIMENTARY CABIN UPGRADE INCLUDED!
ship - MSC Divina
7 Nights
From €1,129 pp
22 June 2020
itinerary -
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) | Civitavecchia (Rome) | Cannes | Palma de Mallorca | Barcelona, Spain
Quote Ref: 24124
  • First
  • Previous
  • 1
  • Next
  • Last