a cosy catastrophe falls into what media genre?
Entity Entity
m.06n90 m.07lw0y
Science Fiction Post-holocaust
class entity
media_common.media_genre m.05wtnw
media_common.media_genre media_common.media_genre
Media genre Cosy catastrophe
none none
media_common.media_genre.child_genres
Child genres
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 :media_common.media_genre . 
VALUES ?x1 { :m.05wtnw } 
?x0 :media_common.media_genre.child_genres ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND media_common.media_genre (JOIN media_common.media_genre.child_genres m.05wtnw))