Revision 7c47b73f
Added by Andreas Müller almost 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/occurrence/OccurrenceDaoHibernateImpl.java | ||
|---|---|---|
| 170 | 170 |
String q2Str = " SELECT DISTINCT m.id " |
| 171 | 171 |
+ " FROM MediaSpecimen spec " |
| 172 | 172 |
+ " JOIN spec.mediaSpecimen m " |
| 173 |
+ " WHERE spec = :occurence " |
|
| 174 |
+ " ORDER BY m.id "; |
|
| 173 |
+ " WHERE spec = :occurence "; |
|
| 175 | 174 |
Query q2 = getSession().createQuery(q2Str); |
| 176 | 175 |
q2.setParameter("occurence", occurence);
|
| 177 | 176 |
List<Integer> list2 = q2.list(); |
Also available in: Unified diff
ref #9642 remove unnecessary order by