Difference between revisions of "Stats/oc"

Latest revision as of 12:58, 8 October 2023

Other languages:

Bahasa Indonesia • ‎Bahasa Melayu • ‎Bali • ‎Bikol Central • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎Toki Pona • ‎Türkçe • ‎asturianu • ‎brezhoneg • ‎català • ‎español • ‎français • ‎galego • ‎lumbaart • ‎occitan • ‎polski • ‎română • ‎sicilianu • ‎svenska • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ

View statistics about:

Global stats Languages Speakers Chronological

Estatisticas globalas

... Loading ...

@@ Line 1: / Line 1: @@
-<languages/>
+__NOTOC__
-== Number of records per languages ==
+<languages/><indicator name="stats"></indicator>{{#SUBTITLE: Lingua Libre alpha espeliguèt en agost de 2018. Lo primièr d'abrial de 2019, "Lili" comptava  pas mens de 100 000 enregistraments   realizats dins 46 lengas, mercé a 128 locutors diferents. En genièr de 2020, i aviá mai de 200 000 enregistraments dins 82 lengas, mercé a 268 locutors.En junh de 2021,  i aviá 500 000 enregistraments (dins 120  lengas, mercé a 538 locutors) e en octobre de 2023, 1 000 000 (dins 200 lengas, mercé a 1300 locutors).}}{{LinguaLibre:Stats/Menu}}
-<query _pagination="10" language="Item" name="Language" nb="Number of records">
+== Estatisticas globalas ==
-    select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
+<query records="Enregistraments" speakers="Locutors" languages="Lengas">
-    where {
+SELECT
-        ?record prop:P2 entity:Q2 .
+(COUNT(DISTINCT ?record) AS ?records)
-        ?record prop:P4 ?lang .
+(COUNT(DISTINCT ?speaker) AS ?speakers)
+(COUNT(DISTINCT ?language) -2 AS ?languages) # Accounting for the 2 duplicata languages
-      	BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+# see Help:SPARQL_for_maintenance#.E2.9C.85_Languages_.E2.86.92_list_of_values_used_including_redirects
+WHERE {
-        SERVICE wikibase:label {
+  ?record prop:P2 entity:Q2 .
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+  ?record prop:P5 ?speaker .
-            ?language  rdfs:label ?languageLabel.
+  ?record prop:P4 ?language .
-        }
+}
-    }
-    GROUP BY ?language ?languageLabel
-    ORDER BY DESC(?nb)
-</query>
-== Locutors los mai prolifics ==
-<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records">
-    select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
-    where {
-        ?record prop:P2 entity:Q2 .
-        ?record prop:P5 ?locutor .
-        ?record prop:P4 ?lang .
-        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
-      	BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
-        SERVICE wikibase:label {
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-        }
-    }
-    GROUP BY ?locutor ?locutorLabel
-    ORDER BY DESC(?nb)
-    LIMIT 50
-</query>
-== Mots los mai enregistrats ==
-<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages">
-    select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
-    where {
-        ?record prop:P2 entity:Q2 .
-        ?record prop:P4 ?lang .
-		BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
-        ?record prop:P7 ?transcription.
-        SERVICE wikibase:label {
-            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-            ?language  rdfs:label ?languageLabel.
-        }
-    }
-    GROUP BY ?transcription
-    ORDER BY DESC(?nb)
-    LIMIT 50
 </query>