From f4a70ada582ee50922764f9d76e0c0f931967c98 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Tue, 19 Dec 2006 19:44:55 +0000 Subject: [PATCH] Reverting...this broke the site. Massive temporary tables and filesort eating up all slave servers. Greg, please test these things on MySQL, using an 'EXPLAIN' on the query. You have been warned before. We may have to start requiring PG compatibility commits to be reviewed before commit. --- includes/SpecialCategories.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/SpecialCategories.php b/includes/SpecialCategories.php index 46601efc7e..89cff20a05 100644 --- a/includes/SpecialCategories.php +++ b/includes/SpecialCategories.php @@ -33,7 +33,7 @@ class CategoriesPage extends QueryPage { $s= "SELECT 'Categories' as type, {$NScat} as namespace, cl_to as title, - cl_to as value, + 1 as value, COUNT(*) as count FROM $categorylinks GROUP BY 1,2,3,4"; -- 2.20.1