add distinct() to querysets creating first_diffusion, to avoid duplicates

diff --git a/panikweb/views.py b/panikweb/views.py
index 380b22c08b6b19ef20d90be8ab1c33ec11f50c82..0f87a9d1beeaee2d6c62b6ca66cca2fb1647222a 100644 (file)
--- a/panikweb/views.py
+++ b/panikweb/views.py
@@ -53,7 +53,7 @@ class EmissionMixin:
                                                 FROM emissions_diffusion
                                                WHERE episode_id = emissions_episode.id)'''],
                         tables=['emissions_diffusion'],
-                    ).order_by('-first_diffusion')
+                    ).order_by('-first_diffusion').distinct()
 
         # get all related soundfiles in a single query
         soundfiles = {}
@@ -422,7 +422,7 @@ class Home(TemplateView):
                     where=['''datetime = (SELECT MIN(datetime)
                                             FROM emissions_diffusion
                                         WHERE episode_id = emissions_episode.id)'''],
-                    tables=['emissions_diffusion'],).order_by('-first_diffusion') [:6]
+                    tables=['emissions_diffusion'],).order_by('-first_diffusion').distinct() [:6]
 
         context['newsletter_form'] = SubscribeForm()
 
@@ -509,7 +509,7 @@ class Listen(TemplateView):
                     where=['''datetime = (SELECT MIN(datetime)
                                             FROM emissions_diffusion
                                         WHERE episode_id = emissions_episode.id)'''],
-                    tables=['emissions_diffusion'],).order_by('-first_diffusion') [:10]
+                    tables=['emissions_diffusion'],).order_by('-first_diffusion').distinct() [:10]
 
         context['categories'] = Category.objects.all()