which fictional character belongs to the ravenclaw quidditch team sub-organization of fictional organization?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.02qdy1 m.0152c0 g.1235kq4s m.01n2f5 m.01nrp0 m.0j7bx88 m.03j0z8 m.08ddsg5 m.0j2g4yz m.0j2dlxb
Professor Filius Flitwick Cho Chang Padma Patil Gilderoy Lockhart Moaning Myrtle Lisa Turpin Garrick Ollivander Penelope Clearwater Michael Corner Stewart Ackerley
class class entity
fictional_universe.fictional_character fictional_universe.fictional_organization m.075ssgq
fictional_universe.fictional_character fictional_universe.fictional_organization fictional_universe.fictional_organization
Fictional Character Organization in fiction Ravenclaw Quidditch Team
none none none
fictional_universe.fictional_character.organizations fictional_universe.fictional_organization.sub_organization_in_fiction
Belongs to organizations Sub-organization in fiction
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 :fictional_universe.fictional_character . 
?x1 :type.object.type :fictional_universe.fictional_organization . 
VALUES ?x2 { :m.075ssgq } 
?x0 :fictional_universe.fictional_character.organizations ?x1 . 
?x1 :fictional_universe.fictional_organization.sub_organization_in_fiction ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND fictional_universe.fictional_character (JOIN fictional_universe.fictional_character.organizations (JOIN fictional_universe.fictional_organization.sub_organization_in_fiction m.075ssgq)))