Obtener los Correos de los Contactos que están Pendientes en la cola de mensajes. Tener en cuenta que los Joins con los módulos correspondientes los tomarán en cuenta, por ejemplo (emailman.related_type='Contacts') SELECT ea.email_address FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Contacts' AND ear.bean_id in ( select contacts.id FROM emailman LEFT JOIN users ON users.id = emailman.related_id and emailman.related_type ='Users' LEFT JOIN contacts ON contacts.id = emailman.related_id and emailman.related_type ='Contacts' LEFT JOIN leads ON leads.id = emailman.related_id and emailman.related_type ='Leads' LEFT JOIN accounts ON accounts.id = emailman.related_id and emailman.related_type ='Accounts' LEFT JOIN prospects ON prospects.id = emailman.related_id and emailman.related_type ='Prospects' LEFT JOIN prospect_lists ON prospect_lists.id = emailman.list_id LEFT JOIN email_addr_bean_rel ON email_addr_bean_rel.bean_id = emailman.related_id and emailman.related_type = email_addr_bean_rel.bean_module and email_addr_bean_rel.deleted=0 LEFT JOIN campaigns ON campaigns.id = emailman.campaign_id LEFT JOIN email_marketing ON email_marketing.id = emailman.marketing_id WHERE emailman.deleted=0 ) AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC