what short story has a character who also is in the adventure of the yellow face?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.02326v m.0232by m.04tvty m.022nsl m.026h02 m.02ffsw m.02hkm2 m.02j87d m.02jf32 m.02jncj m.02mrjf m.02p96r m.02xlp3 m.035cw_ m.03zjmd m.03zk4x m.03zkgf m.03zkkm m.03zkmg m.03zlc0 m.04nv7z m.04p0fb m.04pv3g m.04qtky m.04rvsx m.04t36w m.04tv93 m.04tv_d m.04tvc6 m.04tvd8 m.04tvk8 m.04tvy9 m.04tw1y m.04tw2n m.04tw30 m.04tw42 m.04tw9f m.04tw_9 m.04tw_p m.04twbl m.04twft m.04twl3 m.04twmy m.04twpb m.04twqs m.04twrh m.04twrw m.04twwq m.04twz6 m.02nwdf m.04tkwy m.025w2g m.04tvx5 m.03zk2_ m.05lmkj
The Final Problem The Adventure of the Empty House The Adventure of the Dancing Men The Adventure of the Mazarin Stone Silver Blaze The Adventure of the Bruce-Partington Plans The Adventure of the Red-Headed League The Adventure of the Greek Interpreter A Case of Identity The Boscombe Valley Mystery The Adventure of the Lion's Mane The Problem of Thor Bridge The Five Orange Pips The Adventure of the Musgrave Ritual The Man with the Twisted Lip The Adventure of the Speckled Band The Adventure of the Engineer's Thumb The Adventure of the Noble Bachelor The Adventure of the Beryl Coronet The Adventure of the Copper Beeches The Adventure of the Second Stain The Adventure of the Gloria Scott The Adventure of the Dying Detective The Adventure of the Cardboard Box The Adventure of the Six Napoleons The Adventure of the Stockbroker's Clerk The Adventure of the Reigate Squire The Adventure of Charles Augustus Milverton The Adventure of the Crooked Man The Adventure of the Resident Patient The Adventure of the Naval Treaty The Adventure of the Priory School The Adventure of the Three Students The Adventure of the Golden Pince-Nez The Adventure of the Missing Three-Quarter The Adventure of the Abbey Grange The Adventure of Wisteria Lodge The Adventure of Shoscombe Old Place The Adventure of the Retired Colourman The Adventure of the Red Circle The Adventure of the Devil's Foot His Last Bow The Adventure of the Illustrious Client The Adventure of the Blanched Soldier The Adventure of the Three Gables The Adventure of the Sussex Vampire The Adventure of the Three Garridebs The Adventure of the Creeping Man The Adventure of the Veiled Lodger The Adventure of Black Peter The Adventure of the Norwood Builder A Scandal in Bohemia The Adventure of the Solitary Cyclist The Adventure of the Blue Carbuncle The Disappearance of Lady Frances Carfax
class class entity
book.short_story book.book_character m.04tp7k
book.short_story book.book_character book.short_story
Short Story Book Character The Adventure of the Yellow Face
none none none
book.short_story.characters book.book_character.appears_in_stories
Characters Appears In Stories
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (?x0 AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :book.short_story . 
?x1 :type.object.type :book.book_character . 
VALUES ?x2 { :m.04tp7k } 
?x0 :book.short_story.characters ?x1 . 
?x1 :book.book_character.appears_in_stories ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND book.short_story (JOIN book.short_story.characters (JOIN book.book_character.appears_in_stories m.04tp7k)))