Untitled

select editor from Editor editor 
WHERE  (editor.adr1 LIKE :adr OR editor.adr2 LIKE :adr) or (editor.phone = :phone or editor.email = :email) OR editor IN 
(
select person.editor from Person person 
  where person.email = :email or person.phone = :phone
)