query-6e758a3149de351ec1543f550d4d8626

rq turtle/ttl

memorable trees without code - No DRUSOP SELECT DISTINCT ?item ?USOP ?DRUSOP ?itemLabel ?sitelink ?exist WHERE { ?item wdt:P31 wd:Q811534 . ?item wdt:P17 wd:Q213 . #?item wdt:P131/wdt:P131 wd:Q579648 . #Okres ZR ?item wdt:P677 ?USOP OPTIONAL { ?item wdt:P3296 ?DRUSOP } FILTER (!BOUND(?DRUSOP)) OPTIONAL { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "cs" } SERVICE wikibase:label { bd:serviceParam wikibase:language "cs"} BIND(NOT EXISTS{ ?item wdt:P31 wd:Q15893266 } AS ?exist)
#FILTER ( ?exist) }

Use at

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#>
#memorable trees without code - No DRUSOP
SELECT DISTINCT ?item ?USOP ?DRUSOP ?itemLabel ?sitelink ?exist
WHERE
{
    ?item wdt:P31 wd:Q811534 .
    ?item wdt:P17 wd:Q213 .
    #?item wdt:P131/wdt:P131 wd:Q579648 .         #Okres ZR
    ?item wdt:P677 ?USOP
    OPTIONAL { ?item wdt:P3296 ?DRUSOP  }
    FILTER (!BOUND(?DRUSOP))
    OPTIONAL { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "cs" } 
    SERVICE wikibase:label { bd:serviceParam wikibase:language "cs"}
    BIND(NOT EXISTS{ ?item wdt:P31 wd:Q15893266 } AS ?exist)     
    #FILTER ( ?exist)
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?DRUSOP"):::projected v3("?USOP"):::projected v5("?exist"):::projected v2("?item"):::projected v4("?sitelink"):::projected c9(["cs"]):::literal c2(["wd:Q811534"]):::iri c4(["wd:Q213"]):::iri c11(["bd:serviceParam"]):::iri f0[["not bound(?DRUSOP)"]] f0 --> v1 v2 --"wdt:P31"--> c2 v2 --"wdt:P17"--> c4 v2 --"wdt:P677"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P3296".-> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v2 v4 --"schema:inLanguage"--> c9 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c9 end v2 --"wdt:P31"--> null bind1[/"not "/] subgraph bind1e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q15893266"]):::iri end bind1--EXISTS--> bind1e0 v2 --o bind1 c1 --o bind1 null --o bind1 bind1 --as--o v5