Dennis
3/7/2018 - 9:51 AM

Unsubscribe _ListSubscribers

WHERE ListID = 10198 AND (Status = 'held' OR Status = 'unsubscribed')

WHERE s.SubscriberKey NOT IN (
SELECT SubscriberKey FROM _ListSubscribers
    WHERE ListID = 10198 AND (Status = 'held' OR Status = 'unsubscribed')
)