captain ponting is which cricker roster?
Entity
m.02k88b0
Ashes 2005, First Test, First Inning, Australia
class entity
cricket.cricket_roster m.02cdqb
cricket.cricket_roster cricket.cricket_player
Cricket Roster ponting
none none
cricket.cricket_roster.captain
Captain
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 :cricket.cricket_roster . 
VALUES ?x1 { :m.02cdqb } 
?x0 :cricket.cricket_roster.captain ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND cricket.cricket_roster (JOIN cricket.cricket_roster.captain m.02cdqb))