I have the following query to find all subscribers that have not opened in the past 180 days:

Target Data extension has:
SUBSCRIBER RELATIONSHIP
ContactKey relates to Subscribers on Subscriber Key

all fields are nullable in target DE other than the Contact Key which is the primary key(only need the contact key and email address to pull into the target data extension)

Query validates and runs, yet no data populates the target DE?

Query:

    SELECT distinct s.subscriberkey as ContactKey, e.EmailAddress as Email
    FROM _Sent s
    JOIN _subscribers e
    on s.subscriberkey=e.subscriberkey
    WHERE s.EventDate > dateadd(Day,-180,getdate())
    AND s.subscriberkey NOT IN (
    SELECT e.subscriberkey
    FROM _Open 
    WHERE EventDate > dateadd(Day,-180,getdate()))