From 6ea5008bf75f4461ab93488aa19b5e851b3a471c Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Fri, 20 May 2011 21:30:35 +0000 Subject: [PATCH] Similarise queries to that of SpecialWatchlist --- includes/api/ApiQueryWatchlist.php | 14 +++++++++----- 1 file changed, 9 insertions(+), 5 deletions(-) diff --git a/includes/api/ApiQueryWatchlist.php b/includes/api/ApiQueryWatchlist.php index 1aaa450fb8..120c7ca744 100644 --- a/includes/api/ApiQueryWatchlist.php +++ b/includes/api/ApiQueryWatchlist.php @@ -115,17 +115,21 @@ class ApiQueryWatchlist extends ApiQueryGeneratorBase { } $this->addTables( array( + 'recentchanges', 'watchlist', 'page', - 'recentchanges' ) ); $userId = $user->getId(); + $this->addJoinConds( array( 'watchlist' => array('INNER JOIN', + array( + 'wl_user' => $userId, + 'wl_namespace=rc_namespace', + 'wl_title=rc_title' + ) ) ) ); + $this->addJoinConds( array( 'page' => array( 'LEFT JOIN','rc_cur_id=page_id' ) ) ); + $this->addWhere( array( - 'wl_namespace = rc_namespace', - 'wl_title = rc_title', - 'rc_cur_id = page_id', - 'wl_user' => $userId, 'rc_deleted' => 0, ) ); -- 2.20.1