From 20d6acc1dc6424421922e7c8856076f70d42e93d Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Fri, 7 Dec 2018 16:18:32 +0100 Subject: [server] Fix query --- .../src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'dozentenmodulserver/src/main/java') 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 3ee4f5d3..133ce846 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 @@ -64,7 +64,7 @@ public class DbImage { + " lat.expiretime, lat.filesize, lat.isrestricted, lat.isvalid," + " lat.uploaderid, lat.isprocessed, lat.createtime AS uploadtime," + " perm.canlink, perm.candownload, perm.canedit, perm.canadmin," - + " Sum(allv.filesize) AS filesizesum, Count(allv.*) AS versioncount" + + " Sum(allv.filesize) AS filesizesum, Count(allv.imageversionid) AS versioncount" + " FROM imagebase i" + " LEFT JOIN imageversion lat ON (lat.imageversionid = i.latestversionid)" + " LEFT JOIN imageversion allv ON (allv.imagebaseid = i.imagebaseid)" -- cgit v1.2.3-55-g7522