fix selection of past/future episodes

[django-panik-combo.git] / panikombo / models.py

diff --git a/panikombo/models.py b/panikombo/models.py
index 38da84bea11e46c1ed284885b55b0470e08340bc..3a74383321624dcaa4176102d616ad034de24ba5 100644 (file)
--- a/panikombo/models.py
+++ b/panikombo/models.py
@@ -114,16 +114,16 @@ class EpisodeAutoSelectionCell(CellBase):
                     select={ 'first_diffusion': 'emissions_diffusion.datetime', },
                     select_params=(False, True),
                     where=['''datetime = (SELECT MIN(datetime) FROM emissions_diffusion
-                                           WHERE episode_id = emissions_episode.id AND
-                                                 emissions_diffusion.datetime >= CURRENT_TIMESTAMP)'''],
+                                           WHERE episode_id = emissions_episode.id) AND
+                                                 datetime >= CURRENT_TIMESTAMP'''],
                     tables=['emissions_diffusion'])
         elif self.period == 2:
             episodes_queryset = episodes_queryset.extra(
                     select={ 'first_diffusion': 'emissions_diffusion.datetime', },
                     select_params=(False, True),
                     where=['''datetime = (SELECT MIN(datetime) FROM emissions_diffusion
-                                           WHERE episode_id = emissions_episode.id AND
-                                                 emissions_diffusion.datetime < CURRENT_TIMESTAMP)'''],
+                                           WHERE episode_id = emissions_episode.id) AND
+                                                 datetime < CURRENT_TIMESTAMP'''],
                     tables=['emissions_diffusion'])
 
         return episodes_queryset