LinguaLibre

Difference between revisions of "Stats/Languages"

< LinguaLibre:Stats

(revert while the community has not agreed for a language-specific section (cf Talk page))
Tag: Undo
 
(5 intermediate revisions by one other user not shown)
Line 28: Line 28:
 
</translate>
 
</translate>
 
<query _pagination="10" lang="<translate> <!--T:11--> Item (Language Qid)</translate>" langLabel="<translate> <!--T:12--> Language</translate>" code="<translate> <!--T:13--> ISO 639-3 code</translate>" nb="<translate> <!--T:14--> Number of speakers</translate>">
 
<query _pagination="10" lang="<translate> <!--T:11--> Item (Language Qid)</translate>" langLabel="<translate> <!--T:12--> Language</translate>" code="<translate> <!--T:13--> ISO 639-3 code</translate>" nb="<translate> <!--T:14--> Number of speakers</translate>">
SELECT ?lang ?langLabel ?code ?videos ?signers
+
SELECT ?lang ?langLabel ?code (COUNT(?recorder) as ?nb) WHERE {
WHERE {
 
  ?lang prop:P2 entity:Q4 ;    #  instance of (P2) is language (Q4)
 
        prop:P24 entity:Q88890 .#  of type (P24) hand signed (Q88890)
 
  {
 
    SELECT ?lang (COUNT(?record) as ?videos)
 
    WHERE {
 
      ?record prop:P4 ?lang ;  # language (P4) is ?lang
 
              prop:P2 entity:Q2 # instance of (P2) is record (Q2)
 
    } GROUP BY ?lang
 
  }
 
  {
 
    SELECT ?lang (COUNT(DISTINCT ?signer) as ?signers)
 
    WHERE {
 
      ?record prop:P4 ?lang ;  # language (P4) is ?lang
 
              prop:P5 ?signer. # instance of (P2) is speaker (Q3)
 
    } GROUP BY ?lang
 
  }
 
  OPTIONAL { ?lang prop:P13 ?code }
 
  SERVICE wikibase:label {
 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
    ?lang rdfs:label ?langLabel .
 
  }
 
} ORDER BY DESC(?videos)
 
</query>
 
  
 
+
  {
<translate>
+
      SELECT ?lang ?recorder WHERE {
== Signed languages by videos and speakers ==
+
        ?record prop:P2 entity:Q2 ;
</translate>
+
                prop:P4 ?lang ;
<query _pagination="10" lang="<translate>Item (Language Qid)</translate>" langLabel="<translate> Language</translate>" code="<translate> ISO 639-3 code</translate>" videos="<translate> Number of videos</translate>"> signers="<translate> Number of signers</translate>">
+
                prop:P5 ?recorder
SELECT ?lang ?langLabel ?code ?videos ?signers
+
      } GROUP BY ?lang ?recorder
WHERE {
 
  ?lang prop:P2 entity:Q4 ;     #  instance of (P2) is language (Q4)
 
        prop:P24 entity:Q88890 . #  of type (P24) hand signed (Q88890)
 
  {
 
    SELECT ?lang (COUNT(?record) as ?videos)
 
    WHERE {
 
      ?record prop:P4 ?lang ;   # language (P4) is ?lang
 
              prop:P2 entity:Q2  # instance of (P2) is record (Q2)
 
    } GROUP BY ?lang
 
 
   }
 
   }
   {
+
    
    SELECT ?lang (COUNT(DISTINCT ?signer) as ?signers)
+
  ?lang prop:P2 entity:Q4 .
    WHERE {
+
    
      ?record prop:P4 ?lang ;    # language (P4) is ?lang
 
              prop:P5 ?signer.   # instance of (P2) is speaker (Q3)
 
    } GROUP BY ?lang
 
   }
 
 
 
 
   OPTIONAL { ?lang prop:P13 ?code }
 
   OPTIONAL { ?lang prop:P13 ?code }
 +
 
 
   SERVICE wikibase:label {
 
   SERVICE wikibase:label {
 
     bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
     bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
     ?lang rdfs:label ?langLabel .
 
     ?lang rdfs:label ?langLabel .
 
   }
 
   }
} ORDER BY DESC(?videos)
+
} GROUP BY ?lang ?langLabel ?code
 +
ORDER BY DESC(?nb)
 
</query>
 
</query>
  

Latest revision as of 15:24, 20 October 2023

Other languages:
Bahasa Indonesia • ‎Bahasa Melayu • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎brezhoneg • ‎euskara • ‎français • ‎galego • ‎occitan • ‎polski • ‎sicilianu • ‎svenska • ‎Ελληνικά • ‎македонски • ‎русский • ‎עברית • ‎বাংলা • ‎தமிழ் • ‎తెలుగు
View statistics about:

Languages by number of recordings

... Loading ...


Languages by number of speakers

... Loading ...

See also