db name & language as variables

This query is marked as a draft This query has been published by Achim55.

SQL

SET @c = 'Category:DAF_CG';
(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('[[: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;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...