query-e71e6bc9893ebed71fd282d7d56ad312
in the results, cause this item have an entry when the person was a baby. (Q112988605)Kordula Stropnická My problem is that I get I adapted the query as this :
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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?taille ?item
WHERE
{?item wdt:P31 wd:Q5 ;
wdt:P569 ?naissance ;
p:P2048 ?t .
?t psn:P2048 ?tm ; #unité SI
rdf:type wikibase:BestRank .
optional {?t pq:P585 ?date.}
?tm wikibase:quantityAmount ?taille .
?tm wikibase:quantityUnit ?unit.
FILTER (?taille < 1) #moins de 1 mètre
BIND(YEAR(NOW()) AS ?year)
FILTER (?year - YEAR(?naissance) >= 18) #au moins 18 ans
FILTER (YEAR(?date) - YEAR(?naissance) >= 18) #donnée à au moins 18 ans}
minus {?item wdt:P31 wd:Q190 .} #pas un-e dieu|déesse
minus {VALUES ?item {wd:Q15397819} } #bac à sable
}
ORDER BY (?taille)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?date")
v9("?item"):::projected
v3("?naissance")
v6("?t")
v1("?taille"):::projected
v7("?tm")
v8("?unit")
v9("?year")
c13(["wd:Q190"]):::iri
c9(["wikibase:BestRank"]):::iri
c4(["wd:Q5"]):::iri
f0[["year-from-dateTime(?date) - year-from-dateTime(?naissance) >= '18^^xsd:integer'"]]
f0 --> v2
f0 --> v3
f1[["?year - year-from-dateTime(?naissance) >= '18^^xsd:integer'"]]
f1 --> v9
f1 --> v3
f2[["?taille < '1^^xsd:integer'"]]
f2 --> v1
v9 --"p:direct/P31"--> c4
v9 --"p:direct/P569"--> v3
v9 --"p:P2048"--> v6
v6 --"p:statement/value-normalized/P2048"--> v7
v6 --"a"--> c9
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v6 -."p:qualifier/P585".-> v2
end
v7 --"wikibase:quantityAmount"--> v1
v7 --"wikibase:quantityUnit"--> v8
bind3[/"year-from-dateTime(NOW())"/]
bind3 --as--o v9
subgraph minus4["MINUS"]
style minus4 stroke-width:6px,fill:pink,stroke:red;
v9 --"p:direct/P31"--> c13
end
subgraph minus5["MINUS"]
style minus5 stroke-width:6px,fill:pink,stroke:red;
bind6[/VALUES ?item/]
bind6-->v9
bind60(["wd:Q15397819"])
bind60 --> bind6
end