LinguaLibre
Difference between revisions of "Stats"
(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)) |
(Marked this version for translation) |
||
| Line 2: | Line 2: | ||
<translate> | <translate> | ||
| − | == Global stats == | + | == Global stats == <!--T:4--> |
| + | <!--T:5--> | ||
<query records="Records" speakers="Speakers" languages="Languages"> | <query records="Records" speakers="Speakers" languages="Languages"> | ||
SELECT | SELECT | ||
| Line 19: | Line 20: | ||
== Number of records per languages == <!--T:1--> | == Number of records per languages == <!--T:1--> | ||
| + | <!--T:6--> | ||
<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 25: | Line 27: | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
| − | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | + | <!--T:7--> |
| + | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
| Line 38: | Line 41: | ||
== The most prolific speakers == <!--T:2--> | == The most prolific speakers == <!--T:2--> | ||
| + | <!--T:8--> | ||
<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 46: | Line 50: | ||
#extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
| − | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | + | <!--T:9--> |
| + | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
| Line 59: | Line 64: | ||
== The most recorded words == <!--T:3--> | == The most recorded words == <!--T:3--> | ||
| + | <!--T:10--> | ||
<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 68: | Line 74: | ||
?record prop:P7 ?transcription. | ?record prop:P7 ?transcription. | ||
| − | SERVICE wikibase:label { | + | <!--T:11--> |
| + | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
?language rdfs:label ?languageLabel. | ?language rdfs:label ?languageLabel. | ||