public function testget_unlinked_email_query()
{
$lead = new Lead();
$expected = "SELECT emails.id FROM emails JOIN (select DISTINCT email_id from emails_email_addr_rel eear\n\n\tjoin email_addr_bean_rel eabr on eabr.bean_id ='' and eabr.bean_module = 'Leads' and\n\teabr.email_address_id = eear.email_address_id and eabr.deleted=0\n\twhere eear.deleted=0 and eear.email_id not in\n\t(select eb.email_id from emails_beans eb where eb.bean_module ='Leads' and eb.bean_id = '')\n\t) derivedemails on derivedemails.email_id = emails.id";
$actual = $lead->get_unlinked_email_query();
$this->assertSame($expected, $actual);
}
