query-202be40a4d68dda41a69d20a93e4a513
Propertiessport (P641)instance of (P31)sports season of league or competition (P3450)
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 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