query-6f9cab787e46b629caf976c647f934a1
People where the point in time is after they entered and these people are still a member now.
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
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 ?item ?itemLabel WHERE {
BIND("2010-05-00T00:00:00Z"^^xsd:dateTime AS ?pointintime) .
?item p:P39 ?positionstatement .
?positionstatement ps:P39 wd:Q18887908 .
?positionstatement pq:P580 ?startdate .
MINUS { ?positionstatement pq:P582 ?enddate } .
FILTER(?startdate < ?pointintime ).
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?enddate")
v4("?item"):::projected
v1("?itemLabel"):::projected
v4("?pointintime")
v5("?positionstatement")
v2("?startdate")
c7(["bd:serviceParam"]):::iri
c9(["en"]):::literal
c3(["wd:Q18887908"]):::iri
f0[["?startdate < ?pointintime"]]
f0 --> v2
f0 --> v4
bind1[/"'2010-05-00T00:00:00Z^^xsd:dateTime'"/]
bind1 --as--o v4
v4 --"p:P39"--> v5
v5 --"p:statement/P39"--> c3
v5 --"p:qualifier/P580"--> v2
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v5 --"p:qualifier/P582"--> v6
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end