(CASE 
            WHEN products.offer_price IS NOT NULL 
            AND products.offer_price > 0 
            AND products.offer_date IS NOT NULL 
            AND products.offer_date >= CURDATE() 
            THEN products.offer_price 
            ELSE products.new_price 
        END)