SQL
AخA
USE wikidatawiki_p;
SELECT labels.term_full_entity_id, labels.term_text#, descriptions.term_text
FROM (SELECT * FROM wb_terms WHERE term_language = 'cs' AND term_type = 'label' AND term_text LIKE '% (%)'
AND term_text NOT LIKE '%:%'
AND term_text NOT LIKE '%)%(%') AS labels;
#LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = 'cs' AND term_type = 'description') AS descriptions
# ON descriptions.term_full_entity_id = labels.term_full_entity_id
#LIMIT 10000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.