From: Radek Czajka <radekczajka@nowoczesnapolska.org.pl>
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?ds=sidebyside;hp=a20146248fcfa1c17416ccf3c97277f656242158

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']