LinguaLibre
Difference between revisions of "Stats"
(essai pour permettre la traduction) |
(il semble qu'il n'y ait pas le choix, il faut autoriser la traduction de toute la requête (pour ne traduire que les libellés)) |
||
| Line 3: | Line 3: | ||
== Global stats == | == Global stats == | ||
| − | + | ||
| − | <query records=" | + | <query records="Records" speakers="Speakers" languages="Languages"> |
SELECT | SELECT | ||
(COUNT(DISTINCT ?record) AS ?records) | (COUNT(DISTINCT ?record) AS ?records) | ||
| Line 16: | Line 16: | ||
} | } | ||
</query> | </query> | ||
| − | + | ||
== Number of records per languages == <!--T:1--> | == Number of records per languages == <!--T:1--> | ||
| − | + | ||
<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 36: | Line 36: | ||
</query> | </query> | ||
| − | |||
== The most prolific speakers == <!--T:2--> | == The most prolific speakers == <!--T:2--> | ||
| − | + | ||
<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 58: | Line 57: | ||
</query> | </query> | ||
| − | < | + | == The most recorded words == <!--T:3--> |
| − | |||
| − | |||
<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) | ||
| Line 80: | Line 77: | ||
LIMIT 50 | LIMIT 50 | ||
</query> | </query> | ||
| + | </translate> | ||