Give me {Grand Tour} that {organizer} {Amaury Sport Organisation} and which contains the word {de} in their name
Who is the organizer of the Grand Tour for Amaury Sport Organisation that has the word de in their name?
Who is the organizer of the Grand Tour for Amaury Sport Organisation that has the word de in their name?
SELECT DISTINCT ?t WHERE { ?t property:organizer resource:Amaury_Sport_Organisation . ?t rdf:type ontology:Grand_Tour . FILTER ( CONTAINS ( LCASE ( ?t ) , 'de' ) ) }
SELECT DISTINCT ?sbj ?sbj_label { ?statement1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> ?sbj . ?statement1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P31> . ?statement1 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q866427>. ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> ?sbj . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P664> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q372681>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'de')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q866427 . ?sbj wdt:P664 wd:Q372681 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'de')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 
Tour de France Tour de France