search a contact with by email address in sugarcrm

gistfile1.txt

SELECT contacts.first_name, contacts.last_name
FROM 
contacts 
WHERE contacts.id 
IN 
(
   SELECT email_addr_bean_rel.bean_id
   FROM   email_addr_bean_rel
   JOIN   email_addresses
   ON     email_addr_bean_rel.email_address_id = email_addresses.id
   WHERE
   email_addresses.email_address = 'ychaouche@feeder.fr'
)