query-5ce91094743562131d3426e63d3d0af5
Protonym 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 ?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_42b5416610844a34809f33a099ae9de1110332")
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