diff options
author | Brenda Wallace <shiny@cpan.org> | 2009-06-27 10:24:59 +1200 |
---|---|---|
committer | Brenda Wallace <shiny@cpan.org> | 2009-07-15 20:17:17 +1200 |
commit | 15042ed50b72804eaeefd0c60aa63674bdefe8b4 (patch) | |
tree | 0b70b9c849431388022e2a74017e814c85c16d87 /lib/groupsbypostssection.php | |
parent | 1a151ff6f686da198aac72a0adb5001f5d6dcd43 (diff) |
added user_group.design_id into the group by clause
Diffstat (limited to 'lib/groupsbypostssection.php')
-rw-r--r-- | lib/groupsbypostssection.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/groupsbypostssection.php b/lib/groupsbypostssection.php index 325b4033f..dc7925d5e 100644 --- a/lib/groupsbypostssection.php +++ b/lib/groupsbypostssection.php @@ -48,7 +48,7 @@ class GroupsByPostsSection extends GroupSection $qry = 'SELECT user_group.*, count(*) as value ' . 'FROM user_group JOIN group_inbox '. 'ON user_group.id = group_inbox.group_id ' . - 'GROUP BY user_group.id,user_group.nickname,user_group.fullname,user_group.homepage,user_group.description,user_group.location,user_group.original_logo,user_group.homepage_logo,user_group.stream_logo,user_group.mini_logo,user_group.created,user_group.modified ' . + 'GROUP BY user_group.id,user_group.nickname,user_group.fullname,user_group.homepage,user_group.description,user_group.location,user_group.original_logo,user_group.homepage_logo,user_group.stream_logo,user_group.mini_logo,user_group.created,user_group.modified,user_group.design_id ' . 'ORDER BY value DESC '; $limit = GROUPS_PER_SECTION; |