LinguaLibre
Difference between revisions of "Stats/Languages"
< LinguaLibre:Stats
(first draft) |
(→Languages by numbers of record: + people) |
||
| Line 4: | Line 4: | ||
?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en"). | ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en"). | ||
OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . } | OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . } | ||
| + | } | ||
| + | GROUP BY ?lang ?langLabel | ||
| + | ORDER BY DESC(?nb) | ||
| + | </query> | ||
| + | |||
| + | == Languages by numbers of recorder == | ||
| + | <query> | ||
| + | SELECT ?lang ?langLabel ( count(DISTINCT ?recorder) as ?nb ) WHERE { | ||
| + | ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en"). | ||
| + | OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . } | ||
} | } | ||
GROUP BY ?lang ?langLabel | GROUP BY ?lang ?langLabel | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||