* Populate rev_parent_id

[lhc/web/wiklou.git] / includes / SpecialMostrevisions.php

diff --git a/includes/SpecialMostrevisions.php b/includes/SpecialMostrevisions.php
index 81a49c9..9479a58 100644 (file)
--- a/includes/SpecialMostrevisions.php
+++ b/includes/SpecialMostrevisions.php
@@ -2,8 +2,7 @@
 /**
  * A special page to show pages in the
  *
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
  *
  * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
  * @copyright Copyright © 2005, Ævar Arnfjörð Bjarmason
@@ -11,8 +10,7 @@
  */
 
 /**
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
  */
 class MostrevisionsPage extends QueryPage {
 
@@ -21,8 +19,8 @@ class MostrevisionsPage extends QueryPage {
        function isSyndicated() { return false; }
 
        function getSQL() {
-               $dbr =& wfGetDB( DB_SLAVE );
-               extract( $dbr->tableNames( 'revision', 'page' ) );
+               $dbr = wfGetDB( DB_SLAVE );
+               list( $revision, $page ) = $dbr->tableNamesN( 'revision', 'page' );
                return
                        "
                        SELECT
@@ -31,9 +29,9 @@ class MostrevisionsPage extends QueryPage {
                                page_title as title,
                                COUNT(*) as value
                        FROM $revision
-                       LEFT JOIN $page ON page_id = rev_page
+                       JOIN $page ON page_id = rev_page
                        WHERE page_namespace = " . NS_MAIN . "
-                       GROUP BY rev_page
+                       GROUP BY 1,2,3
                        HAVING COUNT(*) > 1
                        ";
        }
@@ -65,4 +63,4 @@ function wfSpecialMostrevisions() {
        $wpp->doQuery( $offset, $limit );
 }
 
-?>
+