query-c18ed0abf8415d6264149985070ab54c

rq turtle/ttl

IOC identifier worklist

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?item ?label ?year ?month ?day WHERE {
  ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  ?item wdt:P1344 ?event .
  {
    ?event wdt:P31 wd:Q21246076; wdt:P31 wd:Q18536594 . # rowing event
  } UNION {
    ?event wdt:P31 wd:Q720609 . # Rowing at the Summer Olympics
  } UNION {
    ?event wdt:P31 wd:Q159821 . # Summer Olympic Games
  }  
  MINUS { ?item wdt:P3171 [] }
#  ?item rdfs:label ?label .
#  FILTER(LANG(?label) = 'en') .
#  FILTER(REGEX(STR(?label), '^[A-Za-z ]+$') = true) .
#  ?item p:P569 [ psv:P569 [ wikibase:timeValue ?dateOfBirth; wikibase:timePrecision 11 ] ] .
#  BIND(YEAR(?dateOfBirth) AS ?year) .
#  BIND(MONTH(?dateOfBirth) AS ?month) .
#  BIND(DAY(?dateOfBirth) AS ?day) .
}

Query found at

• https://www.wikidata.org/wiki/User:MisterSynergy/rowing/P3171_for_rowers