query-5b0113b24879748410b015be22dec7d2

rq turtle/ttl

Wolbo(P1346)winner

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?tournament ?tournamentLabel ?tournamentEdition ?tournamentEditionLabel ?player ?playerLabel ?handednessLabel (YEAR(?dateOfBirth) AS ?yearOfBirth) ?placeOfBirthLabel ?countryLabel WHERE {
  VALUES ?tournament { wd:Q60874 wd:Q43605 wd:Q41520 wd:Q123577 }
  ?player wdt:P31 wd:Q5;
          wdt:P21 wd:Q6581072;
          wdt:P106 wd:Q10833314.
  { ?player p:P1346/ps:P1346 ?event. } UNION
  { ?event wdt:P1346 ?player. }
  ?event wdt:P31 wd:Q16893403;
         wdt:P361 ?tournamentEdition.
  ?tournamentEdition wdt:P31 ?tournament.
  OPTIONAL { ?player wdt:P552 ?handedness. }
  OPTIONAL { ?player wdt:P569 ?dateOfBirth. }
  OPTIONAL { ?player wdt:P19 ?placeOfBirth. }
  OPTIONAL { ?player wdt:P27 ?country. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?tournamentLabel ?tournamentEditionLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?country") v8("?dateOfBirth"):::projected v5("?event") v7("?handedness") v9("?placeOfBirth") v4("?player"):::projected v3("?tournament"):::projected v6("?tournamentEdition"):::projected v2("?tournamentEditionLabel"):::projected v1("?tournamentLabel"):::projected v11("?yearOfBirth") a1((" ")) c10(["wd:Q16893403"]):::iri c19(["en"]):::literal c4(["wd:Q6581072"]):::iri c6(["wd:Q10833314"]):::iri c17(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri bind0[/VALUES ?tournament/] bind0-->v3 bind00(["wd:Q60874"]) bind00 --> bind0 bind01(["wd:Q43605"]) bind01 --> bind0 bind02(["wd:Q41520"]) bind02 --> bind0 bind03(["wd:Q123577"]) bind03 --> bind0 v4 --"p:direct/P31"--> c2 v4 --"p:direct/P21"--> c4 v4 --"p:direct/P106"--> c6 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P1346"--> v4 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v4 --"p:P1346"--> a1 a1 --"p:statement/P1346"--> v5 end union0r <== or ==> union0l end v5 --"p:direct/P31"--> c10 v5 --"p:direct/P361"--> v6 v6 --"p:direct/P31"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P552".-> v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P569".-> v8 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P19".-> v9 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P27".-> v10 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c17 --"wikibase:language"--> c19 end bind1[/"year-from-dateTime(?dateOfBirth)"/] v8 --o bind1 bind1 --as--o v11