query-4bea755be86772535e6c261efc480098
Liste für ein gegebenes Konsortiums, an welchem andern Konsortien dessen Participants beteiligt sind! (Von Daniel Mietchen)
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 ?Consortium1 ?Consortium1Label ?institution ?institutionLabel ?Consortium2 ?Consortium2Label
WHERE
{
?Consortium1 wdt:P31 wd:Q98270496 .
?Consortium2 wdt:P31 wd:Q98270496 .
FILTER (?Consortium1 != ?Consortium2)
?Consortium1 wdt:P1416 ?institution.
?Consortium2 wdt:P1416 ?institution.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de,en" . }
}
ORDER BY ASC(?Consortium1Label) ASC(?institution) ASC(?Consortium2Label)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?Consortium1"):::projected
v1("?Consortium1Label"):::projected
v5("?Consortium2"):::projected
v3("?Consortium2Label"):::projected
v2("?institution"):::projected
c5(["bd:serviceParam"]):::iri
c7(["#91;AUTO_LANGUAGE#93;,de,en"]):::literal
c2(["wd:Q98270496"]):::iri
f0[["?Consortium1 != ?Consortium2"]]
f0 --> v4
f0 --> v5
v4 --"wdt:P31"--> c2
v5 --"wdt:P31"--> c2
v4 --"wdt:P1416"--> v2
v5 --"wdt:P1416"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end