Código:
por no entiendo SELECT t1.email_id,t2.email_addr from em_list_have_mail as t1,em_user_emails as t2 where t1.email_id not in (SELECT t1.email_id,t2.email_addr from em_list_have_mail as t1,em_user_emails as t2 where t1.email_list_id=11 and t1.email_id=t2.email_id and t2.created_by=1)

