Difference between revisions of "Stats/Languages"

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:

Global stats Languages Speakers Chronological

Languages by number of recordings

... Loading ...

@@ Line 1: / Line 1: @@
 <languages/>
+{{LinguaLibre:Stats/Menu}}
-{{Colored box
-| background-content-color =
-| background-title-color = #3366CC
-| icon = Icon Stats color.svg
-| title = <translate> <!--T:15--> View statistics about:</translate>
-| title-color = white
-| link =
-| link-color =
-| view-text =
-| content = <center>
-{{Clickable button 2|Special:MyLanguage/LL:Stats|<translate> <!--T:16--> Global stats</translate>|class=mw-ui-progressive}}
-{{Clickable button 2|Special:MyLanguage/LL:Stats/Languages|<translate> <!--T:17--> Languages</translate>|class=mw-ui-progressive}}
-{{Clickable button 2|Special:MyLanguage/LL:Stats/Speakers|<translate> <!--T:18--> Speakers</translate>|class=mw-ui-progressive}}
-{{Clickable button 2|Special:MyLanguage/LL:Stats/Time|<translate> <!--T:19--> Chronological</translate>|class=mw-ui-progressive}}
-</center>
-}}
 <translate>
 == 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>">
+<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) = "[AUTO_LANGUAGE],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 }
    SERVICE wikibase:label {
      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
      ?lang rdfs:label ?langLabel .
    }
-}
+} ORDER BY DESC(?numRecords)
-GROUP BY ?lang ?langLabel ?code
-ORDER BY DESC(?nb)
 </query>
 <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>