query-6d4bb907d89d9d07fabce59f5012a90a
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
- https://query.wikidata.org/sparql
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