Redirected BSicon files in use on some wikis

Fork of Redirected BSicon files in use on some wikis by Achim55

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

SQL

USE commonswiki_p;
SELECT CONCAT ('# [[:File:', REPLACE (page_title, '_', ' '), ']] → [[:File:', REPLACE (rd_title, '_', ' '), ']]') FROM page
JOIN globalimagelinks ON gil_to = page_title
JOIN redirect ON rd_from = page_id AND rd_namespace = 6
WHERE page_namespace = 6
AND page_is_redirect = 1
AND (gil_page_namespace_id % 2) = 0 #exclude all talk pages
AND gil_page_namespace_id != 2 #exclude user pages
#AND gil_page_namespace_id != 3 #exclude user talk pages
#AND gil_page_namespace_id = 0 #show article pages only
AND page_title LIKE 'BSicon%'
GROUP BY page_title
LIMIT 10000;

SQL

Checking query status...