Website Banners (5)
SELECT bc.special_message, bc.offer_listing, bc.package_start_date, 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 discovercru_basepoke_list as bl INNER JOIN discovercru_basepoke_cruises as bc ON bl.id = bc.basepoke_id WHERE bl.bl_cruise_id = bc.cruise_id AND bc.offer_start_date < curdate() and bc.offer_end_date > curdate() and bc.departure_date > '2020-05-28 04:09:11' AND bl.basepoke_status = 1 AND bc.base_cruise_status = 1 GROUP BY bc.basepoke_id ORDER BY bc.offer_order DESC LIMIT 0,9
  • First
  • Previous
  • 1
  • Next
  • Last
Rio De Janeiro Stay and Grand Voyage to Southampton
ship - MSC Preziosa
Departs: 26 March 2021 | 18 Nights
Cruise Itinerary - Rio de Janeiro, Brazil | Buzios | At Sea | Ilheus(Bahia) | Bahia de Salvador | At Sea | At Sea | At Sea | ...Southampton, England
Quote Ref: 5968
  • First
  • Previous
  • 1
  • Next
  • Last