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
軽快
.
匿名登録者による、日本語の説明・別名の追加、ラベル・説明・別名の変更であって、巡回されていないものの一覧
Toggle Highlighting
SQL
/*use wikidatawiki_p; select concat( "[[:d:Q", ips_item_id, "]]") from wb_items_per_site where ips_site_id = "jawiki" limit 100*/ use jawiki_p; select pp_page, (case when pp_propname = "disambiguation" then "曖昧さ回避" end ) as "is曖昧さ回避", (case when pp_propname = "wikibase_item" then pp_value end ) as "ウィキデート項目" from page_props where pp_propname = "disambiguation" or pp_propname = "wikibase_item" limit 1000
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...