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