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-10-22 23:07:06' AND bl.basepoke_status = 1 AND bc.base_cruise_status = 1 GROUP BY bc.basepoke_id ORDER BY departure_date ASC LIMIT 0,9
No Offers Found ..