Wikidata:WikiProject sum of all paintings/Collections without inventory number
Jump to navigation
Jump to search
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT ?item (COUNT(?item) AS ?count) WHERE { ?painting wdt:P31 wd:Q3305213 . ?painting wdt:P195 ?item . MINUS {?painting wdt:P217 ?inv } } GROUP BY ?item ORDER BY DESC(?count) LIMIT 100End of automatically generated list.
# The number of paintings in collections without an inventory number by country
SELECT ?countryLabel (COUNT(?country) AS ?count) WHERE {
?item wdt:P31 wd:Q3305213 .
?item wdt:P195 ?collection .
?collection wdt:P17 ?country
MINUS { ?item wdt:P217 [] } .
MINUS { ?item wdt:P195 wd:Q768717} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} GROUP BY ?countryLabel
ORDER BY DESC(?count)
LIMIT 30