List of crat chats

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

Ready for copying using Download Data -> Wikitable

SQL

SELECT
  REPLACE(CONCAT('[[Wikipedia:', page_title, ']]'), '_', ' ') AS page_name,
  (
    SELECT rev_timestamp
    FROM revision
    WHERE rev_page = page_id
    ORDER BY rev_id ASC
    LIMIT 1
  ) AS date,
  null AS outcome
FROM page
WHERE
  (
    page_title LIKE 'Requests_for_%rat_chat' OR
    page_title LIKE 'Requests_for_%rat_discussion'
  )
  AND page_namespace = 4
ORDER BY page_id 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...