query-2ed06a614a5bb03fdf018aac429f4e99

rq turtle/ttl

Nor

Use at

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 ?type ?typeLabel ?count
WITH {
  SELECT ?type WHERE {
    VALUES ?basetype {
      wd:Q16070115
      wd:Q70( 58673
      wd:Q209163
      wd:Q4393107
      wd:Q865493
      wd:Q60997816
    }
    ?type wdt:P279* ?basetype.
  }
} AS %types
WITH {
  SELECT ?type (COUNT(?item) as ?count) WHERE {
    INCLUDE %types.
    {
      ?item wdt:P31 ?type.
    }
  }
  GROUP BY ?type
} AS %items
WITH {
  SELECT ?type (COUNT(?item) as ?count) WHERE {
    BIND(wd:Q7889 AS ?type).
    ?item wdt:P31 ?type.
  }
  GROUP BY ?type
} AS %items2
WHERE {
  INCLUDE %types.
  INCLUDE %items.
  INCLUDE %items2.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?count)

Query found at