Difference between revisions of "Stats/ja"

Revision as of 22:01, 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 • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ

世界の統計

... Loading ...

毎月の統計

... Loading ...

言語ごとの録音数

... 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>

最も投稿の多いスピーカー

... 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 20: / Line 20: @@
 == 毎月の統計==
-<div class="mw-translate-fuzzy">
+<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
-<query yearmonth="Date" records="New records" speakers="New speakers" languages="New languages">
-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>
-</div>
 SELECT
 ?yearmonth