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)
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
 
{{LinguaLibre:Stats/Menu}}
 
{{LinguaLibre:Stats/Menu}}
 
== Languages by number of recordings ==
 
== Languages by number of recordings ==
<query _pagination="10" lang=" Item (Language Qid)" langLabel=" Language" code=" ISO 639-3 code" nb=" Number of records">
+
<query _pagination="10" lang=" Item (Language Qid)" langLabel=" Language" code=" ISO 639-3 code" numRecords=" Number of records" numSpeakers=" Number of speakers">
SELECT ?lang ?langLabel ?code ( count(DISTINCT ?record) as ?nb ) WHERE {
+
SELECT ?lang ?langLabel ?code ?numRecords ?numSpeakers WHERE {
   ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "[AUTO_LANGUAGE]").
+
   {
  OPTIONAL { ?record prop:P4 ?lang ; prop:P2 entity:Q2 . }
+
    SELECT ?lang (COUNT(?record) as ?numRecords) WHERE {
   OPTIONAL { ?lang prop:P13 ?code }
+
      ?record prop:P4 ?lang ; prop:P2 entity:Q2
  SERVICE wikibase:label {
+
    } GROUP BY ?lang
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+
  }
     ?lang rdfs:label ?langLabel .
+
 
 +
   {
 +
    SELECT ?lang (COUNT(DISTINCT ?recorder) as ?numSpeakers) WHERE {
 +
      ?record prop:P2 entity:Q2 ;
 +
              prop:P4 ?lang ;
 +
              prop:P5 ?recorder
 +
     } GROUP BY ?lang
 
   }
 
   }
}
+
 
GROUP BY ?lang ?langLabel ?code
+
   ?lang prop:P2 entity:Q4  
ORDER BY DESC(?nb)
+
    
</query>
 
 
 
== Languages by number of speakers ==
 
<query _pagination="10" lang=" Item (Language Qid)" langLabel=" Language" code=" ISO 639-3 code" nb=" Number of speakers">
 
SELECT ?lang ?langLabel ?code ( count(DISTINCT ?recorder) as ?nb ) WHERE {
 
   ?lang prop:P2 entity:Q4 ; rdfs:label ?langLabel . FILTER (lang(?langLabel) = "[AUTO_LANGUAGE]").
 
   OPTIONAL { ?record prop:P4 ?lang ; prop:P5 ?recorder ; prop:P2 entity:Q2 . }
 
 
   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(?numRecords)
GROUP BY ?lang ?langLabel ?code
 
ORDER BY DESC(?nb)
 
 
</query>
 
</query>
  

Latest revision as of 17:27, 5 July 2024

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

Languages by number of recordings

... Loading ...

See also