LinguaLibre
Difference between revisions of "Stats/Languages/en"
< LinguaLibre:Stats
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
− | == | + | == Languages by number of recordings == |
− | <query _pagination="10" | + | <query _pagination="10" lang=" Item (Language Qid)" langLabel=" Language" code=" ISO 639-3 code" nb=" Number of records"> |
− | + | SELECT ?lang ?langLabel ?code ( count(DISTINCT ?record) as ?nb ) WHERE { | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
?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 . } | ||
+ | OPTIONAL { ?lang prop:P13 ?code } | ||
} | } | ||
− | GROUP BY ?lang ?langLabel | + | GROUP BY ?lang ?langLabel ?code |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
− | == Languages by | + | == Languages by number of speakers == |
− | <query> | + | <query _pagination="10" lang=" Item (Language Qid)" langLabel=" Language" code=" ISO 639-3 code" nb=" Number of speakers"> |
− | SELECT ?lang ?langLabel ( count(DISTINCT ?recorder) as ?nb ) WHERE { | + | SELECT ?lang ?langLabel ?code ( count(DISTINCT ?recorder) as ?nb ) WHERE { |
?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:P5 ?recorder ; prop:P2 entity:Q2 . } | OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . } | ||
+ | OPTIONAL { ?lang prop:P13 ?code } | ||
} | } | ||
− | GROUP BY ?lang ?langLabel | + | GROUP BY ?lang ?langLabel ?code |
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> |