query-5c1bdfcb4b7f1bcd18a0a9de7e537396
MH construit plus de 25 ans après la mort de l'architecte SELECT DISTINCT ?item ?itemLabel ?dateConstruction ?dateDeces WHERE { { ?item wdt:P1435 wd:Q10387575 . } UNION { ?item wdt:P1435 wd:Q10387684 . } #MH ?item wdt:P571 ?dateConstruction ; wdt:P84/wdt:P570 ?dateDeces . FILTER(year(?dateConstruction) - year(?dateDeces) > 25) SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } . }
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 bd: <http://www.bigdata.com/rdf#>
#MH construit plus de 25 ans après la mort de l'architecte
SELECT DISTINCT ?item ?itemLabel ?dateConstruction ?dateDeces WHERE {
{ ?item wdt:P1435 wd:Q10387575 . } UNION { ?item wdt:P1435 wd:Q10387684 . } #MH
?item wdt:P571 ?dateConstruction ; wdt:P84/wdt:P570 ?dateDeces .
FILTER(year(?dateConstruction) - year(?dateDeces) > 25)
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } .
}
Query found at
- https://www.wikidata.org/wiki/Wikidata:WikiProject_France/Monuments_historiques
- https://www.wikidata.org/wiki/Wikidata:WikiProject_France/Monuments_historiques/Requ%C3%AAtes
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?dateConstruction"):::projected
v2("?dateDeces"):::projected
v3("?item"):::projected
a1((" "))
c4(["wd:Q10387684"]):::iri
c3(["wd:Q10387575"]):::iri
c9(["bd:serviceParam"]):::iri
c11(["fr"]):::literal
f0[["year-from-dateTime(?dateConstruction) - year-from-dateTime(?dateDeces) > '25^^xsd:integer'"]]
f0 --> v1
f0 --> v2
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v3 --"wdt:P1435"--> c4
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v3 --"wdt:P1435"--> c3
end
union0r <== or ==> union0l
end
v3 --"wdt:P571"--> v1
v3 --"wdt:P84"--> a1
a1 --"wdt:P570"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end