query-d7ff78e93c0854b08106acf32aa93c6d
title:Unreferenced statements about Khalili Collections objects SELECT ?item ?prop ?statement ?itemLabel ?url WHERE { ?item wdt:P195/wdt:P361? wd:Q63160499. ?item wdt:P973 ?url. ?item ?prop ?statement FILTER(STRSTARTS(STR(?prop), "http://www.wikidata.org/prop/direct/") ) FILTER(?prop not in (wdt:P973, wdt:P18, wdt:P571)).
FILTER NOT EXISTS { ?item ?prop ?statement . ?statement prov:wasDerivedFrom ?derivedFrom } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ?item ?prop
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 prov: <http://www.w3.org/ns/prov#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Unreferenced statements about Khalili Collections objects
SELECT ?item ?prop ?statement ?itemLabel ?url WHERE {
?item wdt:P195/wdt:P361? wd:Q63160499.
?item wdt:P973 ?url.
?item ?prop ?statement FILTER(STRSTARTS(STR(?prop), "http://www.wikidata.org/prop/direct/") )
FILTER(?prop not in (wdt:P973, wdt:P18, wdt:P571)).
FILTER NOT EXISTS {
?item ?prop ?statement .
?statement prov:wasDerivedFrom ?derivedFrom }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?item ?prop
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?derivedFrom")
v1("?item"):::projected
v2("?prop"):::projected
v3("?statement"):::projected
v5("?url"):::projected
a1((" "))
c10(["bd:serviceParam"]):::iri
c7(["wd:Q63160499"]):::iri
c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 -->e0v2--> e0v3
e0v3 --"prov:wasDerivedFrom"--> e0v4
e0v4("?derivedFrom"):::projected
e0v1("?item"):::projected
e0v2("?prop"):::projected
e0v3("?statement"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> v2
f0 --> v3
f0 --> c1
f0 --> v4
v1 -->v2--> v3
v3 --"prov:wasDerivedFrom"--> v4
f1[["?prop != 'wdt:P973'?prop != 'wdt:P18'?prop != 'wdt:P571'"]]
f1 --> v2
f2[["starts-with(str(?prop),'http://www.wikidata.org/prop/direct/')"]]
f2 --> v2
v1 --"wdt:P195"--> a1
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
a1 --"wdt:P361"--> c7
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
end
union0r <== or ==> union0l
end
v1 --"wdt:P973"--> v5
v1 -->v2--> v3
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end