query-04dc06b3e4b3c6d3ee7f695fe72d8632

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?viaf ?lccn
WHERE {
    SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "יהודי".
    ?item wikibase:apiOutputItem mwapi:title .
  }
  MINUS {
    ?item p:P8189 ?j9u.
  }
  ?item schema:description ?itemDescription . filter(lang(?itemDescription)="he") 

#  FILTER (lcase(str(?itemDescription)) ="church") # - just find lower case church
  FILTER (contains(?itemDescription,"יהודי")) # - any case of church, somewhere in the description
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],he,en,ru". }
  OPTIONAL {?item wdt:P214 ?viaf}
  OPTIONAL {?item wdt:P244 ?lccn}
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v1("?itemDescription"):::projected v3("?j9u") v5("?lccn"):::projected v4("?viaf"):::projected c8(["www.wikidata.org"]):::literal c1(["יהודי"]):::literal c4(["bd:serviceParam"]):::iri c6(["Search"]):::literal c11(["mwapi:title"]):::iri c16(["#91;AUTO_LANGUAGE#93;,he,en,ru"]):::literal f0[["contains(?itemDescription,'יהודי')"]] f0 --> v1 f1[["?itemDescription = 'he'"]] f1 --> v1 subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c4 --"mwapi:api"--> c6 c4 --"mwapi:endpoint"--> c8 c4 --"mwapi:srsearch"--> c1 v2 --"mwapi:apiOutputItem"--> c11 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v2 --"p:P8189"--> v3 end v2 --"schema:description"--> v1 subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c4 --"mwapi:language"--> c16 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P214".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P244".-> v5 end