Some cross-namespace redirects

SQL

USE enwiki_p;
SELECT * FROM logging
JOIN page p ON p.page_title = log_title AND p.page_namespace = 0
WHERE log_type = 'move'
AND log_namespace = 0
AND log_timestamp > 20160600000000
AND (log_params LIKE "User:%" OR
     log_params LIKE "Wikipedia:%" OR
     log_params LIKE "Template:%" OR
     log_params LIKE "Help:%" OR
     log_params LIKE "Category:%" OR
     log_params LIKE "Portal:%" OR
     log_params LIKE "Book:%" OR
     log_params LIKE "Draft:%" OR
     log_params LIKE "Education Program:%" OR
     log_params LIKE "TimedText:%" OR
     log_params LIKE "Module:%" OR
     log_params LIKE "Talk:%" OR
     log_params LIKE "User talk:%" OR
     log_params LIKE "Wikipedia talk:%" OR
     log_params LIKE "File talk:%" OR
     log_params LIKE "MediaWiki talk:%" OR
     log_params LIKE "Template talk:%" OR
     log_params LIKE "Help talk:%" OR
     log_params LIKE "Category talk:%" OR
     log_params LIKE "Portal talk:%" OR
     log_params LIKE "Book talk:%" OR
     log_params LIKE "Draft talk:%" OR
     log_params LIKE "Education Program talk:%" OR
     log_params LIKE "TimedText talk:%" OR
     log_params LIKE "Module talk:%" OR
     log_params LIKE "Gadget talk:%" OR
     log_params LIKE "Gadget definition talk:%") # note that log_params uses space not underscore
SQL

Checking query status...
