distros: Actually filter the latest release

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/buildservice/distribution.py b/src/buildservice/distribution.py
index e269e543f42db8dcf4dc3456977c6d7c531085e9..6204fe102c4da87c599cd4988adff1eea5c9eb7e 100644 (file)
--- a/src/buildservice/distribution.py
+++ b/src/buildservice/distribution.py
@@ -434,6 +434,10 @@ class Distribution(base.DataObject):
                                published_at IS NOT NULL
                        AND
                                published_at <= CURRENT_TIMESTAMP
+                       ORDER BY
+                               published_at DESC
+                       LIMIT
+                               1
                        """, self.id,
                )