query-4dd3f97da920b1f41d78238492f5f9f6
TODO
Use at
- https://query.wikidata.org/sparql
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/>
SELECT ?item ?startdate ?date WHERE{
?item p:P31 ?node .
?node ps:P31 wd:Q12813115;
pq:P580 ?startdate .
BIND(SUBSTR(STR(?startdate), 0, 10) as ?date)
FILTER(?date NOT IN ("1960-11-01","1965-11-01","1970-11-01","1975-11-01","1980-09-15","1985-12-31","1990-12-31","1995-12-31","2000-12-31","2005-12-31","2010-12-31","2015-12-31"))
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?date"):::projected
v2("?item"):::projected
v3("?node")
v4("?startdate"):::projected
c15(["wd:Q12813115"]):::iri
f0[["?date != '1960-11-01'?date != '1965-11-01'?date != '1970-11-01'?date != '1975-11-01'?date != '1980-09-15'?date != '1985-12-31'?date != '1990-12-31'?date != '1995-12-31'?date != '2000-12-31'?date != '2005-12-31'?date != '2010-12-31'?date != '2015-12-31'"]]
f0 --> v5
v2 --"p:P31"--> v3
v3 --"p:statement/P31"--> c15
v3 --"p:qualifier/P580"--> v4
bind1[/"substring(str(?startdate),'0^^xsd:integer','10^^xsd:integer')"/]
v4 --o bind1
bind1 --as--o v5