Updated offer query