I have an E2.0 account with parent/child MIDs and I'm trying to pull in a population for a Journey.
When I combine
_EnterpriseAttribute and declare
ListID = 'All Subs List ID" the query works fine... when I change the
ListID value to a specific list value, I get 0 records.
Since the fields are shared across all Lists, I assumed this would work...?
The field we're running the query against is
Joined Mailing List Date
Here's the query:
SELECT a.[Joined mailing list date], b.SubscriberKey, b.EmailAddress as Email FROM ent._EnterpriseAttribute a JOIN ent._ListSubscribers b ON a._SubscriberID= b.SubscriberID WHERE b.ListID= '66391' AND b.SubscriberKey like 'PRE_%' AND b.SubscriberKey Not Like '%@%' AND (datediff(d,[Joined mailing list date],getdate()) = 1 OR datediff(d,[Joined mailing list date],getdate()) = 2) AND b.SubscriberKey NOT IN (SELECT SubscriberKey FROM Welcome_Suppression)