query-3e586b50128c63ededbb44ec9255f8e4
Unreferenced statements about things in the Pitt Rivers Museum
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#>
SELECT (SUBSTR(STR(?item),32) AS ?wdq) (SUBSTR(STR(?prop),32) AS ?wdp) ?object ?url WHERE {
?item wdt:P195 wd:Q1456119.
?item wdt:P973 ?url FILTER CONTAINS(STR(?url), "ox.ac.uk").
?item ?p ?statement.
?prop wikibase:claim ?p; wikibase:statementProperty ?ps FILTER (?prop != wd:P973) FILTER (?prop != wd:P953)
FILTER (?prop != wd:P18) FILTER (?prop != wd:P571).
?statement ?ps ?object .
FILTER NOT EXISTS {?statement prov:wasDerivedFrom ?derivedFrom}
} ORDER BY ?item
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?derivedFrom")
v1("?item"):::projected
v8("?object"):::projected
v6("?p")
v4("?prop"):::projected
v7("?ps")
v2("?statement")
v5("?url"):::projected
v10("?wdp")
v9("?wdq")
c8(["wd:Q1456119"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"prov:wasDerivedFrom"--> e0v2
e0v2("?derivedFrom"):::projected
e0v1("?statement"):::projected
end
f0--EXISTS--> f0e0
f0 --> v2
f0 --> c1
f0 --> v3
v2 --"prov:wasDerivedFrom"--> v3
f1[["?prop != 'wd:P571'"]]
f1 --> v4
f2[["?prop != 'wd:P18'"]]
f2 --> v4
f3[["?prop != 'wd:P953'"]]
f3 --> v4
f4[["?prop != 'wd:P973'"]]
f4 --> v4
f5[["contains(str(?url),'ox.ac.uk')"]]
f5 --> v5
v1 --"wdt:P195"--> c8
v1 --"wdt:P973"--> v5
v1 -->v6--> v2
v4 --"wikibase:claim"--> v6
v4 --"wikibase:statementProperty"--> v7
v2 -->v7--> v8
bind6[/"substring(str(?item),'32^^xsd:integer')"/]
v1 --o bind6
bind6 --as--o v9
bind7[/"substring(str(?prop),'32^^xsd:integer')"/]
v4 --o bind7
bind7 --as--o v10