LinguaLibre
Difference between revisions of "Stats/Languages"
< LinguaLibre:Stats
(Marked this version for translation) |
(Optimizing query - Now only requires ~ 6 seconds to load) |
||
| Line 5: | Line 5: | ||
</translate> | </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>"> | <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 ( | + | 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 } | OPTIONAL { ?lang prop:P13 ?code } | ||
| + | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
?lang rdfs:label ?langLabel . | ?lang rdfs:label ?langLabel . | ||
} | } | ||
| − | } | + | } ORDER BY DESC(?nb) |
| − | |||
| − | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
<translate> | <translate> | ||
| + | |||
== Languages by number of speakers == <!--T:6--> | == Languages by number of speakers == <!--T:6--> | ||
</translate> | </translate> | ||
Revision as of 18:20, 20 May 2023
Languages by number of recordings