From 10bb5e658d9397da20389866847117f2cc405cfb Mon Sep 17 00:00:00 2001
From: Aaron Schulz <aaron@users.mediawiki.org>
Date: Wed, 9 Apr 2008 01:20:04 +0000
Subject: [PATCH] LEFT JOIN on page, this picks up deletion log and salting
 stuff

---
 includes/SpecialWatchlist.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/includes/SpecialWatchlist.php b/includes/SpecialWatchlist.php
index 83146b6354..a090685297 100644
--- a/includes/SpecialWatchlist.php
+++ b/includes/SpecialWatchlist.php
@@ -187,11 +187,11 @@ function wfSpecialWatchlist( $par ) {
 		$wltsfield=", ${watchlist}.wl_notificationtimestamp ";
 	}
 	$sql = "SELECT ${recentchanges}.* ${wltsfield}
-	  FROM $watchlist,$recentchanges,$page
+	  FROM $watchlist,$recentchanges
+	  LEFT JOIN $page ON rc_cur_id=page_id
 	  WHERE wl_user=$uid
 	  AND wl_namespace=rc_namespace
 	  AND wl_title=rc_title
-	  AND rc_cur_id=page_id
 	  $andcutoff
 	  $andLatest
 	  $andHideOwn
-- 
2.20.1