X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fmake_changelog.py;h=44aae5226d02d7e0f1663461ffc7fcf9a9fd856d;hb=973ed88e272000b2864fa33c554105e24de3a2bf;hp=6fffb456f8bb66ef223f2a4c8f725c1c1ba07e79;hpb=ad4d199f56e90f0614a29c80d4d4498313fcf75f;p=dak.git

diff --git a/dak/make_changelog.py b/dak/make_changelog.py
index 6fffb456..44aae522 100755
--- a/dak/make_changelog.py
+++ b/dak/make_changelog.py
@@ -166,8 +166,9 @@ def export_files(session, pool, clpool, temppath):
     """
 
     sources = {}
-    query = """SELECT s.source, su.suite_name AS suite, s.version, f.filename
+    query = """SELECT DISTINCT s.source, su.suite_name AS suite, s.version, f.filename
                FROM source s
+               JOIN newest_source n ON n.source = s.source AND n.version = s.version
                JOIN src_associations sa ON sa.source = s.id
                JOIN suite su ON su.id = sa.suite
                JOIN files f ON f.id = s.file