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") where page_namespace = 0 and page_title in (".ac", ".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...