I got some help and found a solution
ActivityContactID AS ActivityContactIDContactID,
ContactID AS ActivityContactIDContactID,
At the end I put in
Where ActivityTitle = 'Opened marketing email 'Title of Email''
This gave me the email I wanted to show the opens from along with all the other contact info associated with the contact in Kentico.