query-4ad539d83298087c6daff1c4056bd654

rq turtle/ttl

count of properties for all instances of an item

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 DISTINCT ?property ?propertyLabel ?count


WHERE {
   {
  SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    ?item wdt:P31*/wdt:P279* wd:Q20820271 .
  }
  LIMIT 200000
  }
    ?item ?p [ ] .
    ?property a wikibase:Property;
                wikibase:claim ?p.
  }
  GROUP BY ?property 
  LIMIT 100
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100

Query found at

• https://www.wikidata.org/wiki/User:Bluerasberry/sandbox