WHERE unsubscribedby IS NULL

##</code><code>##

WHERE unsubscribedby IS NULL OR unsubscribedby=''