How get email lead by query?
I need get email email address of lead by query, but not email_address in lead table.
How get email lead by query?
I need get email email address of lead by query, but not email_address in lead table.
SELECT
ea.*
FROM
email_addresses ea
INNER JOIN email_addr_bean_rel eabr ON eabr.email_address_id = ea.id AND eabr.bean_module = 'Leads' AND eabr.deleted = 0
WHERE
ea.deleted = 0
AND eabr.bean_id = 'ID_OF_YOUR_LEAD'