Template:Scholia-topic recently-published-works

{{#sparql: PREFIX target: <http://www.wikidata.org/entity/Q632814>

SELECT ?date ?work ?workLabel (CONCAT("/work/", SUBSTR(STR(?work), 32)) AS ?workUrl)

 ?topicsUrl ?topics 

WITH {

 SELECT DISTINCT ?work WHERE {
   ?work wdt:P921 / (wdt:P361+ | wdt:P1269+ | (wdt:P31* / wdt:P279*) ) target: .
 }

} AS %works WITH {

 SELECT (MAX(?dates) as ?datetime) ?work (GROUP_CONCAT(DISTINCT ?topic_label; separator=" // ") AS ?topics) 
                                   (CONCAT("../topics/", GROUP_CONCAT(DISTINCT SUBSTR(STR(?topic), 32); separator=",")) AS ?topicsUrl) 
 WHERE {
   INCLUDE %works
   ?work wdt:P921 ?topic . 
   OPTIONAL { ?work wdt:P577 ?dates . }
   ?topic rdfs:label ?topic_label .  FILTER (lang(?topic_label) = 'en')
 }
 GROUP BY ?work

} AS %result WHERE {

 INCLUDE %result

 # There is a problem with BC dates
 # BIND(xsd:date(?datetime) AS ?date)
 BIND(REPLACE(STR(?datetime), 'T.*', ) AS ?date)
   
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,nl,no,ru,sv,zh". }

} GROUP BY ?date ?work ?workLabel ?topicsUrl ?topics ORDER BY DESC(?date) LIMIT 500 |config=http://www.wikidata.org }}