query-ba08d7dc200179ca7c3833d70b148b09

rq turtle/ttl

.on Mastodon and on TwitterOriginally posted

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?itemLabel ?itemDescription WHERE {
  ?item wdt:P31 wd:Q5;
        wdt:P463 wd:Q47131;
        rdfs:label ?itemLabel;
        schema:description ?itemDescription.
  FILTER(LANG(?itemLabel) = "en")
  FILTER(LANG(?itemDescription) = "en")
  FILTER(!CONTAINS(?itemDescription, "Klux"))
  FILTER(!CONTAINS(?itemDescription, "KKK"))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v1("?itemDescription"):::projected v2("?itemLabel"):::projected c7(["wd:Q47131"]):::iri c5(["wd:Q5"]):::iri f0[["not contains(?itemDescription,'KKK')"]] f0 --> v1 f1[["not contains(?itemDescription,'Klux')"]] f1 --> v1 f2[["?itemDescription = 'en'"]] f2 --> v1 f3[["?itemLabel = 'en'"]] f3 --> v2 v3 --"wdt:P31"--> c5 v3 --"wdt:P463"--> c7 v3 --"rdfs:label"--> v2 v3 --"schema:description"--> v1