SELECT CONCAT('[[WP:',rc_title,']]') AS name,

       rc_timestamp,

       rc_source,

       CONCAT('[[Special:Diff/', rc_this_oldid, '|diff]]') AS diff,

       (rc_new_len - rc_old_len) AS delta,

       actor_name,

       comment_text

FROM recentchanges

LEFT JOIN comment_recentchanges ON comment_id = rc_comment_id

LEFT JOIN actor_recentchanges ON actor_id = rc_actor

WHERE rc_namespace = 4

  AND rc_title LIKE 'Featured_article_candidates/%'

ORDER BY rc_timestamp DESC

LIMIT 1000;