query-e8d914fc168011e3b1041b87fa0df4d4
...als Graph ...as a graph with DFG disciplines only
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Graph
#SELECT ?p ?pLabel ("EC0000" AS ?rgb) ?topic (CONCAT(?dfgTopic,?topicLabel) AS ?topicLabelFull) ?dfgTopic ?topicLabel
SELECT ?p ?pLabel ("EC0000" AS ?rgb) ?discipline (?dfgdisciplineName AS ?disciplineLabel)
WHERE
{
?p wdt:P31 wd:Q98270496 .
?p wdt:P101 ?discipline .
?discipline p:P10287 ?statement .
?statement ps:P10287 ?dfgdisciplineID .
OPTIONAL {?statement pq:P1810 ?dfgdisciplineName}
SERVICE wikibase:label {bd:serviceParam wikibase:language "de, en"}
} ORDER BY ASC(?pLabel) ASC(?dfgdisciplineName)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?dfgdisciplineID")
v2("?dfgdisciplineName"):::projected
v4("?discipline"):::projected
v8("?disciplineLabel")
v3("?p"):::projected
v1("?pLabel"):::projected
v7("?rgb")
v5("?statement")
c8(["bd:serviceParam"]):::iri
c10(["de, en"]):::literal
c2(["wd:Q98270496"]):::iri
v3 --"p:direct/P31"--> c2
v3 --"p:direct/P101"--> v4
v4 --"p:P10287"--> v5
v5 --"p:statement/P10287"--> v6
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v5 -."p:qualifier/P1810".-> v2
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end
bind0[/"'EC0000'"/]
bind0 --as--o v7
bind1[/"?dfgdisciplineName"/]
v2 --o bind1
bind1 --as--o v8