query-15cc1530d8d607ead1b430da8140b8ca

rq turtle/ttl

rdfs:label

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?trademark ?trademarkLabel ?image ?organization WHERE {
  ?trademark wdt:P31/wdt:P279* wd:Q167270; rdfs:label ?trademarkLabel .
  FILTER(LANG(?trademarkLabel) = 'en') .
  FILTER(CONTAINS(LCASE(?trademarkLabel), 'mercedes')) . 

  # that is owned by an instance of organization
  ?trademark wdt:P127 ?organization .
  ?organization wdt:P31/wdt:P279* wd:Q43229 .

  # and has a logo image
  ?trademark wdt:P154 ?image .
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?image"):::projected v3("?organization"):::projected v2("?trademark"):::projected v1("?trademarkLabel"):::projected a1((" ")) a2((" ")) c5(["wd:Q167270"]):::iri c8(["wd:Q43229"]):::iri f0[["contains(lower-case(?trademarkLabel),'mercedes')"]] f0 --> v1 f1[["?trademarkLabel = 'en'"]] f1 --> v1 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c5 v2 --"rdfs:label"--> v1 v2 --"wdt:P127"--> v3 v3 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c8 v2 --"wdt:P154"--> v4