4,162
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Most common locations for WMSE events
(→Events) |
|||
| Line 88: | Line 88: | ||
=Events= | =Events= | ||
==Most common locations for WMSE events== | ==Most common locations for WMSE events== | ||
<SPARQL tryit="1"> | |||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
#defaultView:BubbleChart | |||
SELECT ?location ?locationLabel (COUNT(?item) AS ?count) | |||
WHERE | |||
{ | |||
?item wbt:P5/wbt:P4* wb:Q40 . | |||
?item wbt:P27 ?location. | |||
?item wbt:P14 wb:Q9. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
GROUP BY ?location ?locationLabel | |||
ORDER BY DESC(?count) | |||
</SPARQL> | |||
==Number of events 2021-2022 and total number of participants== | ==Number of events 2021-2022 and total number of participants== | ||
<SPARQL tryit="1"> | <SPARQL tryit="1"> | ||