4,466
edits
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> |