- extract( $dbr->tableNames( 'cur', 'links' ) );
- $sql = "SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment," .
- "cur_user_text,cur_timestamp,cur_minor_edit,cur_is_new FROM $links, $cur " .
- "WHERE cur_timestamp > '{$cutoff}' {$cmq} AND l_to=cur_id AND l_from=$id " .
- "GROUP BY cur_id,cur_namespace,cur_title,cur_user,cur_comment,cur_user_text," .
- "cur_timestamp,cur_minor_edit,cur_is_new,inverse_timestamp ORDER BY inverse_timestamp LIMIT {$limit}";
+ $sql = "SELECT page_id,page_namespace,page_title,rev_user,rev_comment," .
+ "rev_user_text,rev_timestamp,rev_minor_edit,page_is_new FROM $links, $revision, $page " .
+ "WHERE rev_timestamp > '{$cutoff}' {$cmq} AND l_to=page_id AND l_from=$id " .
+ "GROUP BY page_id,page_namespace,page_title,rev_user,rev_comment,rev_user_text," .
+ "rev_timestamp,rev_minor_edit,page_is_new ORDER BY rev_timestamp DESC LIMIT {$limit}";