From: Radek Czajka Date: Mon, 31 Mar 2014 13:57:56 +0000 (+0200) Subject: SQL fix. X-Git-Url: https://git.mdrn.pl/prawokultury.git/commitdiff_plain/b4491cb6f55169a95ce98ea67065ea6878618416 SQL fix. --- diff --git a/questions/views.py b/questions/views.py index 328ad3e..25ec438 100644 --- a/questions/views.py +++ b/questions/views.py @@ -66,7 +66,7 @@ class QuestionListView(ListView): LEFT JOIN questions_tagitem i ON i.tag_id=t.id LEFT JOIN questions_question q ON q.id=i.object_id WHERE q.published - GROUP BY t.category_id, t.click_count, t.id, t.name, t.slug + GROUP BY t.category_id, t.click_count, t.id, t.name, t.slug, c.slug ORDER BY c.slug, c DESC, t.slug """) uncategorized_tags_click_count = Tag.objects.filter(category=None).aggregate(models.Sum('click_count'))['click_count__sum']