Pages containing 'Presbyterian' created in the last week

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 Anna Frodesiak.

https://en.wikipedia.org/w/index.php?title=Wikipedia:Request_a_query&diff=791041419&oldid=787228069

SQL

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;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...