Difference between revisions of "Stats/Languages/en"

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/>
-== Number of records per languages ==
+{{LinguaLibre:Stats/Menu}}
-<query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records">
+== Languages by number of recordings ==
-select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
+<query _pagination="10" lang=" Item (Language Qid)" langLabel=" Language" code=" ISO 639-3 code" numRecords=" Number of records" numSpeakers=" Number of speakers">
-where {
+SELECT ?lang ?langLabel ?code ?numRecords ?numSpeakers WHERE {
-  ?record prop:P2 entity:Q2 .
+  {
-   ?record prop:P4 ?language .
+    SELECT ?lang (COUNT(?record) as ?numRecords) WHERE {
-   OPTIONAL { ?language prop:P13 ?code }
+      ?record prop:P4 ?lang ; prop:P2 entity:Q2
-   OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
+    } GROUP BY ?lang
-}
+  }
-GROUP BY ?language ?languageLabel ?code
-ORDER BY DESC(?nb)
+   {
-</query><!-- Just insert corresponding language code instead of "en" -->
+    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)
+</query>
-== Languages by numbers of record ==
+== See also ==
-<query>
+* [[LinguaLibre:List of languages]]
-SELECT ?lang ?langLabel ( count(DISTINCT ?record) as ?nb ) WHERE {
-  ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en").
-  OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . }
-}
-GROUP BY ?lang ?langLabel
-ORDER BY DESC(?nb)
-</query>
-== Languages by numbers of recorder ==
+[[Category:Lingua Libre:DataViz{{#translation:}}]]
-<query>
-SELECT ?lang ?langLabel ( count(DISTINCT ?recorder) as ?nb ) WHERE {
-  ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en").
-  OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . }
-}
-GROUP BY ?lang ?langLabel
-ORDER BY DESC(?nb)
-</query>