LinguaLibre
Difference between revisions of "Stats/Languages"
< LinguaLibre:Stats
WikiLucas00 (talk | contribs) (Slimming down the page, two queries were redundant) |
|||
(10 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
+ | {{LinguaLibre:Stats/Menu}} | ||
<translate> | <translate> | ||
== Languages by number of recordings == <!--T:5--> | == Languages by number of recordings == <!--T:5--> | ||
</translate> | </translate> | ||
− | <query _pagination="10" lang="<translate> Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" nb="<translate> Number of records</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>"> |
SELECT ?lang ?langLabel ?code ( count(DISTINCT ?record) as ?nb ) WHERE { | SELECT ?lang ?langLabel ?code ( count(DISTINCT ?record) as ?nb ) WHERE { | ||
− | ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = " | + | ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "[AUTO_LANGUAGE]"). |
OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . } | OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . } | ||
OPTIONAL { ?lang prop:P13 ?code } | OPTIONAL { ?lang prop:P13 ?code } | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?lang rdfs:label ?langLabel . | ||
+ | } | ||
} | } | ||
GROUP BY ?lang ?langLabel ?code | GROUP BY ?lang ?langLabel ?code | ||
Line 16: | Line 21: | ||
== Languages by number of speakers == <!--T:6--> | == Languages by number of speakers == <!--T:6--> | ||
</translate> | </translate> | ||
− | <query _pagination="10" lang="<translate> Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" nb="<translate> Number of speakers</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(DISTINCT ?recorder) as ?nb ) WHERE { | SELECT ?lang ?langLabel ?code ( count(DISTINCT ?recorder) as ?nb ) WHERE { | ||
− | ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = " | + | ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "[AUTO_LANGUAGE]"). |
OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . } | OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . } | ||
OPTIONAL { ?lang prop:P13 ?code } | OPTIONAL { ?lang prop:P13 ?code } | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?lang rdfs:label ?langLabel . | ||
+ | } | ||
} | } | ||
GROUP BY ?lang ?langLabel ?code | GROUP BY ?lang ?langLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
+ | |||
+ | == <translate>See also</translate> == | ||
+ | * [[LinguaLibre:List of languages]] | ||
+ | [[Category:Lingua Libre:DataViz{{#translation:}}]] |