query-0f03f128ee362250e76cabe0b8e85435
Weight classes
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription (GROUP_CONCAT(DISTINCT ?sport; SEPARATOR=', ') AS ?sports) ?any WHERE {
?item ?any [ wdt:P279* wd:Q17080472 ] .
[] wikibase:directClaim ?any .
FILTER(?any NOT IN (wdt:P2094)) .
OPTIONAL { ?item wdt:P641/rdfs:label ?sport . FILTER(LANG(?sport) = 'en') }
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
MINUS { ?item wdt:P31 wd:Q4167836 }
FILTER(?item NOT IN (wd:Q1520639, wd:Q7674850, wd:Q7248117, wd:Q2943040, wd:Q6404298, wd:Q1326107, wd:Q2531472)) .
} GROUP BY ?item ?itemLabel ?itemDescription ?any ORDER BY ASC(?itemLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?any"):::projected
v2("?item"):::projected
v1("?itemLabel"):::projected
v4("?sport"):::projected
v5("?sports")
a2((" "))
a1((" "))
a3((" "))
c9(["en"]):::literal
c16(["bd:serviceParam"]):::iri
c11(["wd:Q17080472"]):::iri
c19(["wd:Q4167836"]):::iri
f0[["?item != 'wd:Q1520639'?item != 'wd:Q7674850'?item != 'wd:Q7248117'?item != 'wd:Q2943040'?item != 'wd:Q6404298'?item != 'wd:Q1326107'?item != 'wd:Q2531472'"]]
f0 --> v2
f1[["?any != 'wdt:P2094'"]]
f1 --> v3
a1 --"wdt:P279"--> c11
v2 -->v3--> a1
a2 --"wikibase:directClaim"--> v3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P641".-> a3
a3 --"rdfs:label"--> v4
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c16 --"wikibase:language"--> c9
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P31"--> c19
end
bind4[/"?sport"/]
v4 --o bind4
bind4 --as--o v5