Give me {patent medicine} that {discoverer or inventor} {John Pemberton} and which contains the word {coca} in their name
Which is the patent medication that was once invented by using John Pemberton and incorporates the word coca in it is name?
Which is the patent medicine that was invented by John Pemberton and contains the word coca in it's name?
SELECT DISTINCT ?e WHERE { ?e rdf:type ontology:patent_medicine . FILTER ( CONTAINS ( LCASE ( ?e ) , 'coca' ) ) . ?e property:discoverer_or_inventor resource:John_Pemberton }
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/Q3480271>. ?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/P61> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q215959>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'coca')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q3480271 . ?sbj wdt:P61 wd:Q215959 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'coca')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 