query-202be40a4d68dda41a69d20a93e4a513

rq turtle/ttl

Propertiessport (P641)instance of (P31)sports season of league or competition (P3450)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel WHERE {
  ?item wdt:P641 ?sport ;
        wdt:P31 ?competition ;
        p:P3450 ?statement .
  FILTER (?sport IN (wd:Q1682809, wd:Q926191, wd:Q4179462, wd:Q4305887, wd:Q38108))
  FILTER (?competition IN (wd:Q57305027, wd:Q2990963))
  MINUS {
    ?statement ?pq ?qualifier.
    ?property wikibase:qualifier ?pq.
  }
  MINUS {
    ?statement prov:wasDerivedFrom ?reference.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?competition") v3("?item"):::projected v5("?pq") v7("?property") v6("?qualifier") v8("?reference") v2("?sport") v4("?statement") c14(["bd:serviceParam"]):::iri c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal list0c2(["wd:Q2990963"]):::iri list0c1(["wd:Q57305027"]):::iri list0c1 --o f0 list0c2 --o f0 f0[[" in "]] f0 --> v1 list1c4(["wd:Q4305887"]):::iri list1c2(["wd:Q926191"]):::iri list1c5(["wd:Q38108"]):::iri list1c1(["wd:Q1682809"]):::iri list1c3(["wd:Q4179462"]):::iri list1c1 --o f1 list1c2 --o f1 list1c3 --o f1 list1c4 --o f1 list1c5 --o f1 f1[[" in "]] f1 --> v2 v3 --"p:direct/P641"--> v2 v3 --"p:direct/P31"--> v1 v3 --"p:P3450"--> v4 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v4 -->v5--> v6 v7 --"wikibase:qualifier"--> v5 end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v4 --"prov:wasDerivedFrom"--> v8 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end