X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=lib%2Fgroupsbypostssection.php;h=d0fadcb4506eccce19a9af4c65ce493c2fe664bf;hb=b53e1439969bfa2c0b551d8cc2fc8fe15652c62a;hp=c338ab7e9717f0a74df1ba2ba8111a3142d2221d;hpb=41dc9ca497dd065d72440cb2c706038f191a2c0c;p=quix0rs-gnu-social.git diff --git a/lib/groupsbypostssection.php b/lib/groupsbypostssection.php index c338ab7e97..d0fadcb450 100644 --- a/lib/groupsbypostssection.php +++ b/lib/groupsbypostssection.php @@ -47,7 +47,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,user_group.design_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;