More query reorganisation, in an attempt to be index friendly

diff --git a/includes/api/ApiQueryCategoryMembers.php b/includes/api/ApiQueryCategoryMembers.php
index 5ac888e..6f005dc 100644 (file)
--- a/includes/api/ApiQueryCategoryMembers.php
+++ b/includes/api/ApiQueryCategoryMembers.php
@@ -93,9 +93,7 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase {
 
                $this->addTables( array( 'page', 'categorylinks' ) );   // must be in this order for 'USE INDEX'
 
-               $this->setContinuation( $params['continue'], $params['dir'] );
                $this->addWhereFld( 'cl_to', $categoryTitle->getDBkey() );
-
                $this->addWhereFld( 'cl_type', $params['type'] );
 
                // Scanning large datasets for rare categories sucks, and I already told
@@ -129,6 +127,8 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase {
 
                $this->addWhere( 'cl_from=page_id' );
 
+               $this->setContinuation( $params['continue'], $params['dir'] );
+
                $limit = $params['limit'];
                $this->addOption( 'LIMIT', $limit + 1 );