- Count grouped by Number of labels, descriptions & aliases per item
- Should be possible through the wb_terms table
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Addshore | T119182 Track Wikidata data completeness | |||
| Declined | Addshore | T119610 Track Count grouped by Number of labels, descriptions & aliases per item Wikidata |
Event Timeline
Comment Actions
Although this should be possible through the wb_terms table this is going to end up being a VERY slow query
It could all be calculated using:
SELECT COUNT(*) AS count, term_entity_id term_entity_type, term_type, term_language FROM wikidatawiki.wb_terms GROUP BY term_entity_type, term_type, term_language, term_entity_id;
Comment Actions
SELECT a.terms AS terms, a.type AS type, COUNT(*) AS count FROM ( SELECT term_entity_id AS entity, term_type AS type, COUNT(*) AS terms FROM wikidatawiki.wb_terms WHERE term_type IN ( 'label', 'description' ) GROUP BY term_entity_id, term_type ) AS a GROUP BY a.terms, a.type
Takes an hour and 54 mins >.>
Comment Actions
Okay, right now I am going to mark this as declined / not going to do.
The value of this right now is unclear.
If we try to move forward with this particular task again using the dumps would be the only way forward!