Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
Line 30: | Line 30: | ||
</SPARQL> | </SPARQL> | ||
=Documents= | =Documents= | ||
==Documents published in 2020== | |||
<SPARQL tryit="1"> | |||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
SELECT ?item ?itemLabel ?year | |||
WHERE | |||
{ | |||
?item wbt:P5/wbt:P4* wb:Q21. | |||
?item wbt:P18 ?published. | |||
BIND(str(YEAR(?published)) AS ?year) | |||
FILTER (?year = "2020") | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
</SPARQL> | |||
==People and how many documents they have authored== | ==People and how many documents they have authored== | ||
<SPARQL tryit="1"> | <SPARQL tryit="1"> | ||
Line 44: | Line 58: | ||
ORDER BY DESC (?count) | ORDER BY DESC (?count) | ||
</SPARQL> | </SPARQL> | ||
=Events= | =Events= | ||
==Video recordings of events of Wikimedia Sverige== | ==Video recordings of events of Wikimedia Sverige== |