Difference between revisions of "Stats/ja"

Revision as of 13:27, 5 May 2021

Other languages:

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

世界の統計

... Loading ...

毎月の統計

... Loading ...

言語ごとの録音数

... Loading ...

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

... Loading ...

The most prolific speakers for the current month

... Loading ...

@@ Line 54: / Line 54: @@
 == 最も投稿の多いスピーカー ==
+<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records">
+SELECT ?locutor ?locutorLabel ?nb WHERE {
+  {
+    SELECT ?locutor (COUNT(?record) as ?nb)
+    WHERE {
+        ?record prop:P2 entity:Q2 .         # Q2: record, P2: instance of.
+        ?record prop:P5 ?locutor .          # Property:P5: speaker
+    }
+    GROUP BY ?locutor ?locutorLabel
+    ORDER BY DESC(?nb)
+    LIMIT 50
+  }
+  SERVICE wikibase:label {
+    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+    ?locutor rdfs:label ?locutorLabel .
+  }
+}
+ORDER BY DESC(?nb)
+</query>
+== The most prolific speakers for the current month ==
-<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
+<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records for the current month">
 SELECT ?locutor ?locutorLabel ?nb WHERE {
    {
      SELECT ?locutor (COUNT(?record) as ?nb)
      WHERE {
-         ?record prop:P2 entity:Q2 .
+         ?record prop:P2 entity:Q2 .         # Q2: record, P2: instance of.
-         ?record prop:P5 ?locutor .
+         ?record prop:P5 ?locutor .          # Property:P5: speaker
+        ?record prop:P6 ?date .
+      FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) )
      }
      GROUP BY ?locutor ?locutorLabel