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
Edgars2007
.
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT * from wb_terms WHERE #term_entity_id < 10 #AND term_entity_type = 'item' AND term_language <> 'lv' AND term_type = 'label' limit 20; use wikidatawiki_p; select *#concat("[[Q", ips_item_id, "]] ([[User:YMS/LC#Q", ips_item_id, "|LC]])") as item, ips_site_id, ips_site_page from wb_items_per_site #join s51880_akkakkbot.languages on lang_db = "eswiki" and lang_db = ips_site_id and #(ips_site_page like "%, %" or ips_site_page like "% (%)") and not exists #(select term_language from wb_terms where ips_item_id = term_entity_id and lang_wd = term_language and term_type = "label") limit 10;
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...