"where c.email LIKE :email";
//"and c.deleted <> :deleted";
Object idf = PersistenceSessionUtil.createSession();
EntityManager session = PersistenceSessionUtil.getSession();
EntityTransaction tx = session.getTransaction();
tx.begin();
Query query = session.createQuery(hql);
query.setParameter("email", email);
//query.setParameter("deleted", "true");
List<Adresses> addr = query.getResultList();