query-269ca691f53059be4f7fef031c873485

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>

SELECT ?editor ?editorLabel (COUNT(DISTINCT(?film)) AS ?films) ?imdb ?filmportal WHERE {
  ?film wdt:P1040 ?editor
  OPTIONAL { ?article schema:about ?editor . ?article schema:inLanguage "de" } FILTER(!bound(?article))
  OPTIONAL { ?editor wdt:P345 ?imdb }
  OPTIONAL { ?editor wdt:PP2639 ?filmportal }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "de,en"}
}
GROUP BY ?editor ?editorLabel ?imdb ?filmportal
HAVING (?films >= 10)
ORDER BY DESC(?films)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?article") v4("?editor"):::projected v3("?film"):::projected v6("?filmportal"):::projected v7("?films") v5("?imdb"):::projected c5(["de"]):::literal c9(["bd:serviceParam"]):::iri c11(["de,en"]):::literal f0[["?films >= '10^^xsd:integer'"]] f0 --> v7 f1[["not bound(?article)"]] f1 --> v2 v3 --"wdt:P1040"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."schema:about".-> v4 v2 --"schema:inLanguage"--> c5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P345".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:PP2639".-> v6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end bind3[/"count(?film)"/] v3 --o bind3 bind3 --as--o v7