query-d33e3ebc48854ed769e0ca9db3995450

rq turtle/ttl

Duplicate BHL IDs

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel (COUNT(*) AS ?count)
WHERE { ?item p:P4081 [ wikibase:rank ?rank ] . FILTER(!(?rank=wikibase:DeprecatedRank)) 
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
      } 
GROUP BY ?item ?itemLabel HAVING(?count > 1) ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v3("?item"):::projected v2("?rank") a1((" ")) c6(["bd:serviceParam"]):::iri c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?count > '1^^xsd:integer'"]] f0 --> v4 f1[["not ?rank = 'wikibase:DeprecatedRank'"]] f1 --> v2 a1 --"wikibase:rank"--> v2 v3 --"p:P4081"--> a1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind3[/"count(*)"/] bind3 --as--o v4