| Index: trunk/phase3/includes/api/ApiQueryAllLinks.php |
| — | — | @@ -102,9 +102,7 @@ |
| 103 | 103 | $this->addWhere( 'pl_title' . $db->buildLike( $this->titlePartToKey( $params['prefix'] ), $db->anyString() ) ); |
| 104 | 104 | } |
| 105 | 105 | |
| 106 | | - $this->addFields( array( |
| 107 | | - 'pl_title', |
| 108 | | - ) ); |
| | 106 | + $this->addFields( 'pl_title' ); |
| 109 | 107 | $this->addFieldsIf( 'pl_from', !$params['unique'] ); |
| 110 | 108 | |
| 111 | 109 | $this->addOption( 'USE INDEX', 'pl_namespace' ); |
| — | — | @@ -112,7 +110,7 @@ |
| 113 | 111 | $this->addOption( 'LIMIT', $limit + 1 ); |
| 114 | 112 | |
| 115 | 113 | if ( !$params['unique'] ) { |
| 116 | | - $this->addOption( 'ORDER BY', 'pl_from' ); |
| | 114 | + $this->addOption( 'ORDER BY', 'pl_title, pl_from' ); |
| 117 | 115 | } |
| 118 | 116 | |
| 119 | 117 | $res = $this->select( __METHOD__ ); |
| Index: trunk/phase3/includes/api/ApiQueryDeletedrevs.php |
| — | — | @@ -172,7 +172,7 @@ |
| 173 | 173 | if ( $params['unique'] ) { |
| 174 | 174 | $this->addOption( 'GROUP BY', 'ar_title' ); |
| 175 | 175 | } else { |
| 176 | | - $this->addOption( 'ORDER BY', 'ar_timestamp' ); |
| | 176 | + $this->addOption( 'ORDER BY', 'ar_title, ar_timestamp' ); |
| 177 | 177 | } |
| 178 | 178 | } else { |
| 179 | 179 | if ( $mode == 'revs' ) { |