query-3c0ad080a5eafa8804a52fa021db7ff2

rq turtle/ttl

that returns names of brands with logos and Q-id for the bran owners. I want to be able to find a company by a substring of the label. In the example above you see two commented attempts (you can uncomment them interchangeably) to find companies that have "Mercedes" in their label. They don't return anything. I have had moderate success with the approach below, but it displays many duplicates and I find the one above more elegant.

Use at

• https://query.wikidata.org/sparql

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 {
    # find an instance of trademark or any of its subclasses
    ?trademark wdt:P31/wdt:P279* wd:Q167270.

    ?trademark rdfs:label ?trademarkLabel. 
    FILTER(CONTAINS(LCASE(?trademarkLabel), "mercedes"@en)). 

    # 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

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2018/08