query-102e4176fb61e5a6dbb3b910cbe88f05
Propertiesinstance of (P31)part of (P361)dissolved, abolished or demolished date (P576)
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 schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?x ?xLabel WHERE {
# find team-items, no season-items
VALUES ?team {wd:Q1785271 wd:Q20639847 wd:Q20653563 wd:Q20638319 wd:Q6154783 wd:Q382927 wd:Q20653564 wd:Q1756006 wd:Q20653566 wd:Q20639848 wd:Q20652655}
?x wdt:P31 ?team.
?article schema:about ?x .
?article schema:isPartOf <https://de.wikipedia.org/>.
FILTER NOT EXISTS {?x wdt:P361 ?g}.
FILTER NOT EXISTS {?x wdt:P576 ?gg}
SERVICE wikibase:label {bd:serviceParam wikibase:language "de,en,fr,es,nl,ca,pl,pt,it"}
} ORDER BY ASC(?xLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?article")
v4("?g")
v3("?gg")
v5("?team")
v2("?x"):::projected
v1("?xLabel"):::projected
c6([https://de.wikipedia.org/]):::iri
c8(["bd:serviceParam"]):::iri
c10(["de,en,fr,es,nl,ca,pl,pt,it"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P576"--> e0v2
e0v2("?gg"):::projected
e0v1("?x"):::projected
end
f0--EXISTS--> f0e0
f0 --> v2
f0 --> c1
f0 --> v3
v2 --"wdt:P576"--> v3
f1[["not "]]
subgraph f1e1["Exists Clause"]
e1v1 --"wdt:P361"--> e1v2
e1v2("?g"):::projected
e1v1("?x"):::projected
end
f1--EXISTS--> f1e1
f1 --> v2
f1 --> c2
f1 --> v4
v2 --"wdt:P361"--> v4
bind2[/VALUES ?team/]
bind2-->v5
bind20(["wd:Q1785271"])
bind20 --> bind2
bind21(["wd:Q20639847"])
bind21 --> bind2
bind22(["wd:Q20653563"])
bind22 --> bind2
bind23(["wd:Q20638319"])
bind23 --> bind2
bind24(["wd:Q6154783"])
bind24 --> bind2
bind25(["wd:Q382927"])
bind25 --> bind2
bind26(["wd:Q20653564"])
bind26 --> bind2
bind27(["wd:Q1756006"])
bind27 --> bind2
bind28(["wd:Q20653566"])
bind28 --> bind2
bind29(["wd:Q20639848"])
bind29 --> bind2
bind210(["wd:Q20652655"])
bind210 --> bind2
v2 --"wdt:P31"--> v5
v6 --"schema:about"--> v2
v6 --"schema:isPartOf"--> c6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end