Cacher is the code snippet organizer for pro developers

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