Links to redirecting file pages - local

SQL

USE dewiki_p;
#USE enwiki_p;
#USE frwiki_p;
#USE nlwiki_p;
SET @w = LEFT (DATABASE(), LENGTH(DATABASE()) - 2);
SELECT now() AS timestamp;
#wikipedia imagelinks
(SELECT CONCAT('# [[', IF (wp.page_namespace = 14, ':{{ns:14}}:', ''), REPLACE (wp.page_title, '_', ' '), ']] ',
               '• [{{fullurl:', IF (wp.page_namespace = 14, '{{ns:14}}:', ''), REPLACE (wp.page_title, '_', ' '), '|action=edit}} edit] ',
               '→ [[:{{ns:6}}:', REPLACE (cp.page_title, '_', ' '), ']]') AS wpage
FROM page wp
INNER JOIN imagelinks ON il_from = wp.page_id AND il_from_namespace IN (0, 14)
INNER JOIN page cp ON cp.page_title = il_to AND cp.page_namespace = 6 AND cp.page_is_redirect = 1
WHERE wp.page_namespace IN (0, 14)
) UNION
#interwiki to Commons
(SELECT CONCAT('# [[', IF (wp.page_namespace = 14, ':{{ns:14}}:', ''), REPLACE (wp.page_title, '_', ' '), ']] ',
               '• [{{fullurl:', IF (wp.page_namespace = 14, '{{ns:14}}:', ''), REPLACE (wp.page_title, '_', ' '), '|action=edit}} edit] ',
               '→ [[c:File:', REPLACE (iwl_title, '_', ' '), ']]') AS wpage
FROM iwlinks
INNER JOIN page wp ON wp.page_id = iwl_from AND wp.page_namespace IN (0, 14)
INNER JOIN commonswiki_p.page cp ON cp.page_title = iwl_title AND cp.page_namespace = 6 AND cp.page_is_redirect = 1
WHERE iwl_prefix IN ('c', 'commons')
) UNION
#globalimagelinks
(SELECT CONCAT('# [[', IF (wp.page_namespace = 14, ':{{ns:14}}:', ''), REPLACE (wp.page_title, '_', ' '), ']] ',
               '• [{{fullurl:', IF (wp.page_namespace = 14, '{{ns:14}}:', ''), REPLACE (wp.page_title, '_', ' '), '|action=edit}} edit] ',
               '→ [[c:File:', REPLACE (gil_to, '_', ' '), ']]') AS wpage
FROM commonswiki_p.globalimagelinks
INNER JOIN page wp ON wp.page_id = gil_page AND wp.page_namespace IN (0, 14)
INNER JOIN commonswiki_p.page cp ON cp.page_title = iwl_title AND cp.page_namespace = 6 AND cp.page_is_redirect = 1
WHERE gil_wiki = @w
)
ORDER BY wpage
LIMIT 100;
SELECT * FROM commonswiki_p.globalimagelinks WHERE gil_to = 'Bandera_e_Oxox.png' LIMIT 10;
SQL

Checking query status...
