which collectable item is of the collection category whose parent category is memorabilia?
Entity Entity Entity
m.067408 m.0d8_vj m.0dv2wy
Album cover Backstage pass Concert T-shirt
class class entity
interests.collectable_item interests.collection_category m.03rnxq
interests.collectable_item interests.collection_category interests.collection_category
Collectable item Collection category memorabilia
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.03rnxq } 
?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.03rnxq)))