Bad links from wikis to m, mw, species articles: broken

SQL

USE enwiki_p;
SELECT now() AS timestamp;/*
#empty links, no target given
(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 = 'Category:'
)
UNION
#broken interwikilinks
(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_title LIKE 'Category:%'
AND NOT EXISTS (SELECT 1 FROM commonswiki_p.page cp
                WHERE cp.page_title = SUBSTRING(iwl_title, 10)
                AND cp.page_namespace = 14)
)
UNION*/
#broken external interwiki links
(SELECT CONCAT('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage, CONCAT('→ [[:c:Category:', REPLACE (cp.page_title, '_', ' '), ']]') 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
#INNER JOIN commonswiki_p.page cp
#ON cp.page_title = SUBSTRING(REPLACE (el_to, '?uselang=en', ''), 45)
#AND cp.page_namespace = 14
#INNER JOIN commonswiki_p.categorylinks ccl
#ON ccl.cl_from = cp.page_id
#AND ccl.cl_to = 'Disambiguation'
#WHERE el_to LIKE 'https://commons.wikimedia.org/wiki/Category:%'
AND NOT EXISTS (SELECT 1 FROM commonswiki_p.page cp
#ON cp.page_title = SUBSTRING(REPLACE (el_to, '?uselang=en', ''), 45)
#WHERE el_to LIKE 'https://commons.wikimedia.org/wiki/Category:%'
AND cp.page_namespace = 14)
)*/
#ORDER BY wpage
LIMIT 100;
SQL

Checking query status...
