Cacher is the code snippet organizer for pro developers

select
j.JourneyName,
j.VersionNumber,
su.EmailAddress,
su.SubscriberKey as 'ContactKey',
a.id,
a.UMAX_AccountNr__c
from [_Sent] s
join [_JourneyActivity] ja 
on s.TriggererSendDefinitionObjectID = ja.JourneyActivityObjectID
join [_Journey] j
on ja.VersionID = j.VersionID
join [_Subscribers] su
on s.SubscriberID = su.SubscriberID
LEFT JOIN Contact_salesforce AS c ON su.subscriberkey = c.Id
Left JOIN Account_Salesforce AS a ON c.AccountId = a.Id
where ja.ActivityType in  ('EMAIL','EMAILV2')
and j.JourneyName = 'Consumenten - 3 maanden klant'
and s.EventDate > dateadd(mm,-24,getdate())