Interwiki file links from wikis to Commons

SQL

#USE dewiki_p;
#USE dewikivoyage_p;
USE enwiki_p;
#USE frwiki_p;
#USE itwiki_p;
#USE nlwiki_p;
#USE specieswiki_p;
SET @w = LEFT (DATABASE(), LENGTH(DATABASE()) - 2); SET @l = (SELECT lang FROM meta_p.wiki WHERE dbname = @w);
#SET @p = '^$'; #dummy
SELECT now() AS timestamp;
#interwiki links to file pages
(SELECT CONCAT ('# [[', REPLACE (wp.page_title, '_', ' '), ']] ', 
                '→ [[:c:', REPLACE (iwl_title, '_', ' '), ']]') AS wikipage
FROM iwlinks
INNER JOIN page wp
ON wp.page_id = iwl_from
AND wp.page_namespace = 0
AND wp.page_is_redirect = 0
WHERE iwl_prefix ='commons'
AND iwl_title REGEXP '^[Ff]ile:'
AND iwl_title REGEXP '.\.(?:jpe?g|JPE?G|png|PNG|svg|SVG|tiff?|TIFF?)'
) /*UNION
#external interwiki links to file pages
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']] ',
               '→ [[:c:', REPLACE ((SUBSTRING(REPLACE (REPLACE (el_to, '#mw-subcategories', ''), CONCAT('?uselang=', @l), ''), IF ((LEFT (el_to, 5) = 'https'), 36, 35))), '_', ' '), ']]') as wikipage
FROM externallinks
INNER JOIN page wp
ON wp.page_id = el_from
AND wp.page_namespace = 0
AND wp.page_is_redirect = 0
WHERE el_to REGEXP '^https?\:\/\/commons\.wikimedia\.org\/wiki\/[Ff]ile\:'
AND el_to REGEXP '.\.(?:jpe?g|JPE?G|png|PNG|svg|SVG|tiff?|TIFF?)'
AND el_to NOT LIKE '%\%%' #temp
)*/
#ORDER BY wikipage
LIMIT 1000;
SQL

Checking query status...
