query-dbe0b4fa99f3197628c935aa9630e523

rq turtle/ttl

title:References by retrieval date SELECT ?subject ?subjectLabel ?subjectDescription ?date ?cons WHERE {
?subject p:P569/psv:P569 ?date_node . ?date_node wikibase:timePrecision "7"^^xsd:integer . ?date_node wikibase:timeValue ?date . FILTER (year(?date) > 1702 ) . FILTER (year(?date) < 1802 ) . ?subject p:P569/prov:wasDerivedFrom/pr:P248 wd:Q23833686 . ?subject p:P569/prov:wasDerivedFrom/pr:P813 ?cons . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ?cons

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:References by retrieval date
SELECT ?subject ?subjectLabel ?subjectDescription ?date ?cons
WHERE {  
   ?subject p:P569/psv:P569 ?date_node .
   ?date_node wikibase:timePrecision "7"^^xsd:integer .
   ?date_node wikibase:timeValue ?date . 
   FILTER (year(?date) > 1702 ) .
   FILTER (year(?date) < 1802 ) .
   ?subject p:P569/prov:wasDerivedFrom/pr:P248 wd:Q23833686 .
   ?subject p:P569/prov:wasDerivedFrom/pr:P813 ?cons .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?cons

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?cons"):::projected v2("?date"):::projected v4("?date_node") v3("?subject"):::projected a1((" ")) a2((" ")) a3((" ")) a4((" ")) a5((" ")) c10(["wd:Q23833686"]):::iri c13(["bd:serviceParam"]):::iri c6(["7^^xsd:integer"]):::literal c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["year-from-dateTime(?date) < '1802^^xsd:integer'"]] f0 --> v2 f1[["year-from-dateTime(?date) > '1702^^xsd:integer'"]] f1 --> v2 v3 --"p:P569"--> a1 a1 --"p:statement/value/P569"--> v4 v4 --"wikibase:timePrecision"--> c6 v4 --"wikibase:timeValue"--> v2 v3 --"p:P569"--> a2 a2 --"prov:wasDerivedFrom"--> a3 a3 --"p:reference/P248"--> c10 v3 --"p:P569"--> a4 a4 --"prov:wasDerivedFrom"--> a5 a5 --"p:reference/P813"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end