Dreams:report-index: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[https://dreams.wikibase.cloud/query/#PREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%0A%20%20%3Fpublication_datetime%20%0A%20%20%3Freport%0A%20%20%3Ftitle%0AWHERE%20%7B%0A%20%20%3Freport%20dreamst%3AP2%20%2F%20dreamst%3AP10%2a%20dreams%3AQ8%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Freport%20dreamst%3AP1%20%3Ftitle%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Freport%20dreamst%3AP6%20%3Fpublication_datetime%20.%20%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3Fpublication_datetime%20] | [https://dreams.wikibase.cloud/query/#PREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%0A%20%20%3Fpublication_datetime%20%0A%20%20%3Freport%0A%20%20%3Ftitle%0AWHERE%20%7B%0A%20%20%3Freport%20dreamst%3AP2%20%2F%20dreamst%3AP10%2a%20dreams%3AQ8%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Freport%20dreamst%3AP1%20%3Ftitle%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Freport%20dreamst%3AP6%20%3Fpublication_datetime%20.%20%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3Fpublication_datetime%20] | ||
{{SPARQL | query = | {{SPARQL | query= | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | ||
Revision as of 11:55, 11 August 2022
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)