query-65ce2ea50a5ce50114985c823b99f5de

rq turtle/ttl

Olympyans' weight and height SELECT ?item ?itemLabel ?weight ?height WHERE { ?item wdt:P31 wd:Q5. # ?item wdt:P21 wd:Q6581097. # Recent ?item wdt:P569 ?birth. filter (?birth > "1900-01-01"^^xsd:dateTime). ?item wdt:P1344/wdt:P31 wd:Q26132862. # Only kg and cm ?item p:P2067/psv:P2067 [ wikibase:quantityAmount ?weight ; wikibase:quantityUnit wd:Q11570 ]. ?item p:P2048/psv:P2048 [ wikibase:quantityAmount ?height ; wikibase:quantityUnit wd:Q174728 ]. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }

Use at

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Olympyans' weight and height
SELECT ?item ?itemLabel ?weight ?height 
WHERE 
{
  ?item wdt:P31 wd:Q5.
  # ?item wdt:P21 wd:Q6581097.
  # Recent
  ?item wdt:P569 ?birth.
  filter (?birth > "1900-01-01"^^xsd:dat).
  ?item wdt:P1344/wdt:P31 wd:Q26132862.
  # Only kg and cm
  ?item p:P2067/psv:P2067 [ wikibase:quantityAmount     ?weight ;
                              wikibase:quantityUnit       wd:Q11570 ].
  ?item p:P2048/psv:P2048 [ wikibase:quantityAmount     ?height ;
                              wikibase:quantityUnit       wd:Q174728 ].
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?birth") v4("?height"):::projected v2("?item"):::projected v3("?weight"):::projected a1((" ")) a3((" ")) a2((" ")) a5((" ")) a4((" ")) c16(["bd:serviceParam"]):::iri c9(["wd:Q11570"]):::iri c12(["wd:Q174728"]):::iri c3(["wd:Q5"]):::iri c18(["#91;AUTO_LANGUAGE#93;,en"]):::literal c6(["wd:Q26132862"]):::iri f0[["?birth > s1900-01-01^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f0 --> v1 v2 --"p:direct/P31"--> c3 v2 --"p:direct/P569"--> v1 v2 --"p:direct/P1344"--> a1 a1 --"p:direct/P31"--> c6 a2 --"wikibase:quantityAmount"--> v3 a2 --"wikibase:quantityUnit"--> c9 v2 --"p:P2067"--> a3 a3 --"p:statement/value/P2067"--> a2 a4 --"wikibase:quantityAmount"--> v4 a4 --"wikibase:quantityUnit"--> c12 v2 --"p:P2048"--> a5 a5 --"p:statement/value/P2048"--> a4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c16 --"wikibase:language"--> c18 end