SELECT c.email, c.company_name, c.status, c.unsubscribed, c.id FROM contacts c WHERE LOWER(c.email)='troy@conexon.us';
SELECT m.list_name, m.company_name AS list_company FROM contact_list_memberships m JOIN contacts c ON c.id=m.contact_id WHERE LOWER(c.email)='troy@conexon.us';
SELECT suppression_type FROM sendgrid_suppressions WHERE email='troy@conexon.us';