query-d36fa9a37a746233766f42327d1b9490

rq turtle/ttl

fortifications with rejected in description

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#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?label ?description
WHERE
{
      ?item p:P17 ?statement2.
      ?statement2 (ps:P17/(wdt:P279*)) wd:Q145.
  ?item wdt:P31 wd:Q57821;
         schema:description ?description;
         rdfs:label ?label.
  FILTER(LANG(?description) = "en").
  FILTER(CONTAINS(?description, "rejected")).
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?description"):::projected v2("?item"):::projected v4("?label"):::projected v3("?statement2") a1((" ")) c8(["wd:Q57821"]):::iri c6(["wd:Q145"]):::iri f0[["contains(?description,'rejected')"]] f0 --> v1 f1[["?description = 'en'"]] f1 --> v1 v2 --"p:P17"--> v3 v3 --"p:statement/P17"--> a1 a1 --"p:direct/P279"--> c6 v2 --"p:direct/P31"--> c8 v2 --"schema:description"--> v1 v2 --"rdfs:label"--> v4