query-05b1080677a02ac49c7aaa5b991af0de

Propertiescollection (P195)inventory number (P217)

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT (COUNT(?obj) AS ?count)  WHERE {
?obj p:P217 ?s.
  ?s pq:P195 ?collection
MINUS {?obj wdt:P195 []}
}

Query found at

https://www.wikidata.org/wiki/User:MartinPoulter/queries/collections

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?collection") v4("?count") v1("?obj"):::projected v2("?s") a1((" ")) v1 --"p:P217"--> v2 v2 --"p:qualifier/P195"--> v3 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v1 --"p:direct/P195"--> a1 end bind2[/"count(?obj)"/] v1 --o bind2 bind2 --as--o v4