SELECT DISTINCT
a.email_id AS "email",
c.name AS "name"
FROM `tabCustomer` c
LEFT JOIN `tabDynamic Link` dl
ON dl.link_doctype = 'Customer'
AND dl.link_name = c.name
LEFT JOIN `tabAddress` a
ON a.name = dl.parent
AND dl.parenttype = 'Address'
WHERE
a.email_id IS NOT NULL
AND a.email_id != ''
ORDER BY
a.email_id;
