query-e4105ec7d09b5e5d0520677e5f7d33f9
Search for non-rowing stuff on watchlist
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 bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel WHERE {
VALUES ?item {
# put items here
}
MINUS { ?item wdt:P106?/wdt:P279* wd:Q26270618 } # rowing people
MINUS { ?item wdt:P31?/wdt:P279* wd:Q21246076 } # events
MINUS { ?item wdt:P31?/wdt:P279* wd:Q21224061 } # regattas
MINUS { ?item wdt:P3450/wdt:P279* wd:Q21224061 } # seasons
MINUS { ?item wdt:P31?/wdt:P279* wd:Q43445087 } # organizations
MINUS { ?item wdt:P31|wdt:P366 wd:Q2137251 } # venues
MINUS { ?item wdt:P31 wd:Q22936940; wdt:P641/wdt:P279* wd:Q159354 } # competition classes
MINUS { ?item wdt:P31 wd:Q26211803 } # boat classes
MINUS { ?item wdt:P279*|wdt:P361 wd:Q606305 } # equipment
MINUS { ?item wdt:P641?/wdt:P279* wd:Q159354 } # just sport
MINUS { ?item wdt:P31/wdt:P279* wd:Q4167836 } # categories
MINUS { ?item wdt:P31/wdt:P279* wd:Q11266439 } # templates
MINUS { ?item wdt:P31 wd:Q13406463 } # lists
MINUS { ?item wdt:P31 wd:Q4167410 } # dab
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("?item"):::projected
a1((" "))
a2((" "))
a3((" "))
a4((" "))
a5((" "))
a6((" "))
a7((" "))
a8((" "))
a9((" "))
c20(["wd:Q4167410"]):::iri
c24(["en"]):::literal
c19(["wd:Q13406463"]):::iri
c8(["wd:Q43445087"]):::iri
c15(["wd:Q606305"]):::iri
c9(["wd:Q2137251"]):::iri
c22(["bd:serviceParam"]):::iri
c6(["wd:Q21224061"]):::iri
c5(["wd:Q21246076"]):::iri
c3(["wd:Q26270618"]):::iri
c11(["wd:Q22936940"]):::iri
c17(["wd:Q4167836"]):::iri
c13(["wd:Q159354"]):::iri
c14(["wd:Q26211803"]):::iri
c18(["wd:Q11266439"]):::iri
bind0[/VALUES ?item/]
bind0-->v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P106"--> a1
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
end
union0r <== or ==> union0l
end
a1 --"wdt:P279"--> c3
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> a2
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
end
union1r <== or ==> union1l
end
a2 --"wdt:P279"--> c5
end
subgraph minus3["MINUS"]
style minus3 stroke-width:6px,fill:pink,stroke:red;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> a3
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
end
union2r <== or ==> union2l
end
a3 --"wdt:P279"--> c6
end
subgraph minus4["MINUS"]
style minus4 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P3450"--> a4
a4 --"wdt:P279"--> c6
end
subgraph minus5["MINUS"]
style minus5 stroke-width:6px,fill:pink,stroke:red;
subgraph union3[" Union "]
subgraph union3l[" "]
style union3l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> a5
end
subgraph union3r[" "]
style union3r fill:#abf,stroke-dasharray: 3 3;
end
union3r <== or ==> union3l
end
a5 --"wdt:P279"--> c8
end
subgraph minus6["MINUS"]
style minus6 stroke-width:6px,fill:pink,stroke:red;
subgraph union4[" Union "]
subgraph union4l[" "]
style union4l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P366"--> c9
end
subgraph union4r[" "]
style union4r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P31"--> c9
end
union4r <== or ==> union4l
end
end
subgraph minus7["MINUS"]
style minus7 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P31"--> c11
v1 --"wdt:P641"--> a6
a6 --"wdt:P279"--> c13
end
subgraph minus8["MINUS"]
style minus8 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P31"--> c14
end
subgraph minus9["MINUS"]
style minus9 stroke-width:6px,fill:pink,stroke:red;
subgraph union5[" Union "]
subgraph union5l[" "]
style union5l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P361"--> c15
end
subgraph union5r[" "]
style union5r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P279"--> c15
end
union5r <== or ==> union5l
end
end
subgraph minus10["MINUS"]
style minus10 stroke-width:6px,fill:pink,stroke:red;
subgraph union6[" Union "]
subgraph union6l[" "]
style union6l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P641"--> a7
end
subgraph union6r[" "]
style union6r fill:#abf,stroke-dasharray: 3 3;
end
union6r <== or ==> union6l
end
a7 --"wdt:P279"--> c13
end
subgraph minus11["MINUS"]
style minus11 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P31"--> a8
a8 --"wdt:P279"--> c17
end
subgraph minus12["MINUS"]
style minus12 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P31"--> a9
a9 --"wdt:P279"--> c18
end
subgraph minus13["MINUS"]
style minus13 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P31"--> c19
end
subgraph minus14["MINUS"]
style minus14 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P31"--> c20
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c22 --"wikibase:language"--> c24
end