query-c8f17b275fea341786dcec06cccf7f43

rq turtle/ttl

significant event and time (P585)point in time . Often it is (P582)end time , (P580)start time . But I need also the time. So that I can order all events by time. Sometime it is type (Q331483)demolition . I also get the kind of event like (P793)significant event I want query all objects in my hometown Dresden with

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#---------------------------------------------------------------------------------------
#---------------------------------------------------------------------------------------
#defaultView:Table
SELECT ?item ?itemLabel  ?significant_eventLabel ?typeLabel ?time 
WHERE {
  ?item (wdt:P131/wdt:P279*) wd:Q1731.                # items in Dresden
  ?item wdt:P793 [  pq:* ?significant_event  ].       # significant event
  #?item p:P793 [  pq:* ?eventstatment ].   
  #?eventstatment prov:* ?type.
  #?eventstatment psv:* ?time.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
order by ?time ?significant_eventLabel ?itemLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/08