db name & language as variables

SQL

USE dewiki_p;
#broken external interwiki links
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage,
        CONCAT('→ [[:c:', REPLACE ((SUBSTRING(REPLACE (REPLACE (el_to, '#mw-category-media', ''), '&uselang=de', ''), 67)), '_', ' '), ']]') 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/w/index.php?title=Category:%'
AND el_to NOT LIKE '%\%%' #temp
AND NOT EXISTS (SELECT 1 FROM commonswiki_p.page cp
                WHERE cp.page_namespace = 14
                AND cp.page_title = SUBSTRING(REPLACE (REPLACE (el_to, '#mw-category-media', ''), '&uselang=de', ''), 58)
               )
)
#ORDER BY wpage
LIMIT 20;
SQL

Checking query status...
