query-af1d19bd26db0b82ecbe32a7d6093cd2
Leeftijd bij uitzending
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 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