query-158a6ae75435e495575a61f3da79a199

rq turtle/ttl

Frequency table of uses of properties in direct claims, qualifiers and references

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
  ?property
  ?propertyLabel
  ?countInDirectClaims
  ?countInQualifiers
  ?countInReferences
{
   {
  SELECT ?property (?count AS ?countInDirectClaims) {
     {
  SELECT ?wdt (COUNT(*) AS ?count) {
    [] ?wdt [].
  }
  GROUP BY ?wdt
}
    ?property wikibase:directClaim ?wdt.
  }
}
   {
  SELECT ?property (?count AS ?countInQualifiers) {
     {
  SELECT ?wdt (COUNT(*) AS ?count) {
    [] ?wdt [].
  }
  GROUP BY ?wdt
}
    ?property wikibase:qualifier ?wdt.
  }
}
   {
  SELECT ?property (?count AS ?countInReferences) {
     {
  SELECT ?wdt (COUNT(*) AS ?count) {
    [] ?wdt [].
  }
  GROUP BY ?wdt
}
    ?property wikibase:reference ?wdt.
  }
}
  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE]"}.
}
ORDER BY DESC(?count)

Query found at

• https://www.wikidata.org/wiki/User:Rdrg109/1/25