From 11f4a449fafaf79bbdb3790da978e4d084faa0ce Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Mon, 14 Mar 2011 11:05:35 +0000 Subject: [PATCH] Partial revert r83845, use indexed fields for join --- includes/specials/SpecialActiveusers.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/specials/SpecialActiveusers.php b/includes/specials/SpecialActiveusers.php index 7d6d2c0cfb..caba7f3a43 100644 --- a/includes/specials/SpecialActiveusers.php +++ b/includes/specials/SpecialActiveusers.php @@ -106,7 +106,7 @@ class ActiveUsersPager extends UsersPager { 'USE INDEX' => array( 'recentchanges' => 'rc_user_text' ) ), 'join_conds' => array( - 'user' => array( 'INNER JOIN', 'rc_user=user_id' ), + 'user' => array( 'INNER JOIN', 'rc_user_text=user_name' ), 'ipblocks' => array( 'LEFT JOIN', 'user_id=ipb_user AND ipb_auto=0 AND ipb_deleted=1' ), ), 'conds' => $conds -- 2.20.1