cleanup

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/statistics/StatisticsDaoHibernateImpl.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/statistics/StatisticsDaoHibernateImpl.java
index 140b285da1728708b952b392064bb7e9cb2fbc9b..02141975dbb4118167de05f343fd4726c87a3d02 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/statistics/StatisticsDaoHibernateImpl.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/statistics/StatisticsDaoHibernateImpl.java
@@ -1039,8 +1039,9 @@ public class StatisticsDaoHibernateImpl
                // "where tn.uuid in (:parents) ";
 
                // just for testing, but does not work anyway
-               String queryString = "select distinct chn.uuid from TaxonNode tn "
-                               + "join tn.childNodes as chn " + "where tn.uuid = :parent ";
+               String queryString = "SELECT DISTINCT chn.uuid FROM TaxonNode tn "
+                               + " JOIN tn.childNodes as chn "
+                       + " WHERE tn.uuid = :parent ";
 
                Query<UUID> query = getSession().createQuery(queryString, UUID.class);