sparql-examples

A set of SPARQL examples that are used in different TGX resources

View the Project on GitHub BiGCAT-UM/sparql-examples

028

rq turtle/ttl

Award aspect: recent publications by recipients

Use at

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX target: <http://www.wikidata.org/entity/Q44585>

SELECT ?publication_date ?work ?workLabel ?recipient ?recipientLabel
WITH {
  SELECT
    (MAX(?publication_datetimes) AS ?publication_datetime)
    ?work ?recipient
  WHERE {
    ?recipient wdt:P166 target: .
    ?work wdt:P50 ?recipient .
    OPTIONAL { ?work wdt:P577 ?publication_datetimes . }
  }
  GROUP BY ?work ?recipient
} AS %result
WHERE {
  INCLUDE %result 
  BIND(xsd:date(?publication_datetime) AS ?publication_date)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en,da,de,es,fr,jp,no,ru,sv,zh" . }  
}
ORDER BY DESC(?publication_date)
LIMIT 500

graph TD