query-dfcc6414910b01eb04355f45f679a607
Propertiespoint in time (P585)start time (P580)end time (P582)part of (P361)instance of (P31)
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?year ?yearLabel WHERE {
?year p:P31 ?statement.
?statement ps:P31 wd:Q577.
FILTER NOT EXISTS {?year wdt:P585 ?time1 }
FILTER NOT EXISTS {?year wdt:P580 ?time2 }
FILTER NOT EXISTS {?year wdt:P582 ?time3 }
FILTER NOT EXISTS {?statement pq:P361 wd:Q44722 }
FILTER NOT EXISTS {?year wdt:P361 wd:Q44722 }
FILTER NOT EXISTS {?statement pq:P361 wd:Q28892 }
FILTER NOT EXISTS {?year wdt:P361 wd:Q28892 }
FILTER NOT EXISTS {?statement pq:P361 wd:Q950135 }
FILTER NOT EXISTS {?year wdt:P361 wd:Q950135 }
FILTER NOT EXISTS {?statement pq:P361 wd:Q3353159}
FILTER NOT EXISTS {?year wdt:P361 wd:Q3353159 }
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;
v2("?statement")
v5("?time1")
v4("?time2")
v3("?time3")
v1("?year"):::projected
c5(["wd:Q28892"]):::iri
c6(["wd:Q44722"]):::iri
c2(["wd:Q3353159"]):::iri
c12(["wd:Q577"]):::iri
c14(["bd:serviceParam"]):::iri
c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c4(["wd:Q950135"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"p:direct/P361"--> e0c2
e0v1("?year"):::projected
e0c2(["wd:Q3353159"]):::iri
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> c2
v1 --"p:direct/P361"--> c2
f1[["not "]]
subgraph f1e1["Exists Clause"]
e1v1 --"p:qualifier/P361"--> e1c2
e1v1("?statement"):::projected
e1c2(["wd:Q3353159"]):::iri
end
f1--EXISTS--> f1e1
f1 --> v2
f1 --> c3
f1 --> c2
v2 --"p:qualifier/P361"--> c2
f2[["not "]]
subgraph f2e2["Exists Clause"]
e2v1 --"p:direct/P361"--> e2c2
e2v1("?year"):::projected
e2c2(["wd:Q950135"]):::iri
end
f2--EXISTS--> f2e2
f2 --> v1
f2 --> c1
f2 --> c4
v1 --"p:direct/P361"--> c4
f3[["not "]]
subgraph f3e3["Exists Clause"]
e3v1 --"p:qualifier/P361"--> e3c2
e3v1("?statement"):::projected
e3c2(["wd:Q950135"]):::iri
end
f3--EXISTS--> f3e3
f3 --> v2
f3 --> c3
f3 --> c4
v2 --"p:qualifier/P361"--> c4
f4[["not "]]
subgraph f4e4["Exists Clause"]
e4v1 --"p:direct/P361"--> e4c2
e4v1("?year"):::projected
e4c2(["wd:Q28892"]):::iri
end
f4--EXISTS--> f4e4
f4 --> v1
f4 --> c1
f4 --> c5
v1 --"p:direct/P361"--> c5
f5[["not "]]
subgraph f5e5["Exists Clause"]
e5v1 --"p:qualifier/P361"--> e5c2
e5v1("?statement"):::projected
e5c2(["wd:Q28892"]):::iri
end
f5--EXISTS--> f5e5
f5 --> v2
f5 --> c3
f5 --> c5
v2 --"p:qualifier/P361"--> c5
f6[["not "]]
subgraph f6e6["Exists Clause"]
e6v1 --"p:direct/P361"--> e6c2
e6v1("?year"):::projected
e6c2(["wd:Q44722"]):::iri
end
f6--EXISTS--> f6e6
f6 --> v1
f6 --> c1
f6 --> c6
v1 --"p:direct/P361"--> c6
f7[["not "]]
subgraph f7e7["Exists Clause"]
e7v1 --"p:qualifier/P361"--> e7c2
e7v1("?statement"):::projected
e7c2(["wd:Q44722"]):::iri
end
f7--EXISTS--> f7e7
f7 --> v2
f7 --> c3
f7 --> c6
v2 --"p:qualifier/P361"--> c6
f8[["not "]]
subgraph f8e8["Exists Clause"]
e8v1 --"p:direct/P582"--> e8v2
e8v2("?time3"):::projected
e8v1("?year"):::projected
end
f8--EXISTS--> f8e8
f8 --> v1
f8 --> c7
f8 --> v3
v1 --"p:direct/P582"--> v3
f9[["not "]]
subgraph f9e9["Exists Clause"]
e9v1 --"p:direct/P580"--> e9v2
e9v2("?time2"):::projected
e9v1("?year"):::projected
end
f9--EXISTS--> f9e9
f9 --> v1
f9 --> c8
f9 --> v4
v1 --"p:direct/P580"--> v4
f10[["not "]]
subgraph f10e10["Exists Clause"]
e10v1 --"p:direct/P585"--> e10v2
e10v2("?time1"):::projected
e10v1("?year"):::projected
end
f10--EXISTS--> f10e10
f10 --> v1
f10 --> c9
f10 --> v5
v1 --"p:direct/P585"--> v5
v1 --"p:P31"--> v2
v2 --"p:statement/P31"--> c12
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c14 --"wikibase:language"--> c16
end