query-64abf8f7a6fabd8a8370734d7f9af079
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?item ?itemLabel ?descr ?count
where {
{ select ?item ?descr { ?item wdt:P4342 ?odnb1 ; schema:description ?descr . filter (lang(?descr) = 'en') } }.
{ select (count(?item) as ?count) ?descr { { select ?item ?descr { ?item wdt:P4342 ?odnb1 ; schema:description ?descr . filter (lang(?descr) = 'en') } }} group by ?descr having(?count>1)}.
service wikibase:label { bd:serviceParam wikibase:language "en". }
} order by desc(?count) # asc(xsd:integer(substr(str(?item),33)))
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?count"):::projected
v2("?descr"):::projected
v3("?item"):::projected
v4("?odnb1")
c6(["bd:serviceParam"]):::iri
c1(["en"]):::literal
f0[["?descr = 'en'"]]
f0 --> v2
v3 --"wdt:P4342"--> v4
v3 --"schema:description"--> v2
f1[["?count > '1^^xsd:integer'"]]
f1 --> v5
f2[["?descr = 'en'"]]
f2 --> v2
v3 --"wdt:P4342"--> v4
v3 --"schema:description"--> v2
bind4[/"count(?item)"/]
v3 --o bind4
bind4 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c1
end