SELECT CONCAT('[[',

              (CASE rc_namespace

               WHEN 0 THEN ''

               WHEN 1 THEN 'Talk:'

               WHEN 2 THEN 'User:'

               WHEN 3 THEN 'User talk:'

               WHEN 4 THEN 'Wikipedia:'

               WHEN 5 THEN 'Wikipedia talk:'

               WHEN 6 THEN ':File:'

               WHEN 7 THEN 'File talk:'

               WHEN 10 THEN ':Template:'

               WHEN 11 THEN 'Template talk:'

               WHEN 14 THEN ':Category:'

               WHEN 15 THEN 'Category talk:'

               WHEN 100 THEN 'Portal:'

               WHEN 101 THEN 'Portal talk:'

               WHEN 108 THEN 'Book:'

               WHEN 109 THEN 'Book talk:'

               WHEN 118 THEN 'Draft:'

               WHEN 119 THEN 'Draft talk:'

               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_new = 1

AND rc_title LIKE '%Presbyterian%'

ORDER BY creation DESC;

​