| Index: trunk/extensions/Nuke/SpecialNuke_body.php |
| — | — | @@ -115,19 +115,18 @@ |
| 116 | 116 | |
| 117 | 117 | function getNewPages( $username ) { |
| 118 | 118 | $dbr = wfGetDB( DB_SLAVE ); |
| 119 | | - $result = $dbr->select( array( 'recentchanges', 'revision' ), |
| 120 | | - array( 'rc_namespace', 'rc_title', 'rc_timestamp', 'COUNT(rev_id) AS edits' ), |
| | 119 | + $result = $dbr->select( 'recentchanges', |
| | 120 | + array( 'rc_namespace', 'rc_title', 'rc_timestamp', 'COUNT(*) AS edits' ), |
| 121 | 121 | array( |
| 122 | 122 | 'rc_user_text' => $username, |
| 123 | 123 | '(rc_new = 1) OR (rc_log_type = "upload" AND rc_log_action = "upload")' |
| 124 | | - ), |
| | 124 | + ), |
| 125 | 125 | __METHOD__, |
| 126 | 126 | array( |
| 127 | 127 | 'ORDER BY' => 'rc_timestamp DESC', |
| 128 | | - 'GROUP BY' => $dbr->implicitGroupby() ? 'rev_page' : 'rc_namespace, rc_title, rc_timestamp' |
| 129 | | - ), |
| 130 | | - array( 'revision' => array( 'LEFT JOIN', 'rc_cur_id=rev_page' ) ) |
| 131 | | - ); |
| | 128 | + 'GROUP BY' => 'rc_namespace, rc_title' |
| | 129 | + ) |
| | 130 | + ); |
| 132 | 131 | $pages = array(); |
| 133 | 132 | while( $row = $dbr->fetchObject( $result ) ) { |
| 134 | 133 | $pages[] = array( Title::makeTitle( $row->rc_namespace, $row->rc_title ), $row->edits ); |