SELECT bc.created_date, bc.offer_listing, 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.special_message, bc.offer_price,bc.departure_date FROM crsbtq_basepoke_list as bl INNER JOIN crsbtq_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-08-12 03:42:19' AND bl.basepoke_status = 1 AND bc.base_cruise_status = 1 GROUP BY bc.basepoke_id ORDER BY bc.created_date DESC LIMIT 0,9
  • First
  • Previous
  • 1
  • Next
  • Last
Limited Time Only
THAILAND & MALAYSIA CRUISE W/ SINGAPORE STAY
Departure : 14 October 2020 |
8 Nights
£899 pp
Royal Caribbean Sale
ROYAL GREECE & CROATIA CRUISE W/ VENICE STAY
Departure : 23 January 2021 |
8 Nights
£799 pp
  • First
  • Previous
  • 1
  • Next
  • Last
WhatsApp Chat