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,
       page_namespace,
       page_title,
       page_is_redirect,
       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]+\\)'
  ORDER BY 'is on WP:RFD' ASC, page_title ASC, page_is_redirect ASC;

SQL

Checking query status...