X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Fgroupsbymemberssection.php;h=9b1bac21545b275e6e84b6683769dcea4d6de14d;hb=e8d1bb25469fe1ef0cbcb32c3022010997aca4b0;hp=4cb8ed46f07bf040655222f55f8d7a76dbb99c8e;hpb=41a883aeab970b1fe27c67524e04590456ddc92b;p=quix0rs-gnu-social.git diff --git a/lib/groupsbymemberssection.php b/lib/groupsbymemberssection.php index 4cb8ed46f0..9b1bac2154 100644 --- a/lib/groupsbymemberssection.php +++ b/lib/groupsbymemberssection.php @@ -47,7 +47,7 @@ class GroupsByMembersSection extends GroupSection $qry = 'SELECT user_group.*, count(*) as value ' . 'FROM user_group JOIN group_member '. 'ON user_group.id = group_member.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;