SELECT 
contacts.id ref_id,
jt0.assigned_user_id account_name_owner,
'Accounts' account_name_mod,
jt0.name account_name,
jtl0.account_id account_id,
opportunities_contacts.opportunity_id opportunity_id,
opportunities_contacts.id opportunity_role_id,
opportunities_contacts.contact_role opportunity_role 
FROM contacts
LEFT JOIN  accounts_contacts jtl0 ON jt0.id=jtl0.contact_id  AND jtl0.deleted=0
LEFT JOIN  accounts jt0 ON jt0.id=jtl0.account_id AND jt0.deleted=0 AND jt0.deleted=0 
INNER JOIN opportunities_contacts ON (contacts.id=opportunities_contacts.contact_id AND opportunities_contacts.opportunity_id='b3db9b8f-f9d6-e6a3-d0f4-44d23c531818')
where (  opportunities_contacts.deleted=0 AND contacts.deleted=0) AND contacts.deleted=0