Non-mainspace pages with wikidata Q#s in title

Enwiki non-mainspace pages whose title contains a Wikidata Q number as a disambiguator; what they redirect to if they're currently redirects, and whether they're in [[Category:All redirects for discussion]].

For [[WT:CSD#Redirects with database (e.g. Wikidata) identifiers]] circa 5 Nov 2019 and [[Wikipedia:Redirects for discussion/Log/2019 November 5#Wikidata redirects]].

SQL

SELECT page_id,
       CASE WHEN page_namespace = 1 THEN CONCAT('[[Talk:', page_title, ']]')
            WHEN page_namespace = 2 THEN CONCAT('[[User:', page_title, ']]')
            ELSE CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]')
            END AS 'page title',
       CASE WHEN page_is_redirect = 0 THEN NULL
            ELSE (SELECT CASE WHEN rd_namespace = 0 THEN CONCAT('[[', rd_title, ']]')
                              WHEN rd_namespace = 1 THEN CONCAT('[[Talk:', rd_title, ']]')
                              WHEN rd_namespace = 2 THEN CONCAT('[[User:', rd_title, ']]')
                              ELSE CONCAT('[[{{ns:', rd_namespace, '}}:', rd_title, ']]')
                              END
                  FROM redirect
                  WHERE rd_from = page_id)
            END AS 'redirect to',
       EXISTS (SELECT 1 FROM categorylinks
               WHERE cl_from = page_id
               AND cl_to = 'All_redirects_for_discussion') AS 'is on WP:RFD'
FROM page
WHERE page_namespace != 0
  AND page_title RLIKE '\\(Q[0-9]+\\)';

SQL

Checking query status...