query-fa681793099149ce8ef0399cf4597e8c
Concatenate more values); (Q530546)Per un amico with link to the a user page page for the album. Now I have this query to have the tracklist (example for list of the albumI'm playing with discography and Wikidatalist. I have generated a page for the
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?song ?songLabel ?composerLabel ?lyrics_byLabel WHERE {
BIND(wd:Q530546 AS ?item) # this is the item of the album
?item wdt:P658 ?song.
?song wdt:P86 ?composer. # need concatenate all the composer
?song wdt:P676 ?lyrics_by # need concatenate all the lyrics by
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,it" .}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?composer")
v1("?item")
v4("?lyrics_by")
v2("?song"):::projected
c5(["bd:serviceParam"]):::iri
c7(["en,it"]):::literal
bind0[/"'wd:Q530546'"/]
bind0 --as--o v1
v1 --"wdt:P658"--> v2
v2 --"wdt:P86"--> v3
v2 --"wdt:P676"--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end