query-942aef7e921bf59ccbd98e59d85258a6

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
Select ?pers ?persLabel ?count {
  {
    SELECT ?pers (COUNT (DISTINCT ?article) as ?count)  WHERE {
    ?pers wdt:P31 wd:Q5 .
    {
        ?pers wdt:P27 wd:Q183 .
    } Union
    {
        ?pers wdt:P27 wd:Q40 .
    } Union
    {
        ?pers wdt:P27 wd:Q39 .
    } Union
    {
        ?pers wdt:P103 wd:Q188 .
    } Minus {
        ?pers wdt:P443 ?audio
    } .

    ?article schema:about $pers .

    } group by ?pers 
    ORDER BY DESC(?count) Limit 1000
 }

  SERVICE wikibase:label {
         bd:serviceParam wikibase:language "de" .
     }  
} ORDER BY DESC(?count) Limit 200

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article") v3("?audio") v5("?count"):::projected v2("?pers"):::projected c14(["de"]):::literal c5(["wd:Q40"]):::iri c6(["wd:Q39"]):::iri c12(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c4(["wd:Q183"]):::iri c8(["wd:Q188"]):::iri v2 --"wdt:P31"--> c2 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P103"--> c8 end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P27"--> c6 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P27"--> c5 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P27"--> c4 end union0r <== or ==> union0l end subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P443"--> v3 end v4 --"schema:about"--> v2 bind2[/"count(?article)"/] v4 --o bind2 bind2 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end