query-91db047423f3b26999eda300b11a6dbb
title: Get Refs for Kriegerdenkmal in Austria SELECT ?item ?ref1 ?ref2Label ?ref3Label WHERE { ?item wdt:P17 wd:Q40 . {?item wdt:P31 wd:Q358 .} union {?item wdt:P31 wd:Q2065736 .} ?item wdt:P625 [] . ?item rdfs:label ?itemLabel . FILTER (LANG(?itemLabel) = "de"). FILTER regex(?itemLabel, ".Kriegerdenkmal.", "i"). ?item p:P31 [ prov:wasDerivedFrom ?ref ] . ?ref pr:P248 ?ref1. ?ref pr:P854 ?ref2. ?ref pr:P577 ?ref3. #?ref1 rdfs:label ?ref1Label . #?ref2 rdfs:label ?ref2Label . #?ref3 rdfs:label ?ref3Label . MINUS {?item wdt:P31 wd:Q261543 }. Minus {?item wdt:P31 wd:Q406957 }.
SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE,de,en]' } }
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 prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Get Refs for Kriegerdenkmal in Austria
SELECT ?item ?ref1 ?ref2Label ?ref3Label
WHERE {
?item wdt:P17 wd:Q40 .
{?item wdt:P31 wd:Q358 .} union {?item wdt:P31 wd:Q2065736 .}
?item wdt:P625 [] .
?item rdfs:label ?itemLabel .
FILTER (LANG(?itemLabel) = "de").
FILTER regex(?itemLabel, ".*Kriegerdenkmal.*", "i").
?item p:P31 [ prov:wasDerivedFrom ?ref ] .
?ref pr:P248 ?ref1.
?ref pr:P854 ?ref2.
?ref pr:P577 ?ref3.
#?ref1 rdfs:label ?ref1Label .
#?ref2 rdfs:label ?ref2Label .
#?ref3 rdfs:label ?ref3Label .
MINUS {?item wdt:P31 wd:Q261543 }.
Minus {?item wdt:P31 wd:Q406957 }.
SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE,de,en]' }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v1("?itemLabel")
v3("?ref")
v4("?ref1"):::projected
v5("?ref2")
v6("?ref3")
a1((" "))
a2((" "))
c17(["wd:Q406957"]):::iri
c5(["wd:Q40"]):::iri
c16(["wd:Q261543"]):::iri
c7(["wd:Q358"]):::iri
c19(["bd:serviceParam"]):::iri
c8(["wd:Q2065736"]):::iri
c21(["#91;AUTO_LANGUAGE,de,en#93;"]):::literal
f0[["regex(?itemLabel,'.*Kriegerdenkmal.*','i')"]]
f0 --> v1
f1[["?itemLabel = 'de'"]]
f1 --> v1
v2 --"p:direct/P17"--> c5
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v2 --"p:direct/P31"--> c8
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:direct/P31"--> c7
end
union0r <== or ==> union0l
end
v2 --"p:direct/P625"--> a1
v2 --"rdfs:label"--> v1
a2 --"prov:wasDerivedFrom"--> v3
v2 --"p:P31"--> a2
v3 --"p:reference/P248"--> v4
v3 --"p:reference/P854"--> v5
v3 --"p:reference/P577"--> v6
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v2 --"p:direct/P31"--> c16
end
subgraph minus3["MINUS"]
style minus3 stroke-width:6px,fill:pink,stroke:red;
v2 --"p:direct/P31"--> c17
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c19 --"wikibase:language"--> c21
end