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 {... ») |
|||
| Line 13: | Line 13: | ||
} | } | ||
} | } | ||
| − | GROUP BY ?language ?languageLabel | + | GROUP BY ?language ?languageLabel |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
| Line 33: | Line 33: | ||
} | } | ||
GROUP BY ?transcription | GROUP BY ?transcription | ||
| + | ORDER BY DESC(?nb) | ||
| + | LIMIT 10 | ||
| + | </query> | ||
| + | |||
| + | == 10 most prolific locutors == | ||
| + | <query> | ||
| + | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | ||
| + | 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 { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | } | ||
| + | } | ||
| + | GROUP BY ?locutor ?locutorLabel | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
LIMIT 10 | LIMIT 10 | ||
</query> | </query> | ||