Cacher is the code snippet organizer for pro developers

SELECT nb.SubscriberKey, nb.Email AS EmailAddress FROM NBVerzending AS nb
LEFT JOIN _Sent AS s ON s.SubscriberKey = nb.SubscriberKey
LEFT JOIN _Job AS j ON j.JobID = s.JobID
LEFT JOIN _Open AS o
ON j.JobID = o.JobID AND s.ListID = o.ListID AND s.BatchID = o.BatchID AND s.SubscriberID = o.SubscriberID AND o.IsUnique = 1
LEFT JOIN _Click AS c
ON j.JobID = c.JobID AND s.ListID = c.ListID AND s.BatchID = c.BatchID AND s.SubscriberID = c.SubscriberID AND c.IsUnique = 1
WHERE
j.Category = 'Nieuwsbrief'
AND (o.SubscriberID is NULL and c.SubscriberID is NULL)