798
edits
Magnus Sälgö (talk | contribs) |
Magnus Sälgö (talk | contribs) |
||
Line 130: | Line 130: | ||
} | } | ||
ORDER BY ?spkrLabel | 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> | </sparql> | ||
[[category:SPARQL]] | [[category:SPARQL]] |