All pages with wikidata Q#s/P#s in title

Fork of Mainspace pages with wikidata Q#s in title by Cryptic

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

Enwiki pages whose title contains a Wikidata Q number or P number as a disambiguator, even if the closing parenthesis is missing or the Q or P is lowercase; and what they redirect to if they're currently redirects.

For [[MediaWiki talk:Titleblacklist#Request to prevent "Wikidata" titles from being created]] circa 14 Nov 2019.

SQL

SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS 'page title',
       CASE WHEN page_is_redirect = 0 THEN NULL
            ELSE (SELECT CASE WHEN rd_namespace = 0 THEN CONCAT('[[', rd_title, ']]')
                              ELSE CONCAT('[[{{ns:', rd_namespace, '}}:', rd_title, ']]')
                              END
                  FROM redirect
                  WHERE rd_from = page_id)
            END AS 'redirect to',
FROM page
WHERE page_title RLIKE '\\([qQpP][0-9]+';

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