query-00889d1f2300d46874c08c2ace53a38f

rq turtle/ttl

TEMPLATE={ "template":"Video games with the most nominations at the ?ceremony award ceremony","variables":{"?ceremony":{"query":" SELECT ?id WHERE { ?id wdt:P31 wd:Q4504495; wdt:P1269 ?award. ?award wdt:P279 wd:Q18328126. }"} } } SELECT ?item ?itemLabel ?developer (GROUP_CONCAT(?awardLabel; SEPARATOR = ", ") AS ?awards) (COUNT(?award) AS ?award_received) WHERE { BIND(wd:Q102300180 AS ?ceremony) ?item p:P166 ?statement. ?statement ps:P166 ?award; pq:P805 ?ceremony. OPTIONAL { ?item wdt:P178 ?developer. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?award rdfs:label ?awardLabel. ?item rdfs:label ?itemLabel. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?item ?itemLabel ?developer ORDER BY DESC (?award_received)

Use at

• https://query.wikidata.org/sparql

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#TEMPLATE={ "template":"Video games with the most nominations at the ?ceremony award ceremony","variables":{"?ceremony":{"query":" SELECT ?id WHERE { ?id wdt:P31 wd:Q4504495; wdt:P1269 ?award. ?award wdt:P279 wd:Q18328126. }"} } }
SELECT ?item ?itemLabel ?developer (GROUP_CONCAT(?awardLabel; SEPARATOR = ", ") AS ?awards) (COUNT(?award) AS ?award_received) WHERE {
  BIND(wd:Q102300180 AS ?ceremony)
  ?item p:P166 ?statement.
  ?statement ps:P166 ?award;
    pq:P805 ?ceremony.
  OPTIONAL { ?item wdt:P178 ?developer. }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?award rdfs:label ?awardLabel.
    ?item rdfs:label ?itemLabel.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item ?itemLabel ?developer
ORDER BY DESC (?award_received)

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Video_games/Queries