From edf8cbff18b193514e032f6b306ad87b65e0ebd7 Mon Sep 17 00:00:00 2001 From: Rob Church Date: Sun, 30 Apr 2006 23:25:10 +0000 Subject: [PATCH] (bug 5723) Don't count pages linked to from the MediaWiki namespace as "wanted" --- RELEASE-NOTES | 2 +- includes/SpecialWantedpages.php | 11 +++++++---- 2 files changed, 8 insertions(+), 5 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index c984a6f772..30b0f6d463 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -173,7 +173,7 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN * Show a boilerplate "(none)" in place of a blank within the log action text for user rights * (bug 137) Commented out translations for copyrightwarning which mention GNU FDL - +* (bug 5723) Don't count pages linked to from the MediaWiki namespace as "wanted" == Compatibility == diff --git a/includes/SpecialWantedpages.php b/includes/SpecialWantedpages.php index f0c24a4b6a..dcae3eccc8 100644 --- a/includes/SpecialWantedpages.php +++ b/includes/SpecialWantedpages.php @@ -44,10 +44,13 @@ class WantedPagesPage extends QueryPage { pl_title AS title, COUNT(*) AS value FROM $pagelinks - LEFT JOIN $page - ON pl_namespace=page_namespace AND pl_title=page_title - WHERE page_namespace IS NULL - GROUP BY pl_namespace,pl_title + LEFT JOIN $page AS pg1 + ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title + LEFT JOIN $page AS pg2 + ON pl_from = pg2.page_id + WHERE pg1.page_namespace IS NULL + AND pg2.page_namespace != 8 + GROUP BY pl_namespace, pl_title HAVING COUNT(*) > $count"; } -- 2.20.1