LinguaLibre

Difference between revisions of "Stats"

(Page créée avec « == Number of records per languages == <query> select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb) where {... »)
 
m (0x010C moved page DataViz:Stats to LinguaLibre:Stats without leaving a redirect: Part of translatable page "DataViz:Stats")
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Number of records per languages ==
+
<languages/>
<query>
+
<translate>
 +
== Number of records per languages == <!--T:1-->
 +
</translate>
 +
<query _pagination="10" language="Item" name="Language" nb="Number of records">
 
     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
 
     select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb)
 
     where {
 
     where {
Line 13: Line 16:
 
         }
 
         }
 
     }
 
     }
     GROUP BY ?language ?languageLabel ?patate
+
     GROUP BY ?language ?languageLabel
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
 
</query>
 
</query>
  
== 10 most recorded words ==
+
<translate>
<query>
+
== The most prolific speakers == <!--T:2-->
     select ?transcription (COUNT(?record) as ?nb) (COUNT(DISTINCT ?language) as ?nbLanguages) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages)
+
</translate>
 +
<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>
 +
 
 +
<translate>
 +
 
 +
== The most recorded words == <!--T:3-->
 +
</translate>
 +
<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 {
 
     where {
 
         ?record prop:P2 entity:Q2 .
 
         ?record prop:P2 entity:Q2 .
Line 25: Line 53:
 
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 
        
 
        
         ?record prop:P8 ?transcription.
+
         ?record prop:P7 ?transcription.
  
 
         SERVICE wikibase:label {
 
         SERVICE wikibase:label {
Line 34: Line 62:
 
     GROUP BY ?transcription
 
     GROUP BY ?transcription
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
     LIMIT 10
+
     LIMIT 50
 
</query>
 
</query>

Revision as of 09:25, 25 December 2018

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

Number of records per languages

... Loading ...

The most prolific speakers

... Loading ...


The most recorded words

... Loading ...