4,162
edits
User:Alicia Fagerving (WMSE)/Sandbox: Difference between revisions
Jump to navigation
Jump to search
User:Alicia Fagerving (WMSE)/Sandbox (view source)
Revision as of 09:17, 27 March 2024
, 3 months agono edit summary
No edit summary Tag: Reverted |
No edit summary Tag: Reverted |
||
| Line 85: | Line 85: | ||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | PREFIX wb: <https://metabase.wikibase.cloud/entity/> | ||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | ||
SELECT ?item ?itemLabel ?when | SELECT ?item ?itemLabel ?when (GROUP_CONCAT(DISTINCT ?speakerLabel; SEPARATOR = ", ") AS ?speakers) | ||
WHERE | WHERE | ||
{ | { | ||
?item wbt:P17 wb:Q22660. | ?item wbt:P17 wb:Q22660. | ||
OPTIONAL {?item wbt:P23 ?when} | OPTIONAL {?item wbt:P23 ?when} | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,es | OPTIONAL {?item wbt:P33 ?speaker} | ||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "en,sv,es". | |||
?item rdfs:label ?itemLabel. | |||
?speaker rdfs:label ?speakerLabel. | |||
} | |||
} | } | ||
GROUP BY ?item ?itemLabel ?when | |||
ORDER BY ?when | ORDER BY ?when | ||
</SPARQL> | </SPARQL> | ||