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 {... ») |
(+Languages) |
||
(20 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | == Number of records per languages == | + | <languages/> |
− | <query> | + | <translate> |
+ | |||
+ | == Global stats == <!--T:4--> | ||
+ | |||
+ | <!--T:5--> | ||
+ | <query records="Records" speakers="Speakers" languages="Languages"> | ||
+ | SELECT | ||
+ | (COUNT(DISTINCT ?record) AS ?records) | ||
+ | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
+ | (COUNT(DISTINCT ?language) AS ?languages) | ||
+ | WHERE { | ||
+ | ?record prop:P2 entity:Q2 . | ||
+ | ?record prop:P6 ?date . | ||
+ | ?record prop:P5 ?speaker . | ||
+ | ?record prop:P4 ?language . | ||
+ | } | ||
+ | </query> | ||
+ | |||
+ | == Number of records per languages == <!--T:1--> | ||
+ | |||
+ | <!--T:6--> | ||
+ | <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 { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
+ | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
+ | |||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?language rdfs:label ?languageLabel. | ||
+ | } | ||
+ | } | ||
+ | GROUP BY ?language ?languageLabel | ||
+ | ORDER BY DESC(?nb) | ||
+ | </query> | ||
− | + | == The most prolific speakers == <!--T:2--> | |
+ | |||
+ | <!--T:8--> | ||
+ | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> | ||
+ | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT ?langLabel;separator=", ") as ?languages) | ||
+ | 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 { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
− | ? | + | ?lang rdfs:label ?langLabel . |
+ | ?locutor rdfs:label ?locutorLabel . | ||
} | } | ||
} | } | ||
− | GROUP BY ? | + | GROUP BY ?locutor ?locutorLabel |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
+ | LIMIT 50 | ||
</query> | </query> | ||
− | == | + | == The most recorded words == <!--T:3--> |
− | <query> | + | |
− | select ?transcription (COUNT(?record) as ?nb | + | <!--T:10--> |
+ | <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 70: | ||
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
− | ?record prop: | + | ?record prop:P7 ?transcription. |
− | + | 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. | ||
Line 34: | Line 78: | ||
GROUP BY ?transcription | GROUP BY ?transcription | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
− | LIMIT | + | LIMIT 50 |
</query> | </query> | ||
+ | </translate> |