query-2993f482c18d2a65668f21f16ac05d60

rq turtle/ttl

Propertiesaward received (P166)instance of (P31)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?person ?personLabel (COUNT(?award) AS ?awards) (GROUP_CONCAT(?awardLabel; separator=", ") as ?list) WHERE {
  ?person wdt:P166 ?award.
  ?award wdt:P31 wd:Q17701409 
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . ?award rdfs:label ?awardLabel . ?person rdfs:label ?personLabel }
} GROUP BY ?person ?personLabel
HAVING ( ?awards > 1 )
ORDER BY DESC(?awards)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?award"):::projected v4("?awardLabel"):::projected v6("?awards") v6("?list") v2("?person"):::projected v5("?personLabel"):::projected c4(["wd:Q17701409"]):::iri c6(["bd:serviceParam"]):::iri c8(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal f0[["?awards > '1^^xsd:integer'"]] f0 --> v6 v2 --"wdt:P166"--> v3 v3 --"wdt:P31"--> c4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 v3 --"rdfs:label"--> v4 v2 --"rdfs:label"--> v5 end bind3[/"count(?award)"/] v3 --o bind3 bind3 --as--o v6 bind4[/"?awardLabel"/] v4 --o bind4 bind4 --as--o v6