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
Matěj Suchánek
.
Toggle Highlighting
SQL
/*USE wikidatawiki_p; SELECT term_full_entity_id, term_language, term_text FROM wb_terms WHERE term_type = 'description' AND term_language = 'cs' AND term_full_entity_id LIKE 'Q%' AND ( term_text LIKE 'Anglick%' OR term_text LIKE 'Britsk%' OR term_text LIKE 'Budova %' OR term_text LIKE 'Býval%' OR term_text LIKE 'Česk%' OR term_text LIKE 'Hrad %' OR term_text LIKE 'Hudební %' OR term_text LIKE 'Italsk%' OR term_text LIKE 'Japonsk%' OR term_text LIKE 'Kniha %' OR term_text LIKE 'Křížová %' OR term_text LIKE 'Obec %' OR term_text LIKE 'Ostrov %' OR term_text LIKE 'Polsk%' OR term_text LIKE 'Potok %' OR term_text LIKE 'Rod %' OR term_text LIKE 'Rozhlasov%' OR term_text LIKE 'Řeka %' OR term_text LIKE 'Rusk%' OR term_text LIKE 'Sbor %' ) ORDER BY term_text;*/
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...