query-fd200de87f3ddab1c3c5d53c7c32328c

rq turtle/ttl

Which organisations are in which consortium?If you replace ?s by the ID of your consortium, you can get the basis for the question "If one or more members of your consortium are participating in other NFDI consortia, please list these multiple participations here" from the interim report

Use at

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#>
#defaultView:Table
SELECT DISTINCT ?consortium ?consortiumLabel ?affiliation ?affiliationLabel
WHERE {
  ?s wdt:P1416 ?affiliation.
  wd:Q61658497 wdt:P355 ?consortium. 
  ?consortium wdt:P1416 ?affiliation.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?consortiumLabel) ASC(?affiliationLabel)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?affiliation"):::projected v2("?affiliationLabel"):::projected v5("?consortium"):::projected v1("?consortiumLabel"):::projected v3("?s") c5(["bd:serviceParam"]):::iri c2(["wd:Q61658497"]):::iri c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal v3 --"wdt:P1416"--> v4 c2 --"wdt:P355"--> v5 v5 --"wdt:P1416"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end