query-ffd10f834b0242dd87348286d5cc1e98

rq turtle/ttl

Historical markers with unveiling dates without referencesPlease use the following query:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?marker ?markerLabel ?unveiled WHERE {
  ?marker wdt:P31 wd:Q21562164;
          p:P571 ?unveiledStatement;
          rdfs:label ?markerLabel FILTER((LANG(?markerLabel)) = "en").
  ?unveiledStatement ps:P571 ?unveiled.
  FILTER EXISTS { ?unveiledStatement psv:P571/wikibase:timePrecision 11 }
  FILTER NOT EXISTS { ?unveiledStatement prov:wasDerivedFrom ?ref }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?marker"):::projected v3("?markerLabel"):::projected v2("?ref") v5("?unveiled"):::projected v1("?unveiledStatement") a1((" ")) c4(["11^^xsd:integer"]):::literal c7(["wd:Q21562164"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"prov:wasDerivedFrom"--> e0v2 e0v2("?ref"):::projected e0v1("?unveiledStatement"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> v2 v1 --"prov:wasDerivedFrom"--> v2 f1[[" "]] subgraph f1e1["Exists Clause"] e1v1 --"p:statement/value/P571"--> e1a1 e1a1 --"wikibase:timePrecision"--> e1c3 e1v1("?unveiledStatement"):::projected e1a1((" ")):::projected e1c3(["11^^xsd:integer"]):::literal end f1--EXISTS--> f1e1 f1 --> v1 f1 --> c2 f1 --> a1 f1 --> c3 f1 --> c4 v1 --"p:statement/value/P571"--> a1 a1 --"wikibase:timePrecision"--> c4 f2[["?markerLabel = 'en'"]] f2 --> v3 v4 --"p:direct/P31"--> c7 v4 --"p:P571"--> v1 v4 --"rdfs:label"--> v3 v1 --"p:statement/P571"--> v5