query-4f7d4daaab3b0e03d6b2b147fbaae568

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)instance of (P31)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) 
  (CONCAT("https://scholia.toolforge.org/authors/", GROUP_CONCAT(DISTINCT SUBSTR(STR(?researcher), 32); separator=",")) AS ?recipientsUrl)
  WHERE {
    { 
      SELECT DISTINCT ?researcher ?award WHERE {

        ?researcher wdt:P6104 wd:Q56241615 ; 
                    wdt:P31 wd:Q5 ;
                    wdt:P166 ?award .
      } 
      LIMIT 100000
    }
    ?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; v6("?_anon_42b5416610844a34809f33a099ae9de1118295") v5("?award"):::projected v2("?awardLabel"):::projected v7("?count"):::projected v7("?recipients"):::projected v8("?recipientsUrl"):::projected v4("?researcher") v3("?researcher_label") c3(["wd:Q56241615"]):::iri c5(["wd:Q5"]):::iri f0[["?awardLabel = 'en'"]] f0 --> v2 f1[["?researcher_label = 'en'"]] f1 --> v3 v4 --"wdt:P6104"--> c3 v4 --"wdt:P31"--> c5 v4 --"wdt:P166"--> v5 v4 --"rdfs:label"--> v3 bind5[/"substring(str(?researcher),'32^^xsd:integer')"/] v4 --o bind5 bind5 --as--o v6 bind6[/"count(?researcher)"/] v4 --o bind6 bind6 --as--o v7 bind7[/"?researcher_label"/] v3 --o bind7 bind7 --as--o v7 bind8[/"concat('https://scholia.toolforge.org/authors/',)"/] null --o bind8 bind8 --as--o v8 v5 --"rdfs:label"--> v2