Dreams:report-index

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT 
  ?publication_datetime 
  ?report
  ?title
  ?id
  ?url
WHERE {
  ?report dreamst:P2 / dreamst:P10* dreams:Q8 .
  OPTIONAL {
    ?report dreamst:P1 ?title .
  }
  OPTIONAL {
    ?report dreamst:P6 ?publication_datetime . 
  }
  OPTIONAL {
    ?report dreamst:P40 ?id .
    BIND(IRI(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?id))) AS ?url)
  }
}
ORDER BY DESC(?publication_datetime)