Give me {guide book} that contains the word {ארץ} in their name
Tell me a fictional detective whose name includes the word sam.
Tell me fictional detective whose name has the word sam in it.
SELECT DISTINCT ?w WHERE { ?w rdf:type ontology:guide_book . FILTER ( CONTAINS ( LCASE ( ?w ) , 'ארץ' ) ) }
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/Q223638>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'ארץ')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q223638 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'ארץ')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 