redirs from target+additional word

Redirects that consist of their target's title plus a single additional word, and whose targets are a single word.

There are about twice as many if the target can be multiple words like [[Organic farming methods]]→[[Organic farming]], many more if it can include punctuation such as [[Barnes & Noble Incorporated]]→[[Barnes & Noble]], and tens of thousands more the restrictions on the target are omitted entirely, such as [[517 deaths]]→[[517]]; but Quarry performs very poorly with queries with more than about a hundred thousand rows in the resultset.

For [[User talk:Pppery#Elephant population]] circa 17 May 2024.

SQL

SELECT page_title AS 'redirect', rd_title AS 'target'
FROM redirect
JOIN page ON page_id = rd_from
WHERE page_namespace = 0
  AND rd_namespace = 0
  AND page_title LIKE CONCAT(rd_title, '\_%')
  AND page_title RLIKE CONCAT('^', rd_title, '_[[:alpha:]]+$')
  AND rd_title RLIKE '^[[:alpha:]]+$';

AخA
 
SELECT page_title AS 'redirect', rd_title AS 'target'FROM redirectJOIN page ON page_id = rd_fromWHERE page_namespace = 0  AND rd_namespace = 0  AND page_title LIKE CONCAT(rd_title, '\_%')  AND page_title RLIKE CONCAT('^', rd_title, '_[[:alpha:]]+$')  AND rd_title RLIKE '^[[:alpha:]]+$';

SQL

Checking query status...