query-af1d19bd26db0b82ecbe32a7d6093cd2

rq turtle/ttl

Leeftijd bij uitzending

Use at

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#>
select ?guestLabel ?age where {
  ?item wdt:P179 wd:Q2330424;
        wdt:P5030 ?guest;
        wdt:P577 ?pubDate. 
  ?guest wdt:P569 ?dob. 
  bind (year(?dob) as ?dobyear). 
  bind (year(?pubDate) as ?pubyear).
  bind (?pubyear - ?dobyear as ?age).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
} order by asc(?age)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?age"):::projected v5("?dob") v6("?dobyear") v3("?guest") v2("?item") v4("?pubDate") v7("?pubyear") c7(["bd:serviceParam"]):::iri c2(["wd:Q2330424"]):::iri c9(["nl"]):::literal v2 --"wdt:P179"--> c2 v2 --"wdt:P5030"--> v3 v2 --"wdt:P577"--> v4 v3 --"wdt:P569"--> v5 bind0[/"year-from-dateTime(?dob)"/] v5 --o bind0 bind0 --as--o v6 bind1[/"year-from-dateTime(?pubDate)"/] v4 --o bind1 bind1 --as--o v7 bind2[/"?pubyear - ?dobyear"/] v7 --o bind2 v6 --o bind2 bind2 --as--o v8 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end