which amusement ride is designed by channel 4 ?
Entity
m.05086j
Splash Mountain
class entity
amusement_parks.ride m.01w92
amusement_parks.ride amusement_parks.ride_designer
Amusement Ride Channel 4
none none
amusement_parks.ride.designer
Designer
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 :amusement_parks.ride . 
VALUES ?x1 { :m.01w92 } 
?x0 :amusement_parks.ride.designer ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND amusement_parks.ride (JOIN amusement_parks.ride.designer m.01w92))