LinguaLibre
Difference between revisions of "Stats/Languages"
< LinguaLibre:Stats
(first draft) |
(over 60 % more performance with this query with identical results (~ 40 seconds -> 11-15 seconds)) |
||
(19 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | == Languages by | + | <languages/> |
− | <query> | + | {{LinguaLibre:Stats/Menu}} |
− | SELECT ?lang ?langLabel ( | + | <translate> |
− | ?lang prop:P2 entity:Q4 | + | == Languages by number of recordings == <!--T:5--> |
− | + | </translate> | |
− | } | + | <query _pagination="10" lang="<translate> <!--T:7--> Item (Language Qid)</translate>" langLabel="<translate> <!--T:8--> Language</translate>" code="<translate> <!--T:9--> ISO 639-3 code</translate>" nb="<translate> <!--T:10--> Number of records</translate>"> |
− | GROUP BY ?lang ?langLabel | + | SELECT ?lang ?langLabel ?code ?nb WHERE { |
+ | { | ||
+ | SELECT ?lang (COUNT(?record) as ?nb) WHERE { | ||
+ | ?record prop:P4 ?lang ; prop:P2 entity:Q2 | ||
+ | } GROUP BY ?lang | ||
+ | } | ||
+ | |||
+ | ?lang prop:P2 entity:Q4 | ||
+ | |||
+ | OPTIONAL { ?lang prop:P13 ?code } | ||
+ | |||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?lang rdfs:label ?langLabel . | ||
+ | } | ||
+ | } ORDER BY DESC(?nb) | ||
+ | </query> | ||
+ | |||
+ | <translate> | ||
+ | |||
+ | == Languages by number of speakers == <!--T:6--> | ||
+ | </translate> | ||
+ | <query _pagination="10" lang="<translate> <!--T:11--> Item (Language Qid)</translate>" langLabel="<translate> <!--T:12--> Language</translate>" code="<translate> <!--T:13--> ISO 639-3 code</translate>" nb="<translate> <!--T:14--> Number of speakers</translate>"> | ||
+ | SELECT ?lang ?langLabel ?code (COUNT(?recorder) as ?nb) WHERE { | ||
+ | |||
+ | { | ||
+ | SELECT ?lang ?recorder WHERE { | ||
+ | ?record prop:P2 entity:Q2 ; | ||
+ | prop:P4 ?lang ; | ||
+ | prop:P5 ?recorder | ||
+ | } GROUP BY ?lang ?recorder | ||
+ | } | ||
+ | |||
+ | ?lang prop:P2 entity:Q4 . | ||
+ | |||
+ | OPTIONAL { ?lang prop:P13 ?code } | ||
+ | |||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?lang rdfs:label ?langLabel . | ||
+ | } | ||
+ | } GROUP BY ?lang ?langLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
+ | |||
+ | <translate> | ||
+ | == See also == <!--T:20--></translate> | ||
+ | * [[LinguaLibre:List of languages]] | ||
+ | |||
+ | [[Category:Lingua Libre:DataViz{{#translation:}}]] |
Revision as of 19:17, 20 May 2023
Languages by number of recordings