query-5bc3484e63c8d6b48c0ee9dd02ec04d7

rq turtle/ttl

added before 2016-10

SELECT ?name (COUNT(?otherName) AS ?count) WHERE { ?name wdt:P31 wd:Q202444; wdt:P460 ?otherName. } GROUP BY ?name ORDER BY DESC(?count) LIMIT 10

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#added before 2016-10

SELECT ?name (COUNT(?otherName) AS ?count)
WHERE
{
  ?name wdt:P31 wd:Q202444;
        wdt:P460 ?otherName.
}
GROUP BY ?name
ORDER BY DESC(?count)
LIMIT 10

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v2("?name"):::projected v3("?otherName"):::projected c2(["wd:Q202444"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P460"--> v3 bind1[/"count(?otherName)"/] v3 --o bind1 bind1 --as--o v4