X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Fgroupsbypostssection.php;h=325b4033f408dda4ef9b8fe6434090dfe85dd6c9;hb=a13bfa5848705d23353783f195b67c088a72a8cb;hp=1a60ddb4fc8ebc0ad6fb169c95537fa952ce2eb0;hpb=115519a5e7e84e57656c653918efb39ab4107fe9;p=quix0rs-gnu-social.git diff --git a/lib/groupsbypostssection.php b/lib/groupsbypostssection.php index 1a60ddb4fc..325b4033f4 100644 --- a/lib/groupsbypostssection.php +++ b/lib/groupsbypostssection.php @@ -45,10 +45,10 @@ class GroupsByPostsSection extends GroupSection { function getGroups() { - $qry = 'SELECT user_group.id, count(*) as value ' . + $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 ' . + '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 ' . 'ORDER BY value DESC '; $limit = GROUPS_PER_SECTION;