query-5ce91094743562131d3426e63d3d0af5

rq turtle/ttl

Protonym oddities, maybe

Use at

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 ?taxonname (min(?item) as ?min) (max(?item) as ?max) (count(?item) as ?count)
WHERE
{
     ?item wdt:P171+ wd:Q25368. 
     ?item p:P225 ?name.
     ?name  ps:P225 ?taxonname.
     ?item p:P2868 ?statement0.
     ?statement0 ps:P2868 wd:Q14192851.
} group by ?taxonname having( count(?item) > 1)
order by DESC(?count)  ?taxonname

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?_anon_d00291b7e9a143df8ec0be8c8ebd714c110313") v9("?count") v3("?item"):::projected v8("?max") v7("?min") v4("?name") v5("?statement0") v2("?taxonname"):::projected a1((" ")) c3(["wd:Q25368"]):::iri c8(["wd:Q14192851"]):::iri f0[[" > '1^^xsd:integer'"]] f0 --> a1 v3 --"p:direct/P171"--> c3 v3 --"p:P225"--> v4 v4 --"p:statement/P225"--> v2 v3 --"p:P2868"--> v5 v5 --"p:statement/P2868"--> c8 bind5[/"count(?item)"/] v3 --o bind5 bind5 --as--o v6 bind6[/"min(?item)"/] v3 --o bind6 bind6 --as--o v7 bind7[/"max(?item)"/] v3 --o bind7 bind7 --as--o v8 bind8[/"count(?item)"/] v3 --o bind8 bind8 --as--o v9