Bad links from wikis to m, mw: redirects

SQL

#USE stopthisrun;
wiki = enwiki_p;
(SELECT CONCAT ('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage, CONCAT ('→ [[:c:', REPLACE (wiwl.iwl_title, '_', ' '), ']]') AS commonscat FROM enwiki_p.iwlinks wiwl
INNER JOIN enwiki_p.page wp ON wp.page_id = wiwl.iwl_from
WHERE wiwl.iwl_prefix ='commons'
AND wp.page_namespace = 0
AND wiwl.iwl_title = 'Category:')
UNION
(SELECT CONCAT ('# [[', REPLACE (wp.page_title, '_', ' '), ']]') AS wpage, CONCAT ('→ [[:c:', REPLACE (wiwl.iwl_title, '_', ' '), ']]') AS commonscat FROM enwiki_p.iwlinks wiwl
INNER JOIN enwiki_p.page wp ON wp.page_id = wiwl.iwl_from
INNER JOIN commonswiki_p.page cp ON CONCAT('Category:',cp.page_title) = wiwl.iwl_title
RIGHT JOIN commonswiki_p.categorylinks ccl ON ccl.cl_from = cp.page_id
WHERE wiwl.iwl_prefix ='commons'
AND wp.page_namespace = 0
AND wiwl.iwl_title LIKE 'Category:%'
AND cp.page_namespace = 14
AND (cp.page_is_redirect = 1 OR ccl.cl_to = 'Category_redirects')
)
ORDER BY wpage
LIMIT 1000;
SQL

Checking query status...
