Bad links from wikis to m, mw: redirects

SQL

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

Checking query status...
