From 8848055583be85ef23aa0ea24f7e71936956cafc Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Tue, 5 Sep 2006 07:00:04 +0000 Subject: [PATCH] revert complete breakage on MySQL --- includes/SpecialListusers.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/includes/SpecialListusers.php b/includes/SpecialListusers.php index fa1d12eaef..db6434e05a 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, user_id"; + " GROUP BY user_name"; + return $sql; } -- 2.20.1