query-bde81a15d4a22fc46cc78891e9e8fe54

rq turtle/ttl

Propertiesmain subject (P921)author (P50)award received (P166)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?count ?award ?awardLabel ?recipients ?recipientsUrl
WHERE {
   {
  SELECT (COUNT(?researcher) AS ?count) ?award 
  (GROUP_CONCAT(DISTINCT ?researcher_label; separator=", ") AS ?recipients) 
  WHERE {
    { 
      SELECT DISTINCT ?researcher ?award WHERE {
        VALUES ?topic { wd:Q84263196 wd:Q81068910 wd:Q82069695 } 


        ?work wdt:P921 ?topic .
        ?work wdt:P50 ?researcher .
        ?researcher wdt:P166 ?award .
      } 
      LIMIT 100
    }
    ?researcher rdfs:label ?researcher_label . FILTER (LANG(?researcher_label) = 'en')
  }
  GROUP BY ?award 
}    ?award rdfs:label ?awardLabel . FILTER (LANG(?awardLabel) = 'en')
}
GROUP BY ?count ?award ?awardLabel ?recipients ?recipientsUrl
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?award"):::projected v2("?awardLabel"):::projected v8("?count"):::projected v8("?recipients"):::projected v6("?researcher") v3("?researcher_label") v4("?topic") v5("?work") f0[["?awardLabel = 'en'"]] f0 --> v2 f1[["?researcher_label = 'en'"]] f1 --> v3 bind2[/VALUES ?topic/] bind2-->v4 bind20(["wd:Q84263196"]) bind20 --> bind2 bind21(["wd:Q81068910"]) bind21 --> bind2 bind22(["wd:Q82069695"]) bind22 --> bind2 v5 --"wdt:P921"--> v4 v5 --"wdt:P50"--> v6 v6 --"wdt:P166"--> v7 v6 --"rdfs:label"--> v3 bind5[/"count(?researcher)"/] v6 --o bind5 bind5 --as--o v8 bind6[/"?researcher_label"/] v3 --o bind6 bind6 --as--o v8 v7 --"rdfs:label"--> v2