From 4106d5106330f6797535d357b305cc3dd19705f9 Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Fri, 14 Jan 2011 23:45:20 +0000 Subject: [PATCH] Bye bye filesorts. Making order by cl_type, and then addWhereRange adds cl_sortkey, cl_from to this ORDER BY --- includes/api/ApiQueryCategoryMembers.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/includes/api/ApiQueryCategoryMembers.php b/includes/api/ApiQueryCategoryMembers.php index 9310011f98..840258efcc 100644 --- a/includes/api/ApiQueryCategoryMembers.php +++ b/includes/api/ApiQueryCategoryMembers.php @@ -116,6 +116,8 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { $this->addOption( 'USE INDEX', 'cl_timestamp' ); } else { + $this->addOption( 'ORDER BY', 'cl_type' ); + $this->addWhereRange( 'cl_sortkey', $dir, $params['startsortkey'], -- 2.20.1