query-6d4bb907d89d9d07fabce59f5012a90a

rq turtle/ttl

are filtered out. Otherwise this list would become too big. (Q18600731)Cultural Heritage Agency of the Netherlands Art Collection . At the moment works in the Wikidata:WikiProject sum of all paintings/Missing creator you can help by adding the missing creators. This is part of Paintings without creator in the NetherlandsThis is an overview of Query to try to find more matches for RCE works.

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?item ?description ?name ?painter ?rkdid ?painterLabel 
WHERE {
   {
  SELECT DISTINCT ?item ?description ?name WHERE {
  ?item wdt:P31 wd:Q3305213 .
  ?item wdt:P195 wd:Q18600731 .
  MINUS { ?item p:P170 [] } .
  ?item schema:description ?description .  FILTER (LANG(?description) = "en")
  BIND(REPLACE(?description, '^painting by ([^\\)]+)(\\([^\\)]+\\))?$', "$1") AS ?name)
  } LIMIT 1000 # ORDER BY ?description
}
   {
  SELECT ?painter ?rkdid ?painterLabel ?name WHERE {
  ?painter wdt:P650 ?rkdid .
  ?painter wdt:P31 wd:Q5 .
  ?painter rdfs:label ?painterLabel . FILTER (LANG(?painterLabel) = "en") .
  BIND(REPLACE(?painterLabel, '^(.)([[^\\s]]+) (.+)$', "$1. $3") AS ?name)
    }
}
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?description"):::projected v2("?item"):::projected v7("?name"):::projected v5("?painter"):::projected v4("?painterLabel"):::projected v6("?rkdid"):::projected a1((" ")) c3(["wd:Q3305213"]):::iri c5(["wd:Q18600731"]):::iri c9(["wd:Q5"]):::iri f0[["?description = 'en'"]] f0 --> v1 v2 --"p:direct/P31"--> c3 v2 --"p:direct/P195"--> c5 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"p:P170"--> a1 end v2 --"schema:description"--> v1 bind2[/"replace(?description,'^painting by (#91;^\)#93;+)(\(#91;^\)#93;+\))?$','$1')"/] v1 --o bind2 bind2 --as--o v7 f3[["?painterLabel = 'en'"]] f3 --> v4 v5 --"p:direct/P650"--> v6 v5 --"p:direct/P31"--> c9 v5 --"rdfs:label"--> v4 bind4[/"replace(?painterLabel,'^(.)(#91;#91;^\s#93;#93;+) (.+)$','$1. $3')"/] v4 --o bind4 bind4 --as--o v7