Difference between revisions of "Speaker of the month"

Revision as of 10:17, 1 January 2023

... Loading ...

@@ Line 226: / Line 226: @@
 |1089
 |}
+== SPARQL Request for the most prolific speaker of each month ==
+<query _pagination="10" yearmonth1="Date" speaker2="Item (locutor Qid)" speakerLabel2="Speaker" max ="Number of records">
+SELECT ?yearmonth1 ?speakerLabel2 ?max WHERE {
+  {
+    SELECT ?yearmonth1 (MAX (?records1) as ?max) WHERE {
+        SELECT ?yearmonth1 ?speaker1 (COUNT (DISTINCT ?record1) AS ?records1) WHERE {
+          ?record1 prop:P2 entity:Q2 .
+          ?record1 prop:P6 ?date1 .
+          ?record1 prop:P5 ?speaker1 .
+          BIND( SUBSTR(str(?date1), 0, 8) as ?yearmonth1 )
+        }
+        GROUP BY ?yearmonth1 ?speaker1
+    }
+    GROUP BY ?yearmonth1
+  }
+  {
+    SELECT ?yearmonth2 ?speaker2 (COUNT (DISTINCT ?record2) AS ?records2) WHERE {
+      ?record2 prop:P2 entity:Q2 .
+      ?record2 prop:P6 ?date2 .
+      ?record2 prop:P5 ?speaker2 .
+      BIND( SUBSTR(str(?date2), 0, 8) as ?yearmonth2 )
+    }
+	GROUP BY ?yearmonth2 ?speaker2
+  }
+  FILTER(?yearmonth1 = ?yearmonth2)
+  FILTER(?max = ?records2)
+  SERVICE wikibase:label {
+    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+    ?speaker2 rdfs:label ?speakerLabel2 .
+  }
+}
+ORDER BY DESC(?yearmonth1)
+</query>