query-1b3447d7cd977ef585a49ab3c19109ae

rq turtle/ttl

Top 100 of author name string (P2093)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT DISTINCT ?shortname ?no_shortname WHERE {  
  ?item wdt:P2093 ?shortname .  
  {
  SELECT ?shortname (COUNT(?shortname) AS ?no_shortname) WHERE { 
     ?item wdt:P2093 ?shortname .
  }
  GROUP BY ?shortname
  HAVING(?no_shortname > 1)         
  }
}
ORDER BY DESC(?no_shortname)
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item") v4("?no_shortname"):::projected v3("?shortname"):::projected v2 --"wdt:P2093"--> v3 f0[["?no_shortname > '1^^xsd:integer'"]] f0 --> v4 v2 --"wdt:P2093"--> v3 bind2[/"count(?shortname)"/] v3 --o bind2 bind2 --as--o v4