query-de68d082a503d7167b9b7cebe724a8bc

rq turtle/ttl

من اكتشف معظم الكواكب؟ (مع قائمة) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Kdo objevil nejvíce planet? (se seznamem) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Qui a découvert le plus de planètes? (et lesquelles) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Chi ha scoperto più pianeti? (con elenco) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Wien huet déi meeschte Planéiten entdeckt? (mat enger Lëscht) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Wie heeft de meeste planeten ontdekt? (met lijst) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Кто открыл наибольшее число планет? (со списком) Who discovered the most planets? (with list) Vem har upptäckt flest planeter? (med lista) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) Who discovered the most planets? (with list) 谁发现最多的行星？（附名单）

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
  ?discoverer ?discovererLabel
  (COUNT(DISTINCT ?planet) as ?count)
  (GROUP_CONCAT(DISTINCT(?planetLabel); separator=", ") as ?planets)
WHERE
{
  ?ppart wdt:P279* wd:Q634 .
  ?planet wdt:P31 ?ppart .
  ?planet wdt:P61 ?discoverer .
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?discoverer rdfs:label ?discovererLabel .
    ?planet rdfs:label ?planetLabel
  }
}
GROUP BY ?discoverer ?discovererLabel
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?count") v4("?discoverer"):::projected v5("?discovererLabel"):::projected v3("?planet"):::projected v6("?planetLabel"):::projected v7("?planets") v2("?ppart") c6(["bd:serviceParam"]):::iri c2(["wd:Q634"]):::iri c8(["en"]):::literal v2 --"wdt:P279"--> c2 v3 --"wdt:P31"--> v2 v3 --"wdt:P61"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 v4 --"rdfs:label"--> v5 v3 --"rdfs:label"--> v6 end bind2[/"count(?planet)"/] v3 --o bind2 bind2 --as--o v7 bind3[/"?planetLabel"/] v6 --o bind3 bind3 --as--o v7