SQL
x
/*USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN wikidatawiki_p.wb_terms ON term_language = 'cs' AND term_type = 'description' AND term_full_entity_id = pp_value
WHERE pp_propname = 'wikibase_item'
AND term_text IS NULL;*/
USE wikidatawiki_p;
SELECT COUNT(*) AS number FROM wb_terms
JOIN wb_items_per_site ON ips_item_id = REPLACE(term_full_entity_id, 'Q', '') AND ips_site_id = 'cswiki'
WHERE term_language = 'cs' AND term_type = 'description';
SELECT COUNT(*) AS number FROM wb_items_per_site WHERE ips_site_id = 'cswiki';
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.