query-3e586b50128c63ededbb44ec9255f8e4

rq turtle/ttl

Unreferenced statements about things in the Pitt Rivers Museum

Use at

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