which adaptation is adapted from adapted work which is an adaptation from the great adventure?
Entity Entity Entity Entity Entity
m.04f3x6f m.04lg3q5 m.0crxvs9 m.05b0ngf m.04lfsrt
The Call of the Wild The Call of the Wild Call of the Wild: Foxfire The Call of the Wild: Dog of the Yukon The Call of the Wild
class class entity
media_common.adaptation media_common.adapted_work m.04j1p1p
media_common.adaptation media_common.adapted_work media_common.adaptation
Adaptation Adapted Work The Great Adventure
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.04j1p1p } 
?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.04j1p1p)))