From b2177cc7c9f820c07679490d73064a57682524fa Mon Sep 17 00:00:00 2001 From: Andrew Garrett Date: Wed, 24 Jan 2007 04:45:10 +0000 Subject: [PATCH] Make this query slightly less crack-headed. Rewrite with a Pager subclass coming soon... --- includes/SpecialProtectedpages.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/SpecialProtectedpages.php b/includes/SpecialProtectedpages.php index ceeadce8cd..78a26b1267 100644 --- a/includes/SpecialProtectedpages.php +++ b/includes/SpecialProtectedpages.php @@ -44,7 +44,7 @@ class ProtectedPagesPage extends PageQueryPage { list( $page, $page_restrictions ) = $dbr->tableNamesN( 'page', 'page_restrictions' ); return "SELECT DISTINCT page_id, 'Protectedpages' as type, page_namespace AS namespace, page_title as title, " . "page_title AS value, pr_level, pr_expiry " . - "FROM $page LEFT JOIN $page_restrictions ON page_id = pr_page WHERE pr_level IS NOT NULL AND pr_user IS NULL "; + "FROM $page, $page_restrictions WHERE page_id = pr_page AND pr_user IS NULL "; } /** -- 2.20.1