Returns all awards received by a given person, with the award name, the year it was conferred, the conferring event or organization, the work it was given for, and the full list of recipients. An award can have several recipients: a best paper award is received jointly by all authors of the paper.
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix wd: <http://www.wikidata.org/entity/> prefix vivo: <http://vivoweb.org/ontology/core#> select ?award ?award_label ?year ?conferrer ?conferrer_label ?work (group_concat(distinct str(?recipient); separator=" ") as ?recipients_multi_iri) (group_concat(distinct replace(replace(str(?rname), "\\\\", "\\\\\\\\"), "[\r\n]+", "\\\\n"); separator="\n") as ?recipients_label_multi) ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?pi . ?np npx:introduces ?award . } graph ?a { ?award a vivo:AwardReceipt . ?_recipient_iri wd:P166 ?award . ?recipient wd:P166 ?award . optional { ?award rdfs:label ?award_label . } optional { ?award dct:issued ?year . } optional { ?award wd:P1027 ?conferrer . } optional { ?award wd:P1686 ?work . } } # Labels for the conferrer and the recipients live in the pubinfo graph, not # the assertion. Each OPTIONAL wraps its GRAPH rather than the other way # round: `GRAPH ?x { OPTIONAL {...} }` drops the whole row in RDF4J. optional { graph ?pi { ?conferrer rdfs:label ?conferrer_label . } } optional { graph ?pi { ?recipient foaf:name ?rname . } } } group by ?award ?award_label ?year ?conferrer ?conferrer_label ?work ?np order by desc(?year)