what is the tv character that has a rank of john soap mactavish?
(AND tv.tv_character (JOIN (R fictional_universe.character_rank.characters_of_this_rank) (JOIN (R fictional_universe.fictional_character.rank) m.09rljlg)))