findByCriteria = hibernateTemplate.findByCriteria(
                    DetachedCriteria.forClass(Event.class).
                    setFetchMode("images", FetchMode.JOIN).
                    add(Restrictions.eq("visible", true)).addOrder(Order.desc("id")), 0,5);

 
List<Event> execute = (List<Event>) hibernateTemplate.execute(new HibernateCallback() {
            @Override
            public List<Event> doInHibernate(Session session) {
               
                
                List<Event> list = session.createQuery("from Event e left join fetch e.images where e.visible = true order by e.id                desc").setFirstResult(0).setMaxResults(3).list();
                
               
                
                return list;
            }
        });



        return execute;

 List<Event> execute = (List<Event>) hibernateTemplate.execute(new HibernateCallback() {

            @Override
            public List<Event> doInHibernate(Session session) {

               
                 List<Event> result = null;
                
                Criteria criteria = session.createCriteria(Event.class);                
                criteria.addOrder(Order.desc("id")).setFirstResult(0).setMaxResults(3);
                
                
                
                result = criteria.list();

                for (Event event : result) {
                    hibernateTemplate.initialize(event.images);                                       
                }


                return result;

            }
        });

      
List<Event> execute = (List<Event>) hibernateTemplate.execute(new HibernateCallback() {

            @Override
            public List<Event> doInHibernate(Session session) {


                List<Event> result = null;

                Criteria criteria = session.createCriteria(Event.class);
                criteria.setFirstResult(0).setMaxResults(3);
                criteria.addOrder(Order.desc("id"));
                
                             
                  
                    criteria.setProjection(Projections.distinct(
                            Projections.projectionList().add(Projections.id())));
                    
                  
                    
                    List list = criteria.list();
                   
                    List<Long> idlist = new ArrayList<Long>();

                    for (Iterator iditer = list.iterator(); iditer.hasNext();) {
                        Long record = (Long) iditer.next();
                        idlist.add(record);
                    }

                    //Массив с id'шниками
                    Long[] listLong = idlist.toArray(new Long[0]);

                    List<Event> listResult = null;
                  
                   
                    if (idlist.size() > 0) {
                    Query setParameter = session.createQuery("from Event event inner join fetch event.images where event.visible = true AND event.id IN (:mas)").setParameterList("mas", listLong).setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
                    listResult = setParameter.list();
                    } else {
                        return new ArrayList();
                    }
               
                



                return listResult;



            }
        });



        return execute;

Hibernate: select distinct this_.id as y0_ from event this_ order by this_.id desc limit ?

Hibernate: select event* , image* from event inner join image on event.id=images.parent_id where event.event_visible=1 and (event.id in (? , ? , ?))

SELECT id
     , image.parent_id    
     , image.image_id
FROM
  shootride.event
LEFT JOIN image
ON image.parent_id = event.id
WHERE
  event.id IN (1, 2, 3);


SELECT id
     , image.parent_id    
     , image.image_id
FROM
  shootride.event
LEFT JOIN image
ON image.parent_id = event.id
WHERE
  event.id IN (SELECT event.id from event order by event.id limit 0,3);