From 42c6170fd1f23c80462a64a704d395a85ce405c6 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 7 Dec 2018 16:27:27 +0100
Subject: [server] Fix query

---
 .../src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java     | 1 +
 1 file changed, 1 insertion(+)

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java
index 133ce846..ca4c3e3c 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java
@@ -69,6 +69,7 @@ public class DbImage {
 					+ " LEFT JOIN imageversion lat ON (lat.imageversionid = i.latestversionid)"
 					+ " LEFT JOIN imageversion allv ON (allv.imagebaseid = i.imagebaseid)"
 					+ " LEFT JOIN imagepermission perm ON (i.imagebaseid = perm.imagebaseid AND perm.userid = :userid)"
+					+ " GROUP BY imagebaseid"
 					+ Paginator.limitStatement(page));
 			stmt.setString("userid", user.userId);
 			ResultSet rs = stmt.executeQuery();
-- 
cgit v1.2.3-55-g7522