LinguaLibre
Difference between revisions of "Stats"
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | <translate> | ||
== Number of records per languages == | == Number of records per languages == | ||
+ | </translate> | ||
<query _pagination="10" language="Item" name="Language" nb="Number of records"> | <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) | ||
Line 17: | Line 20: | ||
</query> | </query> | ||
+ | <translate> | ||
== The most prolific locutors == | == The most prolific locutors == | ||
+ | </translate> | ||
<query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | ||
select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
Line 37: | Line 42: | ||
</query> | </query> | ||
+ | <translate> | ||
== The most recorded words == | == The most recorded words == | ||
+ | </translate> | ||
<query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages"> | <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) | select ?transcription (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT (if( ?language = entity:Q4, '???', ?languageLabel )); SEPARATOR=", ") AS ?languages) |