query-bea7e2d9c17fc49ed880f07147ac77d6

rq turtle/ttl

Constraints with violations SELECT ?propLabel ?constraintLabel ?numViolations WHERE { { SELECT DISTINCT ?prop ?constraint (COUNT(?stmt) AS ?numViolations) WHERE { ?stmt wikibase:hasViolationForConstraint ?constraintStmt . ?prop p:P2302 ?constraintStmt . ?constraintStmt ps:P2302 ?constraint . } GROUP BY ?prop ?constraint } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?numViolations)

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Constraints with violations
SELECT ?propLabel ?constraintLabel ?numViolations
WHERE {
  {
    SELECT DISTINCT ?prop ?constraint (COUNT(?stmt) AS ?numViolations)
    WHERE 
    {
      ?stmt wikibase:hasViolationForConstraint ?constraintStmt .
      ?prop p:P2302 ?constraintStmt .
      ?constraintStmt ps:P2302 ?constraint .
    }
    GROUP BY ?prop ?constraint
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?numViolations)

Query found at

• https://www.wikidata.org/wiki/User:Realworldobject/QueryExamples