query-7e972478f46c8818fd87bf9c73fc6d14

rq turtle/ttl

Propertiessport (P641)participant (P710)ISU figure skater ID (P2694)reference URL (P854)together with (P1706)identifier shared with (P4070)

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 prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
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 WHERE {
  ?compet wdt:P641 ?sport.
  ?compet p:P710 ?statement.
  ?statement ps:P710 ?skater.
  ?statement pq:P1706 ?skater2.
  ?statement prov:wasDerivedFrom ?ref.
  ?ref pr:P854 ?refURL.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  FILTER(CONTAINS(STR(?refURL), "www.isuresults.com"))
  FILTER(NOT EXISTS {
    ?skater p:P2694 ?stat.
    ?stat ps:P2694 ?isu.
    ?stat pq:P4070 ?skater2.
  })
  FILTER(?sport IN(wd:Q1682809, wd:Q926191, wd:Q38108))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?compet") v4("?isu") v9("?ref") v6("?refURL") v2("?skater"):::projected v5("?skater2") v1("?sport") v3("?stat") v8("?statement") c17(["en"]):::literal c15(["bd:serviceParam"]):::iri list0c2(["wd:Q926191"]):::iri list0c3(["wd:Q38108"]):::iri list0c1(["wd:Q1682809"]):::iri list0c1 --o f0 list0c2 --o f0 list0c3 --o f0 f0[[" in "]] f0 --> v1 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"p:P2694"--> e1v2 e1v2 --"p:statement/P2694"--> e1v3 e1v2 --"p:qualifier/P4070"--> e1v4 e1v3("?isu"):::projected e1v1("?skater"):::projected e1v4("?skater2"):::projected e1v2("?stat"):::projected end f1--EXISTS--> f1e1 f1 --> v2 f1 --> c4 f1 --> v3 f1 --> c5 f1 --> v4 f1 --> c6 f1 --> v5 v2 --"p:P2694"--> v3 v3 --"p:statement/P2694"--> v4 v3 --"p:qualifier/P4070"--> v5 f2[["contains(str(?refURL),'www.isuresults.com')"]] f2 --> v6 v7 --"p:direct/P641"--> v1 v7 --"p:P710"--> v8 v8 --"p:statement/P710"--> v2 v8 --"p:qualifier/P1706"--> v5 v8 --"prov:wasDerivedFrom"--> v9 v9 --"p:reference/P854"--> v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end