User:Mcarondiotte/Height and Weight of Humans
SELECT DISTINCT ?person ?personLabel ?height ?weight ?gender ?genderLabel WHERE {
?person wdt:P31 wd:Q5 .
?person wdt:P2048 ?height .
?person wdt:P2067 ?weight .
?person wdt:P21 ?gender .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "fr,en" .
}
}
LIMIT 10000
With units :
SELECT DISTINCT ?person ?personLabel ?genderLabel ?height ?heightUnitLabel ?weight ?weightUnitLabel WHERE
{
?person wdt:P31 wd:Q5 .
?person wdt:P2048 ?height .
?person p:P2048 [ a wikibase:BestRank ; psv:P2048 [ wikibase:quantityAmount ?height ; wikibase:quantityUnit ?heightUnit ] ] .
?person wdt:P2067 ?weight .
?person p:P2067 [ a wikibase:BestRank ; psv:P2067 [ wikibase:quantityAmount ?weight ; wikibase:quantityUnit ?weightUnit ] ] .
?person wdt:P21 ?gender
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 5000