class PhoneUser {
   @ManyToOne
   @JoinColumn(name="phoneId")
   private Phone phone;

   @ManyToOne
   @JoinColumn(name="userId")
   private User user;

   @Column
   private String appVersion;

   @Column
   private String endPointArn;
}

class Phone {
    @ManyToOne
    @JoinColumn(name = "userApproved")
    private User userApproved;

    @Column
    private String cloudRegistrationError;

    @ManyToOne
    @JoinColumn(name = "userRegisteredId")
    private User userRegistered;

    @Column
    private String deviceModel;
}

class User {}

public List<PhoneUser> getDeviceListByUserIdList(List<Integer> userIdList) {
    Criteria criteria = getSession().createCriteria(PhoneUser.class).createAlias("user", "user").createCriteria("phone", "phone");
    criteria.add(Property.forName("user.id").in(userIdList));
    criteria.add(Restrictions.isNotNull("endPointArn"));
    criteria.setResultTransformer(new DistinctAliasToBeanResultTransformer(MobileDeviceUser.class));
    criteria.addOrder(Order.desc("when"));
    criteria.setProjection(projectionList);
    return criteria.list();
}