Difference between revisions of "Stats/de"

Revision as of 21:40, 10 October 2020

Other languages:

Bahasa Indonesia • ‎Bahasa Melayu • ‎Bali • ‎Bikol Central • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎Toki Pona • ‎Türkçe • ‎asturianu • ‎brezhoneg • ‎català • ‎español • ‎français • ‎galego • ‎lumbaart • ‎occitan • ‎polski • ‎română • ‎sicilianu • ‎svenska • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ

Globale Statistiken

... Loading ...

Monatliche Aktivität

... Loading ...

SELECT ?yearmonth (COUNT(DISTINCT ?record) AS ?records) (COUNT(DISTINCT ?speaker) AS ?speakers) (COUNT(DISTINCT ?language) AS ?languages) WHERE {

 ?record prop:P2 entity:Q2 .
 ?record prop:P6 ?date .
 ?record prop:P5 ?speaker .
 ?record prop:P4 ?language .
 BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )

} GROUP BY ?yearmonth ORDER BY ?yearmonth </query>

Anzahl Aufnahmen pro Sprache

... Loading ...

select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) where {

 ?record prop:P2 entity:Q2 .
 ?record prop:P4 ?language .
 OPTIONAL { ?language prop:P13 ?code }
 OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). }

} GROUP BY ?language ?languageLabel ?code ORDER BY DESC(?nb) </query>

Aktivste Sprecher

... Loading ...

   select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
   where {
       ?record prop:P2 entity:Q2 .
       ?record prop:P5 ?locutor .
       ?record prop:P4 ?lang .
       #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
       SERVICE wikibase:label {
           bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
           ?locutor rdfs:label ?locutorLabel .
       }
   }
   GROUP BY ?locutor ?locutorLabel
   ORDER BY DESC(?nb)
   LIMIT 50

</query>

@@ Line 19: / Line 19: @@
 }
 </query>
-<div class="mw-translate-fuzzy">
 == Monatliche Aktivität ==
-</div>
 <div class="mw-translate-fuzzy">