| Index: branches/wmf-deployment/extensions/FlaggedRevs/specialpages/ProblemChanges_body.php |
| — | — | @@ -291,7 +291,7 @@ |
| 292 | 292 | global $wgUser, $wgOldChangeTagsIndex; |
| 293 | 293 | $ctIndex = $wgOldChangeTagsIndex ? 'ct_rev_id' : 'change_tag_rev_tag'; |
| 294 | 294 | $conds = $this->mConds; |
| 295 | | - $tables = array( 'page', 'revision', 'change_tag' ); |
| | 295 | + $tables = array( 'revision', 'change_tag', 'page' ); |
| 296 | 296 | $fields = array('page_namespace','page_title','page_latest'); |
| 297 | 297 | # Show outdated "stable" versions |
| 298 | 298 | if( $this->level < 0 ) { |
| — | — | @@ -301,7 +301,7 @@ |
| 302 | 302 | $conds[] = 'fp_pending_since IS NOT NULL'; |
| 303 | 303 | $conds[] = 'page_id = fp_page_id'; |
| 304 | 304 | # Find revisions that are tagged as such |
| 305 | | - $conds[] = 'rev_page = page_id'; |
| | 305 | + $conds[] = 'rev_page = fp_page_id'; |
| 306 | 306 | $conds[] = 'rev_id > fp_stable'; |
| 307 | 307 | $conds[] = 'ct_rev_id = rev_id'; |
| 308 | 308 | $conds['ct_tag'] = $this->tag; |