query-6f33230a15895ef98f424dceffbd99d0
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
SELECT ?item (COUNT(DISTINCT ?gnd) AS ?gnd_cnt) (GROUP_CONCAT(?gnd; SEPARATOR=', ') AS ?gnds) ?dewiki_sitelink WHERE {
{
SELECT DISTINCT ?item WHERE {
?item wdt:P227 ?gnd .
} GROUP BY ?item HAVING(COUNT(DISTINCT ?gnd) > 1)
}.
?item wdt:P227 ?gnd .
?dewiki_sitelink schema:about ?item; schema:isPartOf <https://de.wikipedia.org/> .
} GROUP BY ?item ?dewiki_sitelink
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?_anon_42b5416610844a34809f33a099ae9de1105928")
v4("?dewiki_sitelink"):::projected
v2("?gnd"):::projected
v5("?gnd_cnt")
v6("?gnds")
v1("?item"):::projected
a1((" "))
c5([https://de.wikipedia.org/]):::iri
f0[[" > '1^^xsd:integer'"]]
f0 --> a1
v1 --"wdt:P227"--> v2
bind2[/"count(?gnd)"/]
v2 --o bind2
bind2 --as--o v3
v1 --"wdt:P227"--> v2
v4 --"schema:about"--> v1
v4 --"schema:isPartOf"--> c5
bind5[/"count(?gnd)"/]
v2 --o bind5
bind5 --as--o v5
bind6[/"?gnd"/]
v2 --o bind6
bind6 --as--o v6