query-cb7ba454e5632a23fb80ebe10d830c48

rq turtle/ttl

Olympic rowing eventsGeneral overview:

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?regatta ?year ?item ?itemLabel ?class ?participants ?distance {
  ?item wdt:P31 wd:Q18536594; wdt:P3157 ?distance; wdt:P361 ?regatta; wdt:P1132 ?participants .
  ?regatta wdt:P31 wd:Q720609; wdt:P580 ?time .
  BIND(YEAR(?time) AS ?year) .
  OPTIONAL {
    ?item wdt:P2094 ?class .
  }
  ?item rdfs:label ?itemLabel .
  FILTER(LANG(?itemLabel) = 'de') .
} ORDER BY ASC(?year)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?class"):::projected v4("?distance"):::projected v3("?item"):::projected v2("?itemLabel"):::projected v6("?participants"):::projected v5("?regatta"):::projected v7("?time") v8("?year"):::projected c7(["wd:Q720609"]):::iri c3(["wd:Q18536594"]):::iri f0[["?itemLabel = 'de'"]] f0 --> v2 v3 --"wdt:P31"--> c3 v3 --"wdt:P3157"--> v4 v3 --"wdt:P361"--> v5 v3 --"wdt:P1132"--> v6 v5 --"wdt:P31"--> c7 v5 --"wdt:P580"--> v7 bind1[/"year-from-dateTime(?time)"/] v7 --o bind1 bind1 --as--o v8 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P2094".-> v8 end v3 --"rdfs:label"--> v2