SELECT
            COALESCE(MAX(CASE WHEN tp.pricetype = 'price' THEN tp.price END), v.price) AS price,
            COALESCE(MAX(CASE WHEN tp.pricetype = 'specialprice' THEN tp.price END), v.specialprice) AS specialprice,
            COALESCE(MAX(CASE WHEN tp.pricetype = 'rrp' THEN tp.price END), v.rrp) AS rrp, 
            COALESCE(MAX(CASE WHEN tp.pricetype = 'specialprice' THEN DATE(tp.activation) END), v.sostart) AS sostart, 
            COALESCE(MAX(CASE WHEN tp.pricetype = 'specialprice' THEN IFNULL(tp.soexpiry, v.soexpiry) END), v.soexpiry) AS soexpiry
            FROM variants AS v
            LEFT JOIN timed_pricing AS tp ON tp.code = v.code AND tp.pricetype IN ('price','specialprice','rrp','trade_price','trade_specialprice') AND '2026-09-22' BETWEEN DATE(tp.activation) AND IF(tp.soexpiry='0000-00-00','2026-09-22',tp.soexpiry)
            WHERE v.code = 'OC-Coffee-Table-Class'