Give me {intelligence agency} that {parent organization} {Foreign and Commonwealth Office} and which contains the word {intelligence} in their name
Tell me the brain business enterprise which has as mum or dad enterprise the Foreign and Commonwealth Office and carries the word Genius in it is name?
Tell me the intelligence agency which has as parent organization the Foreign and Commonwealth Office and contains the word intelligence in it's name?
SELECT DISTINCT ?s WHERE { ?s property:parent_organization resource:Foreign,_Commonwealth_and_Development_Office . ?s rdf:type ontology:intelligence_agency . FILTER ( CONTAINS ( LCASE ( ?s ) , 'intelligence' ) ) }
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/Q47913>. ?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/P749> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q358834>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'intelligence')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q47913 . ?sbj wdt:P749 wd:Q358834 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'intelligence')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 
Secret Intelligence Service Secret Intelligence Service