Does any one have a SQL query to fetch contact role saved on Customer form?

I search for a customer on Customer form, go to account, go to Communications tab, I see 4 contacts. When I click on Details, it opens Contact Information page. I go down to Contact Roles, I see a contact role called Marketing. Under it there's a button called "Add Another Role". I have been trying to build a query to fetch email_address for all contacts for out customers that have an active contact role of "Marketing". Can someone help me with that? I searched in hz_contact_points, hz_contact_find_v, etc. I can find email_address, but how do I know if it is