All XNRs from mainspace on enwiki, less pseudo-nses, no cats

Fork of All XNRs from mainspace on enwiki, less pseudo-nses by Tamzin

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

SQL

SELECT page_title, rd_namespace, rd_title
FROM page
INNER JOIN redirect ON page_id = rd_from
WHERE page_namespace = 0
AND rd_namespace != 0
AND rd_namespace != 14
AND page_title NOT LIKE "MOS:%"
AND page_title NOT LIKE "H:%"
AND page_title NOT LIKE "CAT:%"
AND page_title NOT LIKE "P:%"
AND page_title NOT LIKE "Mos:%" -- deprecated but retained
AND page_title NOT LIKE "MoS:%" -- deprecated but retained
AND page_title NOT LIKE "SMOS:%"
AND page_title NOT LIKE "ISO\_639:%" -- most point to mainspace but some don't

SQL

Checking query status...