Bad links from wikis to Commons galleries: broken

SQL

#USE stop;
USE dewiki_p;
SELECT now() AS timestamp;
#empty links, no target given (galleries)
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage,
        CONCAT('→ [[:c:', REPLACE (iwl_title, '_', ' '), ']]') AS commonscat
FROM iwlinks
INNER JOIN page wp
ON wp.page_id = iwl_from
AND wp.page_namespace = 0
WHERE iwl_prefix ='commons'
AND iwl_title REGEXP '^ *$'
)
UNION
#broken interwikilinks (galleries)
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage,
        CONCAT('→ [[:c:', REPLACE (iwl_title, '_', ' '), ']]') AS commonscat
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 NOT LIKE '%:%'
AND NOT EXISTS (SELECT 1 FROM commonswiki_p.page cp
                WHERE cp.page_title = iwl_title
                AND cp.page_namespace = 0)
)
UNION
#broken external interwiki links (galleries)
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage,
        CONCAT('→ [[:c:', REPLACE ((SUBSTRING(REPLACE (el_to, '?uselang=de', ''), 36)), '_', ' '), ']]') AS commonscat
 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 LIKE 'https://commons.wikimedia.org/wiki/%'
 AND el_to NOT LIKE 'https://commons.wikimedia.org/wiki/%:%'
 AND el_to NOT LIKE '%#%' #temp
 AND el_to NOT LIKE '%\%%' #temp
 AND NOT EXISTS (SELECT 1 FROM commonswiki_p.page cp
                 WHERE cp.page_namespace = 0
                 AND cp.page_title = SUBSTRING(REPLACE (el_to, '?uselang=de', ''), 36)
                )
)
ORDER BY wpage
LIMIT 2000;
SQL

Checking query status...
