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 left join wikidatawiki_p.wb_items_per_site a on a.ips_site_page = ll_title and a.ips_site_id = concat(replace(ll_lang,"-","_"), "wiki") where page_namespace = 0 and page_title in (".ad" , ".ae" , ".af" , ".ag" , ".ai" , ".al" , ".am" , ".an" , ".ao" , ".aq" , ".ar" , ".as" , ".at" , ".au" , ".aw" , ".az" , ".ba" , ".bb" , ".bd" , ".be" , ".bf" , ".bg" , ".bh" , ".bi" , ".bj" , ".bm" , ".bn") limit 400
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...