which collectable item is of the collection category whose parent category is movie tie-in?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.05kny5c m.02qx6rt m.05kp06d m.05yy177 m.05yy189 m.05yy1hz m.05yy1l4 m.05z20mz m.05z20pf m.05z20sq m.05z2vty m.05z2vv6 m.05z2vw3 m.05z2vwb m.05z2vww m.05z2vx2 m.05z2x_7 m.05z2x_s m.05z2y63 m.05z2y8y m.05z2yb_ m.05z2yf2 m.05z2yg8 m.05z2yh9 m.05z2yhj m.05z2yhr m.05z2yj0 m.05z2yj7 m.05z2yjg m.05yy1d6 m.05yy12h
WDW Mickey Mouse Pin Trading 2006 pin Optimash prime WDW Tinkerbell Leap Day 2008 pin 1983 Chief Chirpa action figure 1984 Lumat action figure Spud Trooper Artoo-Potatoo Spuda Fett Darth Mash Luke Frywalker X Wing Fighter action figure vehicle 1978 TIE Fighter action figure vehicle 1978 Land speeder action figure vehicle 1978 Sonic-controlled land speeder action figure vehicle 1978 Millennium Falcon action figure vehicle 1979 Darth Vader TIE Fighter action figure vehicle 1979 Radio-controlled Sandcrawler action figure vehicle 1979 Imperial Troop Transporter action figure vehicle 1979 Rebel Armored Snowspeeder action figure vehicle 1980 Twin Pod Cloud Car action figure vehicle 1980 AT-AT action figure vehicle 1981 Imperial Cruiser action figure vehicle 1981 Slave 1 action figure vehicle 1981 Death Star Space Station action figure playset 1978 Cantina Adventure Set action figure playset 1978 Land of the Jawas Action Playset 1979 Creature Cantina Action Playset 1979 Droid Factory playset 1979 Hoth Ice Planet Adventure Set 1980 Darth Tater Darth Vader stained glass window
class class entity
interests.collectable_item interests.collection_category m.020dz6
interests.collectable_item interests.collection_category interests.collection_category
Collectable item Collection category movie tie-in
none none none
interests.collection_category.items_in_this_category interests.collection_category.parent_category
Items in this category Parent category
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 :interests.collectable_item . 
?x1 :type.object.type :interests.collection_category . 
VALUES ?x2 { :m.020dz6 } 
?x1 :interests.collection_category.items_in_this_category ?x0 . 
?x1 :interests.collection_category.parent_category ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND interests.collectable_item (JOIN (R interests.collection_category.items_in_this_category) (JOIN interests.collection_category.parent_category m.020dz6)))