for military science fiction what is the parent genre?
(AND media_common.media_genre (JOIN media_common.media_genre.child_genres m.01smf2))