query-3de208ece1cd6c06a140c7cb4879b2d4

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

SELECT ?p ?pLabel ?p_article ?z1Label ?z2Label WHERE {
   VALUES ?z1 {wd:Q183 wd:Q40 wd:Q39} # Staat DE, AT, CH
   ?p wdt:P17 ?z1 .
   VALUES ?z2 {wd:Q23397 wd:Q131681} # See, Stausee
   ?p wdt:P31 ?z2 FILTER NOT EXISTS {?p wdt:P201 ?x }  # ohne Abfluss P201
   SERVICE wikibase:label {bd:serviceParam wikibase:language "en,de"}   
   OPTIONAL {  # add a sitelinked article, if it is on de-wiki
     ?p_article schema:about ?p .
     ?p_article schema:inLanguage "de" .
     FILTER (SUBSTR(str(?p_article), 1, 25) = "https://de.wikipedia.org/")
   }      
 } LIMIT 10

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?p"):::projected v3("?p_article"):::projected v2("?x") v4("?z1") v5("?z2") c13(["de"]):::literal c10(["en,de"]):::literal c8(["bd:serviceParam"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P201"--> e0v2 e0v1("?p"):::projected e0v2("?x"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> v2 v1 --"wdt:P201"--> v2 bind1[/VALUES ?z1/] bind1-->v4 bind10(["wd:Q183"]) bind10 --> bind1 bind11(["wd:Q40"]) bind11 --> bind1 bind12(["wd:Q39"]) bind12 --> bind1 v1 --"wdt:P17"--> v4 bind2[/VALUES ?z2/] bind2-->v5 bind20(["wd:Q23397"]) bind20 --> bind2 bind21(["wd:Q131681"]) bind21 --> bind2 v1 --"wdt:P31"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."schema:about".-> v1 v3 --"schema:inLanguage"--> c13 end