Give me {mineral variety} that {crystal system} {hexagonal crystal system} and which contains the word {lonsdaleite} in their name
What is the title of the mineral that has an hexagonal crystal machine and that has the word "lonsdaleite" in its name?
What is the name of the mineral that has an hexagonal crystal system and that has the word "lonsdaleite" in its name?
SELECT DISTINCT ?a WHERE { ?a property:crystal_system resource:hexagonal_crystal_system . ?a rdf:type ontology:mineral_variety . FILTER ( CONTAINS ( LCASE ( ?a ) , 'lonsdaleite' ) ) }
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/Q429795>. ?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/P556> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q663314>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'lonsdaleite')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q429795 . ?sbj wdt:P556 wd:Q663314 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'lonsdaleite')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 
lonsdaleite lonsdaleite