what amusement ride has a drop of premier rides?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.0fqql5 g.12195_0j g.121nxf3g g.1z2v7r0ys m.010qclrl m.0130z6gc m.02699jp m.0269css m.02qnwkt m.03hm0nl m.070jrq m.08ngzz m.0cc5wdd m.0ch4c5d m.0ch5qcd m.0dlxk5 m.0dn4d9 m.0f99_c m.0flltf m.0fwh_q m.0g9c2p m.0h55l8x m.0lqhw80
Poltergeist null null null Adlabs Imagica Deep Space Tempesto Powder Keg: A Blast into the Wilderness Buzz Saw Falls Speed – The Ride Vonkaputous Revenge of the Mummy Batman & Robin: The Chiller Revenge of the Mummy Sky Rocket Bandit Mr. Freeze The Joker's Jinx Runaway Mountain Flight of Fear Flight of Fear Backlot Stunt Coaster Superman: Ultimate Flight Full Throttle
class entity
amusement_parks.ride m.0fpllj
amusement_parks.ride amusement_parks.ride_manufacturer
Amusement Ride Premier Rides
none none
amusement_parks.ride.manufacturer
Manufacturer
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.0fpllj } 
?x0 :amusement_parks.ride.manufacturer ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND amusement_parks.ride (JOIN amusement_parks.ride.manufacturer m.0fpllj))