From b4491cb6f55169a95ce98ea67065ea6878618416 Mon Sep 17 00:00:00 2001 From: Radek Czajka Date: Mon, 31 Mar 2014 15:57:56 +0200 Subject: [PATCH] SQL fix. --- questions/views.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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'] -- 2.20.1