4,162
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Video recordings of events of Wikimedia Sverige
| Line 87: | Line 87: | ||
=Events= | =Events= | ||
==Number of events 2021-2022 and total number of participants== | |||
<SPARQL tryit="1"> | |||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
SELECT (count(?item) as ?total_events) (sum(?participants) as ?total_participants) | |||
WHERE | |||
{ | |||
?item wbt:P23 ?when. | |||
FILTER (?when > "2021-01-01"^^xsd:dateTime && ?when < "2022-12-31"^^xsd:dateTime) | |||
OPTIONAL{?item wbt:P28 ?participants.} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
</SPARQL> | |||
==Video recordings of events of Wikimedia Sverige== | ==Video recordings of events of Wikimedia Sverige== | ||
<SPARQL tryit="1"> | <SPARQL tryit="1"> | ||