Pages containing 'Presbyterian' created in the last 30 days

Fork of Pages containing 'Presbyterian' created in the last week by Cryptic

This query is marked as a draft This query has been published by Cryptic.

SQL

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;

SQL

Checking query status...