home: get sounds ordered by creation time, not diffusion time (#1125)

diff --git a/panikweb/views.py b/panikweb/views.py
index 169aa8ada40ce27a1aaefcbfa1c955f3e7bfe92c..d7deb6001e84b0ca901806877aadcfc16be57c47 100644 (file)
--- a/panikweb/views.py
+++ b/panikweb/views.py
@@ -431,7 +431,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').distinct() [:3]
+                    tables=['emissions_diffusion'],).order_by('-creation_timestamp').distinct() [:3]
 
         context['newsletter_form'] = SubscribeForm()