query-6fe288c8b927fad0939d831ed6101e21

rq turtle/ttl

15:45, 21 January 2018 (UTC)) talk (Tagishsimon ... that's another thing we need to do. --tool aimed at adding creators to painting items: good work much appreciated. I'm sorry collectienederland.nl is keeping you unnecessarily busy :(. Not sure if you're aware, btw, that Magnus has a MultichillThanks @ 15:06, 21 January 2018 (UTC)) talk (Multichill, I fixed that too. (P973)described at URL . Seems to leave us with a duplicate fixing the urls and including some more info: doing a new run of the collection Hsarrazin, Tagishsimon@ 11:26, 21 January 2018 (UTC)) talk (Multichill. Some were returned to the (heirs of) owners, some not and ended up in this collection. returned to the Netherlands: that's provenance data. Quite a lot of works have been stolen around WW2 by the German occupier and after the war Tagishsimon@ 12:17, 20 January 2018 (UTC)) talk (Tagishsimon? Where does that data come from? Confused. --(Q28060147)Landscape near Alkmaar : what's with the multiple collection statements on MultichillOn a tangent, @ 19:00, 19 January 2018 (UTC)) talk (Multichillseems to return the right url's. Needs more checking before someone actually replaces it. And of course the references need to be fixed too. For completeness sake the current query: ┘────────────────────────────────────────────────────────────────────────────────────────────────────┌

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?inventory_no ?wrongurl ?righturl WHERE {
  ?item wdt:P31 wd:Q3305213 .
  ?item wdt:P195 wd:Q18600731 .
  ?item wdt:P973 ?wrongurl .
  ?item wdt:P973 ?righturl .
  ?item p:P217 ?invstatement .
  ?invstatement ps:P217 ?inventory_no .
  ?invstatement pq:P195 wd:Q18600731 .
  BIND(IRI(CONCAT("http://data.collectienederland.nl/resource/aggregation/rce-kunstcollectie/", ?inventory_no)) AS ?newurl)  .
  FILTER(CONTAINS(str(?wrongurl), "http://data.collectienederland.nl/resource/aggregation/rce-kunstcollectie/") ) .
  FILTER(?righturl=?newurl && ?wrongurl!=?newurl)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2018/01