http://www.mediawiki.org/wiki/Special:Code/MediaWiki/56483
Revision: 56483
Author: aaron
Date: 2009-09-17 01:45:34 +0000 (Thu, 17 Sep 2009)
Log Message:
-----------
query optimization
Modified Paths:
--------------
trunk/extensions/FlaggedRevs/specialpages/ProblemChanges_body.php
Modified: trunk/extensions/FlaggedRevs/specialpages/ProblemChanges_body.php
===================================================================
--- trunk/extensions/FlaggedRevs/specialpages/ProblemChanges_body.php
2009-09-17 01:23:06 UTC (rev 56482)
+++ trunk/extensions/FlaggedRevs/specialpages/ProblemChanges_body.php
2009-09-17 01:45:34 UTC (rev 56483)
@@ -291,7 +291,7 @@
global $wgUser, $wgOldChangeTagsIndex;
$ctIndex = $wgOldChangeTagsIndex ? 'ct_rev_id' :
'change_tag_rev_tag';
$conds = $this->mConds;
- $tables = array( 'page', 'revision', 'change_tag' );
+ $tables = array( 'revision', 'change_tag', 'page' );
$fields = array('page_namespace','page_title','page_latest');
# Show outdated "stable" versions
if( $this->level < 0 ) {
@@ -301,7 +301,7 @@
$conds[] = 'fp_pending_since IS NOT NULL';
$conds[] = 'page_id = fp_page_id';
# Find revisions that are tagged as such
- $conds[] = 'rev_page = page_id';
+ $conds[] = 'rev_page = fp_page_id';
$conds[] = 'rev_id > fp_stable';
$conds[] = 'ct_rev_id = rev_id';
$conds['ct_tag'] = $this->tag;
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
