- extract( $dbr->tableNames( 'categorylinks', 'pagelinks', 'revision', 'page' ) );
-
+ list($recentchanges, $categorylinks, $pagelinks, $watchlist) =
+ $dbr->tableNamesN( 'recentchanges', 'categorylinks', 'pagelinks', "watchlist" );
+
+ $uid = $wgUser->getID();
+
+ $GROUPBY = "
+ GROUP BY rc_cur_id,rc_namespace,rc_title,
+ rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor,rc_deleted,
+ rc_new, rc_id, rc_this_oldid, rc_last_oldid, rc_bot, rc_patrolled, rc_type, rc_old_len, rc_new_len
+" . ($uid ? ",wl_user" : "") . "
+ ORDER BY rc_timestamp DESC
+ LIMIT {$limit}";
+