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
SET @ext = '(?:[Ii]mage|[Ff]ile)\:.*\.(?:jpe?g|JPE?G|png|PNG|svg|SVG|tiff?|TIFF?)';
IF (@w = 'dewiki') THEN
 SET @p = '^Ascheim$';
END IF;
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
#AND wp.page_title NOT REGEXP @p
WHERE iwl_prefix IN ('c', 'commons')
AND iwl_title REGEXP @ext
AND iwl_title NOT LIKE '%#%' #temp
)
UNION
#external interwiki links to file pages
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']] → ', el_to) 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
#AND wp.page_title NOT REGEXP @p
WHERE ((el_to LIKE 'https://commons.wikimedia.org/wiki/%') OR (el_to LIKE 'https://commons.wikimedia.org/wiki/%'))
AND el_to REGEXP @ext
AND REPLACE (el_to, '#mw-subcategories', '') NOT LIKE '%#%' #temp
AND el_to NOT LIKE '%\%%' #temp
)
ORDER BY wikipage
LIMIT 500;
SQL

Checking query status...
