Addshore created this task.
Addshore added a subscriber: Addshore.
Addshore added projects: WMDE-Analytics-Engineering, Wikidata.
Herald added subscribers: StudiesWorld, Aklapper.
TASK DESCRIPTION
In order to see the coverage of wikidata by language.
The following could be used for user interface language
```
SELECT
count(*) as count,
COALESCE(up_value,'en') AS language
FROM user
LEFT JOIN
( SELECT up_user, up_value FROM user_properties WHERE
user_properties.up_property = 'language' ) AS b
ON user.user_id = b.up_user
GROUP BY language
ORDER BY count;
```
Babel languages may be a better indication but where can these be found?
TASK DETAIL
https://phabricator.wikimedia.org/T119068
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Aklapper, Addshore, StudiesWorld, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
