SELECT c.description,c.client_id,coalesce (pce.email,'') AS Partner_Email,coalesce (mce.email,'') AS Manager_Email,coalesce (ace.email,'') AS Associate_Email,coalesce (cce.email,'') AS Client_Email FROM Client_View AS c LEFT JOIN Staff AS pstf ON pstf.staff_KEY = c.partner__staff_KEY LEFT JOIN Contact AS pc ON pc.contact_KEY = pstf.contact_KEY LEFT JOIN Contact_Email AS pce ON pc.contact_KEY = pce.contact_KEY AND pce.contact_email_type_KEY = pc.primary__contact_email_type_KEY LEFT JOIN Staff AS mstf ON mstf.staff_KEY = c.manager__staff_KEY LEFT JOIN Contact AS mc ON mc.contact_KEY = mstf.contact_KEY LEFT JOIN Contact_Email AS mce ON mc.contact_KEY = mce.contact_KEY AND mce.contact_email_type_KEY = mc.primary__contact_email_type_KEY LEFT JOIN Staff AS astf ON c.associate__staff_KEY = astf.staff_KEY LEFT JOIN Contact AS ac ON ac.contact_KEY = astf.contact_KEY LEFT JOIN Contact_Email AS ace ON ace.contact_KEY = ac.contact_KEY AND ace.contact_email_type_KEY = ac.primary__contact_email_type_KEY LEFT JOIN Client AS cem ON cem.contact_KEY = c.contact_KEY LEFT JOIN Contact AS cc ON cc.contact_KEY = cem.contact_KEY LEFT JOIN Contact_Email AS cce ON cce.contact_KEY = cc.contact_KEY AND cce.contact_email_type_KEY = cc.primary__contact_email_type_KEY WHERE c.client_status_KEY = 1