query-4976d9e694e56b799f5a65e9b3c5c895

rq turtle/ttl

above for essentially the same question. Maybe there is some workaround. #Sort_ordering_within_a_group Above a way to concatenate some of it. You could add this in one line to the album (see below), but I don't think you can sort the songs when grouping it that way. See

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT (GROUP_CONCAT(DISTINCT ?songdesc; separator="; ") as ?s)
{
  SELECT ?song ?songLabel
    (GROUP_CONCAT(DISTINCT ?composerLabel; separator=" and ") as ?comp)
    (GROUP_CONCAT(DISTINCT ?lyrics_byLabel; separator=" and ") as ?lyri)
    (CONCAT('"', str(?songLabel), '" by ', str(?comp), " (comp.), ", str(?lyri), " (lyrics)") as ?songdesc)
  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" .  ?composer rdfs:label ?composerLabel . ?lyrics_by rdfs:label ?lyrics_byLabel . ?song rdfs:label ?songLabel }
  }
  GROUP BY ?song ?songLabel
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2017/06