Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Snævar
.
Toggle Highlighting
SQL
select page_namespace, page_title, ll_lang, ll_title, concat("[[d:", a.ips_item_id, "]]") from iswiki_p.page join iswiki_p.langlinks on ll_from = page_id join wikidatawiki_p.wb_items_per_site a on a.ips_site_page = ll_title and a.ips_site_id = concat(ll_lang, "wiki") join wikidatawiki_p.wb_items_per_site b on a.ips_item_id = b.ips_item_id where page_title in ("Wolfram~iswiki", "Forsíða/Safn_1", "Sindri", "Zbihniew~iswiki", "Rogper~iswiki", "OttarGE~iswiki", "Mats_Halldin~iswiki", "Íslensk_skáld", "Mannsheili", "Andlitsbein", "Gdh", "Taugakerfi", "Skynfæri", "Tölvuleikur", "Borislav", "Ævar_Arnfjörð_Bjarmason", "Plaudite~iswiki", "Listener~iswiki", "Andre_Engels", "Robbot", "Þágufall", "Friðrik_Bragi_Dýrfjörð", "Spm", "Stubbur", "Lífræn_efnafræði", "Looxix~iswiki", ) limit 200
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
.
Checking query status...