NOSAD-POC: Difference between revisions

NOSAD-POC (view source)

787 bytes added , 1 year ago

798

edits

@@ Line 130: / Line 130: @@
 }
 ORDER BY ?spkrLabel
+</sparql>
+#### Inlägg Sveriges Dataportal skapat av talare per org
+<sparql tryit="1">
+#title: Talare NOSAD som finns på Sveriges Dataportal och har skapat inlägg per org
+#defaultView:BarChart
+PREFIX od: <https://oswald.wikibase.cloud/entity/>
+PREFIX odt: <https://oswald.wikibase.cloud/prop/direct/>
+PREFIX odp: <https://oswald.wikibase.cloud/prop/>
+PREFIX odpq: <https://oswald.wikibase.cloud/prop/qualifier/>
+SELECT  ?orgLabel (sum(?NumberPosts) AS ?AkrivitetDataportalen)
+WHERE {
+  ?pres odt:P12 od:Q157 . # a Presentation
+  ?pres odt:P13 ?spkr .
+  ?pres odt:P14 ?org.
+  ?spkr odp:P31 ?DPidP.
+  ?DPidP odpq:P41 ?NumberPosts.
+  SERVICE wikibase:label {
+    bd:serviceParam wikibase:language "sv,en".
+  }
+} group by ?orgLabel
+order by desc(xsd:integer(?AkrivitetDataportalen))
 </sparql>
 [[category:SPARQL]]