query-0b3f43f2e1bfd1e40b9668f414cabb99

rq turtle/ttl

]reply[19:51, 11 May 2022 (UTC)) talk (Игорь Темиров field separated by commas? With thanks spousesHow can I make it so that if there are two wives, they are displayed not in a separate line, but in the : By using the GROUP_CONCAT aggregation function for ?spouse and/or ?spouseLabel, and use GROUP BY for the other variables in the SELECT. To aggregate over a label, you also need to use the manual version of the label service:Игорь Темиров@

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?p ?pLabel (GROUP_CONCAT(?spouse; separator=", ") AS ?spouses) (GROUP_CONCAT(?spouseLabel; separator=", ") AS ?spouseLabels) WHERE {
  BIND(wd:Q30 AS ?country)
  ?country (p:P6/ps:P6) ?p.
  ?p wdt:P26 ?spouse.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?p rdfs:label ?pLabel.
    ?spouse rdfs:label ?spouseLabel.
  }
}
GROUP BY ?p ?pLabel

Query found at

• https://www.wikidata.org/wiki/User_talk:Dipsacus_fullonum