[dak/master] make-changelog: only consider latest sources in suites

[Luca Falavigna <dktrkranz@debian.org>]

Signed-off-by: Luca Falavigna <dktrkranz@debian.org>
---
 dak/make_changelog.py |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/dak/make_changelog.py b/dak/make_changelog.py
index 6fffb45..44aae52 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
-- 
1.5.6.5