where=['''datetime = (SELECT MIN(datetime) FROM emissions_diffusion
WHERE episode_id = emissions_episode.id)'''],
tables=['emissions_diffusion'])
- episodes_queryset = episodes_queryset.order_by(Lower('title')).distinct()
+ episodes_queryset = episodes_queryset.order_by('first_diffusion').distinct()
elif self.period == 1:
episodes_queryset = episodes_queryset.extra(
select={ 'first_diffusion': 'emissions_diffusion.datetime', },