From a1515f6ee5123def426bf85a8f7f6b991e3a7d0c Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sun, 20 Apr 2008 23:57:30 +0000 Subject: [PATCH] FORCE should only apply when no group given --- includes/SpecialListusers.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/includes/SpecialListusers.php b/includes/SpecialListusers.php index 9b456bc204..924bb5d990 100644 --- a/includes/SpecialListusers.php +++ b/includes/SpecialListusers.php @@ -61,6 +61,9 @@ class UsersPager extends AlphabeticPager { $conds[]='ipb_deleted IS NULL OR ipb_deleted = 0'; if ($this->requestedGroup != "") { $conds['ug_group'] = $this->requestedGroup; + $useIndex = ''; + } else { + $useIndex = 'FORCE INDEX (user_name)'; } if ($this->requestedUser != "") { $conds[] = 'user_name >= ' . wfGetDB()->addQuotes( $this->requestedUser ); @@ -69,7 +72,7 @@ class UsersPager extends AlphabeticPager { list ($user,$user_groups,$ipblocks) = wfGetDB()->tableNamesN('user','user_groups','ipblocks'); $query = array( - 'tables' => " $user FORCE INDEX(user_name) LEFT JOIN $user_groups ON user_id=ug_user + 'tables' => " $user $useIndex LEFT JOIN $user_groups ON user_id=ug_user LEFT JOIN $ipblocks ON user_id=ipb_user AND ipb_auto=0 ", 'fields' => array('user_name', 'MAX(user_id) AS user_id', -- 2.20.1