db name & language as variables

SQL

SET @c = 'Category:Redirects';
(SELECT CONCAT('[[:ceb:', page_title, ']]') FROM cebwiki_p.iwlinks INNER JOIN cebwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:de:', page_title, ']]') FROM dewiki_p.iwlinks INNER JOIN dewiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:en:', page_title, ']]') FROM enwiki_p.iwlinks INNER JOIN enwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:es:', page_title, ']]') FROM eswiki_p.iwlinks INNER JOIN eswiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:fr:', page_title, ']]') FROM frwiki_p.iwlinks INNER JOIN frwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:hu:', page_title, ']]') FROM huwiki_p.iwlinks INNER JOIN huwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:it:', page_title, ']]') FROM itwiki_p.iwlinks INNER JOIN itwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:ja:', page_title, ']]') FROM jawiki_p.iwlinks INNER JOIN jawiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:pl:', page_title, ']]') FROM plwiki_p.iwlinks INNER JOIN plwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:pt:', page_title, ']]') FROM ptwiki_p.iwlinks INNER JOIN ptwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:ru:', page_title, ']]') FROM ruwiki_p.iwlinks INNER JOIN ruwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:sv:', page_title, ']]') FROM svwiki_p.iwlinks INNER JOIN svwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:vi:', page_title, ']]') FROM viwiki_p.iwlinks INNER JOIN viwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c) UNION
(SELECT CONCAT('[[:war:', page_title, ']]') FROM warwiki_p.iwlinks INNER JOIN warwiki_p.page ON page_id = iwl_from AND page_namespace = 0 WHERE iwl_prefix = 'commons' AND iwl_title = @c)
LIMIT 100;
SQL

Checking query status...
