query-d2a699b9a75413fc37a1067e10a3d643
Visual artists dead more than 70 yearsHi all, I would like to run a query that gives all visual artists that are dead more than 70 years and that have been dead between 70 years and 90 years, because of public domain notifications in Europe. So far, I have come up with this query (mix n matched from existing queries), but I get a time out and I do not know why this is. Can you help me, please?
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?_date_of_death ?_country ?_occupation ?_date_of_birth WHERE {
?person wdt:P106/wdt:P279* wd:Q483501 . #person with occupation (P106) any subclass(P279) of artist (Q483501)
?person wdt:P570 ?death .
FILTER (?death >= "1946-01-01T00:00:00Z"^^xsd:dateTime) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
OPTIONAL { ?item wdt:P570 ?_date_of_death. }
OPTIONAL { ?item wdt:P17 ?_country. }
OPTIONAL { ?item wdt:P106 ?_occupation. }
OPTIONAL { ?item wdt:P569 ?_date_of_birth. }
}
LIMIT 500
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?_country"):::projected
v7("?_date_of_birth"):::projected
v4("?_date_of_death"):::projected
v6("?_occupation"):::projected
v1("?death")
v3("?item"):::projected
v2("?person")
a1((" "))
c7(["bd:serviceParam"]):::iri
c4(["wd:Q483501"]):::iri
c9(["en"]):::literal
f0[["?death >= '1946-01-01T00:00:00Z^^xsd:dateTime'"]]
f0 --> v1
v2 --"wdt:P106"--> a1
a1 --"wdt:P279"--> c4
v2 --"wdt:P570"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P570".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P17".-> v5
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P106".-> v6
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P569".-> v7
end