SELECT CONCAT('[[',

              (CASE rc_namespace

               WHEN 1 THEN 'Talk:'

               WHEN 14 THEN ':Category:'

               WHEN 15 THEN 'Category talk:'

               WHEN 118 THEN 'Draft:'

               ELSE CONCAT('{{ns:', rc_namespace, '}}:')

              END),

              REPLACE(rc_title, '_', ' '),

              ']]') AS 'page',

       DATE_FORMAT(rc_timestamp, '%Y-%m-%d %H:%i:%s') AS 'creation'

FROM recentchanges

WHERE rc_timestamp >= DATE_SUB(NOW(), INTERVAL 7 day)+0

AND rc_new = 1

AND rc_title LIKE '%Presbyterian%'

ORDER BY creation DESC;

​