query-621a1a3c557403fa8427eeb8703b7919

rq turtle/ttl

Personnes les plus lourdes SELECT DISTINCT ?itemLabel ?poids ?item WHERE {?item wdt:P31 wd:Q5 ; p:P2067 ?valeur . minus {?valeur wikibase:rank wikibase:DeprecatedRank}.
?valeur psn:P2067 [wikibase:quantityAmount ?poids; wikibase:quantityUnit ?unit] . FILTER(?poids > 440) . } order by desc (?poids)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
PREFIX p: <http://www.wikidata.org/prop/>
#Personnes les plus lourdes
SELECT DISTINCT ?itemLabel ?poids ?item WHERE {?item wdt:P31 wd:Q5 ;
                                                   p:P2067 ?valeur .
  minus {?valeur wikibase:rank wikibase:DeprecatedRank}.     
  ?valeur psn:P2067 [wikibase:quantityAmount ?poids; wikibase:quantityUnit ?unit] .
        FILTER(?poids > 440) .
       }
order by desc (?poids)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v1("?poids"):::projected v4("?unit") v3("?valeur") a1((" ")) c3(["wd:Q5"]):::iri c6(["wikibase:DeprecatedRank"]):::iri f0[["?poids > '440^^xsd:integer'"]] f0 --> v1 v2 --"p:direct/P31"--> c3 v2 --"p:P2067"--> v3 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v3 --"wikibase:rank"--> c6 end a1 --"wikibase:quantityAmount"--> v1 a1 --"wikibase:quantityUnit"--> v4 v3 --"p:statement/value-normalized/P2067"--> a1