Miscellany

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 contactsLEFT JOIN  accounts_contacts jtl0 ON jt0.id=jtl0.contact_id  AND jtl0.deleted=0LEFT 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