query-4dd3f97da920b1f41d78238492f5f9f6

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"))
}

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