query-563b7a35b047572216d680637354cb2c
StatisticsAt 25th August 2018 there are (Q4167836)Wikimedia category (P279)subclass of (P31)instance of with 4179162 items (Q4167836)Wikimedia category (P31)instance of with 4106857 itemsDetailed count:
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?cat ?catLabel ?ct
WHERE {
{ SELECT ?cat (count(*) as ?ct)
WHERE
{ ?item wdt:P31 ?cat . ?cat (wdt:P279)* wd:Q4167836 }
GROUP BY ?cat
ORDER BY DESC(?ct)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?ct) ASC(?cat)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?cat"):::projected
v4("?ct"):::projected
v3("?item")
c5(["bd:serviceParam"]):::iri
c7(["en"]):::literal
c3(["wd:Q4167836"]):::iri
v3 --"wdt:P31"--> v2
v2 --"wdt:P279"--> c3
bind1[/"count(*)"/]
bind1 --as--o v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end