Links to redirecting file pages - local

SQL

#USE dewiki_p;
USE enwiki_p;
#USE nlwiki_p;
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')
)
ORDER BY wpage
LIMIT 1000;
SQL

Checking query status...
