Give me {book} that {published in} {Journal des débats} and which contains the word {count} in their name
WHICH IS THE BOOK THAT PUBLISHED IN JOURNAL DES DEBATS THAT CONTAINS THE WORD COUNT IN THEIR NAME
WHICH IS THE BOOK THAT PUBLISHED IN JOURNAL DES DEBATS THAT CONTAINS THE WORD COUNT IN THEIR NAME
SELECT DISTINCT ?a WHERE { FILTER ( CONTAINS ( LCASE ( ?a ) , 'COUNT' ) ) . ?a property:published_in resource:Journal_des_débats . ?a rdf:type ontology:book }
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/Q571>. ?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/P1433> . ?statement2 <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <http://wikidata.dbpedia.org/resource/Q2565164>. ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'count')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25
SELECT DISTINCT ?sbj ?sbj_label WHERE { ?sbj wdt:P31 wd:Q571 . ?sbj wdt:P1433 wd:Q2565164 . ?sbj rdfs:label ?sbj_label . FILTER(CONTAINS(lcase(?sbj_label), 'count')) . FILTER (lang(?sbj_label) = 'en') } LIMIT 25 