public function testemail_addresses_query()
{
$table = 'accounts';
$module = 'Accounts';
$bean_id = 1;
$expected = $table . ".id IN (SELECT ear.bean_id FROM email_addresses ea\n LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id\n WHERE ear.bean_module = '{$module}'\n AND ear.bean_id != '{$bean_id}'\n AND ear.deleted = 0";
$mergeRecord = new MergeRecord();
$result = $mergeRecord->email_addresses_query($table, $module, $bean_id);
$this->assertSame($expected, $result);
}
