query-23b915ebbf6c416b86b14895a4c7b0bd

Original combination oddities, maybe

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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(?statement0) as ?count)
WHERE
{
     ?item wdt:P171+ wd:Q28319.
     ?item p:P1403 ?statement0.
     ?statement0 ps:P1403 [].
} group by ?item having( count(?statement0) > 1)
order by DESC(?count)

Query found at

https://www.wikidata.org/wiki/User:William_Avery/SPARQL

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?_anon_d00291b7e9a143df8ec0be8c8ebd714c76586") v5("?count") v2("?item"):::projected v3("?statement0"):::projected a2((" ")) a1((" ")) c3(["wd:Q28319"]):::iri f0[[" > '1^^xsd:integer'"]] f0 --> a1 v2 --"p:direct/P171"--> c3 v2 --"p:P1403"--> v3 v3 --"p:statement/P1403"--> a2 bind3[/"count(?statement0)"/] v3 --o bind3 bind3 --as--o v4 bind4[/"count(?statement0)"/] v3 --o bind4 bind4 --as--o v5