- $use_index = $db->useIndexClause( 'name_title_timestamp' );
- $oldtable = $db->tableName( 'old' );
-
- $sql = "SELECT old_id,old_user," .
- "old_comment,old_user_text,old_timestamp,old_minor_edit ".
- "FROM $oldtable $use_index " .
- "WHERE old_namespace={$namespace} AND " .
- "old_title='" . $db->strencode( $this->mTitle->getDBkey() ) . "' " .
- "ORDER BY inverse_timestamp".$db->limitResult($limitplus,$rawoffset);
+ if ($uid && $wgShowUpdatedMarker && $wgUser->getOption( 'showupdated' ))
+ $notificationtimestamp = $db->selectField( 'watchlist',
+ 'wl_notificationtimestamp',
+ array( 'wl_namespace' => $namespace, 'wl_title' => $this->mTitle->getDBkey(), 'wl_user' => $uid ),
+ $fname );
+ else $notificationtimestamp = false;
+
+ $use_index = $db->useIndexClause( 'page_timestamp' );
+ $revision = $db->tableName( 'revision' );
+
+ $sql = "SELECT rev_id,rev_user," .
+ "rev_comment,rev_user_text,rev_timestamp,rev_minor_edit ".
+ "FROM $revision $use_index " .
+ "WHERE rev_page=$id " .
+ "ORDER BY rev_timestamp DESC ".$db->limitResult($limitplus,$offset);