Difference between revisions of "Stats/Languages"

Revision as of 16:38, 4 August 2021

Other languages:

Bahasa Indonesia • ‎Bahasa Melayu • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎brezhoneg • ‎euskara • ‎français • ‎galego • ‎occitan • ‎polski • ‎sicilianu • ‎svenska • ‎македонски • ‎русский • ‎עברית • ‎বাংলা • ‎தமிழ் • ‎తెలుగు

Languages by number of recordings

... Loading ...

Languages by number of speakers

... Loading ...

@@ Line 1: / Line 1: @@
 <languages/>
 <translate>
-== Number of records per languages == <!--T:1-->
+== Languages by number of recordings == <!--T:5-->
 </translate>
-<query _pagination="10" language="<translate><!--T:2--> Item (Language Qid)</translate>" code="<translate><!--T:3--> ISO 639-3 code</translate>" nb="<translate><!--T:4--> Number of records</translate>">
+<query _pagination="10" lang="<translate> Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" nb="<translate> Number of records</translate>">
-select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
+SELECT ?lang ?langLabel ?code ( count(DISTINCT ?record) as ?nb ) WHERE {
-where {
-  ?record prop:P2 entity:Q2 .
-  ?record prop:P4 ?language .
-  OPTIONAL { ?language prop:P13 ?code }
-  OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
-}
-GROUP BY ?language ?languageLabel ?code
-ORDER BY DESC(?nb)
-</query><!-- Just insert corresponding language code instead of "en" -->
-<translate>
-== Languages by numbers of record == <!--T:5-->
-</translate>
-<query>
-SELECT ?lang ?langLabel ( count(DISTINCT ?record) as ?nb ) WHERE {
    ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "en").
    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)
 </query>
 <translate>
-== Languages by numbers of recorder == <!--T:6-->
+== Languages by number of speakers == <!--T:6-->
 </translate>
-<query>
+<query _pagination="10" lang="<translate> Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" nb="<translate> Number of speakers</translate>">
-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").
    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)
 </query>

LinguaLibre

Difference between revisions of "Stats/Languages"

< LinguaLibre:Stats

Revision as of 16:38, 4 August 2021

Languages by number of recordings

Languages by number of speakers