From 336b0c014f4c47ae59c030a3e15709518dd89979 Mon Sep 17 00:00:00 2001 From: Rob Church Date: Sat, 8 Apr 2006 00:50:45 +0000 Subject: [PATCH] Fix silly little ballsed-up wrong-way-round join causing Village Pumpers to whine about missing redlinks in watchlists. --- includes/SpecialWatchlist.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/SpecialWatchlist.php b/includes/SpecialWatchlist.php index af633ab869..3d9fbd8d70 100644 --- a/includes/SpecialWatchlist.php +++ b/includes/SpecialWatchlist.php @@ -164,7 +164,7 @@ function wfSpecialWatchlist( $par ) { # Patch A2 # The following was proposed by KTurner 07.11.2004 to T.Gries # $sql = "SELECT distinct (wl_namespace & ~1),wl_title FROM $watchlist WHERE wl_user=$uid"; - $sql = "SELECT wl_namespace, wl_title, page_is_redirect FROM $page LEFT JOIN $watchlist ON wl_namespace = page_namespace AND wl_title = page_title WHERE wl_user=$uid"; + $sql = "SELECT wl_namespace, wl_title, page_is_redirect FROM $watchlist LEFT JOIN $page ON wl_namespace = page_namespace AND wl_title = page_title WHERE wl_user=$uid"; $res = $dbr->query( $sql, $fname ); -- 2.20.1