query-91db047423f3b26999eda300b11a6dbb

rq turtle/ttl

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

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