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 ( count(DISTINCT ?record) as ?nb ) WHERE {
+
SELECT ?lang ?langLabel ?code ?nb WHERE {
  ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "[AUTO_LANGUAGE]").
+
  {
   OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . }
+
    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)
GROUP BY ?lang ?langLabel ?code
 
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

Other languages:
Bahasa Indonesia • ‎Bahasa Melayu • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎brezhoneg • ‎euskara • ‎français • ‎galego • ‎occitan • ‎polski • ‎sicilianu • ‎svenska • ‎македонски • ‎русский • ‎עברית • ‎বাংলা • ‎தமிழ் • ‎తెలుగు
View statistics about:

Languages by number of recordings

... Loading ...


Languages by number of speakers

... Loading ...

See also