db name & language as variables

SQL

SET @c = 'Category:Cologne';
(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('[[:nl:', page_title, ']]') FROM nlwiki_p.iwlinks INNER JOIN nlwiki_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)
LIMIT 10;
SQL

Checking query status...
