Count of cswiki sitelinks on Wikidata

SQL

/*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';

SQL

Checking query status...