LinguaLibre
Difference between revisions of "Stats/Languages"
< LinguaLibre:Stats
(over 60 % more performance with this query with identical results (~ 40 seconds -> 11-15 seconds)) |
|||
(5 intermediate revisions by the same user not shown) | |||
Line 48: | Line 48: | ||
} GROUP BY ?lang ?langLabel ?code | } GROUP BY ?lang ?langLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
+ | </query> | ||
+ | |||
+ | |||
+ | <translate> | ||
+ | == Signed languages by number of signers and videos == | ||
+ | </translate> | ||
+ | <query _pagination="10" lang="<translate>Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" signers="<translate> Number of signers</translate>" videos="<translate> Number of videos</translate>"> | ||
+ | SELECT ?lang ?langLabel ?code (COUNT(DISTINCT ?signer) as ?signers) (COUNT(?record) as ?videos) | ||
+ | WHERE { | ||
+ | ?lang prop:P2 entity:Q4 ; # instance of (P2) is language (Q4) | ||
+ | prop:P24 entity:Q88890 . # of type (P24) hand signed (Q88890) | ||
+ | OPTIONAL { ?lang prop:P13 ?code } | ||
+ | ?record prop:P4 ?lang ; # language (P4) is ?lang | ||
+ | prop:P5 ?signer. # instance of (P2) is speaker (Q3) | ||
+ | ?record prop:P2 entity:Q2. # instance of (P2) is record (Q2) | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | } | ||
+ | } | ||
+ | GROUP BY ?lang ?langLabel ?code | ||
+ | ORDER BY DESC(?videos) | ||
</query> | </query> | ||
Revision as of 12:09, 16 October 2023
Languages by number of recordings
Languages by number of speakers