query-f03c9beedef7c5f9f3d299e32582b72b

rq turtle/ttl

PropertiesVIAF ID (P214)property constraint (P2302)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item (COUNT(?s) AS ?count)
WHERE {
  ?s ps:P2302 wd:Q19474404.
  ?stmt wikibase:hasViolationForConstraint ?s .
  ?item p:P214 ?stmt .
}
GROUP BY ?item
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count") v4("?item"):::projected v2("?s"):::projected v3("?stmt") c2(["wd:Q19474404"]):::iri v2 --"p:statement/P2302"--> c2 v3 --"wikibase:hasViolationForConstraint"--> v2 v4 --"p:P214"--> v3 bind1[/"count(?s)"/] v2 --o bind1 bind1 --as--o v5