From b9bf243650bf347ed611908a0a61376fb578f8ac Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Sat, 2 Sep 2006 21:45:15 +0000 Subject: [PATCH] Fix to bug #7186: adds item to GROUP BY clause. --- includes/SpecialListusers.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/includes/SpecialListusers.php b/includes/SpecialListusers.php index db6434e05a..fa1d12eaef 100644 --- a/includes/SpecialListusers.php +++ b/includes/SpecialListusers.php @@ -127,13 +127,13 @@ class ListUsersPage extends QueryPage { // non-default groups as we go down the list. $userspace = NS_USER; - $sql = "SELECT 'Listusers' as type, $userspace AS namespace, user_name AS title, " . - "user_name as value, user_id, COUNT(ug_group) as numgroups " . + $sql = "SELECT 'Listusers' AS type, $userspace AS namespace, ". + "user_name AS title, user_name AS value, ". + "user_id, COUNT(ug_group) AS numgroups ". "FROM $user ". - "LEFT JOIN $user_groups ON user_id=ug_user " . + "LEFT JOIN $user_groups ON user_id=ug_user ". $this->userQueryWhere( $dbr ) . - " GROUP BY user_name"; - + "GROUP BY user_name, user_id"; return $sql; } -- 2.20.1