SELECT j.TriggeredSendCustomerKey, j.DeliveredTime as SendTime, o.EventDate as OpenTime, s.EmailAddress, s.SubscriberKey from [_Job] j INNER JOIN [_Open] o ON j.JobID = o.JobID INNER JOIN ENT._Subscribers s ON o.SubscriberID = s.SubscriberID WHERE o.isunique = 1 AND o.EventDate > dateadd(d,-30,getdate()) AND j.TriggeredSendCustomerKey in ('163400','163399')