query-1873949870c418aea227fbb9169ca32b

rq turtle/ttl

List of authors per number of articles descending ordered SELECT DISTINCT (COUNT(?author) AS ?count) ?author WHERE { ?article wdt:P31 wd:Q13442814; wdt:P179 wd:Q57081850. OPTIONAL { ?article wdt:P2093 ?author. } } GROUP BY ?author ORDER BY DESC (?count)

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#List of authors per number of articles descending ordered
SELECT DISTINCT (COUNT(?author) AS ?count) ?author WHERE {
  ?article wdt:P31 wd:Q13442814; wdt:P179 wd:Q57081850.
  OPTIONAL { ?article wdt:P2093 ?author. }
}
GROUP BY ?author
ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?article") v3("?author"):::projected v4("?count") c4(["wd:Q57081850"]):::iri c2(["wd:Q13442814"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P179"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2093".-> v3 end bind1[/"count(?author)"/] v3 --o bind1 bind1 --as--o v4