EDIT

import java.util.Set;

import java.util.UUID;

import org.hibernate.Criteria;

import org.hibernate.Hibernate;

import org.hibernate.criterion.Projections;

        if (relTypeUuids != null && !relTypeUuids.isEmpty()){

            query.setParameterList("relTypeUuid", relTypeUuids);

        }

        List<List<Integer>> partitionList = splitIdList(query.list(), DEFAULT_SET_SUBTREE_PARTITION_SIZE);

        for (List<Integer> taxonIdList : partitionList){

            @SuppressWarnings({ "unchecked", "rawtypes" })

             if (pattern != null && !pattern.equals("?")){

                 query.setParameter("pattern", pattern);

             }

             List<SortableTaxonNodeQueryResult> resultClassifications = query.list();

             result.addAll(resultClassifications);

                + ") "

                + " FROM TaxonNode p "

                + "   INNER JOIN p.childNodes AS tn"

                + "   INNER JOIN t.name AS name "

                + "   INNER JOIN tn.classification AS cl "

                + "	  LEFT OUTER JOIN tn.statusNote as note "

                + "   LEFT OUTER JOIN name.rank AS rank ";

        return queryString;

    }

    public String getTaxonNodeDtoQueryWithoutParent() {

        String queryString = "SELECT new " + SortableTaxonNodeQueryResult.class.getName() + "("

        	+	"tn.uuid, tn.id, t.titleCache"// rank "

        //    + "tn.uuid, tn.id, t.uuid, t.titleCache, name.titleCache, rank, cl.uuid,  t.publish, tn.status, note "

            + ") "

            + " FROM TaxonNode tn "

//            + "   LEFT JOIN t.name AS name "

//            + "   INNER JOIN tn.classification AS cl ";

//            + "	  LEFT OUTER JOIN tn.statusNote as note ";

      //      + "   LEFT OUTER JOIN name.rank AS rank ";

        return queryString;

    }

    @Override

    public List<TaxonNodeDto> getTaxonNodeDtos(List<UUID> nodeUuids) {

        return list;

    }

    @Override

    public List<TaxonNodeDto> getTaxonNodeDtosWithoutParent(List<UUID> nodeUuids) {

        String queryString = getTaxonNodeDtoQueryWithoutParent();

        if (subTreeIndex != null) {

        	query.setParameter("subTreeIndex", subTreeIndex);

        }

        List<SortableTaxonNodeQueryResult> result = query.list();

        List<TaxonNodeDto> list = createNodeDtos(result);

        if (list.isEmpty()) {

        return getTaxonNodeUuidAndTitleCacheOfAcceptedTaxaByClassification(classification, limit, pattern, searchForClassifications, false);

    }

}