Give me {geographic region} that {located on terrain feature} {Oceania} and which contains the word {melanesia} in their name
Let me know the geographic region that's found within the territory include of Oceania and contains the word melanesia in it's name?
Tell me the geographic region that is located in the terrain feature of Oceania and contains the word melanesia in it's name?
SELECT DISTINCT ?d WHERE { ?d property:located_on_terrain_feature resource:Oceania . FILTER ( CONTAINS ( LCASE ( ?d ) , 'melanesia' ) ) . ?d rdf:type ontology:geographic_region }
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/Q82794>. ?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/P706> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q538>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'melanesia')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q82794 . ?sbj wdt:P706 wd:Q538 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'melanesia')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 
Melanesia Melanesia