query-60839c3bad20450b5219ee8bd67b75dc

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT (COUNT(?item) AS ?people_died_in_Berlin_on_Wikidata)
       (COUNT(?article_fr) AS ?French_articles)
       (COUNT(?article_de) AS ?German_articles)
WHERE
{
  ?item wdt:P31 wd:Q5. # Item is a human
  ?item wdt:P20 ?place_of_death.
  ?place_of_death wdt:P131* wd:Q64. # Place of death is in Berlin
  OPTIONAL {
    ?article_fr schema:about ?item.
    ?article_fr schema:isPartOf <https://fr.wikipedia.org/>.
  }
  OPTIONAL {
    ?article_de schema:about ?item.
    ?article_de schema:isPartOf <https://de.wikipedia.org/>.
  }
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?French_articles") v7("?German_articles") v4("?article_de"):::projected v3("?article_fr"):::projected v1("?item"):::projected v5("?people_died_in_Berlin_on_Wikidata") v2("?place_of_death") c9([https://de.wikipedia.org/]):::iri c2(["wd:Q5"]):::iri c5(["wd:Q64"]):::iri c8([https://fr.wikipedia.org/]):::iri v1 --"wdt:P31"--> c2 v1 --"wdt:P20"--> v2 v2 --"wdt:P131"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."schema:about".-> v1 v3 --"schema:isPartOf"--> c8 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v1 v4 --"schema:isPartOf"--> c9 end bind3[/"count(?item)"/] v1 --o bind3 bind3 --as--o v5 bind4[/"count(?article_fr)"/] v3 --o bind4 bind4 --as--o v6 bind5[/"count(?article_de)"/] v4 --o bind5 bind5 --as--o v7