query-163f6d4fbebd9559b3d5bdd2846340f6
TODO
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 ?object ?objectLabel ?count WHERE {
{
SELECT ?object (COUNT(DISTINCT ?a) AS ?count) WHERE {
?a wdt:P106 wd:Q3357567 .
?a wdt:P27 ?object .
} GROUP BY ?object
HAVING (?count > 1)
} .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
ORDER BY DESC(?count) ?objectLabel
LIMIT 500
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?a")
v5("?count"):::projected
v4("?object"):::projected
v2("?objectLabel"):::projected
c6(["bd:serviceParam"]):::iri
c3(["wd:Q3357567"]):::iri
c8(["en"]):::literal
f0[["?count > '1^^xsd:integer'"]]
f0 --> v5
v3 --"wdt:P106"--> c3
v3 --"wdt:P27"--> v4
bind2[/"count(?a)"/]
v3 --o bind2
bind2 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end