LinguaLibre

Difference between revisions of "Stats/Languages"

< LinguaLibre:Stats

(+ Menu)
(Merge two queries into a single one)
 
(20 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
<languages/>
 
<languages/>
 
+
{{LinguaLibre:Stats/Menu}}
{{Colored box
 
| background-content-color =
 
| background-title-color = #3366CC
 
| icon = Icon Stats color.svg
 
| title = <translate> <!--T:1--> View statistics about:</translate>
 
| title-color = white
 
| link =
 
| link-color =
 
| view-text =
 
| content = <center>
 
{{Clickable button 2|Special:MyLanguage/LL:Stats|<translate><!--T:2--> Global stats</translate>|class=mw-ui-progressive}}
 
{{Clickable button 2|Special:MyLanguage/LL:Stats/Languages|<translate><!--T:3--> Languages</translate>|class=mw-ui-progressive}}
 
{{Clickable button 2|Special:MyLanguage/LL:Stats/Speakers|<translate><!--T:4--> Speakers</translate>|class=mw-ui-progressive}}
 
{{Clickable button 2|Special:MyLanguage/LL:Stats/Time|<translate><!--T:5--> Chronological</translate>|class=mw-ui-progressive}}
 
</center>
 
}}
 
 
<translate>
 
<translate>
 
== Languages by number of recordings == <!--T:5-->
 
== Languages by number of recordings == <!--T: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>" numRecords="<translate> <!--T:10--> Number of records</translate>" numSpeakers="<translate> <!--T:14--> Number of speakers</translate>">
SELECT ?lang ?langLabel ?code ( count(DISTINCT ?record) as ?nb ) WHERE {
+
SELECT ?lang ?langLabel ?code ?numRecords ?numSpeakers WHERE {
  ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en").
+
  {
  OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . }
+
    SELECT ?lang (COUNT(?record) as ?numRecords) WHERE {
 +
      ?record prop:P4 ?lang ; prop:P2 entity:Q2
 +
    } GROUP BY ?lang
 +
  }
 +
 
 +
  {
 +
    SELECT ?lang (COUNT(DISTINCT ?recorder) as ?numSpeakers) WHERE {
 +
      ?record prop:P2 entity:Q2 ;
 +
              prop:P4 ?lang ;
 +
              prop:P5 ?recorder
 +
    } GROUP BY ?lang
 +
  }
 +
 
 +
  ?lang prop:P2 entity:Q4
 +
 
 
   OPTIONAL { ?lang prop:P13 ?code }
 
   OPTIONAL { ?lang prop:P13 ?code }
}
+
         
GROUP BY ?lang ?langLabel ?code
+
  SERVICE wikibase:label {
ORDER BY DESC(?nb)
+
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
    ?lang rdfs:label ?langLabel .
 +
  }
 +
} ORDER BY DESC(?numRecords)
 
</query>
 
</query>
  
 
<translate>
 
<translate>
== Languages by number of speakers == <!--T:6-->
+
== See also == <!--T:20--></translate>
</translate>
+
* [[LinguaLibre:List of languages]]
<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 {
+
[[Category:Lingua Libre:DataViz{{#translation:}}]]
  ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en").
 
  OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . }
 
  OPTIONAL { ?lang prop:P13 ?code }
 
}
 
GROUP BY ?lang ?langLabel ?code
 
ORDER BY DESC(?nb)
 
</query>
 

Latest revision as of 17:27, 5 July 2024

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

Languages by number of recordings

... Loading ...

See also