query-1cfcfa1c802512952ef426bd51338796

number of items in private collections

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT (count(?item) as ?count) WHERE {
 ?item wdt:P170 wd:Q381238 .     
 ?item p:P195 ?statement.
 ?statement pq:P3831 wd:Q768717 .
 Minus{ ?statement pq:P518 wd:Q114187913 }
}

Query found at

https://www.wikidata.org/wiki/User:Jarekt/Witkacy_queries

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?count") v1("?item"):::projected v2("?statement") c2(["wd:Q381238"]):::iri c7(["wd:Q114187913"]):::iri c5(["wd:Q768717"]):::iri v1 --"p:direct/P170"--> c2 v1 --"p:P195"--> v2 v2 --"p:qualifier/P3831"--> c5 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v2 --"p:qualifier/P518"--> c7 end bind2[/"count(?item)"/] v1 --o bind2 bind2 --as--o v3