Cross-namespace redirects

SQL

SELECT p.page_id, p.page_title, p.page_namespace FROM page p
JOIN redirect r ON r.rd_from = p.page_id
WHERE p.page_namespace = 0
AND r.rd_namespace NOT IN (0, #Article
                           14, # Category
                           10, # Template
                           4, # Wikipedia
                           5, # Wikipedia talk - see Wikipedia:Redirects for discussion/Log/2012 July 16#Rules to consider/Confer in e-mail debate
                           12, # Help
                           100) # Portal
AND p.page_id NOT IN (36422437, 28376039, 5518477, 5518482, 26880825, # Five redirects to other namespaces which have been kept at [[WP:RFD]]
                      59320427) # Shortcut, looks acceptable.
SQL

Checking query status...
