query-d29f2aa103e97ef3a5208adffd20ef39

rq turtle/ttl

Propertiesinstance of (P31)sport (P641)partner in business or sport (P1327)participant (P710)together with (P1706)

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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?skater ?skaterLabel ?partner ?partnerLabel ?compet
WHERE {
  ?compet p:P710 ?statement .
  ?statement ps:P710 ?skater ;
             pq:P1706 ?partner .
  ?skater wdt:P31 wd:Q5 ;
          wdt:P641 wd:Q38108.
  ?partner wdt:P31 wd:Q5 .
  MINUS { ?skater wdt:P1327 ?partner .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?compet"):::projected v4("?partner"):::projected v3("?skater"):::projected v2("?statement") c10(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri c12(["en"]):::literal c7(["wd:Q38108"]):::iri v1 --"p:P710"--> v2 v2 --"p:statement/P710"--> v3 v2 --"p:qualifier/P1706"--> v4 v3 --"p:direct/P31"--> c5 v3 --"p:direct/P641"--> c7 v4 --"p:direct/P31"--> c5 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v3 --"p:direct/P1327"--> v4 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end