aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/memberlist.php1
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php
index 825819d3e4..791c40a63f 100644
--- a/phpBB/memberlist.php
+++ b/phpBB/memberlist.php
@@ -106,6 +106,7 @@ switch ($mode)
LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.group_id = g.group_id AND ug.user_id = ' . $user->data['user_id'] . ')
WHERE u.user_id IN (' . implode(', ', $admin_id_ary + $mod_id_ary) . ')
AND u.group_id = g.group_id
+ GROUP BY u.user_id
ORDER BY g.group_name ASC, u.username ASC';
$result = $db->sql_query($sql);