what is the tv character that has a rank of john soap mactavish?
Entity Entity
m.04d9gc m.0c7204k
Captain Black Tom Matthews
class class entity
tv.tv_character fictional_universe.character_rank m.09rljlg
tv.tv_character fictional_universe.character_rank cvg.game_character
TV Character Character Rank John Soap MacTavish
none none none
fictional_universe.character_rank.characters_of_this_rank fictional_universe.fictional_character.rank
Characters of This Rank Rank
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 :tv.tv_character . 
?x1 :type.object.type :fictional_universe.character_rank . 
VALUES ?x2 { :m.09rljlg } 
?x1 :fictional_universe.character_rank.characters_of_this_rank ?x0 . 
?x2 :fictional_universe.fictional_character.rank ?x1 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND tv.tv_character (JOIN (R fictional_universe.character_rank.characters_of_this_rank) (JOIN (R fictional_universe.fictional_character.rank) m.09rljlg)))