LinguaLibre
Difference between revisions of "Stats"
| Line 4: | Line 4: | ||
== Number of records per languages == | == Number of records per languages == | ||
| − | <query> | + | <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 21: | Line 21: | ||
</query> | </query> | ||
| − | == | + | == The most prolific locutors == |
| − | <query> | + | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> |
| − | select ? | + | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) |
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P5 ?locutor . | ||
?record prop:P4 ?lang . | ?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" . | ||
| − | |||
} | } | ||
} | } | ||
| − | GROUP BY ? | + | GROUP BY ?locutor ?locutorLabel |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
| − | LIMIT | + | LIMIT 50 |
</query> | </query> | ||
| − | == | + | == The most recorded words == |
| − | <query> | + | <query _pagination=10 transcription="Transcription" nb="Number of records" language="Languages"> |
| − | select ? | + | 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 . | ||
| − | |||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
| − | + | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | |
| + | |||
| + | ?record prop:P7 ?transcription. | ||
| − | |||
| − | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?language rdfs:label ?languageLabel. | ||
} | } | ||
} | } | ||
| − | GROUP BY ? | + | GROUP BY ?transcription |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
| − | LIMIT | + | LIMIT 50 |
</query> | </query> | ||
Revision as of 19:20, 24 June 2018
During the beta, data shown here are refresh only once a day.