See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
SELECT `contacts`.`idContacts` , `contacts`.`First_Name`, `contacts`.`Last_Name` , `Contacts_idContacts` , `contacts`.`Email1` , `Groups_idGroup`, `Group` FROM `libertytools`.`contacts` JOIN `libertytools`.`groups_has_contacts` ON Contacts_idContacts=idContacts JOIN `libertytools`.`groups` ON Groups_idGroup=idGroup WHERE (Groups_idGroup = 20 OR Groups_idGroup = 21) AND NOT EXISTS ( SELECT 1 FROM `libertytools`.`groups_has_contacts` gc2 WHERE (gc2.Groups_idGroup = 350 OR gc2.Groups_idGroup = 250) AND gc2.Contacts_idContacts=idContacts ) AND (`contacts`.`Email1` IS NOT NULL AND `contacts`.`Email1` <> '') order by `contacts`.`Last_Name` ASC;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!