which adaptation adapted another adaptation which stems from twilight?
Entity Entity Entity Entity
m.075wx7_ m.05pdh86 m.0djz0rc m.09gjmvw
Eclipse The Twilight Saga: New Moon The Twilight Saga: Breaking Dawn - Part 2 The Twilight Saga
class class entity
media_common.adaptation media_common.adapted_work m.03nm_fh
media_common.adaptation media_common.adapted_work media_common.adaptation
Adaptation Adapted Work Twilight
none none none
media_common.adaptation.adapted_from media_common.adapted_work.adaptations
Adapted From Adaptations
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.adaptation . 
?x1 :type.object.type :media_common.adapted_work . 
VALUES ?x2 { :m.03nm_fh } 
?x0 :media_common.adaptation.adapted_from ?x1 . 
?x1 :media_common.adapted_work.adaptations ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND media_common.adaptation (JOIN media_common.adaptation.adapted_from (JOIN media_common.adapted_work.adaptations m.03nm_fh)))