which basketball team is in colonial athletic association
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.05c_sck m.012w3sgj m.05g1z84 m.05gqc47 m.05gklq0 m.05c_syq m.03wj896 m.0j65xwr m.05ghmrn m.0bs2z92
College of Charleston Cougars men's basketball Hofstra Pride women's basketball Hofstra Pride men's basketball James Madison Dukes men's basketball Towson Tigers men's basketball Delaware Fightin' Blue Hens men's basketball William & Mary Tribe men's basketball Northeastern Huskies men's basketball Drexel Dragons men's basketball UNC Wilmington Seahawks men's basketball
class entity
basketball.basketball_team m.02p6sl
basketball.basketball_team basketball.basketball_conference
Basketball Team Colonial Athletic Association
none none
basketball.basketball_team.conference
Conference
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 :basketball.basketball_team . 
VALUES ?x1 { :m.02p6sl } 
?x0 :basketball.basketball_team.conference ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND basketball.basketball_team (JOIN basketball.basketball_team.conference m.02p6sl))