update USR_CPHIVE_SUBSCRIPTION set SUBSCRIBED = 'Y' where scope like 'product%' and scope not like '%deleted'