| Index: trunk/extensions/FlaggedRevs/specialpages/PendingChanges_body.php |
| — | — | @@ -343,7 +343,6 @@ |
| 344 | 344 | $conds[] = 'page_id = fp_page_id'; |
| 345 | 345 | $conds[] = 'rev_id = fp_stable'; // PK |
| 346 | 346 | $conds[] = 'fp_pending_since IS NOT NULL'; |
| 347 | | - $useIndex = array( 'flaggedpages' => 'fp_pending_since', 'page' => 'PRIMARY' ); |
| 348 | 347 | # Filter by pages configured to be stable |
| 349 | 348 | if ( $this->stable ) { |
| 350 | 349 | $tables[] = 'flaggedpage_config'; |
| — | — | @@ -355,7 +354,6 @@ |
| 356 | 355 | $tables[] = 'categorylinks'; |
| 357 | 356 | $conds[] = 'cl_from = fp_page_id'; |
| 358 | 357 | $conds['cl_to'] = $this->category; |
| 359 | | - $useIndex['categorylinks'] = 'cl_from'; |
| 360 | 358 | } |
| 361 | 359 | $this->mIndexField = 'fp_pending_since'; |
| 362 | 360 | # Show outdated version for a specific review level |
| — | — | @@ -367,8 +365,6 @@ |
| 368 | 366 | $conds[] = 'page_id = fpp_page_id'; |
| 369 | 367 | $conds[] = 'rev_id = fpp_rev_id'; // PK |
| 370 | 368 | $conds[] = 'fpp_pending_since IS NOT NULL'; |
| 371 | | - $useIndex = array( |
| 372 | | - 'flaggedpage_pending' => 'fpp_quality_pending', 'page' => 'PRIMARY' ); |
| 373 | 369 | # Filter by review level |
| 374 | 370 | $conds['fpp_quality'] = $this->level; |
| 375 | 371 | # Filter by pages configured to be stable |
| — | — | @@ -382,7 +378,6 @@ |
| 383 | 379 | $tables[] = 'categorylinks'; |
| 384 | 380 | $conds[] = 'cl_from = fpp_page_id'; |
| 385 | 381 | $conds['cl_to'] = $this->category; |
| 386 | | - $useIndex['categorylinks'] = 'cl_from'; |
| 387 | 382 | } |
| 388 | 383 | $this->mIndexField = 'fpp_pending_since'; |
| 389 | 384 | } |
| — | — | @@ -407,8 +402,7 @@ |
| 408 | 403 | return array( |
| 409 | 404 | 'tables' => $tables, |
| 410 | 405 | 'fields' => $fields, |
| 411 | | - 'conds' => $conds, |
| 412 | | - 'options' => array( 'USE INDEX' => $useIndex ) |
| | 406 | + 'conds' => $conds |
| 413 | 407 | ); |
| 414 | 408 | } |
| 415 | 409 | |