Lucas_Werkmeister_WMDE added a comment.
Brief check for usages on enwiki:
MariaDB [enwiki_p]> SELECT eu_aspect, eu_page_id FROM wbc_entity_usage
WHERE eu_entity_id = 'Q1513315' ORDER BY eu_page_id DESC LIMIT 13;
+-----------+------------+
| eu_aspect | eu_page_id |
+-----------+------------+
| C.P793 | 67023127 |
| O | 67023127 |
| C.P793 | 66824389 |
| O | 66824389 |
| C.P18 | 60532910 |
| C.P2670 | 60101418 |
| L.en | 60101418 |
| O | 60101418 |
| C.P793 | 60101418 |
| L.en | 57316060 |
| C.P2670 | 57316060 |
| C.P793 | 57316060 |
| O | 57316060 |
+-----------+------------+
13 rows in set (0.00 sec)
This supports the idea that we’re adding lots of “other” usages with
“statement” usages.
I then did a more thor check on cawiki, and there are ~12k distinct pages
that have some `C%` usage but no `O` usage:
SELECT DISTINCT u1.eu_page_id FROM wbc_entity_usage AS u1 LEFT JOIN
wbc_entity_usage AS u2 ON u1.eu_page_id = u2.eu_page_id AND u2.eu_aspect = 'O'
WHERE u1.eu_aspect LIKE 'C%' AND u2.eu_page_id IS NULL;
I guess those must be coming from accesses to the `claims` in Lua (which,
unlike the `getEntityStatements` function, doesn’t add an “other” usage, if I
read the code correctly). But that’s a fairly small proportion compared to the
~614k total distinct pages with `C%` usage on cawiki.
TASK DETAIL
https://phabricator.wikimedia.org/T283040
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucas_Werkmeister_WMDE
Cc: Lucas_Werkmeister_WMDE, Ladsgroup, Michael, Manuel, Addshore,
RBrounley_WMF, Aklapper, Reedy, Invadibot, maantietaja, Akuckartz, apaskulin,
Iflorez, alaa_wmde, Nandana, lucamauri, Cpaulf30, Lahi, Gq86,
GoranSMilovanovic, Ivana_Isadora, QZanden, LawExplorer, _jensen, rosalieper,
Scott_WUaS, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Jay8g
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
