- Count grouped by Number of site links per item
- Should be possible through the wb_items_per_site table
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Add sitelinks_per_item script | analytics/limn-wikidata-data | master | +48 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Addshore | T119182 Track Wikidata data completeness | |||
| Resolved | Addshore | T119611 Track Count grouped by Number of site links per item Wikidata |
Event Timeline
Comment Actions
Something like this will help..
SELECT ips_item_id AS item, ips_site_id AS site, COUNT(*) AS count FROM wikidatawiki.wb_items_per_site GROUP BY ips_item_id ORDER BY count ASC;
Comment Actions
So, there is actually a wb-sitelinks pageprop
So we can use the page_props table for this
When implementing make sure we count how many have 0!
Comment Actions
Change 255691 had a related patch set uploaded (by Addshore):
Add sitelinks_per_item script
Comment Actions
I am going to close this as resolved as we are now tracking this!
Graphing this in grafana will probably be put off until I can use the natural sort and sortByName functions from graphite (once it gets updated)