Mainspace pages with wikidata Q#s in title

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

I have deliberately left the false positives in, despite the largest group of them (those starting with 'French_submarine_') being easily filterable.

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,
       CONCAT('[[', 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',
       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...