SELECT C.*, A.*, email.`email_address` FROM `contacts` AS C LEFT JOIN `accounts_contacts` AS L
ON C.`id`=L.`contact_id` AND L.`deleted`=0
LEFT JOIN `accounts` AS A
ON L.`account_id`=A.id AND A.`deleted`=0
LEFT JOIN `email_addr_bean_rel` AS EL
ON C.id=EL.`bean_id` AND `bean_module`='Contacts' AND `primary_address`=1 AND EL.`deleted`=0
LEFT JOIN `email_addresses` AS email
ON EL.`email_address_id`=email.`id` AND email.`deleted`=0
where C.deleted=0
メールアドレスはメインアドレスのみのJOINです