Cross-namespace redirects

SQL

USE elwiki_p;
SELECT p.page_title FROM page p
JOIN redirect r ON r.rd_from = p.page_title
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

AخA
 
USE elwiki_p;SELECT p.page_title FROM page pJOIN redirect r ON r.rd_from = p.page_titleWHERE p.page_namespace = 0AND 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                           

SQL

Query status: complete