SELECT bc.special_message, bc.special_message, bc.package_start_date, bc.strike_price,bc.basepoke_id,bl.reff_code,bc.offer_listing,bc.offer_logo,bl.ship_id,bc.cruise_id,bc.offer_title,bc.cruise_nights,bc.offer_price,bc.departure_date,bc.cruise_nights FROM gac_basepoke_list as bl INNER JOIN gac_basepoke_cruises as bc ON bl.id = bc.basepoke_id WHERE bc.offer_start_date < curdate() and bc.offer_end_date > curdate() AND bc.offers_for_homepage = ‘1’ AND bl.basepoke_status = ‘1’ AND bc.base_cruise_status = 1 AND bc.departure_date > curdate() ORDER BY bc.offer_price LIMIT 0,9