query-5e39e474702e658dc70c61cc1dc3fe9f

rq turtle/ttl

FSK ratings with source URL but no Prüfnummer SELECT * WHERE { ?item p:P1981 ?s. ?s prov:wasDerivedFrom/pr:P854 ?source. MINUS { ?s pq:P2676 [] } FILTER(CONTAINS(STR(?source), "fsk.de")) }

Use at

https://query.wikidata.org/sparql

PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#FSK ratings with source URL but no Prüfnummer
SELECT * WHERE {
  ?item p:P1981 ?s.
  ?s prov:wasDerivedFrom/pr:P854 ?source.
  MINUS { ?s pq:P2676 [] }
  FILTER(CONTAINS(STR(?source), "fsk.de"))
}

Query found at

https://www.wikidata.org/wiki/User:M%C3%A1t%C3%A9

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v3("?s"):::projected v1("?source"):::projected a2((" ")) a1((" ")) f0[["contains(str(?source),'fsk.de')"]] f0 --> v1 v2 --"p:P1981"--> v3 v3 --"prov:wasDerivedFrom"--> a1 a1 --"p:reference/P854"--> v1 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v3 --"p:qualifier/P2676"--> a2 end